[Home] [Help]
238: END IF;
239:
240: /* Added for bug#5728852 - START */
241: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id);
242: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'RBS_HEADER_ID');
243: /* Added for bug#5728852 - END */
244:
245: IF (p_context = 'RBS' AND p_rbs_version_id IS NULL) THEN
246: print_time('Context is RBS and rbs version id is NULL. Pl. provide a rbs version id. Exitting.' );
501:
502: l_plan_type_id := p_plan_type_id;
503: l_rbs_version_id := NULL;
504: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id); -- Bug#5099574
505: l_refresh_code := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_process, 'REFRESH_CODE'); -- Bug#5099574
506:
507: -- Bug# 5208322 : the workplan plan_type_id is stored in l_workplan_type_id
508: begin
509: SELECT fin_plan_type_id into l_workplan_type_id
5456: , x_return_status => x_return_status ) ;
5457:
5458: --Bug 6047966.
5459: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id);
5460: l_plan_ver_type_code := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PLAN_VERSION');
5461:
5462: DELETE FROM pji_fm_extr_plan_lines
5463: WHERE (project_id, plan_version_id) IN
5464: (SELECT ver.project_id, ver.plan_version_id
12660: /* Added for bug 7551819 */
12661: begin
12662: select 'Y' into l_from_launch
12663: from dual
12664: where PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'FROM_PROJECT')
12665: like 'UPP-BATCH-%';
12666: exception
12667: when others then
12668: l_from_launch := 'N';