DBA Data[Home] [Help]

APPS.PJI_PROCESS_UTIL dependencies on PJI_SYSTEM_PARAMETERS

Line 88: from PJI_SYSTEM_PARAMETERS

84: begin
85:
86: select VALUE
87: into l_permanent_param
88: from PJI_SYSTEM_PARAMETERS
89: where NAME like 'LAST_PJP_EXTR_DATE%' and
90: ROWNUM = 1;
91:
92: exception when no_data_found then

Line 102: from PJI_SYSTEM_PARAMETERS

98: begin
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

Line 310: from PJI_SYSTEM_PARAMETERS

306: from PJI_SYSTEM_PRC_STATUS
307: where PROCESS_NAME = p_process;
308:
309: delete
310: from PJI_SYSTEM_PARAMETERS
311: where NAME like p_process || '$%';
312:
313: end if;
314: