APPS.PJI_EXTRACTION_UTIL dependencies on PJI_SYSTEM_CONFIG_HIST

Line 550: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_CONFIG_HIST', 'NORMAL', null);

546: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
547:
548: -- PJI summarization tables with persistent data
549: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_MT_PRC_STEPS', 'NORMAL', null);
550: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_CONFIG_HIST', 'NORMAL', null);
551: delete from PJI_SYSTEM_PARAMETERS where NAME not in ('PJI_PJP_ENT_CURR_REP_PERIOD','PJP_SIN_PRG'); -- Bug 13451898
552: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);
553: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_DEBUG_MSG', 'NORMAL', null);
554:

Line 555: insert into PJI_SYSTEM_CONFIG_HIST

551: delete from PJI_SYSTEM_PARAMETERS where NAME not in ('PJI_PJP_ENT_CURR_REP_PERIOD','PJP_SIN_PRG'); -- Bug 13451898
552: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);
553: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_DEBUG_MSG', 'NORMAL', null);
554:
555: insert into PJI_SYSTEM_CONFIG_HIST
556: (
557: REQUEST_ID,
558: USER_NAME,
559: PROCESS_NAME,

Line 695: update PJI_SYSTEM_CONFIG_HIST

691: commit;
692:
693: end if;
694:
695: update PJI_SYSTEM_CONFIG_HIST
696: set END_DATE = sysdate,
697: COMPLETION_TEXT = 'Normal completion'
698: where PROCESS_NAME = 'STAGE1' and
699: END_DATE is null;

Line 711: update PJI_SYSTEM_CONFIG_HIST

707: rollback;
708:
709: l_sqlerrm := substr(sqlerrm, 1, 240);
710:
711: update PJI_SYSTEM_CONFIG_HIST
712: set END_DATE = sysdate,
713: COMPLETION_TEXT = l_sqlerrm
714: where PROCESS_NAME = 'STAGE1' and
715: END_DATE is null;