298: IF (x_mode = 'I') THEN
299: x_last_updated_by := 1;
300: x_last_update_login := 0;
301: ELSIF (x_mode = 'R') THEN
302: x_last_updated_by := fnd_global.user_id;
303: IF (x_last_updated_by IS NULL) THEN
304: x_last_updated_by := -1;
305: END IF;
306: x_last_update_login := fnd_global.login_id;
302: x_last_updated_by := fnd_global.user_id;
303: IF (x_last_updated_by IS NULL) THEN
304: x_last_updated_by := -1;
305: END IF;
306: x_last_update_login := fnd_global.login_id;
307: IF (x_last_update_login IS NULL) THEN
308: x_last_update_login := -1;
309: END IF;
310: x_request_id := fnd_global.conc_request_id;
306: x_last_update_login := fnd_global.login_id;
307: IF (x_last_update_login IS NULL) THEN
308: x_last_update_login := -1;
309: END IF;
310: x_request_id := fnd_global.conc_request_id;
311: x_program_id := fnd_global.conc_program_id;
312: x_program_application_id := fnd_global.prog_appl_id;
313:
314: IF (x_request_id = -1) THEN
307: IF (x_last_update_login IS NULL) THEN
308: x_last_update_login := -1;
309: END IF;
310: x_request_id := fnd_global.conc_request_id;
311: x_program_id := fnd_global.conc_program_id;
312: x_program_application_id := fnd_global.prog_appl_id;
313:
314: IF (x_request_id = -1) THEN
315: x_request_id := NULL;
308: x_last_update_login := -1;
309: END IF;
310: x_request_id := fnd_global.conc_request_id;
311: x_program_id := fnd_global.conc_program_id;
312: x_program_application_id := fnd_global.prog_appl_id;
313:
314: IF (x_request_id = -1) THEN
315: x_request_id := NULL;
316: x_program_id := NULL;
507: IF (X_MODE = 'I') THEN
508: x_last_updated_by := 1;
509: x_last_update_login := 0;
510: ELSIF (x_mode = 'R') THEN
511: x_last_updated_by := fnd_global.user_id;
512: IF x_last_updated_by IS NULL THEN
513: x_last_updated_by := -1;
514: END IF;
515: x_last_update_login := fnd_global.login_id;
511: x_last_updated_by := fnd_global.user_id;
512: IF x_last_updated_by IS NULL THEN
513: x_last_updated_by := -1;
514: END IF;
515: x_last_update_login := fnd_global.login_id;
516: IF (x_last_update_login IS NULL) THEN
517: x_last_update_login := -1;
518: END IF;
519: ELSE
543: x_last_update_login => x_last_update_login
544: );
545:
546: IF (x_mode = 'R') THEN
547: x_request_id := fnd_global.conc_request_id;
548: x_program_id := fnd_global.conc_program_id;
549: x_program_application_id := fnd_global.prog_appl_id;
550: IF (x_request_id = -1) THEN
551: x_request_id := old_references.request_id;
544: );
545:
546: IF (x_mode = 'R') THEN
547: x_request_id := fnd_global.conc_request_id;
548: x_program_id := fnd_global.conc_program_id;
549: x_program_application_id := fnd_global.prog_appl_id;
550: IF (x_request_id = -1) THEN
551: x_request_id := old_references.request_id;
552: x_program_id := old_references.program_id;
545:
546: IF (x_mode = 'R') THEN
547: x_request_id := fnd_global.conc_request_id;
548: x_program_id := fnd_global.conc_program_id;
549: x_program_application_id := fnd_global.prog_appl_id;
550: IF (x_request_id = -1) THEN
551: x_request_id := old_references.request_id;
552: x_program_id := old_references.program_id;
553: x_program_application_id := old_references.program_application_id;