567: END_DATE,
568: COMPLETION_TEXT
569: )
570: select
571: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
572: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
573: 'STAGE1' PROCESS_NAME,
574: 'CLEANALL' RUN_TYPE,
575: substr(p_check || ', ' ||
568: COMPLETION_TEXT
569: )
570: select
571: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
572: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
573: 'STAGE1' PROCESS_NAME,
574: 'CLEANALL' RUN_TYPE,
575: substr(p_check || ', ' ||
576: p_truncate_pji_tables || ', ' ||
626: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FM_XBS_ACCUM_TMP1_DEBUG','NORMAL', null); /* Added for bug 6857368 */
627:
628: -- Added for bug 6603016
629: l_last_update_date := sysdate;
630: l_last_updated_by := FND_GLOBAL.USER_ID;
631: l_last_update_login := FND_GLOBAL.LOGIN_ID;
632:
633: update PA_PROJECTS_ALL
634: set PJI_SOURCE_FLAG = null,
627:
628: -- Added for bug 6603016
629: l_last_update_date := sysdate;
630: l_last_updated_by := FND_GLOBAL.USER_ID;
631: l_last_update_login := FND_GLOBAL.LOGIN_ID;
632:
633: update PA_PROJECTS_ALL
634: set PJI_SOURCE_FLAG = null,
635: LAST_UPDATE_DATE = l_last_update_date,