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_DATA_GROUP_UNITS

Line 158: update_column(p_old_oid, p_new_oid, 'FND_DATA_GROUP_UNITS',

154: ----------------- end of release 9 columns --------------------------
155:
156: update_column(p_old_oid, p_new_oid, 'FND_CONCURRENT_REQUESTS',
157: 'ORACLE_ID', p_option);
158: update_column(p_old_oid, p_new_oid, 'FND_DATA_GROUP_UNITS',
159: 'ORACLE_ID', p_option);
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',

Line 160: update_column(p_old_oid, p_new_oid, 'FND_DATA_GROUP_UNITS',

156: update_column(p_old_oid, p_new_oid, 'FND_CONCURRENT_REQUESTS',
157: 'ORACLE_ID', p_option);
158: update_column(p_old_oid, p_new_oid, 'FND_DATA_GROUP_UNITS',
159: 'ORACLE_ID', p_option);
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',

Line 290: -- fnd_data_group_units if it's not already there.

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: --
293: --
294: --

Line 363: insert into fnd_data_group_units

359:
360: -- insert a row of this product for every apps schema
361: -- decode is used to fulfill the requirement above.
362:
363: insert into fnd_data_group_units
364: (application_id,
365: data_group_id,
366: last_update_date,
367: last_updated_by,

Line 389: fnd_data_group_units du,

385: 160,0,
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

Line 398: from fnd_data_group_units u2

394: and du.oracle_id = u.oracle_id
395: and u.oracle_id between 900 and 999
396: and not exists
397: ( select 'x'
398: from fnd_data_group_units u2
399: where u2.data_group_id = dg.data_group_id
400: and u2.application_id = appid
401: );
402:

Line 405: ' row inserted into fnd_data_group_units.');

401: );
402:
403: if SQL%ROWCOUNT = 1 then
404: dbms_output.put_line(SQL%ROWCOUNT||
405: ' row inserted into fnd_data_group_units.');
406: else
407: dbms_output.put_line(SQL%ROWCOUNT||
408: ' rows inserted into fnd_data_group_units.');
409: end if;

Line 408: ' rows inserted into fnd_data_group_units.');

404: dbms_output.put_line(SQL%ROWCOUNT||
405: ' row inserted into fnd_data_group_units.');
406: else
407: dbms_output.put_line(SQL%ROWCOUNT||
408: ' rows inserted into fnd_data_group_units.');
409: end if;
410:
411: exit; -- exit the LOOP
412: end if;

Line 418: -- insert a row into fnd_data_group_units if not already exists.

414: --
415: -- If here, we have an MOA product, and x_ign should > 0
416: --
417: --
418: -- insert a row into fnd_data_group_units if not already exists.
419: --
420: errmsg := 'insert into fnd_data_group_units';
421:
422: insert into fnd_data_group_units

Line 420: errmsg := 'insert into fnd_data_group_units';

416: --
417: --
418: -- insert a row into fnd_data_group_units if not already exists.
419: --
420: errmsg := 'insert into fnd_data_group_units';
421:
422: insert into fnd_data_group_units
423: (application_id, data_group_id, last_update_date, last_updated_by,
424: creation_date, created_by, last_update_login, oracle_id)

Line 422: insert into fnd_data_group_units

418: -- insert a row into fnd_data_group_units if not already exists.
419: --
420: errmsg := 'insert into fnd_data_group_units';
421:
422: insert into fnd_data_group_units
423: (application_id, data_group_id, last_update_date, last_updated_by,
424: creation_date, created_by, last_update_login, oracle_id)
425: select distinct appid,
426: dg.data_group_id,

Line 434: fnd_data_group_units du,

430: 1,
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

Line 444: from fnd_data_group_units u2

440: and u.install_group_num = x_ign
441: and u.oracle_id between 900 and 999
442: and not exists
443: ( select 'x'
444: from fnd_data_group_units u2
445: where u2.data_group_id = dg.data_group_id
446: and u2.application_id = appid
447: );
448:

Line 451: ' row inserted into fnd_data_group_units.');

447: );
448:
449: if SQL%ROWCOUNT = 1 then
450: dbms_output.put_line(SQL%ROWCOUNT||
451: ' row inserted into fnd_data_group_units.');
452: else
453: dbms_output.put_line(SQL%ROWCOUNT||
454: ' rows inserted into fnd_data_group_units.');
455: end if;

Line 454: ' rows inserted into fnd_data_group_units.');

450: dbms_output.put_line(SQL%ROWCOUNT||
451: ' row inserted into fnd_data_group_units.');
452: else
453: dbms_output.put_line(SQL%ROWCOUNT||
454: ' rows inserted into fnd_data_group_units.');
455: end if;
456:
457:
458: end if;