297: IF (x_mode = 'I') THEN
298: x_last_updated_by := 1;
299: x_last_update_login := 0;
300: ELSIF (x_mode = 'R') THEN
301: x_last_updated_by := fnd_global.user_id;
302: IF (x_last_updated_by IS NULL) THEN
303: x_last_updated_by := -1;
304: END IF;
305: x_last_update_login := fnd_global.login_id;
301: x_last_updated_by := fnd_global.user_id;
302: IF (x_last_updated_by IS NULL) THEN
303: x_last_updated_by := -1;
304: END IF;
305: x_last_update_login := fnd_global.login_id;
306: IF (x_last_update_login IS NULL) THEN
307: x_last_update_login := -1;
308: END IF;
309: x_request_id := fnd_global.conc_request_id;
305: x_last_update_login := fnd_global.login_id;
306: IF (x_last_update_login IS NULL) THEN
307: x_last_update_login := -1;
308: END IF;
309: x_request_id := fnd_global.conc_request_id;
310: x_program_id := fnd_global.conc_program_id;
311: x_program_application_id := fnd_global.prog_appl_id;
312:
313: IF (x_request_id = -1) THEN
306: IF (x_last_update_login IS NULL) THEN
307: x_last_update_login := -1;
308: END IF;
309: x_request_id := fnd_global.conc_request_id;
310: x_program_id := fnd_global.conc_program_id;
311: x_program_application_id := fnd_global.prog_appl_id;
312:
313: IF (x_request_id = -1) THEN
314: x_request_id := NULL;
307: x_last_update_login := -1;
308: END IF;
309: x_request_id := fnd_global.conc_request_id;
310: x_program_id := fnd_global.conc_program_id;
311: x_program_application_id := fnd_global.prog_appl_id;
312:
313: IF (x_request_id = -1) THEN
314: x_request_id := NULL;
315: x_program_id := NULL;
509: IF (X_MODE = 'I') THEN
510: x_last_updated_by := 1;
511: x_last_update_login := 0;
512: ELSIF (x_mode = 'R') THEN
513: x_last_updated_by := fnd_global.user_id;
514: IF x_last_updated_by IS NULL THEN
515: x_last_updated_by := -1;
516: END IF;
517: x_last_update_login := fnd_global.login_id;
513: x_last_updated_by := fnd_global.user_id;
514: IF x_last_updated_by IS NULL THEN
515: x_last_updated_by := -1;
516: END IF;
517: x_last_update_login := fnd_global.login_id;
518: IF (x_last_update_login IS NULL) THEN
519: x_last_update_login := -1;
520: END IF;
521: 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;