DBA Data[Home] [Help]

APPS.PJI_PROCESS_UTIL dependencies on PJI_SYSTEM_PARAMETERS

Line 77: from PJI_SYSTEM_PARAMETERS

73: begin
74:
75: select VALUE
76: into l_permanent_param
77: from PJI_SYSTEM_PARAMETERS
78: where NAME like 'LAST_PJP_EXTR_DATE%' and
79: ROWNUM = 1;
80:
81: exception when no_data_found then

Line 91: from PJI_SYSTEM_PARAMETERS

87: begin
88:
89: select VALUE
90: into l_running_param
91: from PJI_SYSTEM_PARAMETERS
92: where NAME like PJI_PJP_SUM_MAIN.g_process || '%PROCESS_RUNNING' and
93: ROWNUM = 1;
94:
95: exception when no_data_found then

Line 250: from PJI_SYSTEM_PARAMETERS

246: from PJI_SYSTEM_PRC_STATUS
247: where PROCESS_NAME = p_process;
248:
249: delete
250: from PJI_SYSTEM_PARAMETERS
251: where NAME like p_process || '$%';
252:
253: end WRAPUP_PROCESS;
254: