485: IF (x_mode = 'I') THEN
486: x_last_updated_by := 1;
487: x_last_update_login := 0;
488: ELSIF (x_mode = 'R') THEN
489: x_last_updated_by := fnd_global.user_id;
490: IF (x_last_updated_by IS NULL) THEN
491: x_last_updated_by := -1;
492: END IF;
493: x_last_update_login := fnd_global.login_id;
489: x_last_updated_by := fnd_global.user_id;
490: IF (x_last_updated_by IS NULL) THEN
491: x_last_updated_by := -1;
492: END IF;
493: x_last_update_login := fnd_global.login_id;
494: IF (x_last_update_login IS NULL) THEN
495: x_last_update_login := -1;
496: END IF;
497: x_request_id := fnd_global.conc_request_id;
493: x_last_update_login := fnd_global.login_id;
494: IF (x_last_update_login IS NULL) THEN
495: x_last_update_login := -1;
496: END IF;
497: x_request_id := fnd_global.conc_request_id;
498: x_program_id := fnd_global.conc_program_id;
499: x_program_application_id := fnd_global.prog_appl_id;
500:
501: IF (x_request_id = -1) THEN
494: IF (x_last_update_login IS NULL) THEN
495: x_last_update_login := -1;
496: END IF;
497: x_request_id := fnd_global.conc_request_id;
498: x_program_id := fnd_global.conc_program_id;
499: x_program_application_id := fnd_global.prog_appl_id;
500:
501: IF (x_request_id = -1) THEN
502: x_request_id := NULL;
495: x_last_update_login := -1;
496: END IF;
497: x_request_id := fnd_global.conc_request_id;
498: x_program_id := fnd_global.conc_program_id;
499: x_program_application_id := fnd_global.prog_appl_id;
500:
501: IF (x_request_id = -1) THEN
502: x_request_id := NULL;
503: x_program_id := NULL;
974: IF (X_MODE = 'I') THEN
975: x_last_updated_by := 1;
976: x_last_update_login := 0;
977: ELSIF (x_mode = 'R') THEN
978: x_last_updated_by := fnd_global.user_id;
979: IF x_last_updated_by IS NULL THEN
980: x_last_updated_by := -1;
981: END IF;
982: x_last_update_login := fnd_global.login_id;
978: x_last_updated_by := fnd_global.user_id;
979: IF x_last_updated_by IS NULL THEN
980: x_last_updated_by := -1;
981: END IF;
982: x_last_update_login := fnd_global.login_id;
983: IF (x_last_update_login IS NULL) THEN
984: x_last_update_login := -1;
985: END IF;
986: ELSE
1050: x_last_update_login => x_last_update_login
1051: );
1052:
1053: IF (x_mode = 'R') THEN
1054: x_request_id := fnd_global.conc_request_id;
1055: x_program_id := fnd_global.conc_program_id;
1056: x_program_application_id := fnd_global.prog_appl_id;
1057: IF (x_request_id = -1) THEN
1058: x_request_id := old_references.request_id;
1051: );
1052:
1053: IF (x_mode = 'R') THEN
1054: x_request_id := fnd_global.conc_request_id;
1055: x_program_id := fnd_global.conc_program_id;
1056: x_program_application_id := fnd_global.prog_appl_id;
1057: IF (x_request_id = -1) THEN
1058: x_request_id := old_references.request_id;
1059: x_program_id := old_references.program_id;
1052:
1053: IF (x_mode = 'R') THEN
1054: x_request_id := fnd_global.conc_request_id;
1055: x_program_id := fnd_global.conc_program_id;
1056: x_program_application_id := fnd_global.prog_appl_id;
1057: IF (x_request_id = -1) THEN
1058: x_request_id := old_references.request_id;
1059: x_program_id := old_references.program_id;
1060: x_program_application_id := old_references.program_application_id;