DBA Data[Home] [Help]

APPS.PJI_PJP_EXTRACTION_UTILS dependencies on PJI_SYSTEM_CONFIG_HIST

Line 516: insert into PJI_SYSTEM_CONFIG_HIST

512: return;
513: end if;
514: /* starts here bug#5414276 , this code is moved out of the profile value check
515: as it should work for only FPM upgrade recovery also */
516: insert into PJI_SYSTEM_CONFIG_HIST
517: (
518: REQUEST_ID,
519: USER_NAME,
520: PROCESS_NAME,

Line 642: update PJI_SYSTEM_CONFIG_HIST

638: PJI_FM_PLAN_MAINT.CREATE_PRIMARY_UPGRD_PVT(p_context => 'TRUNCATE');
639:
640: end if;
641:
642: update PJI_SYSTEM_CONFIG_HIST
643: set END_DATE = sysdate,
644: COMPLETION_TEXT = 'Normal completion'
645: where PROCESS_NAME = 'STAGE3' and
646: END_DATE is null;

Line 663: update PJI_SYSTEM_CONFIG_HIST

659:
660: retcode := 2;
661: errbuf := l_sqlerrm;
662: /* ends here bug#5414276 */
663: update PJI_SYSTEM_CONFIG_HIST
664: set END_DATE = sysdate,
665: COMPLETION_TEXT = l_sqlerrm
666: where PROCESS_NAME = 'STAGE3' and
667: END_DATE is null;