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 164: update_column(p_old_oid, p_new_oid, 'FND_ORACLE_USERID',

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

Line 173: -- ORACLE_ID in FND_ORACLE_USERID itself.

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

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

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

Line 229: -- sequence FND_ORACLE_USERID_S.nextval

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,

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

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:

Line 242: select fnd_oracle_userid_s.nextval into p_new_oid

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:

Line 390: fnd_oracle_userid u

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

Line 435: fnd_oracle_userid u

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