APPS.PJI_EXTRACTION_UTIL dependencies on PJI_SYSTEM_CONFIG_HIST

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

542: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
543:
544: -- PJI summarization tables with persistent data
545: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_MT_PRC_STEPS', 'NORMAL', null);
546: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_CONFIG_HIST', 'NORMAL', null);
547: delete from PJI_SYSTEM_PARAMETERS where NAME not in ('PJI_PJP_ENT_CURR_REP_PERIOD');
548: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);
549: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_DEBUG_MSG', 'NORMAL', null);
550:

Line 551: insert into PJI_SYSTEM_CONFIG_HIST

547: delete from PJI_SYSTEM_PARAMETERS where NAME not in ('PJI_PJP_ENT_CURR_REP_PERIOD');
548: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJ_EXTR_STATUS', 'NORMAL', null);
549: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_DEBUG_MSG', 'NORMAL', null);
550:
551: insert into PJI_SYSTEM_CONFIG_HIST
552: (
553: REQUEST_ID,
554: USER_NAME,
555: PROCESS_NAME,

Line 670: update PJI_SYSTEM_CONFIG_HIST

666: commit;
667:
668: end if;
669:
670: update PJI_SYSTEM_CONFIG_HIST
671: set END_DATE = sysdate,
672: COMPLETION_TEXT = 'Normal completion'
673: where PROCESS_NAME = 'STAGE1' and
674: END_DATE is null;

Line 686: update PJI_SYSTEM_CONFIG_HIST

682: rollback;
683:
684: l_sqlerrm := substr(sqlerrm, 1, 240);
685:
686: update PJI_SYSTEM_CONFIG_HIST
687: set END_DATE = sysdate,
688: COMPLETION_TEXT = l_sqlerrm
689: where PROCESS_NAME = 'STAGE1' and
690: END_DATE is null;