370: IF (x_mode = 'I') THEN
371: x_last_updated_by := 1;
372: x_last_update_login := 0;
373: ELSIF (x_mode = 'R') THEN
374: x_last_updated_by := fnd_global.user_id;
375: IF (x_last_updated_by IS NULL) THEN
376: x_last_updated_by := -1;
377: END IF;
378: x_last_update_login := fnd_global.login_id;
374: x_last_updated_by := fnd_global.user_id;
375: IF (x_last_updated_by IS NULL) THEN
376: x_last_updated_by := -1;
377: END IF;
378: x_last_update_login := fnd_global.login_id;
379: IF (x_last_update_login IS NULL) THEN
380: x_last_update_login := -1;
381: END IF;
382: x_request_id := fnd_global.conc_request_id;
378: x_last_update_login := fnd_global.login_id;
379: IF (x_last_update_login IS NULL) THEN
380: x_last_update_login := -1;
381: END IF;
382: x_request_id := fnd_global.conc_request_id;
383: x_program_id := fnd_global.conc_program_id;
384: x_program_application_id := fnd_global.prog_appl_id;
385:
386: IF (x_request_id = -1) THEN
379: IF (x_last_update_login IS NULL) THEN
380: x_last_update_login := -1;
381: END IF;
382: x_request_id := fnd_global.conc_request_id;
383: x_program_id := fnd_global.conc_program_id;
384: x_program_application_id := fnd_global.prog_appl_id;
385:
386: IF (x_request_id = -1) THEN
387: x_request_id := NULL;
380: x_last_update_login := -1;
381: END IF;
382: x_request_id := fnd_global.conc_request_id;
383: x_program_id := fnd_global.conc_program_id;
384: x_program_application_id := fnd_global.prog_appl_id;
385:
386: IF (x_request_id = -1) THEN
387: x_request_id := NULL;
388: x_program_id := NULL;
536: IF (X_MODE = 'I') THEN
537: x_last_updated_by := 1;
538: x_last_update_login := 0;
539: ELSIF (x_mode = 'R') THEN
540: x_last_updated_by := fnd_global.user_id;
541: IF x_last_updated_by IS NULL THEN
542: x_last_updated_by := -1;
543: END IF;
544: x_last_update_login := fnd_global.login_id;
540: x_last_updated_by := fnd_global.user_id;
541: IF x_last_updated_by IS NULL THEN
542: x_last_updated_by := -1;
543: END IF;
544: x_last_update_login := fnd_global.login_id;
545: IF (x_last_update_login IS NULL) THEN
546: x_last_update_login := -1;
547: END IF;
548: ELSE
565: x_last_update_login => x_last_update_login
566: );
567:
568: IF (x_mode = 'R') THEN
569: x_request_id := fnd_global.conc_request_id;
570: x_program_id := fnd_global.conc_program_id;
571: x_program_application_id := fnd_global.prog_appl_id;
572: IF (x_request_id = -1) THEN
573: x_request_id := old_references.request_id;
566: );
567:
568: IF (x_mode = 'R') THEN
569: x_request_id := fnd_global.conc_request_id;
570: x_program_id := fnd_global.conc_program_id;
571: x_program_application_id := fnd_global.prog_appl_id;
572: IF (x_request_id = -1) THEN
573: x_request_id := old_references.request_id;
574: x_program_id := old_references.program_id;
567:
568: IF (x_mode = 'R') THEN
569: x_request_id := fnd_global.conc_request_id;
570: x_program_id := fnd_global.conc_program_id;
571: x_program_application_id := fnd_global.prog_appl_id;
572: IF (x_request_id = -1) THEN
573: x_request_id := old_references.request_id;
574: x_program_id := old_references.program_id;
575: x_program_application_id := old_references.program_application_id;