360: IF (x_mode = 'I') THEN
361: x_last_updated_by := 1;
362: x_last_update_login := 0;
363: ELSIF (x_mode = 'R') THEN
364: x_last_updated_by := fnd_global.user_id;
365: IF (x_last_updated_by IS NULL) THEN
366: x_last_updated_by := -1;
367: END IF;
368: x_last_update_login := fnd_global.login_id;
364: x_last_updated_by := fnd_global.user_id;
365: IF (x_last_updated_by IS NULL) THEN
366: x_last_updated_by := -1;
367: END IF;
368: x_last_update_login := fnd_global.login_id;
369: IF (x_last_update_login IS NULL) THEN
370: x_last_update_login := -1;
371: END IF;
372: x_request_id := fnd_global.conc_request_id;
368: x_last_update_login := fnd_global.login_id;
369: IF (x_last_update_login IS NULL) THEN
370: x_last_update_login := -1;
371: END IF;
372: x_request_id := fnd_global.conc_request_id;
373: x_program_id := fnd_global.conc_program_id;
374: x_program_application_id := fnd_global.prog_appl_id;
375:
376: IF (x_request_id = -1) THEN
369: IF (x_last_update_login IS NULL) THEN
370: x_last_update_login := -1;
371: END IF;
372: x_request_id := fnd_global.conc_request_id;
373: x_program_id := fnd_global.conc_program_id;
374: x_program_application_id := fnd_global.prog_appl_id;
375:
376: IF (x_request_id = -1) THEN
377: x_request_id := NULL;
370: x_last_update_login := -1;
371: END IF;
372: x_request_id := fnd_global.conc_request_id;
373: x_program_id := fnd_global.conc_program_id;
374: x_program_application_id := fnd_global.prog_appl_id;
375:
376: IF (x_request_id = -1) THEN
377: x_request_id := NULL;
378: x_program_id := NULL;
532: IF (X_MODE = 'I') THEN
533: x_last_updated_by := 1;
534: x_last_update_login := 0;
535: ELSIF (x_mode = 'R') THEN
536: x_last_updated_by := fnd_global.user_id;
537: IF x_last_updated_by IS NULL THEN
538: x_last_updated_by := -1;
539: END IF;
540: x_last_update_login := fnd_global.login_id;
536: x_last_updated_by := fnd_global.user_id;
537: IF x_last_updated_by IS NULL THEN
538: x_last_updated_by := -1;
539: END IF;
540: x_last_update_login := fnd_global.login_id;
541: IF (x_last_update_login IS NULL) THEN
542: x_last_update_login := -1;
543: END IF;
544: ELSE
563: x_last_update_login => x_last_update_login
564: );
565:
566: IF (x_mode = 'R') THEN
567: x_request_id := fnd_global.conc_request_id;
568: x_program_id := fnd_global.conc_program_id;
569: x_program_application_id := fnd_global.prog_appl_id;
570: IF (x_request_id = -1) THEN
571: x_request_id := old_references.request_id;
564: );
565:
566: IF (x_mode = 'R') THEN
567: x_request_id := fnd_global.conc_request_id;
568: x_program_id := fnd_global.conc_program_id;
569: x_program_application_id := fnd_global.prog_appl_id;
570: IF (x_request_id = -1) THEN
571: x_request_id := old_references.request_id;
572: x_program_id := old_references.program_id;
565:
566: IF (x_mode = 'R') THEN
567: x_request_id := fnd_global.conc_request_id;
568: x_program_id := fnd_global.conc_program_id;
569: x_program_application_id := fnd_global.prog_appl_id;
570: IF (x_request_id = -1) THEN
571: x_request_id := old_references.request_id;
572: x_program_id := old_references.program_id;
573: x_program_application_id := old_references.program_application_id;