74:
75: begin
76:
77: l_last_update_date := sysdate;
78: l_last_updated_by := FND_GLOBAL.USER_ID;
79: l_creation_date := sysdate;
80: l_created_by := FND_GLOBAL.USER_ID;
81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:
76:
77: l_last_update_date := sysdate;
78: l_last_updated_by := FND_GLOBAL.USER_ID;
79: l_creation_date := sysdate;
80: l_created_by := FND_GLOBAL.USER_ID;
81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:
83: select count(*)
84: into l_count
77: l_last_update_date := sysdate;
78: l_last_updated_by := FND_GLOBAL.USER_ID;
79: l_creation_date := sysdate;
80: l_created_by := FND_GLOBAL.USER_ID;
81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:
83: select count(*)
84: into l_count
85: from PJI_PJP_PROJ_EXTR_STATUS
570: END_DATE,
571: COMPLETION_TEXT
572: )
573: select
574: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
575: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
576: 'STAGE3' PROCESS_NAME,
577: 'CLEANALL' RUN_TYPE,
578: substr(p_check || ', ' ||
571: COMPLETION_TEXT
572: )
573: select
574: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
575: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
576: 'STAGE3' PROCESS_NAME,
577: 'CLEANALL' RUN_TYPE,
578: substr(p_check || ', ' ||
579: p_fpm_upgrade || ', ' ||