[Home] [Help]
20: begin
21:
22: if (p_stage = 'STAGE1_EXTR') then
23:
24: l_permanent_param := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
25: l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
26: (PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
27:
28: if (l_running_param is not null) then
51: l_stage2_pji_process := null;
52:
53: end;
54:
55: l_permanent_param := PJI_UTILS.GET_PARAMETER('LAST_PJI_EXTR_DATE');
56: l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
57: -- Remove dependency on STAGE2_PJI
58: (l_stage2_pji_process, 'PROCESS_RUNNING');
59: -- (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING');
168: where PROCESS_NAME = p_process and
169: STEP_NAME = p_step and
170: START_DATE is null;
171:
172: -- PJI_UTILS.SET_CURR_FUNCTION(p_process || '$' || to_char(l_seq));
173: PJI_UTILS.WRITE2LOG('Entering ' || p_step || ' for ' || p_process,
174: true, 0);
175: return true;
176: end if;
169: STEP_NAME = p_step and
170: START_DATE is null;
171:
172: -- PJI_UTILS.SET_CURR_FUNCTION(p_process || '$' || to_char(l_seq));
173: PJI_UTILS.WRITE2LOG('Entering ' || p_step || ' for ' || p_process,
174: true, 0);
175: return true;
176: end if;
177:
203: END_DATE = sysdate
204: where PROCESS_NAME = p_process and
205: STEP_NAME = p_step;
206:
207: -- PJI_UTILS.RESET_CURR_FUNCTION;
208: PJI_UTILS.WRITE2LOG('Completed ' || p_step || ' for ' || p_process,
209: true, 0);
210:
211: end REGISTER_STEP_COMPLETION;
204: where PROCESS_NAME = p_process and
205: STEP_NAME = p_step;
206:
207: -- PJI_UTILS.RESET_CURR_FUNCTION;
208: PJI_UTILS.WRITE2LOG('Completed ' || p_step || ' for ' || p_process,
209: true, 0);
210:
211: end REGISTER_STEP_COMPLETION;
212:
298:
299: else -- l_transition is null or 'N'
300:
301: l_params_proj_perf_flag :=
302: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
303: l_params_cost_flag :=
304: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
305: l_params_profit_flag :=
306: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
300:
301: l_params_proj_perf_flag :=
302: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
303: l_params_cost_flag :=
304: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
305: l_params_profit_flag :=
306: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
307: l_params_util_flag :=
308: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
302: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
303: l_params_cost_flag :=
304: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
305: l_params_profit_flag :=
306: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
307: l_params_util_flag :=
308: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
309:
310: end if;
304: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
305: l_params_profit_flag :=
306: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
307: l_params_util_flag :=
308: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
309:
310: end if;
311:
312: if (p_extraction_type = 'FULL') then
390: ) return varchar2 is
391:
392: begin
393:
394: return PJI_UTILS.GET_PARAMETER(p_process || '$' || p_parameter);
395:
396: end;
397:
398: -- ----------------------------------------------------------
406: ) is
407:
408: begin
409:
410: PJI_UTILS.SET_PARAMETER(p_process || '$' || p_parameter, p_value);
411:
412: end;
413:
414:
616:
617: if (FND_CONCURRENT.GET_REQUEST_STATUS
618: (
619: l_request_id,
620: PJI_UTILS.GET_PJI_SCHEMA_NAME,
621: p_request_name,
622: l_phase,
623: l_status,
624: l_dev_phase,