APPS.PJI_FM_EXTR dependencies on PJI_FM_REXT_CDL

Line 1572: insert /*+ append */ into PJI_FM_REXT_CDL

1568: end if;
1569:
1570: if (PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then
1571:
1572: insert /*+ append */ into PJI_FM_REXT_CDL
1573: (
1574: WORKER_ID
1575: , CDL_ROWID
1576: , START_DATE

Line 1603: INSERT /*+ APPEND */ INTO PJI_FM_REXT_CDL

1599: cdl.PJI_SUMMARIZED_FLAG = 'N';
1600:
1601: else
1602:
1603: INSERT /*+ APPEND */ INTO PJI_FM_REXT_CDL
1604: (
1605: WORKER_ID
1606: , CDL_ROWID
1607: , START_DATE

Line 1907: from PJI_FM_REXT_CDL

1903: end if;
1904:
1905: -- delete Non-Util --> Util resources that are getting extracted anyway
1906: delete
1907: from PJI_FM_REXT_CDL
1908: where WORKER_ID = p_worker_id and
1909: PROJECT_ORG_ID = -1 and
1910: PROJECT_ORGANIZATION_ID = -1 and
1911: CDL_ROWID in (select CDL_ROWID

Line 1912: from PJI_FM_REXT_CDL

1908: where WORKER_ID = p_worker_id and
1909: PROJECT_ORG_ID = -1 and
1910: PROJECT_ORGANIZATION_ID = -1 and
1911: CDL_ROWID in (select CDL_ROWID
1912: from PJI_FM_REXT_CDL
1913: where WORKER_ID = p_worker_id and
1914: PROJECT_ORGANIZATION_ID <> -1);
1915:
1916: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

Line 1920: tabname => 'PJI_FM_REXT_CDL',

1916: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
1917: 'CURRENT_BATCH') = 1) then
1918: -- implicit commit
1919: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1920: tabname => 'PJI_FM_REXT_CDL',
1921: percent => 10,
1922: degree => PJI_UTILS.
1923: GET_DEGREE_OF_PARALLELISM);
1924: -- implicit commit

Line 2186: PJI_FM_REXT_CDL scope

2182: , 'Y', decode(cdl.line_type,'R',cdl.Quantity,0)
2183: , 0) AS BILL_QUANTITY /* Modified for bug 9777532 */
2184: ,cdl.CBS_ELEMENT_ID AS CBS_ELEMENT_ID /* Added for CBS Changes */
2185: FROM
2186: PJI_FM_REXT_CDL scope
2187: , pa_cost_distribution_lines_all cdl
2188: , pa_expenditure_items_all ei
2189: , pa_expenditures_all exp
2190: , pa_expenditure_types et

Line 2385: PJI_FM_REXT_CDL

2381: BATCH_ID,
2382: null,
2383: null
2384: from
2385: PJI_FM_REXT_CDL
2386: where
2387: PJI_SUMMARIZED_FLAG is not null;
2388:
2389: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 2460: from PJI_FM_REXT_CDL cdl

2456: update PA_COST_DISTRIBUTION_LINES_ALL cdl
2457: set cdl.PJI_SUMMARIZED_FLAG = null
2458: where cdl.ROWID in (select /*+ cardinality(cdl, 1) */
2459: cdl.CDL_ROWID
2460: from PJI_FM_REXT_CDL cdl
2461: where cdl.PJI_SUMMARIZED_FLAG = 'N' and
2462: cdl.BATCH_ID = l_helper_batch_id);
2463:
2464: update PJI_HELPER_BATCH_MAP

Line 2553: 'PJI_FM_REXT_CDL', 'NORMAL',null);

2549: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);');
2550:
2551: if (PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then
2552: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
2553: 'PJI_FM_REXT_CDL', 'NORMAL',null);
2554: end if;
2555:
2556: commit;
2557:

Line 3791: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);

3787: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);
3788:
3789: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);
3790:
3791: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);
3792:
3793: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);
3794:
3795: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);