Originally posted by gopi
owner = stage_owner
Package = RPT_CA_INVENTORY_AGING
Package body = GET_INVENTORY_AGING_SUMMARY
You have mixed up few things. Package and package body allways have the same name.

In your case:
Package = RPT_CA_INVENTORY_AGING
packaged procedure (not package body) = GET_INVENTORY_AGING_SUMMARY

your problem is that your public synonym was created totaly wrong:
create public synonym "RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY" for
"stage_owner.RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY"
You can't include packaged function/procedure in your synonym. Also, because you used double quotes the schema name STAGE_OWNER has being interpreted wrong, because you used lowercase inside the double quotes. Your create sysnonym statement should be:
Code:
create public synonym RPT_CA_INVENTORY_AGING for
stage_owner.RPT_CA_INVENTORY_AGING;
Now your users will be able to reference those packaged procedures and functions without specifying schema name, eg

SCOTT> exec RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY