279: IF (x_mode = 'I') THEN
280: x_last_updated_by := 1;
281: x_last_update_login := 0;
282: ELSIF (x_mode = 'R') THEN
283: x_last_updated_by := fnd_global.user_id;
284: IF (x_last_updated_by IS NULL) THEN
285: x_last_updated_by := -1;
286: END IF;
287: x_last_update_login := fnd_global.login_id;
283: x_last_updated_by := fnd_global.user_id;
284: IF (x_last_updated_by IS NULL) THEN
285: x_last_updated_by := -1;
286: END IF;
287: x_last_update_login := fnd_global.login_id;
288: IF (x_last_update_login IS NULL) THEN
289: x_last_update_login := -1;
290: END IF;
291: x_request_id := fnd_global.conc_request_id;
287: x_last_update_login := fnd_global.login_id;
288: IF (x_last_update_login IS NULL) THEN
289: x_last_update_login := -1;
290: END IF;
291: x_request_id := fnd_global.conc_request_id;
292: x_program_id := fnd_global.conc_program_id;
293: x_program_application_id := fnd_global.prog_appl_id;
294:
295: IF (x_request_id = -1) THEN
288: IF (x_last_update_login IS NULL) THEN
289: x_last_update_login := -1;
290: END IF;
291: x_request_id := fnd_global.conc_request_id;
292: x_program_id := fnd_global.conc_program_id;
293: x_program_application_id := fnd_global.prog_appl_id;
294:
295: IF (x_request_id = -1) THEN
296: x_request_id := NULL;
289: x_last_update_login := -1;
290: END IF;
291: x_request_id := fnd_global.conc_request_id;
292: x_program_id := fnd_global.conc_program_id;
293: x_program_application_id := fnd_global.prog_appl_id;
294:
295: IF (x_request_id = -1) THEN
296: x_request_id := NULL;
297: x_program_id := NULL;
440: IF (X_MODE = 'I') THEN
441: x_last_updated_by := 1;
442: x_last_update_login := 0;
443: ELSIF (x_mode = 'R') THEN
444: x_last_updated_by := fnd_global.user_id;
445: IF x_last_updated_by IS NULL THEN
446: x_last_updated_by := -1;
447: END IF;
448: x_last_update_login := fnd_global.login_id;
444: x_last_updated_by := fnd_global.user_id;
445: IF x_last_updated_by IS NULL THEN
446: x_last_updated_by := -1;
447: END IF;
448: x_last_update_login := fnd_global.login_id;
449: IF (x_last_update_login IS NULL) THEN
450: x_last_update_login := -1;
451: END IF;
452: ELSE
470: x_last_update_login => x_last_update_login
471: );
472:
473: IF (x_mode = 'R') THEN
474: x_request_id := fnd_global.conc_request_id;
475: x_program_id := fnd_global.conc_program_id;
476: x_program_application_id := fnd_global.prog_appl_id;
477: IF (x_request_id = -1) THEN
478: x_request_id := old_references.request_id;
471: );
472:
473: IF (x_mode = 'R') THEN
474: x_request_id := fnd_global.conc_request_id;
475: x_program_id := fnd_global.conc_program_id;
476: x_program_application_id := fnd_global.prog_appl_id;
477: IF (x_request_id = -1) THEN
478: x_request_id := old_references.request_id;
479: x_program_id := old_references.program_id;
472:
473: IF (x_mode = 'R') THEN
474: x_request_id := fnd_global.conc_request_id;
475: x_program_id := fnd_global.conc_program_id;
476: x_program_application_id := fnd_global.prog_appl_id;
477: IF (x_request_id = -1) THEN
478: x_request_id := old_references.request_id;
479: x_program_id := old_references.program_id;
480: x_program_application_id := old_references.program_application_id;