DBA Data[Home] [Help]

APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_SYSTEM_CONFIG_HIST

Line 1192: insert into PJI_SYSTEM_CONFIG_HIST

1188: commit;
1189:
1190: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1191:
1192: insert into PJI_SYSTEM_CONFIG_HIST
1193: (
1194: REQUEST_ID,
1195: USER_NAME,
1196: PROCESS_NAME,

Line 1290: update PJI_SYSTEM_CONFIG_HIST

1286: retcode := 0;
1287:
1288: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(errbuf, retcode, 'All', 'C', 'N');
1289:
1290: update PJI_SYSTEM_CONFIG_HIST
1291: set END_DATE = sysdate,
1292: COMPLETION_TEXT = 'Normal completion'
1293: where PROCESS_NAME = 'STAGE2' and
1294: END_DATE is null;

Line 1304: update PJI_SYSTEM_CONFIG_HIST

1300: rollback;
1301:
1302: l_sqlerrm := substr(sqlerrm, 1, 240);
1303:
1304: update PJI_SYSTEM_CONFIG_HIST
1305: set END_DATE = sysdate,
1306: COMPLETION_TEXT = l_sqlerrm
1307: where PROCESS_NAME = 'STAGE2' and
1308: END_DATE is null;