APPS.PJI_RM_SUM_MAIN dependencies on PJI_SYSTEM_CONFIG_HIST

Line 182: insert into PJI_SYSTEM_CONFIG_HIST

178: end if;Commented for bug 13011859 */
179:
180: if (l_transition_flag = 'Y') then
181:
182: insert into PJI_SYSTEM_CONFIG_HIST
183: (
184: REQUEST_ID,
185: USER_NAME,
186: PROCESS_NAME,

Line 396: insert into PJI_SYSTEM_CONFIG_HIST

392: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
393: 'EXTRACTION_TYPE',
394: l_extraction_type);
395:
396: insert into PJI_SYSTEM_CONFIG_HIST
397: (
398: REQUEST_ID,
399: USER_NAME,
400: PROCESS_NAME,

Line 1365: update PJI_SYSTEM_CONFIG_HIST

1361: if (l_params_util_flag = 'Y') then
1362: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');
1363: end if;
1364:
1365: update PJI_SYSTEM_CONFIG_HIST
1366: set END_DATE = sysdate
1367: where PROCESS_NAME = g_process || 1 and
1368: RUN_TYPE = 'TRANSITION' and
1369: END_DATE is null;

Line 1428: update PJI_SYSTEM_CONFIG_HIST

1424:
1425: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process || 1);
1426: PJI_PROCESS_UTIL.WRAPUP_PROCESS(g_process);
1427:
1428: update PJI_SYSTEM_CONFIG_HIST
1429: set END_DATE = sysdate,
1430: COMPLETION_TEXT = 'Normal completion'
1431: where PROCESS_NAME = g_process || 1 and
1432: END_DATE is null;

Line 1467: update PJI_SYSTEM_CONFIG_HIST

1463: pji_utils.write2log(sqlerrm, true, 0);
1464:
1465: l_sqlerrm := substr(sqlerrm, 1, 240);
1466:
1467: update PJI_SYSTEM_CONFIG_HIST
1468: set END_DATE = sysdate,
1469: COMPLETION_TEXT = l_sqlerrm
1470: where PROCESS_NAME = g_process || 1 and
1471: END_DATE is null;