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_SEARCH_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 559: (p_timecard_id in hxc_timecard_summary.timecard_id%type,

555: return varchar2
556: is
557:
558: cursor c_timecard_status
559: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
560: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type) is
561: select approval_status
562: from hxc_timecard_summary
563: where timecard_id = p_timecard_id

Line 560: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type) is

556: is
557:
558: cursor c_timecard_status
559: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
560: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type) is
561: select approval_status
562: from hxc_timecard_summary
563: where timecard_id = p_timecard_id
564: and timecard_ovn = p_timecard_ovn;

Line 562: from hxc_timecard_summary

558: cursor c_timecard_status
559: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
560: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type) is
561: select approval_status
562: from hxc_timecard_summary
563: where timecard_id = p_timecard_id
564: and timecard_ovn = p_timecard_ovn;
565:
566: cursor c_timecard_no_ovn_status

Line 567: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

563: where timecard_id = p_timecard_id
564: and timecard_ovn = p_timecard_ovn;
565:
566: cursor c_timecard_no_ovn_status
567: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
568: select approval_status
569: from hxc_timecard_summary
570: where timecard_id = p_timecard_id;
571:

Line 569: from hxc_timecard_summary

565:
566: cursor c_timecard_no_ovn_status
567: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
568: select approval_status
569: from hxc_timecard_summary
570: where timecard_id = p_timecard_id;
571:
572: cursor c_last_timecard_status
573: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

Line 583: l_tcstatus hxc_timecard_summary.approval_status%type;

579: from hxc_time_building_blocks tbb2
580: where tbb2.time_building_block_Id = tbb1.time_building_block_id
581: );
582:
583: l_tcstatus hxc_timecard_summary.approval_status%type;
584:
585: BEGIN
586:
587: open c_timecard_status(bb_id,bb_ovn);

Line 722: if p_mode = hxc_timecard_summary_pkg.c_normal_mode or p_mode is null then

718: l_app_period_count number;
719:
720: BEGIN
721:
722: if p_mode = hxc_timecard_summary_pkg.c_normal_mode or p_mode is null then
723:
724: return get_timecard_status_code(bb_id, bb_ovn);
725:
726: elsif p_mode = hxc_timecard_summary_pkg.c_migration_mode then

Line 726: elsif p_mode = hxc_timecard_summary_pkg.c_migration_mode then

722: if p_mode = hxc_timecard_summary_pkg.c_normal_mode or p_mode is null then
723:
724: return get_timecard_status_code(bb_id, bb_ovn);
725:
726: elsif p_mode = hxc_timecard_summary_pkg.c_migration_mode then
727: l_submitted := 'false';
728:
729: -- Original Timecard Status
730: select approval_status, start_time, stop_time, resource_id into l_tcstatus, l_start_time, l_stop_time, l_resource_id