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.HXT_BATCH_PROCESS dependencies on PAY_BATCH_HEADERS

Line 458: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

454: p_bus_group_id NUMBER,
455: p_mode VARCHAR2
456: )
457: IS
458: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

455: p_mode VARCHAR2
456: )
457: IS
458: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

456: )
457: IS
458: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

457: IS
458: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

458: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

Line 463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

459: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
467: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;

Line 464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

460: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
467: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
468: l_string1 VARCHAR2(5);

Line 465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

461: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
467: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
468: l_string1 VARCHAR2(5);
469: l_string2 VARCHAR2(5);

Line 466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

462: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
467: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
468: l_string1 VARCHAR2(5);
469: l_string2 VARCHAR2(5);
470: l_loop_index1 BINARY_INTEGER;

Line 474: l_parent_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

470: l_loop_index1 BINARY_INTEGER;
471: l_loop_index2 BINARY_INTEGER;
472: l_proc VARCHAR2(72);
473: l_assignment_no PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
474: l_parent_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
475: l_batch_type VARCHAR2(10);
476:
477:
478: -- Bug 13954828

Line 735: FROM pay_batch_headers pbh

731: AND sysdate between effective_start_date and effective_end_date;
732:
733: SELECT pbh.batch_name
734: INTO l_parent_batch_name
735: FROM pay_batch_headers pbh
736: WHERE pbh.batch_id = (SELECT tc.batch_id
737: FROM hxt_timecards_x tc
738: WHERE tc.id = p_merge_batches(l_loop_index1).tc_id
739: );

Line 831: FROM pay_batch_headers pbh, --GLOBAL

827: SELECT pbh.batch_id,
828: hbs.status batch_status, --SIR020
829: pbh.batch_reference ,
830: pbh.object_version_number
831: FROM pay_batch_headers pbh, --GLOBAL
832: hxt_batch_states hbs --SIR020
833: WHERE pbh.business_group_id = p_bus_group_id --GLOBAL
834: AND hbs.batch_id = pbh.batch_id --SIR020
835: AND pbh.batch_id BETWEEN nvl(c_batch_num,0)

Line 2743: pay_batch_headers pbh

2739: cursor c_get_retro_batch_ids(p_batch_id number) is
2740: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number
2741: FROM hxt_det_hours_worked_f hrw,
2742: hxt_timecards_f tim,
2743: pay_batch_headers pbh
2744: WHERE hrw.tim_id = tim.id
2745: AND tim.batch_id = pbh.batch_id
2746: AND tim.batch_id = p_batch_id
2747: AND hrw.retro_batch_id IS NOT NULL;

Line 2755: pay_batch_headers pbh

2751: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number,
2752: pbh.batch_status
2753: FROM hxt_det_hours_worked_f hrw,
2754: hxt_timecards_f tim,
2755: pay_batch_headers pbh
2756: WHERE hrw.tim_id = tim.id
2757: AND hrw.retro_batch_id = pbh.batch_id
2758: AND tim.batch_id = p_batch_id
2759: AND hrw.retro_batch_id IS NOT NULL;

Line 2763: from pay_batch_headers

2759: AND hrw.retro_batch_id IS NOT NULL;
2760:
2761: CURSOR c_get_batch_ovn(p_batch_id number) is
2762: select object_version_number
2763: from pay_batch_headers
2764: where batch_id = p_batch_id;
2765: l_batch_ovn pay_batch_headers.object_version_number%type;
2766: l_batch_line_id pay_batch_lines.batch_line_id%type;
2767: l_line_ovn pay_batch_headers.object_version_number%type;

Line 2765: l_batch_ovn pay_batch_headers.object_version_number%type;

2761: CURSOR c_get_batch_ovn(p_batch_id number) is
2762: select object_version_number
2763: from pay_batch_headers
2764: where batch_id = p_batch_id;
2765: l_batch_ovn pay_batch_headers.object_version_number%type;
2766: l_batch_line_id pay_batch_lines.batch_line_id%type;
2767: l_line_ovn pay_batch_headers.object_version_number%type;
2768: l_num VARCHAR2(5);
2769: BEGIN

Line 2767: l_line_ovn pay_batch_headers.object_version_number%type;

2763: from pay_batch_headers
2764: where batch_id = p_batch_id;
2765: l_batch_ovn pay_batch_headers.object_version_number%type;
2766: l_batch_line_id pay_batch_lines.batch_line_id%type;
2767: l_line_ovn pay_batch_headers.object_version_number%type;
2768: l_num VARCHAR2(5);
2769: BEGIN
2770: -- if no time period is specified, delete all PayMIX entries
2771: IF p_time_period_id IS NULL THEN

Line 2916: FROM pay_batch_headers

2912: -- we will create a new batch, the first time we enter this loop
2913: if not l_batch_created then
2914: SELECT business_group_id, batch_name, batch_reference
2915: INTO l_business_group_id, l_batch_name, l_batch_reference
2916: FROM pay_batch_headers
2917: WHERE batch_id = p_batch_id;
2918: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_header
2919: (p_session_date => sysdate
2920: ,p_batch_name => l_batch_name

Line 3059: FROM pay_batch_headers

3055: IS
3056:
3057: CURSOR get_bg_id
3058: IS SELECT business_group_id
3059: FROM pay_batch_headers
3060: WHERE batch_id = p_batch_id;
3061:
3062: l_bg_id NUMBER;
3063: