APPS.PJI_RM_SUM_MAIN dependencies on PJI_SYSTEM_CONFIG_HIST

Line 182: insert into PJI_SYSTEM_CONFIG_HIST

178: end if;
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 1366: update PJI_SYSTEM_CONFIG_HIST

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

Line 1429: update PJI_SYSTEM_CONFIG_HIST

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

Line 1468: update PJI_SYSTEM_CONFIG_HIST

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