APPS.PJI_RM_SUM_EXTR dependencies on PJI_HELPER_BATCH_MAP

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

1481: 'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS_PRE(p_worker_id);')) then
1482: return;
1483: end if;
1484:
1485: insert /*+ append */ into PJI_HELPER_BATCH_MAP
1486: (
1487: BATCH_ID,
1488: WORKER_ID,
1489: STATUS

Line 1547: update PJI_HELPER_BATCH_MAP

1543: l_helper_batch_id := 0;
1544:
1545: while (l_helper_batch_id <> -1) loop
1546:
1547: update PJI_HELPER_BATCH_MAP
1548: set WORKER_ID = p_worker_id,
1549: STATUS = 'P'
1550: where WORKER_ID is null and
1551: ROWNUM = 1

Line 1580: update PJI_HELPER_BATCH_MAP

1576: fcst.PJI_SUMMARIZED_FLAG = 'N' and
1577: fcst.BATCH_ID = l_helper_batch_id
1578: );
1579:
1580: update PJI_HELPER_BATCH_MAP
1581: set STATUS = 'C'
1582: where WORKER_ID = p_worker_id and
1583: BATCH_ID = l_helper_batch_id;
1584:

Line 1591: from PJI_HELPER_BATCH_MAP

1587: else
1588:
1589: select count(*)
1590: into l_row_count
1591: from PJI_HELPER_BATCH_MAP
1592: where nvl(STATUS, 'X') <> 'C';
1593:
1594: if (l_row_count = 0) then
1595:

Line 1646: 'PJI_HELPER_BATCH_MAP',

1642: return;
1643: end if;
1644:
1645: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
1646: 'PJI_HELPER_BATCH_MAP',
1647: 'NORMAL',
1648: null);
1649:
1650: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION (l_process,