DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_MERGE_BATCH_STATUS

Line 5478: TYPE Batch_t IS TABLE OF pji_merge_batch_status%ROWTYPE

5474:
5475: PROCEDURE UPDATE_BATCH_CONC_STATUS IS
5476: l_rowcount number := 0;
5477:
5478: TYPE Batch_t IS TABLE OF pji_merge_batch_status%ROWTYPE
5479: INDEX BY BINARY_INTEGER;
5480: l_Batch_t Batch_t;
5481:
5482: CURSOR batch IS

Line 5483: SELECT * FROM pji_merge_batch_status

5479: INDEX BY BINARY_INTEGER;
5480: l_Batch_t Batch_t;
5481:
5482: CURSOR batch IS
5483: SELECT * FROM pji_merge_batch_status
5484: WHERE request_status = 'RUNNING';
5485:
5486: BEGIN
5487:

Line 5516: update pji_merge_batch_status

5512: END LOOP; --for loop
5513:
5514: FOR i IN l_Batch_t.first..l_Batch_t.last LOOP
5515:
5516: update pji_merge_batch_status
5517: set request_status = l_Batch_t(i).request_status
5518: where request_id = l_Batch_t(i).request_id;
5519: commit;
5520: