APPS.PJI_FM_EXTR dependencies on PJI_FM_REXT_CDL

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

1561: end if;
1562:
1563: if (PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then
1564:
1565: insert /*+ append */ into PJI_FM_REXT_CDL
1566: (
1567: WORKER_ID
1568: , CDL_ROWID
1569: , START_DATE

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

1592: cdl.PJI_SUMMARIZED_FLAG = 'N';
1593:
1594: else
1595:
1596: INSERT /*+ APPEND */ INTO PJI_FM_REXT_CDL
1597: (
1598: WORKER_ID
1599: , CDL_ROWID
1600: , START_DATE

Line 1900: from PJI_FM_REXT_CDL

1896: end if;
1897:
1898: -- delete Non-Util --> Util resources that are getting extracted anyway
1899: delete
1900: from PJI_FM_REXT_CDL
1901: where WORKER_ID = p_worker_id and
1902: PROJECT_ORG_ID = -1 and
1903: PROJECT_ORGANIZATION_ID = -1 and
1904: CDL_ROWID in (select CDL_ROWID

Line 1905: from PJI_FM_REXT_CDL

1901: where WORKER_ID = p_worker_id and
1902: PROJECT_ORG_ID = -1 and
1903: PROJECT_ORGANIZATION_ID = -1 and
1904: CDL_ROWID in (select CDL_ROWID
1905: from PJI_FM_REXT_CDL
1906: where WORKER_ID = p_worker_id and
1907: PROJECT_ORGANIZATION_ID <> -1);
1908:
1909: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

Line 1913: tabname => 'PJI_FM_REXT_CDL',

1909: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
1910: 'CURRENT_BATCH') = 1) then
1911: -- implicit commit
1912: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1913: tabname => 'PJI_FM_REXT_CDL',
1914: percent => 10,
1915: degree => PJI_UTILS.
1916: GET_DEGREE_OF_PARALLELISM);
1917: -- implicit commit

Line 2175: PJI_FM_REXT_CDL scope

2171: , decode(cdl.Billable_Flag
2172: , 'Y', cdl.Quantity
2173: , 0) AS BILL_QUANTITY
2174: FROM
2175: PJI_FM_REXT_CDL scope
2176: , pa_cost_distribution_lines_all cdl
2177: , pa_expenditure_items_all ei
2178: , pa_expenditures_all exp
2179: , pa_expenditure_types et

Line 2372: PJI_FM_REXT_CDL

2368: BATCH_ID,
2369: null,
2370: null
2371: from
2372: PJI_FM_REXT_CDL
2373: where
2374: PJI_SUMMARIZED_FLAG is not null;
2375:
2376: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 2447: from PJI_FM_REXT_CDL cdl

2443: update PA_COST_DISTRIBUTION_LINES_ALL cdl
2444: set cdl.PJI_SUMMARIZED_FLAG = null
2445: where cdl.ROWID in (select /*+ cardinality(cdl, 1) */
2446: cdl.CDL_ROWID
2447: from PJI_FM_REXT_CDL cdl
2448: where cdl.PJI_SUMMARIZED_FLAG = 'N' and
2449: cdl.BATCH_ID = l_helper_batch_id);
2450:
2451: update PJI_HELPER_BATCH_MAP

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

2536: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);');
2537:
2538: if (PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then
2539: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
2540: 'PJI_FM_REXT_CDL', 'NORMAL',null);
2541: end if;
2542:
2543: commit;
2544:

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

3774: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);
3775:
3776: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);
3777:
3778: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);
3779:
3780: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);
3781:
3782: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);