APPS.HXT_BATCH_PROCESS dependencies on HXT_DET_HOURS_WORKED_F

Line 268: UPDATE hxt_det_hours_worked_f

264: p_object_version_number => l_ovn
265: );
266: ELSIF p_mode = 'R' THEN /* For updating the TC references of Retro Batches to the newly created batch */
267: BEGIN
268: UPDATE hxt_det_hours_worked_f
269: SET retro_batch_id = l_temp_batch_upd_id,
270: object_version_number = object_version_number + 1
271: WHERE retro_batch_id = p_merge_batches(l_loop_index1).batch_id
272: AND tim_id = p_merge_batches(l_loop_index1).tc_id;

Line 1361: UPDATE HXT_DET_HOURS_WORKED_F

1357: );
1358: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115
1359: -- Update OTM detail row to show BEE line entry id
1360: IF p_values_rec.hrw_rowid IS NOT NULL THEN
1361: UPDATE HXT_DET_HOURS_WORKED_F
1362: set PBL_LINE_ID = l_batch_line_id
1363: WHERE rowid = p_values_rec.hrw_rowid;
1364: END IF;
1365: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115

Line 1365: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115

1361: UPDATE HXT_DET_HOURS_WORKED_F
1362: set PBL_LINE_ID = l_batch_line_id
1363: WHERE rowid = p_values_rec.hrw_rowid;
1364: END IF;
1365: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115
1366: EXCEPTION
1367: WHEN g_lookup_not_found THEN
1368: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
1369: p_sum_retcode := 3;

Line 1660: FROM hxt_det_hours_worked_f hrw,

1656: from pay_batch_lines
1657: where batch_id = p_batch_id;
1658: cursor c_get_retro_batch_ids(p_batch_id number) is
1659: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number
1660: FROM hxt_det_hours_worked_f hrw,
1661: hxt_timecards_f tim,
1662: pay_batch_headers pbh
1663: WHERE hrw.tim_id = tim.id
1664: AND tim.batch_id = pbh.batch_id

Line 1720: UPDATE hxt_det_hours_worked_f

1716: -- effective dates will be sent. This is what we want, because
1717: -- those rows will include any adjustments made by time entry
1718: -- personnel.
1719: --SIR424 PWM 17JAN00 Clear the pbl_line_id during the rollback
1720: UPDATE hxt_det_hours_worked_f
1721: SET retro_batch_id = NULL,
1722: pay_status = 'P',
1723: pbl_line_id = NULL
1724: WHERE rowid in (

Line 1726: FROM hxt_det_hours_worked_f hrw,

1722: pay_status = 'P',
1723: pbl_line_id = NULL
1724: WHERE rowid in (
1725: SELECT hrw.rowid
1726: FROM hxt_det_hours_worked_f hrw,
1727: hxt_timecards_f tim
1728: WHERE hrw.tim_id = tim.id
1729: AND tim.batch_id=p_batch_id);
1730: -- step 4 - SET the date_earned (Process Date) back to NULL on the hxt_batch_states table