458: IF (x_mode = 'I') THEN
459: x_last_updated_by := 1;
460: x_last_update_login := 0;
461: ELSIF (x_mode = 'R') THEN
462: x_last_updated_by := fnd_global.user_id;
463: IF (x_last_updated_by IS NULL) THEN
464: x_last_updated_by := -1;
465: END IF;
466: x_last_update_login := fnd_global.login_id;
462: x_last_updated_by := fnd_global.user_id;
463: IF (x_last_updated_by IS NULL) THEN
464: x_last_updated_by := -1;
465: END IF;
466: x_last_update_login := fnd_global.login_id;
467: IF (x_last_update_login IS NULL) THEN
468: x_last_update_login := -1;
469: END IF;
470: x_request_id := fnd_global.conc_request_id;
466: x_last_update_login := fnd_global.login_id;
467: IF (x_last_update_login IS NULL) THEN
468: x_last_update_login := -1;
469: END IF;
470: x_request_id := fnd_global.conc_request_id;
471: x_program_id := fnd_global.conc_program_id;
472: x_program_application_id := fnd_global.prog_appl_id;
473:
474: IF (x_request_id = -1) THEN
467: IF (x_last_update_login IS NULL) THEN
468: x_last_update_login := -1;
469: END IF;
470: x_request_id := fnd_global.conc_request_id;
471: x_program_id := fnd_global.conc_program_id;
472: x_program_application_id := fnd_global.prog_appl_id;
473:
474: IF (x_request_id = -1) THEN
475: x_request_id := NULL;
468: x_last_update_login := -1;
469: END IF;
470: x_request_id := fnd_global.conc_request_id;
471: x_program_id := fnd_global.conc_program_id;
472: x_program_application_id := fnd_global.prog_appl_id;
473:
474: IF (x_request_id = -1) THEN
475: x_request_id := NULL;
476: x_program_id := NULL;
667: IF (X_MODE = 'I') THEN
668: x_last_updated_by := 1;
669: x_last_update_login := 0;
670: ELSIF (x_mode = 'R') THEN
671: x_last_updated_by := fnd_global.user_id;
672: IF x_last_updated_by IS NULL THEN
673: x_last_updated_by := -1;
674: END IF;
675: x_last_update_login := fnd_global.login_id;
671: x_last_updated_by := fnd_global.user_id;
672: IF x_last_updated_by IS NULL THEN
673: x_last_updated_by := -1;
674: END IF;
675: x_last_update_login := fnd_global.login_id;
676: IF (x_last_update_login IS NULL) THEN
677: x_last_update_login := -1;
678: END IF;
679: ELSE
701: x_last_update_login => x_last_update_login
702: );
703:
704: IF (x_mode = 'R') THEN
705: x_request_id := fnd_global.conc_request_id;
706: x_program_id := fnd_global.conc_program_id;
707: x_program_application_id := fnd_global.prog_appl_id;
708: IF (x_request_id = -1) THEN
709: x_request_id := old_references.request_id;
702: );
703:
704: IF (x_mode = 'R') THEN
705: x_request_id := fnd_global.conc_request_id;
706: x_program_id := fnd_global.conc_program_id;
707: x_program_application_id := fnd_global.prog_appl_id;
708: IF (x_request_id = -1) THEN
709: x_request_id := old_references.request_id;
710: x_program_id := old_references.program_id;
703:
704: IF (x_mode = 'R') THEN
705: x_request_id := fnd_global.conc_request_id;
706: x_program_id := fnd_global.conc_program_id;
707: x_program_application_id := fnd_global.prog_appl_id;
708: IF (x_request_id = -1) THEN
709: x_request_id := old_references.request_id;
710: x_program_id := old_references.program_id;
711: x_program_application_id := old_references.program_application_id;