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 159: update_column(p_old_oid, p_new_oid, 'FND_DATA_GROUP_UNITS',

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

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

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

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

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

Line 364: insert into fnd_data_group_units

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

Line 390: fnd_data_group_units du,

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

Line 399: from fnd_data_group_units u2

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

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

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

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

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

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

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

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

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

Line 423: insert into fnd_data_group_units

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

Line 435: fnd_data_group_units du,

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

Line 445: from fnd_data_group_units u2

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

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

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

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

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