572: if(X_MODE = 'I') then
573: X_LAST_UPDATED_BY := 1;
574: X_LAST_UPDATE_LOGIN := 0;
575: elsif (X_MODE IN ('R', 'S')) then
576: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
577: if X_LAST_UPDATED_BY is NULL then
578: X_LAST_UPDATED_BY := -1;
579: end if;
580: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
576: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
577: if X_LAST_UPDATED_BY is NULL then
578: X_LAST_UPDATED_BY := -1;
579: end if;
580: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
581: if X_LAST_UPDATE_LOGIN is NULL then
582: X_LAST_UPDATE_LOGIN := -1;
583: end if;
584: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
580: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
581: if X_LAST_UPDATE_LOGIN is NULL then
582: X_LAST_UPDATE_LOGIN := -1;
583: end if;
584: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
585: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
586: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
587: if (X_REQUEST_ID = -1) then
588: X_REQUEST_ID := NULL;
581: if X_LAST_UPDATE_LOGIN is NULL then
582: X_LAST_UPDATE_LOGIN := -1;
583: end if;
584: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
585: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
586: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
587: if (X_REQUEST_ID = -1) then
588: X_REQUEST_ID := NULL;
589: X_PROGRAM_ID := NULL;
582: X_LAST_UPDATE_LOGIN := -1;
583: end if;
584: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
585: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
586: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
587: if (X_REQUEST_ID = -1) then
588: X_REQUEST_ID := NULL;
589: X_PROGRAM_ID := NULL;
590: X_PROGRAM_APPLICATION_ID := NULL;
944: if(X_MODE = 'I') then
945: X_LAST_UPDATED_BY := 1;
946: X_LAST_UPDATE_LOGIN := 0;
947: elsif (X_MODE IN ('R', 'S')) then
948: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
949: if X_LAST_UPDATED_BY is NULL then
950: X_LAST_UPDATED_BY := -1;
951: end if;
952: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
948: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
949: if X_LAST_UPDATED_BY is NULL then
950: X_LAST_UPDATED_BY := -1;
951: end if;
952: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
953: if X_LAST_UPDATE_LOGIN is NULL then
954: X_LAST_UPDATE_LOGIN := -1;
955: end if;
956: else
992: x_last_updated_by=>X_LAST_UPDATED_BY,
993: x_last_update_login=>X_LAST_UPDATE_LOGIN);
994:
995: if (X_MODE IN ('R', 'S')) then
996: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
997: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
998: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
999: if (X_REQUEST_ID = -1) then
1000: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
993: x_last_update_login=>X_LAST_UPDATE_LOGIN);
994:
995: if (X_MODE IN ('R', 'S')) then
996: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
997: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
998: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
999: if (X_REQUEST_ID = -1) then
1000: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1001: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
994:
995: if (X_MODE IN ('R', 'S')) then
996: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
997: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
998: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
999: if (X_REQUEST_ID = -1) then
1000: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1001: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
1002: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;