225: --
226: -- OVERLOADED PUBLIC FUNCTION UPDATE_ORACLE_ID
227: --
228: -- here the new oracle_id is generated from the
229: -- sequence FND_ORACLE_USERID_S.nextval
230: --
231: --------------------------------------------------
232: procedure update_oracle_id
233: (p_release in varchar2,
236: is
237: p_new_oid number;
238: begin
239:
240: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');
241:
242: select fnd_oracle_userid_s.nextval into p_new_oid
243: from dual;
244:
238: begin
239:
240: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');
241:
242: select fnd_oracle_userid_s.nextval into p_new_oid
243: from dual;
244:
245: up_oid(p_release, p_old_oid, p_new_oid, p_option);
246: