569: IF (x_mode = 'I') THEN
570: x_last_updated_by := 1;
571: x_last_update_login := 0;
572: ELSIF (x_mode = 'R') THEN
573: x_last_updated_by := fnd_global.user_id;
574: IF (x_last_updated_by IS NULL) THEN
575: x_last_updated_by := -1;
576: END IF;
577: x_last_update_login := fnd_global.login_id;
573: x_last_updated_by := fnd_global.user_id;
574: IF (x_last_updated_by IS NULL) THEN
575: x_last_updated_by := -1;
576: END IF;
577: x_last_update_login := fnd_global.login_id;
578: IF (x_last_update_login IS NULL) THEN
579: x_last_update_login := -1;
580: END IF;
581: x_request_id := fnd_global.conc_request_id;
577: x_last_update_login := fnd_global.login_id;
578: IF (x_last_update_login IS NULL) THEN
579: x_last_update_login := -1;
580: END IF;
581: x_request_id := fnd_global.conc_request_id;
582: x_program_id := fnd_global.conc_program_id;
583: x_program_application_id := fnd_global.prog_appl_id;
584:
585: IF (x_request_id = -1) THEN
578: IF (x_last_update_login IS NULL) THEN
579: x_last_update_login := -1;
580: END IF;
581: x_request_id := fnd_global.conc_request_id;
582: x_program_id := fnd_global.conc_program_id;
583: x_program_application_id := fnd_global.prog_appl_id;
584:
585: IF (x_request_id = -1) THEN
586: x_request_id := NULL;
579: x_last_update_login := -1;
580: END IF;
581: x_request_id := fnd_global.conc_request_id;
582: x_program_id := fnd_global.conc_program_id;
583: x_program_application_id := fnd_global.prog_appl_id;
584:
585: IF (x_request_id = -1) THEN
586: x_request_id := NULL;
587: x_program_id := NULL;
797: IF (X_MODE = 'I') THEN
798: x_last_updated_by := 1;
799: x_last_update_login := 0;
800: ELSIF (x_mode = 'R') THEN
801: x_last_updated_by := fnd_global.user_id;
802: IF x_last_updated_by IS NULL THEN
803: x_last_updated_by := -1;
804: END IF;
805: x_last_update_login := fnd_global.login_id;
801: x_last_updated_by := fnd_global.user_id;
802: IF x_last_updated_by IS NULL THEN
803: x_last_updated_by := -1;
804: END IF;
805: x_last_update_login := fnd_global.login_id;
806: IF (x_last_update_login IS NULL) THEN
807: x_last_update_login := -1;
808: END IF;
809: ELSE
835: x_last_update_login => x_last_update_login
836: );
837:
838: IF (x_mode = 'R') THEN
839: x_request_id := fnd_global.conc_request_id;
840: x_program_id := fnd_global.conc_program_id;
841: x_program_application_id := fnd_global.prog_appl_id;
842: IF (x_request_id = -1) THEN
843: x_request_id := old_references.request_id;
836: );
837:
838: IF (x_mode = 'R') THEN
839: x_request_id := fnd_global.conc_request_id;
840: x_program_id := fnd_global.conc_program_id;
841: x_program_application_id := fnd_global.prog_appl_id;
842: IF (x_request_id = -1) THEN
843: x_request_id := old_references.request_id;
844: x_program_id := old_references.program_id;
837:
838: IF (x_mode = 'R') THEN
839: x_request_id := fnd_global.conc_request_id;
840: x_program_id := fnd_global.conc_program_id;
841: x_program_application_id := fnd_global.prog_appl_id;
842: IF (x_request_id = -1) THEN
843: x_request_id := old_references.request_id;
844: x_program_id := old_references.program_id;
845: x_program_application_id := old_references.program_application_id;