[Home] [Help]
675: p_object_version_number => l_ovn
676: );
677: ELSIF p_mode = 'R' THEN /* For updating the TC references of Retro Batches to the newly created batch */
678: BEGIN
679: UPDATE hxt_det_hours_worked_f
680: SET retro_batch_id = l_temp_batch_upd_id,
681: object_version_number = object_version_number + 1
682: WHERE retro_batch_id = p_merge_batches(l_loop_index1).batch_id
683: AND tim_id = p_merge_batches(l_loop_index1).tc_id;
2253: );
2254: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115
2255: -- Update OTM detail row to show BEE line entry id
2256: IF p_values_rec.hrw_rowid IS NOT NULL THEN
2257: UPDATE HXT_DET_HOURS_WORKED_F
2258: set PBL_LINE_ID = l_batch_line_id
2259: WHERE rowid = p_values_rec.hrw_rowid;
2260:
2261: IF g_debug
2259: WHERE rowid = p_values_rec.hrw_rowid;
2260:
2261: IF g_debug
2262: THEN
2263: hr_utility.trace('Updated HXT_DET_HOURS_WORKED_F with line id '||l_batch_line_id);
2264: END IF;
2265:
2266: -- Bug 13777315
2267: ELSE
2387:
2388: -- For all the rowids we found out here, update the pbl_line_id.
2389:
2390: FORALL i IN l_rowtab.FIRST..l_rowtab.LAST
2391: UPDATE hxt_det_hours_worked_f
2392: SET pbl_line_id = l_batch_line_id
2393: WHERE rowid = CHARTOROWID(l_rowtab(i));
2394:
2395: IF g_debug
2403: END IF;
2404:
2405: END IF;
2406:
2407: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115
2408: EXCEPTION
2409: WHEN g_lookup_not_found THEN
2410: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
2411: p_sum_retcode := 3;
2737: -- Bug 13388573
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
2749:
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
2852: -- effective dates will be sent. This is what we want, because
2853: -- those rows will include any adjustments made by time entry
2854: -- personnel.
2855: --SIR424 PWM 17JAN00 Clear the pbl_line_id during the rollback
2856: UPDATE hxt_det_hours_worked_f
2857: SET retro_batch_id = NULL,
2858: pay_status = 'P',
2859: pbl_line_id = NULL
2860: WHERE rowid in (
2858: pay_status = 'P',
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:
3145:
3146: CURSOR get_ret_details(p_tim_id IN NUMBER,
3147: p_batch_id IN NUMBER)
3148: IS
3149: SELECT /*+ INDEX(det HXT_DET_HOURS_WORKED_F_SUM_FK) */
3150: ret.resource_id,
3151: ret.time_building_block_id,
3152: ret.approval_status,
3153: ret.start_time,
3180: ret.attribute2,
3181: ret.attribute3,
3182: ret.request_id
3183: FROM hxt_sum_hours_worked_f sum,
3184: hxt_det_hours_worked_f det,
3185: hxc_ret_pay_latest_details ret
3186: WHERE sum.tim_id = p_tim_id
3187: AND sum.id = det.parent_id
3188: AND ret.time_building_block_id = sum.time_building_block_id
3200: EXIT WHEN get_timecards%NOTFOUND;
3201:
3202: -- For each timecard, pick up the details.
3203: -- The cursor is built in such a way that if there are multiple
3204: -- details per tbb id- OVN combination in hxt_det_hours_worked_f
3205: -- they get picked up multiple times.
3206: -- Eg. hxc_ret_pay_latest_details shows 12 hrs Reg
3207: -- In OTLR this is 8 hrs Reg and 4 hrs Overtime.
3208: -- So we pick up the 12 hrs Reg, delete the record