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 1334: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);');

1330: ;
1331:
1332: end if; -- EXTRACTION_TYPE = 'FULL'
1333:
1334: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);');
1335:
1336: commit;
1337:
1338: end EXTRACT_BATCH_CDL_CRDL_FULL;

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

1351: begin
1352:
1353: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1354:
1355: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);')) then
1356: return;
1357: end if;
1358:
1359: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

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

1534: ;
1535:
1536: end if; -- EXTRACTION_TYPE = 'FULL'
1537:
1538: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);');
1539:
1540: commit;
1541:
1542: end EXTRACT_BATCH_ERDL_FULL;

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

1555: begin
1556:
1557: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1558:
1559: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);')) then
1560: return;
1561: end if;
1562:
1563: if (PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') = 'FULL') then

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

1660: );
1661:
1662: end if;
1663:
1664: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);');
1665:
1666: commit;
1667:
1668: end EXTRACT_BATCH_CDL_ROWIDS;

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

1679: begin
1680:
1681: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1682:
1683: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);')) then
1684: return;
1685: end if;
1686:
1687: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then

Line 1689: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

1685: end if;
1686:
1687: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
1688:
1689: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
1690: 'CURRENT_BATCH') = 1) then
1691: -- implicit commit
1692: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1693: tabname => 'PJI_FM_EXTR_DREVN',

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

1746: -- and NVL(cust.bill_another_project_flag,'N') <> 'Y'; -- ER 6519955
1747:
1748: end if; -- EXTRACTION_TYPE <> 'FULL'
1749:
1750: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);');
1751:
1752: commit;
1753:
1754: end EXTRACT_BATCH_CRDL_ROWIDS;

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

1765: begin
1766:
1767: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1768:
1769: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);')) then
1770: return;
1771: end if;
1772:
1773: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then

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

1848: ;
1849:
1850: end if; -- EXTRACTION_TYPE <> 'FULL'
1851:
1852: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);');
1853:
1854: commit;
1855:
1856: end EXTRACT_BATCH_ERDL_ROWIDS;

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

1869: begin
1870:
1871: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1872:
1873: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);')) then
1874: return;
1875: end if;
1876:
1877: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 1884: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1880: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
1881:
1882: -- This cleanup is intentionally before the implicit commit so as not
1883: -- to interfere with the CDL extraction.
1884: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1885: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROJ_PERF_FLAG'),
1886: 'N') = 'N' and
1887: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1888: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),

Line 1887: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1883: -- to interfere with the CDL extraction.
1884: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1885: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROJ_PERF_FLAG'),
1886: 'N') = 'N' and
1887: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1888: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),
1889: 'N') = 'N' and
1890: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1891: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),

Line 1890: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1886: 'N') = 'N' and
1887: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1888: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_COST_FLAG'),
1889: 'N') = 'N' and
1890: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1891: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
1892: 'N') = 'N') then
1893: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
1894: from PA_PJI_PROJ_EVENTS_LOG log

Line 1909: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

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

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

2329: ;
2330:
2331: end if; -- EXTRACTION_TYPE <> 'FULL'
2332:
2333: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');
2334:
2335: -- truncate intermediate tables no longer required
2336: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2337: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);

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

2333: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);');
2334:
2335: -- truncate intermediate tables no longer required
2336: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2337: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL' , 'NORMAL',null);
2338:
2339: commit;
2340:
2341: end EXTRACT_BATCH_CDL_AND_CRDL;

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

2351: begin
2352:
2353: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2354:
2355: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2356: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);')) then
2357: return;
2358: end if;
2359:

Line 2376: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2372: PJI_FM_REXT_CDL
2373: where
2374: PJI_SUMMARIZED_FLAG is not null;
2375:
2376: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2377: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);');
2378:
2379: commit;
2380:

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

2395: begin
2396:
2397: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2398:
2399: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);')) then
2400: return;
2401: end if;
2402:
2403: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 2403: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2399: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);')) then
2400: return;
2401: end if;
2402:
2403: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2404: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
2405:
2406: select count(*)
2407: into l_leftover_batches

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

2480: l_helper_batch_id := -1;
2481:
2482: else
2483:
2484: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
2485:
2486: end if;
2487:
2488: end if;

Line 2504: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2500: end loop;
2501:
2502: if (l_helper_batch_id <> -2) then
2503:
2504: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2505: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);');
2506:
2507: end if;
2508:

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

2521: begin
2522:
2523: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2524:
2525: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2526: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);')) then
2527: return;
2528: end if;
2529:

Line 2530: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

2526: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);')) then
2527: return;
2528: end if;
2529:
2530: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
2531: 'PJI_HELPER_BATCH_MAP',
2532: 'NORMAL',
2533: null);
2534:

Line 2535: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

2531: 'PJI_HELPER_BATCH_MAP',
2532: 'NORMAL',
2533: null);
2534:
2535: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
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,

Line 2539: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

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

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

2557: begin
2558:
2559: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2560:
2561: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);')) then
2562: return;
2563: end if;
2564:
2565: l_min_date := to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 2570: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2566: PJI_FM_SUM_MAIN.g_date_mask);
2567:
2568: if ( PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE') <> 'FULL') then
2569:
2570: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2571: 'CURRENT_BATCH') = 1) then
2572: -- implicit commit
2573: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
2574: tabname => 'PJI_FM_REXT_ERDL',

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

2831: ;
2832:
2833: end if; -- EXTRACTION_TYPE <> 'FULL'
2834:
2835: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');
2836:
2837: -- truncate intermediate tables no longer required
2838: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2839: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);

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

2835: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);');
2836:
2837: -- truncate intermediate tables no longer required
2838: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2839: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL' , 'NORMAL',null);
2840:
2841: commit;
2842:
2843: end EXTRACT_BATCH_ERDL;

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

2856: begin
2857:
2858: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2859:
2860: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);')) then
2861: return;
2862: end if;
2863:
2864: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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

3140: and dinv.system_reference is not null
3141: and dinv.system_reference <> 0
3142: and dinv.agreement_id = agr.agreement_id;
3143:
3144: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);');
3145:
3146: commit;
3147:
3148: end EXTRACT_BATCH_DINV;

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

3159:
3160: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3161: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3162:
3163: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);')) then
3164: return;
3165: end if;
3166:
3167: UPDATE pa_draft_invoices_all dinv

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

3178: l_extraction_type <> 'INCREMENTAL'
3179: )
3180: ;
3181:
3182: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);');
3183:
3184: commit;
3185:
3186: end MARK_EXTRACTED_DINV_ROWS;

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

3199: begin
3200:
3201: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3202:
3203: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);')) then
3204: return;
3205: end if;
3206:
3207: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

Line 3207: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

3203: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);')) then
3204: return;
3205: end if;
3206:
3207: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
3208: 'CURRENT_BATCH') = 1) then
3209: -- implicit commit
3210: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3211: tabname => 'PJI_FM_EXTR_DINVC',

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

3455: part.worker_id = p_worker_id
3456: and part.gl_date is not null
3457: and part.pa_date is not null;
3458:
3459: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);');
3460:
3461: commit;
3462:
3463: end EXTRACT_BATCH_DINVITEM;

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

3474: begin
3475:
3476: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3477:
3478: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);')) then
3479: return;
3480: end if;
3481:
3482: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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

3551: ar.due_date,
3552: trx.bill_to_customer_id,
3553: part.pji_summarized_flag);
3554:
3555: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);');
3556:
3557: commit;
3558:
3559: end EXTRACT_BATCH_ARINV;

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

3569: begin
3570:
3571: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3572:
3573: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
3574: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);')) then
3575: return;
3576: end if;
3577:

Line 3594: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

3590: PJI_FM_EXTR_ARINV
3591: where
3592: PJI_SUMMARIZED_FLAG = 'O';
3593:
3594: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
3595: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);');
3596:
3597: commit;
3598:

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

3613: begin
3614:
3615: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3616:
3617: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);')) then
3618: return;
3619: end if;
3620:
3621: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 3621: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3617: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);')) then
3618: return;
3619: end if;
3620:
3621: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3622: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
3623:
3624: select count(*)
3625: into l_leftover_batches

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

3700: l_helper_batch_id := -1;
3701:
3702: else
3703:
3704: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
3705:
3706: end if;
3707:
3708: end if;

Line 3724: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

3720: end loop;
3721:
3722: if (l_helper_batch_id <> -2) then
3723:
3724: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
3725: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);');
3726:
3727: end if;
3728:

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

3741: begin
3742:
3743: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3744:
3745: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
3746: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);')) then
3747: return;
3748: end if;
3749:

Line 3750: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

3746: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);')) then
3747: return;
3748: end if;
3749:
3750: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
3751: 'PJI_HELPER_BATCH_MAP',
3752: 'NORMAL',
3753: null);
3754:

Line 3755: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

3751: 'PJI_HELPER_BATCH_MAP',
3752: 'NORMAL',
3753: null);
3754:
3755: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
3756: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);');
3757:
3758: commit;
3759:

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

3770: begin
3771:
3772: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3773:
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);

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

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

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

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

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

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

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);
3783:
3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);

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

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);
3783:
3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3787:
3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);

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

3782: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3783:
3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3787:
3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3789:
3790: end CLEANUP;

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

3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3787:
3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3789:
3790: end CLEANUP;
3791:
3792: end PJI_FM_EXTR;