263: IF (x_mode = 'I') THEN
264: x_last_updated_by := 1;
265: x_last_update_login := 0;
266: ELSIF (x_mode = 'R') THEN
267: x_last_updated_by := fnd_global.user_id;
268: IF (x_last_updated_by IS NULL) THEN
269: x_last_updated_by := -1;
270: END IF;
271: x_last_update_login := fnd_global.login_id;
267: x_last_updated_by := fnd_global.user_id;
268: IF (x_last_updated_by IS NULL) THEN
269: x_last_updated_by := -1;
270: END IF;
271: x_last_update_login := fnd_global.login_id;
272: IF (x_last_update_login IS NULL) THEN
273: x_last_update_login := -1;
274: END IF;
275: x_request_id := fnd_global.conc_request_id;
271: x_last_update_login := fnd_global.login_id;
272: IF (x_last_update_login IS NULL) THEN
273: x_last_update_login := -1;
274: END IF;
275: x_request_id := fnd_global.conc_request_id;
276: x_program_id := fnd_global.conc_program_id;
277: x_program_application_id := fnd_global.prog_appl_id;
278:
279: IF (x_request_id = -1) THEN
272: IF (x_last_update_login IS NULL) THEN
273: x_last_update_login := -1;
274: END IF;
275: x_request_id := fnd_global.conc_request_id;
276: x_program_id := fnd_global.conc_program_id;
277: x_program_application_id := fnd_global.prog_appl_id;
278:
279: IF (x_request_id = -1) THEN
280: x_request_id := NULL;
273: x_last_update_login := -1;
274: END IF;
275: x_request_id := fnd_global.conc_request_id;
276: x_program_id := fnd_global.conc_program_id;
277: x_program_application_id := fnd_global.prog_appl_id;
278:
279: IF (x_request_id = -1) THEN
280: x_request_id := NULL;
281: x_program_id := NULL;
473: IF (X_MODE = 'I') THEN
474: x_last_updated_by := 1;
475: x_last_update_login := 0;
476: ELSIF (x_mode = 'R') THEN
477: x_last_updated_by := fnd_global.user_id;
478: IF x_last_updated_by IS NULL THEN
479: x_last_updated_by := -1;
480: END IF;
481: x_last_update_login := fnd_global.login_id;
477: x_last_updated_by := fnd_global.user_id;
478: IF x_last_updated_by IS NULL THEN
479: x_last_updated_by := -1;
480: END IF;
481: x_last_update_login := fnd_global.login_id;
482: IF (x_last_update_login IS NULL) THEN
483: x_last_update_login := -1;
484: END IF;
485: ELSE
507: x_last_update_login => x_last_update_login
508: );
509:
510: IF (x_mode = 'R') THEN
511: x_request_id := fnd_global.conc_request_id;
512: x_program_id := fnd_global.conc_program_id;
513: x_program_application_id := fnd_global.prog_appl_id;
514: IF (x_request_id = -1) THEN
515: x_request_id := old_references.request_id;
508: );
509:
510: IF (x_mode = 'R') THEN
511: x_request_id := fnd_global.conc_request_id;
512: x_program_id := fnd_global.conc_program_id;
513: x_program_application_id := fnd_global.prog_appl_id;
514: IF (x_request_id = -1) THEN
515: x_request_id := old_references.request_id;
516: x_program_id := old_references.program_id;
509:
510: IF (x_mode = 'R') THEN
511: x_request_id := fnd_global.conc_request_id;
512: x_program_id := fnd_global.conc_program_id;
513: x_program_application_id := fnd_global.prog_appl_id;
514: IF (x_request_id = -1) THEN
515: x_request_id := old_references.request_id;
516: x_program_id := old_references.program_id;
517: x_program_application_id := old_references.program_application_id;