410: if(X_MODE = 'I') then
411: X_LAST_UPDATED_BY := 1;
412: X_LAST_UPDATE_LOGIN := 0;
413: elsif (X_MODE = 'R') then
414: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
415: if X_LAST_UPDATED_BY is NULL then
416: X_LAST_UPDATED_BY := -1;
417: end if;
418: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
414: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
415: if X_LAST_UPDATED_BY is NULL then
416: X_LAST_UPDATED_BY := -1;
417: end if;
418: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
419: if X_LAST_UPDATE_LOGIN is NULL then
420: X_LAST_UPDATE_LOGIN := -1;
421: end if;
422: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
418: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
419: if X_LAST_UPDATE_LOGIN is NULL then
420: X_LAST_UPDATE_LOGIN := -1;
421: end if;
422: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
423: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
424: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
425: if (X_REQUEST_ID = -1) then
426: X_REQUEST_ID := NULL;
419: if X_LAST_UPDATE_LOGIN is NULL then
420: X_LAST_UPDATE_LOGIN := -1;
421: end if;
422: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
423: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
424: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
425: if (X_REQUEST_ID = -1) then
426: X_REQUEST_ID := NULL;
427: X_PROGRAM_ID := NULL;
420: X_LAST_UPDATE_LOGIN := -1;
421: end if;
422: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
423: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
424: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
425: if (X_REQUEST_ID = -1) then
426: X_REQUEST_ID := NULL;
427: X_PROGRAM_ID := NULL;
428: X_PROGRAM_APPLICATION_ID := NULL;
588: if(X_MODE = 'I') then
589: X_LAST_UPDATED_BY := 1;
590: X_LAST_UPDATE_LOGIN := 0;
591: elsif (X_MODE = 'R') then
592: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
593: if X_LAST_UPDATED_BY is NULL then
594: X_LAST_UPDATED_BY := -1;
595: end if;
596: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
592: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
593: if X_LAST_UPDATED_BY is NULL then
594: X_LAST_UPDATED_BY := -1;
595: end if;
596: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
597: if X_LAST_UPDATE_LOGIN is NULL then
598: X_LAST_UPDATE_LOGIN := -1;
599: end if;
600: else
618: x_last_update_login=>X_LAST_UPDATE_LOGIN
619: );
620:
621: if (X_MODE = 'R') then
622: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
623: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
624: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
625: if (X_REQUEST_ID = -1) then
626: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
619: );
620:
621: if (X_MODE = 'R') then
622: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
623: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
624: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
625: if (X_REQUEST_ID = -1) then
626: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
627: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
620:
621: if (X_MODE = 'R') then
622: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
623: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
624: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
625: if (X_REQUEST_ID = -1) then
626: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
627: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
628: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;