392: if(X_MODE = 'I') then
393: X_LAST_UPDATED_BY := 1;
394: X_LAST_UPDATE_LOGIN := 0;
395: elsif (X_MODE = 'R') then
396: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
397: if X_LAST_UPDATED_BY is NULL then
398: X_LAST_UPDATED_BY := -1;
399: end if;
400: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
396: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
397: if X_LAST_UPDATED_BY is NULL then
398: X_LAST_UPDATED_BY := -1;
399: end if;
400: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
401: if X_LAST_UPDATE_LOGIN is NULL then
402: X_LAST_UPDATE_LOGIN := -1;
403: end if;
404:
401: if X_LAST_UPDATE_LOGIN is NULL then
402: X_LAST_UPDATE_LOGIN := -1;
403: end if;
404:
405: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
406: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
407: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
408: IF (X_REQUEST_ID = -1) THEN
409: X_REQUEST_ID := NULL;
402: X_LAST_UPDATE_LOGIN := -1;
403: end if;
404:
405: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
406: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
407: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
408: IF (X_REQUEST_ID = -1) THEN
409: X_REQUEST_ID := NULL;
410: X_PROGRAM_ID := NULL;
403: end if;
404:
405: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
406: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
407: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
408: IF (X_REQUEST_ID = -1) THEN
409: X_REQUEST_ID := NULL;
410: X_PROGRAM_ID := NULL;
411: X_PROGRAM_APPLICATION_ID := NULL;
554: if(X_MODE = 'I') then
555: X_LAST_UPDATED_BY := 1;
556: X_LAST_UPDATE_LOGIN := 0;
557: elsif (X_MODE = 'R') then
558: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
559: if X_LAST_UPDATED_BY is NULL then
560: X_LAST_UPDATED_BY := -1;
561: end if;
562: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
558: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
559: if X_LAST_UPDATED_BY is NULL then
560: X_LAST_UPDATED_BY := -1;
561: end if;
562: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
563: if X_LAST_UPDATE_LOGIN is NULL then
564: X_LAST_UPDATE_LOGIN := -1;
565: end if;
566: else
586: x_last_update_login => X_LAST_UPDATE_LOGIN
587: );
588:
589: if (X_MODE = 'R') then
590: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
591: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
592: X_PROGRAM_APPLICATION_ID :=
593: FND_GLOBAL.PROG_APPL_ID;
594: if (X_REQUEST_ID = -1) then
587: );
588:
589: if (X_MODE = 'R') then
590: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
591: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
592: X_PROGRAM_APPLICATION_ID :=
593: FND_GLOBAL.PROG_APPL_ID;
594: if (X_REQUEST_ID = -1) then
595: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
589: if (X_MODE = 'R') then
590: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
591: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
592: X_PROGRAM_APPLICATION_ID :=
593: FND_GLOBAL.PROG_APPL_ID;
594: if (X_REQUEST_ID = -1) then
595: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
596: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
597: X_PROGRAM_APPLICATION_ID :=