APPS.HXT_BATCH_PROCESS dependencies on HXT_DET_HOURS_WORKED

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

Line 1779: FROM hxt_det_hours_worked hrw, per_assignments_f asm --C421

1775: ,p_object_version_number => batch_line_rec.object_version_number
1776: );
1777: SELECT DISTINCT(hrw.tim_id)
1778: INTO l_tim_id
1779: FROM hxt_det_hours_worked hrw, per_assignments_f asm --C421
1780: WHERE asm.assignment_number = batch_line_rec.assignment_number
1781: AND hrw.assignment_id = asm.assignment_id;
1782: /* AND hrw.parent_id > 0; HXT111*/
1783: -- Set a new batch number for timecards with elements being