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_PLAN_EXTR dependencies on PJI_FM_PLAN_EXTR

Line 1: PACKAGE BODY PJI_FM_PLAN_EXTR AS

1: PACKAGE BODY PJI_FM_PLAN_EXTR AS
2: /* $Header: PJISF07B.pls 120.5.12000000.2 2007/07/25 11:00:21 bifernan ship $ */
3:
4: g_cost_budget_type_code varchar2(30);
5: g_cost_forecast_type_code varchar2(30);

Line 53: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);

49: begin
50:
51: -- Cache setup settings in global variables.
52:
53: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);
54:
55: g_cost_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_BUDGET_TYPE_CODE');
56: g_cost_forecast_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'COST_FORECAST_TYPE_CODE');
57: g_revenue_budget_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process,'REVENUE_BUDGET_TYPE_CODE');

Line 71: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);

67: g_rev_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FP_TYPE_ID');
68: g_cost_forecast_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'COST_FORECAST_FP_TYPE_ID');
69: g_rev_forecast_fp_type_code := pji_process_util.get_process_parameter(PJI_RM_SUM_MAIN.g_process, 'REVENUE_FORECAST_FP_TYPE_ID');
70:
71: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.GET_SYSTEM_SETTINGS',TRUE,3);
72:
73: end get_system_settings;
74:
75: -- -----------------------------------------------------

Line 90: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);

86: -- pickup these changes in the middle of summarization run.
87: -- We get plan settings once from PJI setup table and
88: -- store them as process variables.
89:
90: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);
91:
92: pji_process_util.set_process_parameter(
93: PJI_RM_SUM_MAIN.g_process,
94: 'COST_BUDGET_TYPE_CODE',

Line 177: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);

173: pji_utils.get_setup_parameter('REVENUE_FORECAST_FP_TYPE_ID')
174: );
175:
176:
177: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.INIT_GLOBAL_PARAMETERS',TRUE,3);
178:
179: end init_global_parameters;
180:
181:

Line 190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);

186: procedure cleanup(p_worker_id number) is
187:
188: begin
189:
190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
191:
192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);

Line 199: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);

195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:
198:
199: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
200:
201: end cleanup;
202:
203: -- -----------------------------------------------------

Line 211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);

207: procedure cleanup_log is
208:
209: begin
210:
211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
212:
213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);
214:
215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);

Line 215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);

211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
212:
213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);
214:
215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
216:
217: end cleanup_log;
218:
219:

Line 233: (l_process,'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);')) then

229:
230: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
231:
232: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
233: (l_process,'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);')) then
234: return;
235: end if;
236:
237: get_system_settings;

Line 288: (l_process, 'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);');

284: )
285: ;
286:
287: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
288: (l_process, 'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);');
289:
290: commit;
291:
292: end update_plan_org_info;

Line 309: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);')) then

305:
306: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
307:
308: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
309: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);')) then
310: return;
311: end if;
312:
313: -- Get Financial Plan versions

Line 465: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);');

461: and map.project_id = pln.project_id (+)
462: and pln.project_id is null;
463:
464: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
465: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);');
466:
467: commit;
468:
469: end extract_plan_versions;

Line 487: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);')) then

483:
484: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
485:
486: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
487: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);')) then
488: return;
489: end if;
490:
491: l_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

Line 673: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);');

669: ) <= fii_time.period_id
670: ;
671:
672: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
673: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);');
674:
675: commit;
676:
677: end extract_batch_plan;

Line 694: (l_process,'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);')) then

690:
691: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
692:
693: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
694: (l_process,'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);')) then
695: return;
696: end if;
697:
698: -- spread the ENT amounts

Line 851: (l_process, 'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);');

847: , orginfo.en_calendar_max_date
848: ;
849:
850: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
851: (l_process, 'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);');
852:
853: commit;
854:
855: end spread_ent_plans;

Line 874: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);')) then

870:
871: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
872:
873: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
874: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);')) then
875: return;
876: end if;
877:
878: l_mau := PJI_UTILS.GET_MAU_PRIMARY;

Line 921: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);');

917: time_dangling_flag is null
918: ) tmp;
919:
920: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
921: (l_process, 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);');
922:
923: commit;
924:
925: end plan_curr_conv_table;

Line 942: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);')) then

938:
939: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
940:
941: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
942: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);')) then
943: return;
944: end if;
945:
946: -- convert to GLOBAL CURRENCY

Line 1061: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);');

1057: and rates.time_id > 0
1058: ;
1059:
1060: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1061: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);');
1062:
1063: commit;
1064:
1065: end convert_to_global_currency;

Line 1082: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);')) then

1078:
1079: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1080:
1081: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1082: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);')) then
1083: return;
1084: end if;
1085:
1086: -- convert to GLOBAL CURRENCY

Line 1201: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);');

1197: and rates.time_id > 0
1198: ;
1199:
1200: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1201: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);');
1202:
1203: commit;
1204:
1205: end convert_to_global2_currency;

Line 1222: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);')) then

1218:
1219: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1220:
1221: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1222: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);')) then
1223: return;
1224: end if;
1225:
1226:

Line 1373: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);');

1369:
1370: end if;
1371:
1372: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1373: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);');
1374:
1375: commit;
1376:
1377: end convert_to_pa_periods;

Line 1394: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);')) then

1390:
1391: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1392:
1393: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1394: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);')) then
1395: return;
1396: end if;
1397:
1398:

Line 1545: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);');

1541:
1542: end if;
1543:
1544: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1545: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);');
1546:
1547: commit;
1548:
1549: end convert_to_gl_periods;

Line 1566: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);')) then

1562:
1563: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1564:
1565: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1566: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);')) then
1567: return;
1568: end if;
1569:
1570:

Line 1710: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);');

1706: and tmp.rate2_dangling_flag is null
1707: ;
1708:
1709: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1710: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);');
1711:
1712: commit;
1713:
1714: end convert_to_ent_periods;

Line 1731: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);')) then

1727:
1728: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1729:
1730: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1731: (l_process,'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);')) then
1732: return;
1733: end if;
1734:
1735:

Line 1875: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);');

1871: and tmp.rate2_dangling_flag is null
1872: ;
1873:
1874: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1875: (l_process, 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);');
1876:
1877: commit;
1878:
1879: end convert_to_entw_periods;

Line 1896: (l_process,'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);')) then

1892:
1893: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1894:
1895: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1896: (l_process,'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);')) then
1897: return;
1898: end if;
1899:
1900:

Line 1946: (l_process, 'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);');

1942: and tmp.project_org_id = orginfo.org_id
1943: ;
1944:
1945: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1946: (l_process, 'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);');
1947:
1948: commit;
1949:
1950: end dangling_plan_versions;

Line 1974: (l_process,'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);')) then

1970:
1971: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1972:
1973: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1974: (l_process,'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);')) then
1975: return;
1976: end if;
1977:
1978: select

Line 2240: (l_process, 'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);');

2236: tmp1.START_DATE,
2237: tmp1.END_DATE;
2238:
2239: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2240: (l_process, 'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);');
2241:
2242: commit;
2243:
2244: end summarize_extract;

Line 2261: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);')) then

2257:
2258: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2259:
2260: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2261: (l_process,'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);')) then
2262: return;
2263: end if;
2264:
2265: Insert /*+ APPEND */ into PJI_FM_EXTR_PLNVER2

Line 2373: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);');

2369: ) tmp
2370: ;
2371:
2372: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2373: (l_process, 'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);');
2374:
2375: commit;
2376:
2377: end extract_updated_versions;

Line 2392: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);')) then

2388:
2389: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2390:
2391: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2392: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);')) then
2393: return;
2394: end if;
2395:
2396: insert /*+ append */ into PJI_HELPER_BATCH_MAP

Line 2413: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);');

2409: where
2410: WORKER_ID = p_worker_id;
2411:
2412: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2413: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);');
2414:
2415: commit;
2416:
2417: end update_batch_versions_pre;

Line 2436: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);')) then

2432:
2433: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2434:
2435: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2436: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);')) then
2437: return;
2438: end if;
2439:
2440: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 2549: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);' and

2545: update PJI_SYSTEM_PRC_STATUS
2546: set STEP_STATUS = 'C'
2547: where PROCESS_NAME like PJI_RM_SUM_MAIN.g_process|| to_char(x) and
2548: STEP_NAME =
2549: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);' and
2550: START_DATE is null;
2551:
2552: commit;
2553:

Line 2581: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);');

2577:
2578: if (l_helper_batch_id <> -2) then
2579:
2580: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2581: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);');
2582:
2583: end if;
2584:
2585: commit;

Line 2602: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);')) then

2598:
2599: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2600:
2601: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
2602: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);')) then
2603: return;
2604: end if;
2605:
2606: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',

Line 2612: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);');

2608: 'NORMAL',
2609: null);
2610:
2611: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
2612: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);');
2613:
2614: commit;
2615:
2616: end update_batch_versions_post;

Line 2633: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);'

2629:
2630: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2631: (
2632: l_process,
2633: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);'
2634: )) then
2635: return;
2636: end if;
2637:

Line 2670: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);'

2666:
2667: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2668: (
2669: l_process,
2670: 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);'
2671: );
2672:
2673: commit;
2674:

Line 2706: end PJI_FM_PLAN_EXTR;

2702: g_entw_start_J := to_char(g_entw_start_date,'J');
2703: g_entw_end_J := to_char(g_entw_end_date,'J');
2704:
2705:
2706: end PJI_FM_PLAN_EXTR;