255: IF (x_mode = 'I') THEN
256: x_last_updated_by := 1;
257: x_last_update_login := 0;
258: ELSIF (x_mode = 'R') THEN
259: x_last_updated_by := fnd_global.user_id;
260: IF (x_last_updated_by IS NULL) THEN
261: x_last_updated_by := -1;
262: END IF;
263: x_last_update_login := fnd_global.login_id;
259: x_last_updated_by := fnd_global.user_id;
260: IF (x_last_updated_by IS NULL) THEN
261: x_last_updated_by := -1;
262: END IF;
263: x_last_update_login := fnd_global.login_id;
264: IF (x_last_update_login IS NULL) THEN
265: x_last_update_login := -1;
266: END IF;
267: x_request_id := fnd_global.conc_request_id;
263: x_last_update_login := fnd_global.login_id;
264: IF (x_last_update_login IS NULL) THEN
265: x_last_update_login := -1;
266: END IF;
267: x_request_id := fnd_global.conc_request_id;
268: x_program_id := fnd_global.conc_program_id;
269: x_program_application_id := fnd_global.prog_appl_id;
270:
271: IF (x_request_id = -1) THEN
264: IF (x_last_update_login IS NULL) THEN
265: x_last_update_login := -1;
266: END IF;
267: x_request_id := fnd_global.conc_request_id;
268: x_program_id := fnd_global.conc_program_id;
269: x_program_application_id := fnd_global.prog_appl_id;
270:
271: IF (x_request_id = -1) THEN
272: x_request_id := NULL;
265: x_last_update_login := -1;
266: END IF;
267: x_request_id := fnd_global.conc_request_id;
268: x_program_id := fnd_global.conc_program_id;
269: x_program_application_id := fnd_global.prog_appl_id;
270:
271: IF (x_request_id = -1) THEN
272: x_request_id := NULL;
273: x_program_id := NULL;
434: IF (X_MODE = 'I') THEN
435: x_last_updated_by := 1;
436: x_last_update_login := 0;
437: ELSIF (x_mode = 'R') THEN
438: x_last_updated_by := fnd_global.user_id;
439: IF x_last_updated_by IS NULL THEN
440: x_last_updated_by := -1;
441: END IF;
442: x_last_update_login := fnd_global.login_id;
438: x_last_updated_by := fnd_global.user_id;
439: IF x_last_updated_by IS NULL THEN
440: x_last_updated_by := -1;
441: END IF;
442: x_last_update_login := fnd_global.login_id;
443: IF (x_last_update_login IS NULL) THEN
444: x_last_update_login := -1;
445: END IF;
446: ELSE
466: x_last_update_login => x_last_update_login
467: );
468:
469: IF (x_mode = 'R') THEN
470: x_request_id := fnd_global.conc_request_id;
471: x_program_id := fnd_global.conc_program_id;
472: x_program_application_id := fnd_global.prog_appl_id;
473: IF (x_request_id = -1) THEN
474: x_request_id := old_references.request_id;
467: );
468:
469: IF (x_mode = 'R') THEN
470: x_request_id := fnd_global.conc_request_id;
471: x_program_id := fnd_global.conc_program_id;
472: x_program_application_id := fnd_global.prog_appl_id;
473: IF (x_request_id = -1) THEN
474: x_request_id := old_references.request_id;
475: x_program_id := old_references.program_id;
468:
469: IF (x_mode = 'R') THEN
470: x_request_id := fnd_global.conc_request_id;
471: x_program_id := fnd_global.conc_program_id;
472: x_program_application_id := fnd_global.prog_appl_id;
473: IF (x_request_id = -1) THEN
474: x_request_id := old_references.request_id;
475: x_program_id := old_references.program_id;
476: x_program_application_id := old_references.program_application_id;