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 177: update_column(p_old_oid, p_new_oid, 'FND_PRODUCT_INSTALLATIONS',

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

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

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

Line 300: x_oracle_id fnd_product_installations.oracle_id%TYPE;

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

Line 301: x_db_status fnd_product_installations.db_status%TYPE;

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

Line 302: x_status fnd_product_installations.status%TYPE;

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

Line 303: x_ign fnd_product_installations.install_group_num%TYPE;

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

Line 310: from fnd_product_installations

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

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

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

Line 336: update fnd_product_installations

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

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

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

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

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