563: END_DATE,
564: COMPLETION_TEXT
565: )
566: select
567: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
568: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
569: 'STAGE1' PROCESS_NAME,
570: 'CLEANALL' RUN_TYPE,
571: substr(p_check || ', ' ||
564: COMPLETION_TEXT
565: )
566: select
567: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
568: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
569: 'STAGE1' PROCESS_NAME,
570: 'CLEANALL' RUN_TYPE,
571: substr(p_check || ', ' ||
572: p_truncate_pji_tables || ', ' ||