APPS.PJI_PROCESS_UTIL dependencies on PJI_BATCH_STATUS_420

Line 44882: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',l_partition_name);

44878:
44879: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
44880:
44881: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_HELPER_420','NORMAL',l_partition_name);
44882: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',l_partition_name);
44883:
44884:
44885: insert into pji_helper_420 (worker_id, project_id, batch_id, level_420, partial_mode_420, fpm_upgrade_420)
44886: (select worker_id, project_id, ceil(ROWNUM / l_batch_size) batch_id, l_level, l_partial_mode, l_fpm_upgrade

Line 44914: insert into pji_batch_status_420

44910: );
44911: commit;
44912:
44913: if l_request_id > 0 then
44914: insert into pji_batch_status_420
44915: (worker_id,batch_id,request_id,request_status)
44916: values(rec.worker_id,rec.batch_id,l_request_id,'RUNNING');
44917: commit;
44918:

Line 44937: from pji_batch_status_420

44933:
44934: UPDATE_BATCH_CONC_STATUS_420;
44935:
44936: select count(*) into l_run_count
44937: from pji_batch_status_420
44938: where request_status = 'RUNNING';
44939:
44940: end loop;
44941: end if; -- _conc_count >= l_parallel_proc

Line 44957: from pji_batch_status_420

44953:
44954: UPDATE_BATCH_CONC_STATUS_420;
44955:
44956: select count(*) into l_run_count
44957: from pji_batch_status_420
44958: where request_status = 'RUNNING';
44959:
44960: end loop;
44961:

Line 44964: from pji_batch_status_420

44960: end loop;
44961:
44962: /* Error check */
44963: select count(*) into l_error_count
44964: from pji_batch_status_420
44965: where request_status = 'ERRORED';
44966:
44967: if l_error_count > 0 then
44968: raise_application_error(-20010,'Helper 420 has failed');

Line 44970: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',null);

44966:
44967: if l_error_count > 0 then
44968: raise_application_error(-20010,'Helper 420 has failed');
44969: else
44970: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',null);
44971: end if;
44972:
44973: end if;
44974:

Line 44987: TYPE Batch_t IS TABLE OF pji_batch_status_420%ROWTYPE

44983:
44984: PROCEDURE UPDATE_BATCH_CONC_STATUS_420 IS
44985: l_rowcount number := 0;
44986:
44987: TYPE Batch_t IS TABLE OF pji_batch_status_420%ROWTYPE
44988: INDEX BY BINARY_INTEGER;
44989: l_Batch_t Batch_t;
44990:
44991: CURSOR batch IS

Line 44992: SELECT * FROM pji_batch_status_420

44988: INDEX BY BINARY_INTEGER;
44989: l_Batch_t Batch_t;
44990:
44991: CURSOR batch IS
44992: SELECT * FROM pji_batch_status_420
44993: WHERE request_status = 'RUNNING';
44994:
44995: BEGIN
44996: l_Batch_t.delete;

Line 45024: update pji_batch_status_420

45020: END LOOP; --for loop
45021:
45022: FOR i IN l_Batch_t.first..l_Batch_t.last LOOP
45023:
45024: update pji_batch_status_420
45025: set request_status = l_Batch_t(i).request_status
45026: where request_id = l_Batch_t(i).request_id;
45027: commit;
45028:

Line 46590: update pji_batch_status_420

46586: delete
46587: from pji_helper_420
46588: where batch_id = p_batch_id;
46589:
46590: update pji_batch_status_420
46591: set request_status = 'COMPLETED'
46592: where batch_id = p_batch_id;
46593:
46594: commit;