eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_EXTR dependencies on PJI_PROCESS_UTIL

Line 18: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_FND(p_worker_id);')) then

14: begin
15:
16: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
17:
18: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_FND(p_worker_id);')) then
19: return;
20: end if;
21:
22: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 169: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_FND(p_worker_id);');

165: AND agr.customer_id = cust.customer_id
166: -- AND NVL(cust.bill_another_project_flag,'N') <> 'Y' -- ER 6519955
167: AND pf.date_allocated is not null;
168:
169: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_FND(p_worker_id);');
170:
171: commit;
172:
173: end EXTRACT_BATCH_FND;

Line 187: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

183: begin
184:
185: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
186:
187: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
188: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_PRE(p_worker_id);')) then
189: return;
190: end if;
191:

Line 208: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

204: PJI_FM_EXTR_FUNDG
205: where
206: PJI_SUMMARIZED_FLAG is not null;
207:
208: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
209: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_PRE(p_worker_id);');
210:
211: commit;
212:

Line 231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);')) then

227: begin
228:
229: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
230:
231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);')) then
232: return;
233: end if;
234:
235: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 235: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);')) then
232: return;
233: end if;
234:
235: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
236: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
237:
238: select count(*)
239: into l_leftover_batches

Line 316: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

312: l_helper_batch_id := -1;
313:
314: else
315:
316: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
317:
318: end if;
319:
320: end if;

Line 336: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

332: end loop;
333:
334: if (l_helper_batch_id <> -2) then
335:
336: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
337: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);');
338:
339: end if;
340:

Line 357: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

353: begin
354:
355: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
356:
357: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
358: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_POST(p_worker_id);')) then
359: return;
360: end if;
361:

Line 362: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

358: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_POST(p_worker_id);')) then
359: return;
360: end if;
361:
362: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
363: 'PJI_HELPER_BATCH_MAP',
364: 'NORMAL',
365: null);
366:

Line 367: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

363: 'PJI_HELPER_BATCH_MAP',
364: 'NORMAL',
365: null);
366:
367: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
368: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_POST(p_worker_id);');
369:
370: commit;
371:

Line 390: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);')) then

386: begin
387:
388: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
389:
390: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);')) then
391: return;
392: end if;
393:
394: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 397: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,

393:
394: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
395:
396: l_transition_flag :=
397: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
398: 'TRANSITION');
399:
400: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DREVN
401: (

Line 638: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);');

634: and to_date(log.attribute6, PJI_FM_SUM_MAIN.g_date_mask)
635: between glprd.START_DATE and glprd.END_DATE
636: ;
637:
638: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);');
639:
640: commit;
641:
642: end EXTRACT_BATCH_DREV;

Line 656: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

652: begin
653:
654: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
655:
656: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
657: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_PRE(p_worker_id);')) then
658: return;
659: end if;
660:

Line 679: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

675: (LINE_SOURCE_TYPE = 'R' and
676: PJI_SUMMARIZED_FLAG is not null) or
677: (LINE_SOURCE_TYPE = 'L');
678:
679: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
680: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_PRE(p_worker_id);');
681:
682: commit;
683:

Line 702: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);')) then

698: begin
699:
700: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
701:
702: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);')) then
703: return;
704: end if;
705:
706: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 706: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

702: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);')) then
703: return;
704: end if;
705:
706: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
707: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
708:
709: select count(*)
710: into l_leftover_batches

Line 796: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

792: l_helper_batch_id := -1;
793:
794: else
795:
796: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
797:
798: end if;
799:
800: end if;

Line 816: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

812: end loop;
813:
814: if (l_helper_batch_id <> -2) then
815:
816: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
817: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);');
818:
819: end if;
820:

Line 837: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

833: begin
834:
835: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
836:
837: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
838: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_POST(p_worker_id);')) then
839: return;
840: end if;
841:

Line 842: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

838: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_POST(p_worker_id);')) then
839: return;
840: end if;
841:
842: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
843: 'PJI_HELPER_BATCH_MAP',
844: 'NORMAL',
845: null);
846:

Line 847: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

843: 'PJI_HELPER_BATCH_MAP',
844: 'NORMAL',
845: null);
846:
847: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
848: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_POST(p_worker_id);');
849:
850: commit;
851:

Line 869: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);')) then

865: begin
866:
867: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
868:
869: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);')) then
870: return;
871: end if;
872:
873: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 880: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

876: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then
877:
878: -- This cleanup is intentionally before the implicit commit so as not
879: -- to interfere with the CDL extraction.
880: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
881: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROJ_PERF_FLAG'),
882: 'N') = 'N' and
883: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
884: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),

Line 883: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

879: -- to interfere with the CDL extraction.
880: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
881: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROJ_PERF_FLAG'),
882: 'N') = 'N' and
883: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
884: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),
885: 'N') = 'N' and
886: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
887: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),

Line 886: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

882: 'N') = 'N' and
883: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
884: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),
885: 'N') = 'N' and
886: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
887: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
888: 'N') = 'N') then
889: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
890: from PA_PJI_PROJ_EVENTS_LOG log

Line 894: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

890: from PA_PJI_PROJ_EVENTS_LOG log
891: where EVENT_TYPE = 'DRAFT_REVENUES';
892: end if;
893:
894: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
895: 'CURRENT_BATCH') = 1) then
896: -- implicit commit
897: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
898: tabname => 'PJI_FM_EXTR_DREVN',

Line 1341: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);');

1337: ;
1338:
1339: end if; -- EXTRACTION_TYPE = 'FULL'
1340:
1341: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);');
1342:
1343: commit;
1344:
1345: end EXTRACT_BATCH_CDL_CRDL_FULL;

Line 1362: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);')) then

1358: begin
1359:
1360: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1361:
1362: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);')) then
1363: return;
1364: end if;
1365:
1366: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 1545: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);');

1541: ;
1542:
1543: end if; -- EXTRACTION_TYPE = 'FULL'
1544:
1545: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);');
1546:
1547: commit;
1548:
1549: end EXTRACT_BATCH_ERDL_FULL;

Line 1566: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);')) then

1562: begin
1563:
1564: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1565:
1566: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);')) then
1567: return;
1568: end if;
1569:
1570: if (PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then

Line 1671: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);');

1667: );
1668:
1669: end if;
1670:
1671: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);');
1672:
1673: commit;
1674:
1675: end EXTRACT_BATCH_CDL_ROWIDS;

Line 1690: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);')) then

1686: begin
1687:
1688: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1689:
1690: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);')) then
1691: return;
1692: end if;
1693:
1694: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then

Line 1696: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

1692: end if;
1693:
1694: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
1695:
1696: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
1697: 'CURRENT_BATCH') = 1) then
1698: -- implicit commit
1699: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1700: tabname => 'PJI_FM_EXTR_DREVN',

Line 1757: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);');

1753: -- and NVL(cust.bill_another_project_flag,'N') <> 'Y'; -- ER 6519955
1754:
1755: end if; -- EXTRACTION_TYPE <> 'FULL'
1756:
1757: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);');
1758:
1759: commit;
1760:
1761: end EXTRACT_BATCH_CRDL_ROWIDS;

Line 1776: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);')) then

1772: begin
1773:
1774: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1775:
1776: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);')) then
1777: return;
1778: end if;
1779:
1780: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then

Line 1859: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);');

1855: ;
1856:
1857: end if; -- EXTRACTION_TYPE <> 'FULL'
1858:
1859: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);');
1860:
1861: commit;
1862:
1863: end EXTRACT_BATCH_ERDL_ROWIDS;

Line 1880: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);')) then

1876: begin
1877:
1878: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1879:
1880: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);')) then
1881: return;
1882: end if;
1883:
1884: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 1891: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1887: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
1888:
1889: -- This cleanup is intentionally before the implicit commit so as not
1890: -- to interfere with the CDL extraction.
1891: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1892: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROJ_PERF_FLAG'),
1893: 'N') = 'N' and
1894: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1895: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),

Line 1894: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1890: -- to interfere with the CDL extraction.
1891: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1892: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROJ_PERF_FLAG'),
1893: 'N') = 'N' and
1894: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1895: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),
1896: 'N') = 'N' and
1897: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1898: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),

Line 1897: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1893: 'N') = 'N' and
1894: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1895: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),
1896: 'N') = 'N' and
1897: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1898: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
1899: 'N') = 'N') then
1900: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
1901: from PA_PJI_PROJ_EVENTS_LOG log

Line 1916: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

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,
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',

Line 2346: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');

2342: ;
2343:
2344: end if; -- EXTRACTION_TYPE <> 'FULL'
2345:
2346: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');
2347:
2348: -- truncate intermediate tables no longer required
2349: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2350: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);

Line 2350: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);

2346: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');
2347:
2348: -- truncate intermediate tables no longer required
2349: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2350: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);
2351:
2352: commit;
2353:
2354: end EXTRACT_BATCH_CDL_AND_CRDL;

Line 2368: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

2364: begin
2365:
2366: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2367:
2368: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2369: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);')) then
2370: return;
2371: end if;
2372:

Line 2389: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2385: PJI_FM_REXT_CDL
2386: where
2387: PJI_SUMMARIZED_FLAG is not null;
2388:
2389: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2390: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);');
2391:
2392: commit;
2393:

Line 2412: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);')) then

2408: begin
2409:
2410: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2411:
2412: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);')) then
2413: return;
2414: end if;
2415:
2416: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 2416: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2412: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);')) then
2413: return;
2414: end if;
2415:
2416: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2417: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
2418:
2419: select count(*)
2420: into l_leftover_batches

Line 2497: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

2493: l_helper_batch_id := -1;
2494:
2495: else
2496:
2497: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
2498:
2499: end if;
2500:
2501: end if;

Line 2517: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2513: end loop;
2514:
2515: if (l_helper_batch_id <> -2) then
2516:
2517: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2518: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);');
2519:
2520: end if;
2521:

Line 2538: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

2534: begin
2535:
2536: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2537:
2538: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2539: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);')) then
2540: return;
2541: end if;
2542:

Line 2543: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

2539: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);')) then
2540: return;
2541: end if;
2542:
2543: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
2544: 'PJI_HELPER_BATCH_MAP',
2545: 'NORMAL',
2546: null);
2547:

Line 2548: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2544: 'PJI_HELPER_BATCH_MAP',
2545: 'NORMAL',
2546: null);
2547:
2548: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
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,

Line 2552: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

2548: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
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;

Line 2574: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);')) then

2570: begin
2571:
2572: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2573:
2574: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);')) then
2575: return;
2576: end if;
2577:
2578: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 2583: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2579: PJI_FM_SUM_MAIN.g_date_mask);
2580:
2581: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
2582:
2583: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2584: 'CURRENT_BATCH') = 1) then
2585: -- implicit commit
2586: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
2587: tabname => 'PJI_FM_REXT_ERDL',

Line 2848: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');

2844: ;
2845:
2846: end if; -- EXTRACTION_TYPE <> 'FULL'
2847:
2848: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');
2849:
2850: -- truncate intermediate tables no longer required
2851: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2852: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);

Line 2852: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);

2848: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');
2849:
2850: -- truncate intermediate tables no longer required
2851: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2852: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);
2853:
2854: commit;
2855:
2856: end EXTRACT_BATCH_ERDL;

Line 2873: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);')) then

2869: begin
2870:
2871: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2872:
2873: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);')) then
2874: return;
2875: end if;
2876:
2877: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 3157: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);');

3153: and dinv.system_reference is not null
3154: and dinv.system_reference <> 0
3155: and dinv.agreement_id = agr.agreement_id;
3156:
3157: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);');
3158:
3159: commit;
3160:
3161: end EXTRACT_BATCH_DINV;

Line 3176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);')) then

3172:
3173: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3174: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3175:
3176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);')) then
3177: return;
3178: end if;
3179:
3180: UPDATE pa_draft_invoices_all dinv

Line 3195: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);');

3191: l_extraction_type <> 'INCREMENTAL'
3192: )
3193: ;
3194:
3195: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);');
3196:
3197: commit;
3198:
3199: end MARK_EXTRACTED_DINV_ROWS;

Line 3216: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);')) then

3212: begin
3213:
3214: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3215:
3216: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);')) then
3217: return;
3218: end if;
3219:
3220: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

Line 3220: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

3216: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);')) then
3217: return;
3218: end if;
3219:
3220: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
3221: 'CURRENT_BATCH') = 1) then
3222: -- implicit commit
3223: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3224: tabname => 'PJI_FM_EXTR_DINVC',

Line 3472: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);');

3468: part.worker_id = p_worker_id
3469: and part.gl_date is not null
3470: and part.pa_date is not null;
3471:
3472: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);');
3473:
3474: commit;
3475:
3476: end EXTRACT_BATCH_DINVITEM;

Line 3491: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);')) then

3487: begin
3488:
3489: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3490:
3491: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);')) then
3492: return;
3493: end if;
3494:
3495: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 3568: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);');

3564: ar.due_date,
3565: trx.bill_to_customer_id,
3566: part.pji_summarized_flag);
3567:
3568: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);');
3569:
3570: commit;
3571:
3572: end EXTRACT_BATCH_ARINV;

Line 3586: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

3582: begin
3583:
3584: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3585:
3586: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
3587: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);')) then
3588: return;
3589: end if;
3590:

Line 3607: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

3603: PJI_FM_EXTR_ARINV
3604: where
3605: PJI_SUMMARIZED_FLAG = 'O';
3606:
3607: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
3608: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);');
3609:
3610: commit;
3611:

Line 3630: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);')) then

3626: begin
3627:
3628: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3629:
3630: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);')) then
3631: return;
3632: end if;
3633:
3634: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 3634: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3630: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);')) then
3631: return;
3632: end if;
3633:
3634: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3635: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
3636:
3637: select count(*)
3638: into l_leftover_batches

Line 3717: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

3713: l_helper_batch_id := -1;
3714:
3715: else
3716:
3717: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
3718:
3719: end if;
3720:
3721: end if;

Line 3737: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

3733: end loop;
3734:
3735: if (l_helper_batch_id <> -2) then
3736:
3737: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
3738: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);');
3739:
3740: end if;
3741:

Line 3758: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

3754: begin
3755:
3756: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3757:
3758: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
3759: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);')) then
3760: return;
3761: end if;
3762:

Line 3763: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

3759: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);')) then
3760: return;
3761: end if;
3762:
3763: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
3764: 'PJI_HELPER_BATCH_MAP',
3765: 'NORMAL',
3766: null);
3767:

Line 3768: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

3764: 'PJI_HELPER_BATCH_MAP',
3765: 'NORMAL',
3766: null);
3767:
3768: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
3769: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);');
3770:
3771: commit;
3772:

Line 3787: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);

3783: begin
3784:
3785: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3786:
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);

Line 3789: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);

3785: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3786:
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);

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);

Line 3793: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);

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);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);

Line 3795: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);

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);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);

Line 3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);

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);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3800:
3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);

Line 3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);

3795: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3800:
3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3802:
3803: end CLEANUP;

Line 3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);

3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3800:
3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3802:
3803: end CLEANUP;
3804:
3805: end PJI_FM_EXTR;