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
528: END_DATE,
529: COMPLETION_TEXT
530: )
531: select
532: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
533: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
534: 'STAGE3' PROCESS_NAME,
535: 'CLEANALL' RUN_TYPE,
536: substr(p_check || ', ' ||
529: COMPLETION_TEXT
530: )
531: select
532: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
533: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
534: 'STAGE3' PROCESS_NAME,
535: 'CLEANALL' RUN_TYPE,
536: substr(p_check || ', ' ||
537: p_fpm_upgrade || ', ' ||