APPS.HXT_BATCH_PROCESS dependencies on HXC_RET_PAY_LATEST_DETAILS

Line 687: UPDATE hxc_ret_pay_latest_details

683: AND tim_id = p_merge_batches(l_loop_index1).tc_id;
684:
685: -- Bug 13954828
686: -- Updating the RDB tables with the new Merge batch.
687: UPDATE hxc_ret_pay_latest_details
688: SET batch_id = l_temp_batch_upd_id
689: WHERE batch_id = p_merge_batches(l_loop_index1).batch_id
690: RETURNING timecard_id
691: BULK COLLECT INTO l_tc_tab;

Line 695: hr_utility.trace('List of timecards updated in hxc_ret_pay_latest_details ');

691: BULK COLLECT INTO l_tc_tab;
692:
693: IF l_tc_tab.COUNT > 0
694: THEN
695: hr_utility.trace('List of timecards updated in hxc_ret_pay_latest_details ');
696: FOR i IN l_tc_tab.FIRST..l_tc_tab.LAST
697: LOOP
698: hr_utility.trace(' Timecard id '||l_tc_tab(i));
699: END LOOP;

Line 3185: hxc_ret_pay_latest_details ret

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
3189: AND ret.object_version_number = sum.time_building_block_ovn;

Line 3206: -- Eg. hxc_ret_pay_latest_details shows 12 hrs Reg

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
3209: -- and insert 8 hrs Reg and 4 hrs Overtime.
3210: OPEN get_ret_details(l_tim_id,p_batch_id);

Line 3252: DELETE FROM hxc_ret_pay_latest_details

3248: hxt_request_tab;
3249:
3250: -- Delete the entries already there.
3251: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
3252: DELETE FROM hxc_ret_pay_latest_details
3253: WHERE ROWID = CHARTOROWID(rowid_tab(i));
3254:
3255: -- Insert the new entries.
3256:

Line 3263: INSERT INTO hxc_ret_pay_latest_details

3259: -- These columns would record the original values from SS/TK and will be
3260: -- used in Rollback Batches from BEE process.
3261:
3262: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
3263: INSERT INTO hxc_ret_pay_latest_details
3264: ( resource_id,
3265: time_building_block_id,
3266: approval_status,
3267: start_time,