APPS.PJI_FM_CMT_EXTR dependencies on PJI_HELPER_BATCH_MAP

Line 710: insert into PJI_HELPER_BATCH_MAP

706: -- PA_CHECK_COMMITMENTS.COMMITMENTS_CHANGED(cmt.PROJECT_ID) = 'Y'
707: order by
708: cmt.PROJECT_ID;
709:
710: insert into PJI_HELPER_BATCH_MAP
711: (
712: BATCH_ID,
713: WORKER_ID,
714: STATUS

Line 809: from PJI_HELPER_BATCH_MAP

805: end if;
806:
807: select count(*)
808: into l_leftover_batches
809: from PJI_HELPER_BATCH_MAP
810: where WORKER_ID = p_worker_id and
811: STATUS = 'P';
812:
813: l_helper_batch_id := 0;

Line 823: from PJI_HELPER_BATCH_MAP

819: l_leftover_batches := l_leftover_batches - 1;
820:
821: select BATCH_ID
822: into l_helper_batch_id
823: from PJI_HELPER_BATCH_MAP
824: where WORKER_ID = p_worker_id and
825: STATUS = 'P' and
826: ROWNUM = 1;
827:

Line 830: update PJI_HELPER_BATCH_MAP

826: ROWNUM = 1;
827:
828: else
829:
830: update PJI_HELPER_BATCH_MAP
831: set WORKER_ID = p_worker_id,
832: STATUS = 'P'
833: where WORKER_ID is null and
834: ROWNUM = 1

Line 945: update PJI_HELPER_BATCH_MAP

941: end;
942:
943: end loop;
944:
945: update PJI_HELPER_BATCH_MAP
946: set STATUS = 'C'
947: where WORKER_ID = p_worker_id and
948: BATCH_ID = l_helper_batch_id;
949:

Line 957: from PJI_HELPER_BATCH_MAP

953: else
954:
955: select count(*)
956: into l_row_count
957: from PJI_HELPER_BATCH_MAP
958: where nvl(STATUS, 'X') <> 'C';
959:
960: if (l_row_count = 0) then
961:

Line 1049: 'PJI_HELPER_BATCH_MAP',

1045: 'NORMAL',
1046: null);
1047:
1048: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1049: 'PJI_HELPER_BATCH_MAP',
1050: 'NORMAL',
1051: null);
1052:
1053: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,