1296: if(X_MODE = 'I') then
1297: X_LAST_UPDATED_BY := 1;
1298: X_LAST_UPDATE_LOGIN := 0;
1299: elsif (X_MODE IN ('R', 'S')) then
1300: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1301: if X_LAST_UPDATED_BY is NULL then
1302: X_LAST_UPDATED_BY := -1;
1303: end if;
1304: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1300: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1301: if X_LAST_UPDATED_BY is NULL then
1302: X_LAST_UPDATED_BY := -1;
1303: end if;
1304: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1305: if X_LAST_UPDATE_LOGIN is NULL then
1306: X_LAST_UPDATE_LOGIN := -1;
1307: end if;
1308: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1304: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1305: if X_LAST_UPDATE_LOGIN is NULL then
1306: X_LAST_UPDATE_LOGIN := -1;
1307: end if;
1308: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1309: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1310: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1311: if (X_REQUEST_ID = -1) then
1312: X_REQUEST_ID := NULL ;
1305: if X_LAST_UPDATE_LOGIN is NULL then
1306: X_LAST_UPDATE_LOGIN := -1;
1307: end if;
1308: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1309: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1310: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1311: if (X_REQUEST_ID = -1) then
1312: X_REQUEST_ID := NULL ;
1313: X_PROGRAM_ID := NULL ;
1306: X_LAST_UPDATE_LOGIN := -1;
1307: end if;
1308: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1309: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1310: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1311: if (X_REQUEST_ID = -1) then
1312: X_REQUEST_ID := NULL ;
1313: X_PROGRAM_ID := NULL ;
1314: X_PROGRAM_APPLICATION_ID := NULL ;
1629: if(X_MODE = 'I') then
1630: X_LAST_UPDATED_BY := 1;
1631: X_LAST_UPDATE_LOGIN := 0;
1632: elsif (X_MODE IN ('R', 'S')) then
1633: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1634: if X_LAST_UPDATED_BY is NULL then
1635: X_LAST_UPDATED_BY := -1;
1636: end if;
1637: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1633: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1634: if X_LAST_UPDATED_BY is NULL then
1635: X_LAST_UPDATED_BY := -1;
1636: end if;
1637: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1638: if X_LAST_UPDATE_LOGIN is NULL then
1639: X_LAST_UPDATE_LOGIN := -1;
1640: end if;
1641: else
1681: x_last_updated_by=>X_LAST_UPDATED_BY,
1682: x_last_update_login=>X_LAST_UPDATE_LOGIN
1683: );
1684: if (X_MODE IN ('R', 'S')) then
1685: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1686: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1687: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1688: if (X_REQUEST_ID = -1) then
1689: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID ;
1682: x_last_update_login=>X_LAST_UPDATE_LOGIN
1683: );
1684: if (X_MODE IN ('R', 'S')) then
1685: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1686: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1687: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1688: if (X_REQUEST_ID = -1) then
1689: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID ;
1690: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID ;
1683: );
1684: if (X_MODE IN ('R', 'S')) then
1685: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1686: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1687: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1688: if (X_REQUEST_ID = -1) then
1689: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID ;
1690: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID ;
1691: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID ;