467: if(X_MODE = 'I') then
468: X_LAST_UPDATED_BY := 1;
469: X_LAST_UPDATE_LOGIN := 0;
470: elsif (X_MODE IN ('R', 'S')) then
471: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
472: if X_LAST_UPDATED_BY is NULL then
473: X_LAST_UPDATED_BY := -1;
474: end if;
475: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
471: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
472: if X_LAST_UPDATED_BY is NULL then
473: X_LAST_UPDATED_BY := -1;
474: end if;
475: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
476: if X_LAST_UPDATE_LOGIN is NULL then
477: X_LAST_UPDATE_LOGIN := -1;
478: end if;
479: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
475: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
476: if X_LAST_UPDATE_LOGIN is NULL then
477: X_LAST_UPDATE_LOGIN := -1;
478: end if;
479: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
480: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
481: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
482: if (X_REQUEST_ID = -1) then
483: X_REQUEST_ID := NULL;
476: if X_LAST_UPDATE_LOGIN is NULL then
477: X_LAST_UPDATE_LOGIN := -1;
478: end if;
479: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
480: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
481: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
482: if (X_REQUEST_ID = -1) then
483: X_REQUEST_ID := NULL;
484: X_PROGRAM_ID := NULL;
477: X_LAST_UPDATE_LOGIN := -1;
478: end if;
479: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
480: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
481: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
482: if (X_REQUEST_ID = -1) then
483: X_REQUEST_ID := NULL;
484: X_PROGRAM_ID := NULL;
485: X_PROGRAM_APPLICATION_ID := NULL;
652: if(X_MODE = 'I') then
653: X_LAST_UPDATED_BY := 1;
654: X_LAST_UPDATE_LOGIN := 0;
655: elsif (X_MODE IN ('R', 'S')) then
656: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
657: if X_LAST_UPDATED_BY is NULL then
658: X_LAST_UPDATED_BY := -1;
659: end if;
660: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
656: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
657: if X_LAST_UPDATED_BY is NULL then
658: X_LAST_UPDATED_BY := -1;
659: end if;
660: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
661: if X_LAST_UPDATE_LOGIN is NULL then
662: X_LAST_UPDATE_LOGIN := -1;
663: end if;
664: else
679: x_last_updated_by=>X_LAST_UPDATED_BY,
680: x_last_update_login=>X_LAST_UPDATE_LOGIN);
681:
682: if (X_MODE IN ('R', 'S')) then
683: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
684: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
685: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
686: if (X_REQUEST_ID = -1) then
687: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
680: x_last_update_login=>X_LAST_UPDATE_LOGIN);
681:
682: if (X_MODE IN ('R', 'S')) then
683: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
684: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
685: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
686: if (X_REQUEST_ID = -1) then
687: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
688: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
681:
682: if (X_MODE IN ('R', 'S')) then
683: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
684: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
685: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
686: if (X_REQUEST_ID = -1) then
687: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
688: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
689: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;