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_PRODUCT_INSTALLATIONS

Line 178: update_column(p_old_oid, p_new_oid, 'FND_PRODUCT_INSTALLATIONS',

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',
179: 'ORACLE_ID', p_option);
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',

Line 289: -- This function changes a product's status in fnd_product_installations

285: --------------------------------------------------
286: --
287: -- PUBLIC FUNCTION SET_PROD_TO_SHARED
288: --
289: -- This function changes a product's status in fnd_product_installations
290: -- to be 'S' if the db_status is 'I', and inserts a row into
291: -- fnd_data_group_units if it's not already there.
292: -- If product's status is already 'I' or 'S', doesn't do anything
293: --

Line 301: x_oracle_id fnd_product_installations.oracle_id%TYPE;

297: procedure set_prod_to_shared
298: (p_release in varchar2,
299: p_apps_short_name in varchar2)
300: is
301: x_oracle_id fnd_product_installations.oracle_id%TYPE;
302: x_db_status fnd_product_installations.db_status%TYPE;
303: x_status fnd_product_installations.status%TYPE;
304: x_ign fnd_product_installations.install_group_num%TYPE;
305:

Line 302: x_db_status fnd_product_installations.db_status%TYPE;

298: (p_release in varchar2,
299: p_apps_short_name in varchar2)
300: is
301: x_oracle_id fnd_product_installations.oracle_id%TYPE;
302: x_db_status fnd_product_installations.db_status%TYPE;
303: x_status fnd_product_installations.status%TYPE;
304: x_ign fnd_product_installations.install_group_num%TYPE;
305:
306: appid number; /* application id for the product */

Line 303: x_status fnd_product_installations.status%TYPE;

299: p_apps_short_name in varchar2)
300: is
301: x_oracle_id fnd_product_installations.oracle_id%TYPE;
302: x_db_status fnd_product_installations.db_status%TYPE;
303: x_status fnd_product_installations.status%TYPE;
304: x_ign fnd_product_installations.install_group_num%TYPE;
305:
306: appid number; /* application id for the product */
307: errmsg varchar2(240);

Line 304: x_ign fnd_product_installations.install_group_num%TYPE;

300: is
301: x_oracle_id fnd_product_installations.oracle_id%TYPE;
302: x_db_status fnd_product_installations.db_status%TYPE;
303: x_status fnd_product_installations.status%TYPE;
304: x_ign fnd_product_installations.install_group_num%TYPE;
305:
306: appid number; /* application id for the product */
307: errmsg varchar2(240);
308:

Line 311: from fnd_product_installations

307: errmsg varchar2(240);
308:
309: cursor x_cursor (appl_id in number) is
310: select oracle_id, db_status, status, install_group_num
311: from fnd_product_installations
312: where application_id = appl_id;
313:
314: begin
315: --

Line 334: errmsg := 'update fnd_product_installations for oracle_id '||

330: if x_status is null or (x_status <> 'I' and x_status <> 'S') then
331: --
332: -- set the status to be licensed
333: --
334: errmsg := 'update fnd_product_installations for oracle_id '||
335: x_oracle_id;
336: dbms_output.put_line(errmsg);
337: update fnd_product_installations
338: set status = 'S',

Line 337: update fnd_product_installations

333: --
334: errmsg := 'update fnd_product_installations for oracle_id '||
335: x_oracle_id;
336: dbms_output.put_line(errmsg);
337: update fnd_product_installations
338: set status = 'S',
339: last_update_date = sysdate
340: where application_id = appid
341: and oracle_id = x_oracle_id;

Line 345: ' row updated in fnd_product_installations.');

341: and oracle_id = x_oracle_id;
342:
343: if SQL%ROWCOUNT = 1 then
344: dbms_output.put_line(SQL%ROWCOUNT||
345: ' row updated in fnd_product_installations.');
346: else
347: dbms_output.put_line(SQL%ROWCOUNT||
348: ' rows updated in fnd_product_installations.');
349: end if;

Line 348: ' rows updated in fnd_product_installations.');

344: dbms_output.put_line(SQL%ROWCOUNT||
345: ' row updated in fnd_product_installations.');
346: else
347: dbms_output.put_line(SQL%ROWCOUNT||
348: ' rows updated in fnd_product_installations.');
349: end if;
350:
351: --
352: -- For application id (0, 1, 3, 50, 160) the application_id