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 150: from hxc_tc_ap_links

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

Line 242: /*Remove existing records from hxc_tc_ap_links

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

Line 246: hxc_tc_ap_links_pkg.remove_timecard_links

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

Line 386: hxc_tc_ap_links_pkg.insert_summary_row

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