eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 280: hxc_tc_ap_links_pkg.create_timecard_links

276: -- 4. Create the link information if the
277: -- mode is migration
278: --
279: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then
280: hxc_tc_ap_links_pkg.create_timecard_links
281: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id);
282: end if;
283: End timecard_deposit;
284:

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

348: -- are changed to rejected.
349: --
350:
351: cursor c_timecards
352: (p_ap_id in hxc_tc_ap_links.application_period_id%type) is
353: select ts.timecard_id
354: from hxc_tc_ap_links lnk, hxc_timecard_summary ts
355: where application_period_id = p_ap_id
356: and ts.timecard_id = lnk.timecard_id

Line 354: from hxc_tc_ap_links lnk, hxc_timecard_summary ts

350:
351: cursor c_timecards
352: (p_ap_id in hxc_tc_ap_links.application_period_id%type) is
353: select ts.timecard_id
354: from hxc_tc_ap_links lnk, hxc_timecard_summary ts
355: where application_period_id = p_ap_id
356: and ts.timecard_id = lnk.timecard_id
357: and ts.approval_status <> hxc_timecard.c_rejected_status;
358:

Line 373: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1

369:
370: cursor c_timecards_to_check
371: (p_id in hxc_app_period_summary.application_period_id%type) is
372: select tc1.timecard_id ,tc1.approval_status
373: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
374: where lnk1.application_period_id = p_id
375: and lnk1.timecard_id = tc1.timecard_id
376: and tc1.approval_status <> hxc_timecard.c_submitted_status;
377:

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

375: and lnk1.timecard_id = tc1.timecard_id
376: and tc1.approval_status <> hxc_timecard.c_submitted_status;
377:
378: cursor c_any_reject_app_periods
379: (p_id in hxc_tc_ap_links.timecard_id%type) is
380: select asm.approval_status
381: from hxc_tc_ap_links lnk1, hxc_app_period_summary asm
382: where lnk1.timecard_id = p_id
383: and lnk1.application_period_id = asm.application_period_id

Line 381: from hxc_tc_ap_links lnk1, hxc_app_period_summary asm

377:
378: cursor c_any_reject_app_periods
379: (p_id in hxc_tc_ap_links.timecard_id%type) is
380: select asm.approval_status
381: from hxc_tc_ap_links lnk1, hxc_app_period_summary asm
382: where lnk1.timecard_id = p_id
383: and lnk1.application_period_id = asm.application_period_id
384: and asm.approval_status = hxc_timecard.c_rejected_status;
385:

Line 428: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1

424:
425: cursor c_timecards_to_check
426: (p_id in hxc_app_period_summary.application_period_id%type) is
427: select tc1.timecard_id
428: from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
429: where lnk1.application_period_id = p_id
430: and lnk1.timecard_id = tc1.timecard_id
431: and tc1.approval_status = hxc_timecard.c_submitted_status;
432:

Line 436: from hxc_app_period_summary asm, hxc_tc_ap_links lnk1

432:
433: cursor c_any_non_approved_app_periods
434: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
435: select asm.approval_status
436: from hxc_app_period_summary asm, hxc_tc_ap_links lnk1
437: where lnk1.timecard_id = p_timecard_id
438: and lnk1.application_period_id = asm.application_period_id
439: and asm.approval_status <> hxc_timecard.c_approved_status
440: order by 1 asc;