[Home] [Help]
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;
471: l_loop_index2 BINARY_INTEGER;
654: END IF;
655:
656: IF p_mode = 'NR' THEN /* For updating the TC references of Non-Retro Batches to the newly created batch */
657: l_ovn := p_merge_batches(l_loop_index1).object_version_number;
658: HXT_DML.UPDATE_HXT_TIMECARDS (p_rowid => p_merge_batches(l_loop_index1).tc_rowid,
659: p_id => p_merge_batches(l_loop_index1).tc_id,
660: p_for_person_id => p_merge_batches(l_loop_index1).for_person_id,
661: p_time_period_id => p_merge_batches(l_loop_index1).time_period_id,
662: p_auto_gen_flag => p_merge_batches(l_loop_index1).auto_gen_flag,
724: SELECT assignment_number
725: INTO l_assignment_no
726: FROM per_all_assignments_f
727: WHERE person_id = (SELECT for_person_id
728: FROM hxt_timecards_x
729: WHERE id = p_merge_batches(l_loop_index1).tc_id
730: )
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: );
740:
741: EXCEPTION
837: AND (pbh.batch_reference LIKE nvl(c_reference_num , '%')
838: OR (pbh.batch_reference IS NULL
839: AND c_reference_num IS NULL))
840: AND exists (SELECT 'x'
841: FROM hxt_timecards_x tim --SIR017
842: WHERE tim.batch_id = pbh.batch_id
843: ) --bug 5748118
844: AND NOT EXISTS ( SELECT 1
845: FROM hxc_data_sets hds,
842: WHERE tim.batch_id = pbh.batch_id
843: ) --bug 5748118
844: AND NOT EXISTS ( SELECT 1
845: FROM hxc_data_sets hds,
846: hxt_timecards_f tim
847: WHERE tim.batch_id = pbh.batch_id
848: AND hds.data_set_id = tim.data_set_id
849: AND hds.status IN ('OFF_LINE','ARCHIVE_IN_PROGRESS','RESTORE_IN_PROGRESS')
850: )
2738: /*
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
2750: cursor c_get_retro_batch_ids(p_batch_id number) is
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
2859: pbl_line_id = NULL
2860: WHERE rowid in (
2861: SELECT hrw.rowid
2862: FROM hxt_det_hours_worked_f hrw,
2863: hxt_timecards_f tim
2864: WHERE hrw.tim_id = tim.id
2865: AND tim.batch_id=p_batch_id);
2866:
2867: -- Bug 13388573
2941: AND hrw.assignment_id = asm.assignment_id;
2942: /* AND hrw.parent_id > 0; HXT111*/
2943: -- Set a new batch number for timecards with elements being
2944: -- deleted from PayMIX
2945: UPDATE hxt_timecards tim
2946: SET tim.batch_id = l_new_batch
2947: WHERE tim.batch_id = p_batch_id
2948: AND tim.id = l_tim_id;
2949: -- Delete actual PayMIX batch lines
3024: , p_TYPE IN VARCHAR2) IS --HXT11i1
3025: CURSOR tim_dates is
3026: SELECT effective_start_date,
3027: effective_end_date
3028: FROM HXT_TIMECARDS_X
3029: WHERE id = p_tim_id;
3030: l_eff_start DATE;
3031: l_eff_end DATE;
3032: BEGIN
3130:
3131: -- To pick up each timecard in the batch.
3132: CURSOR get_timecards(p_batch_id IN NUMBER)
3133: IS SELECT id
3134: FROM hxt_timecards_f
3135: WHERE batch_id = p_batch_id;
3136:
3137:
3138: -- To pick up the individual details