APPS.HXT_BATCH_PROCESS dependencies on HXT_BATCH_STATES

Line 137: UPDATE hxt_batch_states

133: IF g_debug THEN
134: hr_utility.set_location('After updating valid batch name: '||l_valid_batch_name, 50);
135: END IF;
136: BEGIN
137: UPDATE hxt_batch_states
138: SET status = 'VV'
139: WHERE batch_id = l_valid_batch_id; /* For updating the status of the newly created batch */
140: END;
141: IF g_debug THEN

Line 142: hr_utility.set_location('After updating valid batch status in hxt_batch_states', 60);

138: SET status = 'VV'
139: WHERE batch_id = l_valid_batch_id; /* For updating the status of the newly created batch */
140: END;
141: IF g_debug THEN
142: hr_utility.set_location('After updating valid batch status in hxt_batch_states', 60);
143: END IF;
144: END IF;
145:
146: l_temp_batch_upd_id := l_valid_batch_id;

Line 181: UPDATE hxt_batch_states

177: IF g_debug THEN
178: hr_utility.set_location('After updating warning batch name: '||l_warning_batch_name, 90);
179: END IF;
180: BEGIN
181: UPDATE hxt_batch_states
182: SET status = 'VW'
183: WHERE batch_id = l_warning_batch_id; /* For updating the status of the newly created batch */
184: END;
185: IF g_debug THEN

Line 186: hr_utility.set_location('After updating warning batch status in hxt_batch_states', 100);

182: SET status = 'VW'
183: WHERE batch_id = l_warning_batch_id; /* For updating the status of the newly created batch */
184: END;
185: IF g_debug THEN
186: hr_utility.set_location('After updating warning batch status in hxt_batch_states', 100);
187: END IF;
188: END IF;
189:
190: l_temp_batch_upd_id := l_warning_batch_id;

Line 226: UPDATE hxt_batch_states

222: IF g_debug THEN
223: hr_utility.set_location('After updating error batch name: '||l_error_batch_name, 130);
224: END IF;
225: BEGIN
226: UPDATE hxt_batch_states
227: SET status = 'VE'
228: WHERE batch_id = l_error_batch_id; /* For updating the status of the newly created batch */
229: END;
230: IF g_debug THEN

Line 231: hr_utility.set_location('After updating error batch status in hxt_batch_states', 140);

227: SET status = 'VE'
228: WHERE batch_id = l_error_batch_id; /* For updating the status of the newly created batch */
229: END;
230: IF g_debug THEN
231: hr_utility.set_location('After updating error batch status in hxt_batch_states', 140);
232: END IF;
233: END IF;
234:
235: l_temp_batch_upd_id := l_error_batch_id;

Line 331: DELETE FROM hxt_batch_states

327: hr_utility.set_location('After deleting empty batches', 180);
328: END IF;
329:
330: BEGIN
331: DELETE FROM hxt_batch_states
332: WHERE batch_id = p_del_empty_batches(l_loop_index2).batch_id;
333: END;
334:
335: IF g_debug THEN

Line 336: hr_utility.set_location('After deleting empty batches from hxt_batch_states', 190);

332: WHERE batch_id = p_del_empty_batches(l_loop_index2).batch_id;
333: END;
334:
335: IF g_debug THEN
336: hr_utility.set_location('After deleting empty batches from hxt_batch_states', 190);
337: END IF;
338:
339: l_loop_index2 := p_del_empty_batches.next(l_loop_index2);
340:

Line 378: hxt_batch_states hbs --SIR020

374: hbs.status batch_status, --SIR020
375: pbh.batch_reference ,
376: pbh.object_version_number
377: FROM pay_batch_headers pbh, --GLOBAL
378: hxt_batch_states hbs --SIR020
379: WHERE pbh.business_group_id = p_bus_group_id --GLOBAL
380: AND hbs.batch_id = pbh.batch_id --SIR020
381: AND pbh.batch_id BETWEEN nvl(c_batch_num,0)
382: AND nvl(c_batch_num,999999999999)

Line 1596: UPDATE hxt_batch_states

1592: p_batch_id NUMBER,
1593: p_status VARCHAR2 )IS
1594: BEGIN
1595: IF (p_status = 'VT' AND p_date_earned IS NOT NULL) THEN
1596: UPDATE hxt_batch_states
1597: SET date_earned = p_date_earned
1598: WHERE batch_id = p_batch_id;
1599: END IF;
1600: UPDATE hxt_batch_states

Line 1600: UPDATE hxt_batch_states

1596: UPDATE hxt_batch_states
1597: SET date_earned = p_date_earned
1598: WHERE batch_id = p_batch_id;
1599: END IF;
1600: UPDATE hxt_batch_states
1601: SET status = p_status
1602: WHERE batch_id = p_batch_id;
1603: --COMMIT;
1604: END Set_batch_status;

Line 1613: FROM hxt_batch_states

1609: l_batch_status VARCHAR2(10);
1610: BEGIN
1611: SELECT status
1612: INTO l_batch_status
1613: FROM hxt_batch_states
1614: WHERE batch_id = p_batch_id;
1615: p_batch_status := l_batch_status;
1616: IF l_batch_status in ('E','VE') THEN
1617: return(2);

Line 1688: -- but we still need to manipulate HXT_BATCH_STATES

1684: end loop;
1685: -- Update Batch status
1686: --
1687: --BEGIN GLOBAL - we no longer need to manipulate PayMIX/BEE batch status;
1688: -- but we still need to manipulate HXT_BATCH_STATES
1689: UPDATE hxt_batch_states
1690: SET status = 'H'
1691: WHERE batch_id = p_batch_id;
1692: -- step 1 - delete retro_batch lines for any timecards in this (regular) batch.

Line 1689: UPDATE hxt_batch_states

1685: -- Update Batch status
1686: --
1687: --BEGIN GLOBAL - we no longer need to manipulate PayMIX/BEE batch status;
1688: -- but we still need to manipulate HXT_BATCH_STATES
1689: UPDATE hxt_batch_states
1690: SET status = 'H'
1691: WHERE batch_id = p_batch_id;
1692: -- step 1 - delete retro_batch lines for any timecards in this (regular) batch.
1693: --Then we loop through the cursor and delete the batch lines and batches as follows.

Line 1730: -- step 4 - SET the date_earned (Process Date) back to NULL on the hxt_batch_states table

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
1731: UPDATE hxt_batch_states
1732: SET date_earned = NULL
1733: WHERE batch_id = p_batch_id;
1734: --COMMIT;

Line 1731: UPDATE hxt_batch_states

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
1731: UPDATE hxt_batch_states
1732: SET date_earned = NULL
1733: WHERE batch_id = p_batch_id;
1734: --COMMIT;
1735: p_rollback_retcode := 0;