APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_AP_DETAIL_LINKS

Line 18: TYPE time_building_block_id_arr IS TABLE OF hxc_ap_detail_links.TIME_BUILDING_BLOCK_ID%TYPE INDEX BY BINARY_INTEGER;

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;
21:
22: TYPE ap_detail_links_rec IS RECORD

Line 20: TYPE time_building_block_ovn_arr IS TABLE OF hxc_ap_detail_links.TIME_BUILDING_BLOCK_OVN%TYPE INDEX BY BINARY_INTEGER;

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;
21:
22: TYPE ap_detail_links_rec IS RECORD
23: (APPLICATION_PERIOD_ID application_period_id_arr,
24: TIME_BUILDING_BLOCK_ID time_building_block_id_arr,

Line 281: /* Remove the existing record from hxc_ap_detail_links table */

277: for l_dup_index IN l_app_period_info.first .. l_app_period_info.last loop
278: if g_debug then
279: hr_utility.set_location('Processing '||l_proc, 50);
280: end if;
281: /* Remove the existing record from hxc_ap_detail_links table */
282: hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
283: /* Remove the record from hxc_app_period_summary table */
284: hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );
285: End loop;

Line 282: hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));

278: if g_debug then
279: hr_utility.set_location('Processing '||l_proc, 50);
280: end if;
281: /* Remove the existing record from hxc_ap_detail_links table */
282: hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
283: /* Remove the record from hxc_app_period_summary table */
284: hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );
285: End loop;
286: end if;

Line 402: /* Bulk insert the nested array into the hxc_ap_detail_links table */

398: end if;
399: if g_debug then
400: hr_utility.set_location('Processing '||l_proc, 110);
401: end if;
402: /* Bulk insert the nested array into the hxc_ap_detail_links table */
403: --Fix the bug 4506258. Added the if condition to take care of empty PL/SQL table when empty TC is submitted
404: if(l_detail_array.application_period_id.count>0) then
405: forall l_dup_index in l_detail_array.application_period_id.first .. l_detail_array.application_period_id.last
406: insert into hxc_ap_detail_links

Line 406: insert into hxc_ap_detail_links

402: /* Bulk insert the nested array into the hxc_ap_detail_links table */
403: --Fix the bug 4506258. Added the if condition to take care of empty PL/SQL table when empty TC is submitted
404: if(l_detail_array.application_period_id.count>0) then
405: forall l_dup_index in l_detail_array.application_period_id.first .. l_detail_array.application_period_id.last
406: insert into hxc_ap_detail_links
407: values ( l_detail_array.APPLICATION_PERIOD_ID(l_dup_index),
408: l_detail_array.TIME_BUILDING_BLOCK_ID(l_dup_index),
409: l_detail_array.TIME_BUILDING_BLOCK_OVN(l_dup_index)
410: );