460: if(X_MODE = 'I') then
461: X_LAST_UPDATED_BY := 1;
462: X_LAST_UPDATE_LOGIN := 0;
463: elsif (X_MODE = 'R') then
464: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
465: if X_LAST_UPDATED_BY is NULL then
466: X_LAST_UPDATED_BY := -1;
467: end if;
468: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
464: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
465: if X_LAST_UPDATED_BY is NULL then
466: X_LAST_UPDATED_BY := -1;
467: end if;
468: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
469: if X_LAST_UPDATE_LOGIN is NULL then
470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
468: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
469: if X_LAST_UPDATE_LOGIN is NULL then
470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
473: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
474: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
475: if (X_REQUEST_ID = -1) then
476: X_REQUEST_ID := NULL;
469: if X_LAST_UPDATE_LOGIN is NULL then
470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
473: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
474: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
475: if (X_REQUEST_ID = -1) then
476: X_REQUEST_ID := NULL;
477: X_PROGRAM_ID := NULL;
470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
473: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
474: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
475: if (X_REQUEST_ID = -1) then
476: X_REQUEST_ID := NULL;
477: X_PROGRAM_ID := NULL;
478: X_PROGRAM_APPLICATION_ID := NULL;
623: if(X_MODE = 'I') then
624: X_LAST_UPDATED_BY := 1;
625: X_LAST_UPDATE_LOGIN := 0;
626: elsif (X_MODE = 'R') then
627: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
628: if X_LAST_UPDATED_BY is NULL then
629: X_LAST_UPDATED_BY := -1;
630: end if;
631: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
627: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
628: if X_LAST_UPDATED_BY is NULL then
629: X_LAST_UPDATED_BY := -1;
630: end if;
631: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
632: if X_LAST_UPDATE_LOGIN is NULL then
633: X_LAST_UPDATE_LOGIN := -1;
634: end if;
635: else
651: x_last_update_login=>X_LAST_UPDATE_LOGIN
652: );
653:
654: if (X_MODE = 'R') then
655: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
656: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
657: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
658: if (X_REQUEST_ID = -1) then
659: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
652: );
653:
654: if (X_MODE = 'R') then
655: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
656: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
657: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
658: if (X_REQUEST_ID = -1) then
659: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
660: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
653:
654: if (X_MODE = 'R') then
655: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
656: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
657: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
658: if (X_REQUEST_ID = -1) then
659: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
660: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
661: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;