eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_UTIL dependencies on FND_ORACLE_USERID

Line 30: from fnd_oracle_userid

26: begin
27:
28: begin
29: select upper(oracle_username) into p_apps_username
30: from fnd_oracle_userid
31: where oracle_id between 900 and 999
32: and read_only_flag = 'U';
33: exception
34: when others then

Line 165: update_column(p_old_oid, p_new_oid, 'FND_ORACLE_USERID',

161: update_column(p_old_oid, p_new_oid, 'FND_DATA_GROUP_UNITS',
162: 'READ_ONLY_ORACLE_ID', p_option);
163: update_column(p_old_oid, p_new_oid, 'FND_DOC_SEQUENCE_ACCESS',
164: 'ORACLE_ID', p_option);
165: update_column(p_old_oid, p_new_oid, 'FND_ORACLE_USERID',
166: 'READ_ONLY_ORACLE_ID', p_option);
167: update_column(p_old_oid, p_new_oid, 'FND_REGRESSION_SUITES',
168: 'ORACLE_ID', p_option);
169: update_column(p_old_oid, p_new_oid, 'FND_REGRESSION_TESTS',

Line 174: -- ORACLE_ID in FND_ORACLE_USERID itself.

170: 'ORACLE_ID', p_option);
171: ----------------------------------------------------------------------------
172: -- FND_PRODUCT% and FND_MODULE% tables are updated separately by AutoInstall
173: -- but we update them here in the PL/SQL API plus we also need to update
174: -- ORACLE_ID in FND_ORACLE_USERID itself.
175: ----------------------------------------------------------------------------
176: update_column(p_old_oid, p_new_oid, 'FND_MODULE_INSTALLATIONS',
177: 'ORACLE_ID', p_option);
178: update_column(p_old_oid, p_new_oid, 'FND_PRODUCT_INSTALLATIONS',

Line 184: update_column(p_old_oid, p_new_oid, 'FND_ORACLE_USERID',

180: update_column(p_old_oid, p_new_oid, 'FND_PRODUCT_DEPENDENCIES',
181: 'ORACLE_ID', p_option);
182: update_column(p_old_oid, p_new_oid, 'FND_PRODUCT_DEPENDENCIES',
183: 'REQUIRED_ORACLE_ID', p_option);
184: update_column(p_old_oid, p_new_oid, 'FND_ORACLE_USERID',
185: 'ORACLE_ID', p_option);
186:
187: end up_oid;
188:

Line 230: -- sequence FND_ORACLE_USERID_S.nextval

226: --
227: -- OVERLOADED PUBLIC FUNCTION UPDATE_ORACLE_ID
228: --
229: -- here the new oracle_id is generated from the
230: -- sequence FND_ORACLE_USERID_S.nextval
231: --
232: --------------------------------------------------
233: procedure update_oracle_id
234: (p_release in varchar2,

Line 241: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');

237: is
238: p_new_oid number;
239: begin
240:
241: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');
242:
243: select fnd_oracle_userid_s.nextval into p_new_oid
244: from dual;
245:

Line 243: select fnd_oracle_userid_s.nextval into p_new_oid

239: begin
240:
241: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');
242:
243: select fnd_oracle_userid_s.nextval into p_new_oid
244: from dual;
245:
246: up_oid(p_release, p_old_oid, p_new_oid, p_option);
247:

Line 391: fnd_oracle_userid u

387: u.oracle_id),
388: u.oracle_id)
389: from fnd_data_groups dg,
390: fnd_data_group_units du,
391: fnd_oracle_userid u
392: where du.data_group_id = dg.data_group_id
393: and du.created_by = 1
394: and dg.created_by = 1
395: and du.oracle_id = u.oracle_id

Line 436: fnd_oracle_userid u

432: 0,
433: u.oracle_id
434: from fnd_data_groups dg,
435: fnd_data_group_units du,
436: fnd_oracle_userid u
437: where du.data_group_id = dg.data_group_id
438: and du.created_by = 1
439: and dg.created_by = 1
440: and du.oracle_id = u.oracle_id