[Home] [Help]
99:
100: select VALUE
101: into l_running_param
102: from PJI_SYSTEM_PARAMETERS
103: where NAME like PJI_PJP_SUM_MAIN.g_process || '%PROCESS_RUNNING' and
104: ROWNUM = 1;
105:
106: exception when no_data_found then
107:
5387: )
5388: values
5389: (
5390: 'PJI_PJP',
5391: 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);',
5392: l_step_seq,
5393: to_char(1 + 2 + 4 + 8), -- generic
5394: 'Y',
5395: 'N',
5412: )
5413: values
5414: (
5415: 'PJI_PJP',
5416: 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);',
5417: l_step_seq,
5418: to_char(1 + 2 + 4 + 8), -- generic
5419: 'Y',
5420: 'N',
5437: )
5438: values
5439: (
5440: 'PJI_PJP',
5441: 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);',
5442: l_step_seq,
5443: to_char(1 + 2 + 4 + 8), -- generic
5444: 'Y',
5445: 'N',
7666: else
7667: /* Added for bug 13030627 */
7668:
7669: /* Start bug 10338478 */
7670: L_PROCESS := PJI_PJP_SUM_MAIN.G_PROCESS || P_WORKER_ID;
7671: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(L_PROCESS,'EXTRACTION_TYPE');
7672: /* End bug 10338478 */
7673:
7674: /* Added for bug 11843459 */