APPS.HXT_BATCH_PROCESS dependencies on HXT_BATCH_STATES

Line 548: UPDATE hxt_batch_states

544: IF g_debug THEN
545: hr_utility.set_location('After updating valid batch name: '||l_valid_batch_name, 50);
546: END IF;
547: BEGIN
548: UPDATE hxt_batch_states
549: SET status = 'VV'
550: WHERE batch_id = l_valid_batch_id; /* For updating the status of the newly created batch */
551: END;
552: IF g_debug THEN

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

549: SET status = 'VV'
550: WHERE batch_id = l_valid_batch_id; /* For updating the status of the newly created batch */
551: END;
552: IF g_debug THEN
553: hr_utility.set_location('After updating valid batch status in hxt_batch_states', 60);
554: END IF;
555: END IF;
556:
557: l_temp_batch_upd_id := l_valid_batch_id;

Line 592: UPDATE hxt_batch_states

588: IF g_debug THEN
589: hr_utility.set_location('After updating warning batch name: '||l_warning_batch_name, 90);
590: END IF;
591: BEGIN
592: UPDATE hxt_batch_states
593: SET status = 'VW'
594: WHERE batch_id = l_warning_batch_id; /* For updating the status of the newly created batch */
595: END;
596: IF g_debug THEN

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

593: SET status = 'VW'
594: WHERE batch_id = l_warning_batch_id; /* For updating the status of the newly created batch */
595: END;
596: IF g_debug THEN
597: hr_utility.set_location('After updating warning batch status in hxt_batch_states', 100);
598: END IF;
599: END IF;
600:
601: l_temp_batch_upd_id := l_warning_batch_id;

Line 637: UPDATE hxt_batch_states

633: IF g_debug THEN
634: hr_utility.set_location('After updating error batch name: '||l_error_batch_name, 130);
635: END IF;
636: BEGIN
637: UPDATE hxt_batch_states
638: SET status = 'VE'
639: WHERE batch_id = l_error_batch_id; /* For updating the status of the newly created batch */
640: END;
641: IF g_debug THEN

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

638: SET status = 'VE'
639: WHERE batch_id = l_error_batch_id; /* For updating the status of the newly created batch */
640: END;
641: IF g_debug THEN
642: hr_utility.set_location('After updating error batch status in hxt_batch_states', 140);
643: END IF;
644: END IF;
645:
646: l_temp_batch_upd_id := l_error_batch_id;

Line 781: DELETE FROM hxt_batch_states

777: hr_utility.set_location('After deleting empty batches', 180);
778: END IF;
779:
780: BEGIN
781: DELETE FROM hxt_batch_states
782: WHERE batch_id = p_del_empty_batches(l_loop_index2).batch_id;
783: END;
784:
785: IF g_debug THEN

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

782: WHERE batch_id = p_del_empty_batches(l_loop_index2).batch_id;
783: END;
784:
785: IF g_debug THEN
786: hr_utility.set_location('After deleting empty batches from hxt_batch_states', 190);
787: END IF;
788:
789: l_loop_index2 := p_del_empty_batches.next(l_loop_index2);
790:

Line 832: hxt_batch_states hbs --SIR020

828: hbs.status batch_status, --SIR020
829: pbh.batch_reference ,
830: pbh.object_version_number
831: FROM pay_batch_headers pbh, --GLOBAL
832: hxt_batch_states hbs --SIR020
833: WHERE pbh.business_group_id = p_bus_group_id --GLOBAL
834: AND hbs.batch_id = pbh.batch_id --SIR020
835: AND pbh.batch_id BETWEEN nvl(c_batch_num,0)
836: AND nvl(c_batch_num,999999999999)

Line 2661: UPDATE hxt_batch_states

2657: p_batch_id NUMBER,
2658: p_status VARCHAR2 )IS
2659: BEGIN
2660: IF (p_status = 'VT' AND p_date_earned IS NOT NULL) THEN
2661: UPDATE hxt_batch_states
2662: SET date_earned = p_date_earned
2663: WHERE batch_id = p_batch_id;
2664: END IF;
2665: UPDATE hxt_batch_states

Line 2665: UPDATE hxt_batch_states

2661: UPDATE hxt_batch_states
2662: SET date_earned = p_date_earned
2663: WHERE batch_id = p_batch_id;
2664: END IF;
2665: UPDATE hxt_batch_states
2666: SET status = p_status
2667: WHERE batch_id = p_batch_id;
2668: --COMMIT;
2669: END Set_batch_status;

Line 2678: FROM hxt_batch_states

2674: l_batch_status VARCHAR2(10);
2675: BEGIN
2676: SELECT status
2677: INTO l_batch_status
2678: FROM hxt_batch_states
2679: WHERE batch_id = p_batch_id;
2680: p_batch_status := l_batch_status;
2681: IF l_batch_status in ('E','VE') THEN
2682: return(2);

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

2791: end loop;
2792: -- Update Batch status
2793: --
2794: --BEGIN GLOBAL - we no longer need to manipulate PayMIX/BEE batch status;
2795: -- but we still need to manipulate HXT_BATCH_STATES
2796: UPDATE hxt_batch_states
2797: SET status = 'H'
2798: WHERE batch_id = p_batch_id;
2799:

Line 2796: UPDATE hxt_batch_states

2792: -- Update Batch status
2793: --
2794: --BEGIN GLOBAL - we no longer need to manipulate PayMIX/BEE batch status;
2795: -- but we still need to manipulate HXT_BATCH_STATES
2796: UPDATE hxt_batch_states
2797: SET status = 'H'
2798: WHERE batch_id = p_batch_id;
2799:
2800: IF g_debug

Line 2802: hr_utility.trace( 'updated hxt_batch_states for this batch ');

2798: WHERE batch_id = p_batch_id;
2799:
2800: IF g_debug
2801: THEN
2802: hr_utility.trace( 'updated hxt_batch_states for this batch ');
2803: END IF;
2804: -- step 1 - delete retro_batch lines for any timecards in this (regular) batch.
2805: --Then we loop through the cursor and delete the batch lines and batches as follows.
2806: FND_FILE.put_line(FND_FILE.log,'=>Picking Retro batches for '||p_batch_id);

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

2885:
2886: END IF;
2887:
2888:
2889: -- step 4 - SET the date_earned (Process Date) back to NULL on the hxt_batch_states table
2890: UPDATE hxt_batch_states
2891: SET date_earned = NULL
2892: WHERE batch_id = p_batch_id;
2893: --COMMIT;

Line 2890: UPDATE hxt_batch_states

2886: END IF;
2887:
2888:
2889: -- step 4 - SET the date_earned (Process Date) back to NULL on the hxt_batch_states table
2890: UPDATE hxt_batch_states
2891: SET date_earned = NULL
2892: WHERE batch_id = p_batch_id;
2893: --COMMIT;
2894: p_rollback_retcode := 0;