APPS.HXC_TIMECARD_SUMMARY_API dependencies on HXC_TC_AP_LINKS

Line 22: from hxc_tc_ap_links tcl,

18: from hxc_timecard_summary ts
19: where timecard_id = p_timecard_id
20: and exists(
21: select 1
22: from hxc_tc_ap_links tcl,
23: hxc_app_period_summary aps
24: where aps.application_period_id = tcl.application_period_id
25: and tcl.timecard_id = ts.timecard_id
26: and aps.approval_status = hxc_timecard.c_submitted_status

Line 78: hxc_tc_ap_links_pkg.remove_timecard_links

74:
75: -- 1. Remove all the links between the timecard and the application
76: -- periods
77:
78: hxc_tc_ap_links_pkg.remove_timecard_links
79: (p_timecard_id => p_timecard_id);
80:
81:
82: open c_get_item_key(p_timecard_id);

Line 172: hxc_tc_ap_links_pkg.remove_timecard_links

168:
169: -- 1. Remove all the links between the timecard and the application
170: -- periods
171:
172: hxc_tc_ap_links_pkg.remove_timecard_links
173: (p_timecard_id => p_timecard_id);
174:
175: open c_get_item_key(p_timecard_id);
176: fetch c_get_item_key into l_item_key;

Line 289: hxc_tc_ap_links_pkg.create_timecard_links

285: -- 4. Create the link information if the
286: -- mode is migration
287: --
288: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then
289: hxc_tc_ap_links_pkg.create_timecard_links
290: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id);
291: end if;
292: End timecard_deposit;
293:

Line 361: (p_ap_id in hxc_tc_ap_links.application_period_id%type) is

357: -- are changed to rejected.
358: --
359:
360: cursor c_timecards
361: (p_ap_id in hxc_tc_ap_links.application_period_id%type) is
362: select ts.timecard_id
363: from hxc_tc_ap_links lnk, hxc_timecard_summary ts
364: where application_period_id = p_ap_id
365: and ts.timecard_id = lnk.timecard_id

Line 363: from hxc_tc_ap_links lnk, hxc_timecard_summary ts

359:
360: cursor c_timecards
361: (p_ap_id in hxc_tc_ap_links.application_period_id%type) is
362: select ts.timecard_id
363: from hxc_tc_ap_links lnk, hxc_timecard_summary ts
364: where application_period_id = p_ap_id
365: and ts.timecard_id = lnk.timecard_id
366: and ts.approval_status <> hxc_timecard.c_rejected_status;
367:

Line 382: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1

378:
379: cursor c_timecards_to_check
380: (p_id in hxc_app_period_summary.application_period_id%type) is
381: select tc1.timecard_id ,tc1.approval_status
382: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
383: where lnk1.application_period_id = p_id
384: and lnk1.timecard_id = tc1.timecard_id
385: and tc1.approval_status <> hxc_timecard.c_submitted_status;
386:

Line 388: (p_id in hxc_tc_ap_links.timecard_id%type) is

384: and lnk1.timecard_id = tc1.timecard_id
385: and tc1.approval_status <> hxc_timecard.c_submitted_status;
386:
387: cursor c_any_reject_app_periods
388: (p_id in hxc_tc_ap_links.timecard_id%type) is
389: select asm.approval_status
390: from hxc_tc_ap_links lnk1, hxc_app_period_summary asm
391: where lnk1.timecard_id = p_id
392: and lnk1.application_period_id = asm.application_period_id

Line 390: from hxc_tc_ap_links lnk1, hxc_app_period_summary asm

386:
387: cursor c_any_reject_app_periods
388: (p_id in hxc_tc_ap_links.timecard_id%type) is
389: select asm.approval_status
390: from hxc_tc_ap_links lnk1, hxc_app_period_summary asm
391: where lnk1.timecard_id = p_id
392: and lnk1.application_period_id = asm.application_period_id
393: and asm.approval_status = hxc_timecard.c_rejected_status;
394:

Line 437: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1

433:
434: cursor c_timecards_to_check
435: (p_id in hxc_app_period_summary.application_period_id%type) is
436: select tc1.timecard_id
437: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
438: where lnk1.application_period_id = p_id
439: and lnk1.timecard_id = tc1.timecard_id
440: and tc1.approval_status = hxc_timecard.c_submitted_status;
441:

Line 445: from hxc_app_period_summary asm, hxc_tc_ap_links lnk1

441:
442: cursor c_any_non_approved_app_periods
443: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
444: select asm.approval_status
445: from hxc_app_period_summary asm, hxc_tc_ap_links lnk1
446: where lnk1.timecard_id = p_timecard_id
447: and lnk1.application_period_id = asm.application_period_id
448: and asm.approval_status <> hxc_timecard.c_approved_status
449: order by 1 asc;