2090: if(X_MODE = 'I') then
2091: X_LAST_UPDATED_BY := 1;
2092: X_LAST_UPDATE_LOGIN := 0;
2093: elsif (X_MODE = 'R') then
2094: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2095: if X_LAST_UPDATED_BY is NULL then
2096: X_LAST_UPDATED_BY := -1;
2097: end if;
2098: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
2094: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2095: if X_LAST_UPDATED_BY is NULL then
2096: X_LAST_UPDATED_BY := -1;
2097: end if;
2098: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
2099: if X_LAST_UPDATE_LOGIN is NULL then
2100: X_LAST_UPDATE_LOGIN := -1;
2101: end if;
2102: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2098: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
2099: if X_LAST_UPDATE_LOGIN is NULL then
2100: X_LAST_UPDATE_LOGIN := -1;
2101: end if;
2102: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2103: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
2104:
2105: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
2106: if (X_REQUEST_ID = -1) then
2099: if X_LAST_UPDATE_LOGIN is NULL then
2100: X_LAST_UPDATE_LOGIN := -1;
2101: end if;
2102: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2103: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
2104:
2105: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
2106: if (X_REQUEST_ID = -1) then
2107: X_REQUEST_ID := NULL;
2101: end if;
2102: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2103: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
2104:
2105: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
2106: if (X_REQUEST_ID = -1) then
2107: X_REQUEST_ID := NULL;
2108: X_PROGRAM_ID := NULL;
2109: X_PROGRAM_APPLICATION_ID := NULL;
2611: if(X_MODE = 'I') then
2612: X_LAST_UPDATED_BY := 1;
2613: X_LAST_UPDATE_LOGIN := 0;
2614: elsif (X_MODE = 'R') then
2615: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2616: if X_LAST_UPDATED_BY is NULL then
2617: X_LAST_UPDATED_BY := -1;
2618: end if;
2619: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
2615: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2616: if X_LAST_UPDATED_BY is NULL then
2617: X_LAST_UPDATED_BY := -1;
2618: end if;
2619: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
2620: if X_LAST_UPDATE_LOGIN is NULL then
2621: X_LAST_UPDATE_LOGIN := -1;
2622: end if;
2623: else
2680: x_abort_flag => x_abort_flag
2681: );
2682:
2683: if (X_MODE = 'R') then
2684: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2685: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
2686: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
2687: if (X_REQUEST_ID = -1) then
2688: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
2681: );
2682:
2683: if (X_MODE = 'R') then
2684: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2685: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
2686: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
2687: if (X_REQUEST_ID = -1) then
2688: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
2689: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
2682:
2683: if (X_MODE = 'R') then
2684: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2685: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
2686: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
2687: if (X_REQUEST_ID = -1) then
2688: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
2689: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
2690: X_PROGRAM_APPLICATION_ID :=