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_APP_PERIOD_SUMMARY

Line 23: hxc_app_period_summary aps

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
27: );

Line 343: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

339:
340: End timecard_delete;
341:
342: procedure reject_timecards
343: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
344: --
345: -- In this case we have a rejection.
346: -- We should ensure all non-rejected timecards
347: -- that overlap with this application periods

Line 368: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

364:
365: End reject_timecards;
366:
367: Procedure submit_timecards
368: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
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

Line 371: (p_id in hxc_app_period_summary.application_period_id%type) is

367: Procedure submit_timecards
368: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
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

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 386: l_approval_status hxc_app_period_summary.approval_status%type;

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:
386: l_approval_status hxc_app_period_summary.approval_status%type;
387:
388: Begin
389:
390: for tc_check in c_timecards_to_check(p_application_period_id) loop

Line 423: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

419:
420: End submit_timecards;
421:
422: Procedure approve_timecards
423: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
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

Line 426: (p_id in hxc_app_period_summary.application_period_id%type) is

422: Procedure approve_timecards
423: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
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

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;

Line 442: l_dummy_approval hxc_app_period_summary.approval_status%type;

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;
441:
442: l_dummy_approval hxc_app_period_summary.approval_status%type;
443:
444: Begin
445:
446: for tc_check in c_timecards_to_check(p_application_period_id) loop

Line 470: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

466:
467: End approve_timecards;
468:
469: Procedure reevaluate_timecard_statuses
470: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
471:
472: cursor c_app_period_info
473: (p_ap_id in hxc_app_period_summary.application_period_id%type) is
474: select approval_status

Line 473: (p_ap_id in hxc_app_period_summary.application_period_id%type) is

469: Procedure reevaluate_timecard_statuses
470: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
471:
472: cursor c_app_period_info
473: (p_ap_id in hxc_app_period_summary.application_period_id%type) is
474: select approval_status
475: from hxc_app_period_summary
476: where application_period_id = p_ap_id;
477:

Line 475: from hxc_app_period_summary

471:
472: cursor c_app_period_info
473: (p_ap_id in hxc_app_period_summary.application_period_id%type) is
474: select approval_status
475: from hxc_app_period_summary
476: where application_period_id = p_ap_id;
477:
478: l_approval_status hxc_app_period_summary.approval_status%type;
479:

Line 478: l_approval_status hxc_app_period_summary.approval_status%type;

474: select approval_status
475: from hxc_app_period_summary
476: where application_period_id = p_ap_id;
477:
478: l_approval_status hxc_app_period_summary.approval_status%type;
479:
480: Begin
481:
482: open c_app_period_info(p_application_period_id);