APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_TC_AP_LINKS

Line 9: (TIMECARD_ID hxc_tc_ap_links.TIMECARD_ID%TYPE,

5: g_debug boolean := hr_utility.debug_enabled;
6:
7: TYPE application_period_table IS TABLE OF hxc_app_period_summary.APPLICATION_PERIOD_ID%TYPE;
8: TYPE tc_ap_links IS RECORD
9: (TIMECARD_ID hxc_tc_ap_links.TIMECARD_ID%TYPE,
10: APPLICATION_PERIOD_ID hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE
11: );
12: TYPE tc_ap_links_table IS TABLE OF tc_ap_links INDEX BY BINARY_INTEGER;
13:

Line 10: APPLICATION_PERIOD_ID hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE

6:
7: TYPE application_period_table IS TABLE OF hxc_app_period_summary.APPLICATION_PERIOD_ID%TYPE;
8: TYPE tc_ap_links IS RECORD
9: (TIMECARD_ID hxc_tc_ap_links.TIMECARD_ID%TYPE,
10: APPLICATION_PERIOD_ID hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE
11: );
12: TYPE tc_ap_links_table IS TABLE OF tc_ap_links INDEX BY BINARY_INTEGER;
13:
14: TYPE time_recipient_table IS TABLE OF HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 16: TYPE application_period_id_arr IS TABLE OF hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE INDEX BY BINARY_INTEGER;

12: TYPE tc_ap_links_table IS TABLE OF tc_ap_links INDEX BY BINARY_INTEGER;
13:
14: TYPE time_recipient_table IS TABLE OF HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE INDEX BY BINARY_INTEGER;
15:
16: TYPE application_period_id_arr IS TABLE OF hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE INDEX BY BINARY_INTEGER;
17:
18: TYPE time_building_block_id_arr IS TABLE OF hxc_ap_detail_links.TIME_BUILDING_BLOCK_ID%TYPE INDEX BY BINARY_INTEGER;
19:
20: TYPE time_building_block_ovn_arr IS TABLE OF hxc_ap_detail_links.TIME_BUILDING_BLOCK_OVN%TYPE INDEX BY BINARY_INTEGER;

Line 151: from hxc_tc_ap_links

147: Cursor c_get_tc_ap_links
148: is
149: select timecard_id,
150: application_period_id
151: from hxc_tc_ap_links
152: where timecard_id = p_tc_bb_id;
153:
154: Cursor c_creation_date
155: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,

Line 243: /*Remove existing records from hxc_tc_ap_links

239:
240: hxc_find_notify_aprs_pkg.cancel_previous_notifications
241: (p_timecard_id => p_tc_bb_id);
242:
243: /*Remove existing records from hxc_tc_ap_links
244: * Most probably there wont be any records as they would have
245: * been deleted in the hxc_timecard package */
246:
247: hxc_tc_ap_links_pkg.remove_timecard_links

Line 247: hxc_tc_ap_links_pkg.remove_timecard_links

243: /*Remove existing records from hxc_tc_ap_links
244: * Most probably there wont be any records as they would have
245: * been deleted in the hxc_timecard package */
246:
247: hxc_tc_ap_links_pkg.remove_timecard_links
248: (p_timecard_id => p_tc_bb_id );
249:
250: open c_get_apps_from_app_set(l_application_set_id );
251: fetch c_get_apps_from_app_set BULK COLLECT INTO l_appl_recipients;

Line 387: hxc_tc_ap_links_pkg.insert_summary_row

383: );
384:
385:
386: /* Call to create the Timecard - Application period link in hxc_yc_ap_links table */
387: hxc_tc_ap_links_pkg.insert_summary_row
388: (p_timecard_id => p_tc_bb_id,
389: p_application_period_id => l_time_building_block_id
390: );
391: