This discussion is archived
1 Reply Latest reply: Nov 5, 2012 9:47 AM by user8854370 RSS

permisssion for executing procedure from different schema

user488418 Newbie
Currently Being Moderated
Hi ,

I am executing following procedure in different package and, I am getting error. Following procedure and error:
Procedrue:
DECLARE
l_tbl_timecard_info APPS.HXC_self_service_time_deposit.timecard_info;
l_tbl_attributes_info APPS.HXC_self_service_time_deposit.app_attributes_info;
l_tbl_messages APPS.HXC_self_service_time_deposit.message_table;
l_new_timecard_id NUMBER;
l_new_timecard_ovn NUMBER;
l_time_building_block_id APPS.HXC_time_building_blocks.time_building_block_id%TYPE;
begin
--FND_GLOBAL.APPS_INITIALIZE( user_id => 12345,resp_id => 56789,resp_appl_id => 809 );
APPS.HXC_timestore_deposit.create_time_entry ( p_measure=> 7, p_day => APPS.fnd_date.canonical_to_date ('2002/09/02'), p_resource_id=> 9389, -- Identifies a person on our DB, REPLACE WITH YOUR IDs
p_app_blocks=> l_tbl_timecard_info, p_app_attributes=> l_tbl_attributes_info, p_time_building_block_id=> l_time_building_block_id);
end;
/
Error:

Error starting at line 1 in command:
DECLARE
l_tbl_timecard_info APPS.HXC_self_service_time_deposit.timecard_info;
l_tbl_attributes_info APPS.HXC_self_service_time_deposit.app_attributes_info;
l_tbl_messages APPS.HXC_self_service_time_deposit.message_table;
l_new_timecard_id NUMBER;
l_new_timecard_ovn NUMBER;
l_time_building_block_id APPS.HXC_time_building_blocks.time_building_block_id%TYPE;
begin
--FND_GLOBAL.APPS_INITIALIZE( user_id => 12345,resp_id => 56789,resp_appl_id => 809 );
APPS.HXC_timestore_deposit.create_time_entry ( p_measure=> 7, p_day => APPS.fnd_date.canonical_to_date ('2002/09/02'), p_resource_id=> 9389, -- Identifies a person on our DB, REPLACE WITH YOUR IDs
p_app_blocks=> l_tbl_timecard_info, p_app_attributes=> l_tbl_attributes_info, p_time_building_block_id=> l_time_building_block_id);
end;
Error report:
ORA-00942: table or view does not exist
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT_UTIL", line 1519
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT_UTIL", line 1599
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 1233
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 1327
ORA-06512: at line 10
00942. 00000 - "table or view does not exist"
*Cause:   
*Action:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points