497: IF (x_mode = 'I') THEN
498: x_last_updated_by := 1;
499: x_last_update_login := 0;
500: ELSIF (x_mode = 'R') THEN
501: x_last_updated_by := fnd_global.user_id;
502: IF (x_last_updated_by IS NULL) THEN
503: x_last_updated_by := -1;
504: END IF;
505: x_last_update_login := fnd_global.login_id;
501: x_last_updated_by := fnd_global.user_id;
502: IF (x_last_updated_by IS NULL) THEN
503: x_last_updated_by := -1;
504: END IF;
505: x_last_update_login := fnd_global.login_id;
506: IF (x_last_update_login IS NULL) THEN
507: x_last_update_login := -1;
508: END IF;
509: x_request_id := fnd_global.conc_request_id;
505: x_last_update_login := fnd_global.login_id;
506: IF (x_last_update_login IS NULL) THEN
507: x_last_update_login := -1;
508: END IF;
509: x_request_id := fnd_global.conc_request_id;
510: x_program_id := fnd_global.conc_program_id;
511: x_program_application_id := fnd_global.prog_appl_id;
512:
513: IF (x_request_id = -1) THEN
506: IF (x_last_update_login IS NULL) THEN
507: x_last_update_login := -1;
508: END IF;
509: x_request_id := fnd_global.conc_request_id;
510: x_program_id := fnd_global.conc_program_id;
511: x_program_application_id := fnd_global.prog_appl_id;
512:
513: IF (x_request_id = -1) THEN
514: x_request_id := NULL;
507: x_last_update_login := -1;
508: END IF;
509: x_request_id := fnd_global.conc_request_id;
510: x_program_id := fnd_global.conc_program_id;
511: x_program_application_id := fnd_global.prog_appl_id;
512:
513: IF (x_request_id = -1) THEN
514: x_request_id := NULL;
515: x_program_id := NULL;
711: IF (X_MODE = 'I') THEN
712: x_last_updated_by := 1;
713: x_last_update_login := 0;
714: ELSIF (x_mode = 'R') THEN
715: x_last_updated_by := fnd_global.user_id;
716: IF x_last_updated_by IS NULL THEN
717: x_last_updated_by := -1;
718: END IF;
719: x_last_update_login := fnd_global.login_id;
715: x_last_updated_by := fnd_global.user_id;
716: IF x_last_updated_by IS NULL THEN
717: x_last_updated_by := -1;
718: END IF;
719: x_last_update_login := fnd_global.login_id;
720: IF (x_last_update_login IS NULL) THEN
721: x_last_update_login := -1;
722: END IF;
723: ELSE
744: x_last_update_login => x_last_update_login
745: );
746:
747: IF (x_mode = 'R') THEN
748: x_request_id := fnd_global.conc_request_id;
749: x_program_id := fnd_global.conc_program_id;
750: x_program_application_id := fnd_global.prog_appl_id;
751: IF (x_request_id = -1) THEN
752: x_request_id := old_references.request_id;
745: );
746:
747: IF (x_mode = 'R') THEN
748: x_request_id := fnd_global.conc_request_id;
749: x_program_id := fnd_global.conc_program_id;
750: x_program_application_id := fnd_global.prog_appl_id;
751: IF (x_request_id = -1) THEN
752: x_request_id := old_references.request_id;
753: x_program_id := old_references.program_id;
746:
747: IF (x_mode = 'R') THEN
748: x_request_id := fnd_global.conc_request_id;
749: x_program_id := fnd_global.conc_program_id;
750: x_program_application_id := fnd_global.prog_appl_id;
751: IF (x_request_id = -1) THEN
752: x_request_id := old_references.request_id;
753: x_program_id := old_references.program_id;
754: x_program_application_id := old_references.program_application_id;