APPS.PJI_FM_PLAN_EXTR dependencies on PJI_HELPER_BATCH_MAP

Line 2396: insert /*+ append */ into PJI_HELPER_BATCH_MAP

2392: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);')) then
2393: return;
2394: end if;
2395:
2396: insert /*+ append */ into PJI_HELPER_BATCH_MAP
2397: (
2398: BATCH_ID,
2399: WORKER_ID,
2400: STATUS

Line 2445: from PJI_HELPER_BATCH_MAP

2441: (PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
2442:
2443: select count(*)
2444: into l_leftover_batches
2445: from PJI_HELPER_BATCH_MAP
2446: where WORKER_ID = p_worker_id and
2447: STATUS = 'P';
2448:
2449: l_helper_batch_id := 0;

Line 2459: from PJI_HELPER_BATCH_MAP

2455: l_leftover_batches := l_leftover_batches - 1;
2456:
2457: select BATCH_ID
2458: into l_helper_batch_id
2459: from PJI_HELPER_BATCH_MAP
2460: where WORKER_ID = p_worker_id and
2461: STATUS = 'P' and
2462: ROWNUM = 1;
2463:

Line 2466: update PJI_HELPER_BATCH_MAP

2462: ROWNUM = 1;
2463:
2464: else
2465:
2466: update PJI_HELPER_BATCH_MAP
2467: set WORKER_ID = p_worker_id,
2468: STATUS = 'P'
2469: where WORKER_ID is null and
2470: ROWNUM = 1

Line 2527: update PJI_HELPER_BATCH_MAP

2523: where WORKER_ID = 1 and
2524: BATCH_ID = l_helper_batch_id)
2525: and map.worker_id = 1;
2526:
2527: update PJI_HELPER_BATCH_MAP
2528: set STATUS = 'C'
2529: where WORKER_ID = p_worker_id and
2530: BATCH_ID = l_helper_batch_id;
2531:

Line 2538: from PJI_HELPER_BATCH_MAP

2534: else
2535:
2536: select count(*)
2537: into l_row_count
2538: from PJI_HELPER_BATCH_MAP
2539: where nvl(STATUS, 'X') <> 'C';
2540:
2541: if (l_row_count = 0) then
2542:

Line 2607: 'PJI_HELPER_BATCH_MAP',

2603: return;
2604: end if;
2605:
2606: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
2607: 'PJI_HELPER_BATCH_MAP',
2608: 'NORMAL',
2609: null);
2610:
2611: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,