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.

[Home] [Help]

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 352: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

348:
349: End timecard_delete;
350:
351: procedure reject_timecards
352: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
353: --
354: -- In this case we have a rejection.
355: -- We should ensure all non-rejected timecards
356: -- that overlap with this application periods

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

373:
374: End reject_timecards;
375:
376: Procedure submit_timecards
377: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
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

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

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

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

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:
395: l_approval_status hxc_app_period_summary.approval_status%type;
396:
397: Begin
398:
399: for tc_check in c_timecards_to_check(p_application_period_id) loop

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

428:
429: End submit_timecards;
430:
431: Procedure approve_timecards
432: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
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

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

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

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;

Line 451: l_dummy_approval hxc_app_period_summary.approval_status%type;

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;
450:
451: l_dummy_approval hxc_app_period_summary.approval_status%type;
452:
453: Begin
454:
455: for tc_check in c_timecards_to_check(p_application_period_id) loop

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

475:
476: End approve_timecards;
477:
478: Procedure reevaluate_timecard_statuses
479: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
480:
481: cursor c_app_period_info
482: (p_ap_id in hxc_app_period_summary.application_period_id%type) is
483: select approval_status

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

478: Procedure reevaluate_timecard_statuses
479: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
480:
481: cursor c_app_period_info
482: (p_ap_id in hxc_app_period_summary.application_period_id%type) is
483: select approval_status
484: from hxc_app_period_summary
485: where application_period_id = p_ap_id;
486:

Line 484: from hxc_app_period_summary

480:
481: cursor c_app_period_info
482: (p_ap_id in hxc_app_period_summary.application_period_id%type) is
483: select approval_status
484: from hxc_app_period_summary
485: where application_period_id = p_ap_id;
486:
487: l_approval_status hxc_app_period_summary.approval_status%type;
488:

Line 487: l_approval_status hxc_app_period_summary.approval_status%type;

483: select approval_status
484: from hxc_app_period_summary
485: where application_period_id = p_ap_id;
486:
487: l_approval_status hxc_app_period_summary.approval_status%type;
488:
489: Begin
490:
491: open c_app_period_info(p_application_period_id);