793: if(X_MODE = 'I') then
794: X_LAST_UPDATED_BY := 1;
795: X_LAST_UPDATE_LOGIN := 0;
796: elsif (X_MODE = 'R') then
797: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
798: if X_LAST_UPDATED_BY is NULL then
799: X_LAST_UPDATED_BY := -1;
800: end if;
801: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
797: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
798: if X_LAST_UPDATED_BY is NULL then
799: X_LAST_UPDATED_BY := -1;
800: end if;
801: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
802: if X_LAST_UPDATE_LOGIN is NULL then
803: X_LAST_UPDATE_LOGIN := -1;
804: end if;
805: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
801: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
802: if X_LAST_UPDATE_LOGIN is NULL then
803: X_LAST_UPDATE_LOGIN := -1;
804: end if;
805: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
806: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
807: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
808: if (X_REQUEST_ID = -1) then
809: X_REQUEST_ID := NULL;
802: if X_LAST_UPDATE_LOGIN is NULL then
803: X_LAST_UPDATE_LOGIN := -1;
804: end if;
805: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
806: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
807: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
808: if (X_REQUEST_ID = -1) then
809: X_REQUEST_ID := NULL;
810: X_PROGRAM_ID := NULL;
803: X_LAST_UPDATE_LOGIN := -1;
804: end if;
805: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
806: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
807: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
808: if (X_REQUEST_ID = -1) then
809: X_REQUEST_ID := NULL;
810: X_PROGRAM_ID := NULL;
811: X_PROGRAM_APPLICATION_ID := NULL;
1081: if(X_MODE = 'I') then
1082: X_LAST_UPDATED_BY := 1;
1083: X_LAST_UPDATE_LOGIN := 0;
1084: elsif (X_MODE = 'R') then
1085: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1086: if X_LAST_UPDATED_BY is NULL then
1087: X_LAST_UPDATED_BY := -1;
1088: end if;
1089: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1085: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1086: if X_LAST_UPDATED_BY is NULL then
1087: X_LAST_UPDATED_BY := -1;
1088: end if;
1089: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1090: if X_LAST_UPDATE_LOGIN is NULL then
1091: X_LAST_UPDATE_LOGIN := -1;
1092: end if;
1093: Before_DML(
1115: x_last_update_date => X_LAST_UPDATE_DATE,
1116: x_last_updated_by => X_LAST_UPDATED_BY,
1117: x_last_update_login => X_LAST_UPDATE_LOGIN
1118: );
1119: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1120: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1121: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1122: if (X_REQUEST_ID = -1) then
1123: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1116: x_last_updated_by => X_LAST_UPDATED_BY,
1117: x_last_update_login => X_LAST_UPDATE_LOGIN
1118: );
1119: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1120: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1121: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1122: if (X_REQUEST_ID = -1) then
1123: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1124: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1117: x_last_update_login => X_LAST_UPDATE_LOGIN
1118: );
1119: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1120: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1121: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1122: if (X_REQUEST_ID = -1) then
1123: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1124: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1125: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;