APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_SYSTEM_CONFIG_HIST

Line 1244: insert into PJI_SYSTEM_CONFIG_HIST

1240: commit;
1241:
1242: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1243:
1244: insert into PJI_SYSTEM_CONFIG_HIST
1245: (
1246: REQUEST_ID,
1247: USER_NAME,
1248: PROCESS_NAME,

Line 1342: update PJI_SYSTEM_CONFIG_HIST

1338: retcode := 0;
1339:
1340: -- PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(errbuf, retcode, 'All', 'C', 'N');
1341:
1342: update PJI_SYSTEM_CONFIG_HIST
1343: set END_DATE = sysdate,
1344: COMPLETION_TEXT = 'Normal completion'
1345: where PROCESS_NAME = 'STAGE2' and
1346: END_DATE is null;

Line 1356: update PJI_SYSTEM_CONFIG_HIST

1352: rollback;
1353:
1354: l_sqlerrm := substr(sqlerrm, 1, 240);
1355:
1356: update PJI_SYSTEM_CONFIG_HIST
1357: set END_DATE = sysdate,
1358: COMPLETION_TEXT = l_sqlerrm
1359: where PROCESS_NAME = 'STAGE2' and
1360: END_DATE is null;