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.FND_PROFILE_OPTIONS_PKG dependencies on FND_PROFILE_CAT_OPTIONS

Line 424: -- Application2 to Fnd_Profile_cat_Options table.

420: x_appl_id varchar2);
421:
422: -- Bug 5060938.
423: -- This api is used to propagate updation of profile from Application1 to
424: -- Application2 to Fnd_Profile_cat_Options table.
425: -- Drop this api after finding out a way to create Foreign_Key and
426: -- Primary_Key info in FND_FOREIGN_KEYS and FND_PRIMARY_KEYS AOL meta data
427: -- through fnd_profile_cat_options.xdf.
428: PROCEDURE UPDATE_CAT_OPTIONS_APPL_ID( x_profile_option_name varchar2,

Line 427: -- through fnd_profile_cat_options.xdf.

423: -- This api is used to propagate updation of profile from Application1 to
424: -- Application2 to Fnd_Profile_cat_Options table.
425: -- Drop this api after finding out a way to create Foreign_Key and
426: -- Primary_Key info in FND_FOREIGN_KEYS and FND_PRIMARY_KEYS AOL meta data
427: -- through fnd_profile_cat_options.xdf.
428: PROCEDURE UPDATE_CAT_OPTIONS_APPL_ID( x_profile_option_name varchar2,
429: x_profile_id varchar2,
430: x_appl_id number);
431:

Line 473: ** Fnd_Profile_Cat_Options.xdf. Right now though foreign key info is

469: update_appl_id_pk_columns(L_PROFILE_OPTION_NAME,x_profile_option_id,x_application_id);
470:
471: /** Remove this call after finding a way to create Foreign_Key info in AOL
472: ** Meta data (Fnd_Foreign_Key and Fnd_Foreign_key_Columns table) using
473: ** Fnd_Profile_Cat_Options.xdf. Right now though foreign key info is
474: ** available in fnd_profile_cat_options.xdf, data is not uploaded into
475: ** FND_FOREIGN_KEYS, FND_PRIMARY_KEYS (and it's COLUMN's table) when the
476: ** above xdf is uploaded.
477: **/

Line 474: ** available in fnd_profile_cat_options.xdf, data is not uploaded into

470:
471: /** Remove this call after finding a way to create Foreign_Key info in AOL
472: ** Meta data (Fnd_Foreign_Key and Fnd_Foreign_key_Columns table) using
473: ** Fnd_Profile_Cat_Options.xdf. Right now though foreign key info is
474: ** available in fnd_profile_cat_options.xdf, data is not uploaded into
475: ** FND_FOREIGN_KEYS, FND_PRIMARY_KEYS (and it's COLUMN's table) when the
476: ** above xdf is uploaded.
477: **/
478: UPDATE_CAT_OPTIONS_APPL_ID(L_PROFILE_OPTION_NAME,x_profile_option_id,x_application_id);

Line 1434: ** APPLICATION_ID in FND_PROFILE_CAT_OPTIONS.

1430:
1431:
1432: /*
1433: ** UPDATE_APPL_ID_CAT_OPTIONS - Updates the fk references of
1434: ** APPLICATION_ID in FND_PROFILE_CAT_OPTIONS.
1435: **
1436: **
1437: ** AOL_INTERNAL ONLY
1438: **

Line 1441: ** Application2 to Fnd_Profile_cat_Options table.

1437: ** AOL_INTERNAL ONLY
1438: **
1439: ** Bug 5060938.
1440: ** This api is used to propagate updation of profile from Application1 to
1441: ** Application2 to Fnd_Profile_cat_Options table.
1442: ** DROP/DELETE this api after finding out a way to create Foreign_Key and
1443: ** Primary_Key info in FND_FOREIGN_KEYS and FND_PRIMARY_KEYS AOL meta data
1444: ** through fnd_profile_cat_options.xdf.
1445: **

Line 1444: ** through fnd_profile_cat_options.xdf.

1440: ** This api is used to propagate updation of profile from Application1 to
1441: ** Application2 to Fnd_Profile_cat_Options table.
1442: ** DROP/DELETE this api after finding out a way to create Foreign_Key and
1443: ** Primary_Key info in FND_FOREIGN_KEYS and FND_PRIMARY_KEYS AOL meta data
1444: ** through fnd_profile_cat_options.xdf.
1445: **
1446: ** If the profile is moved to a different application, replace old
1447: ** application_id with the new value.
1448: **

Line 1449: ** Check if Fnd_Profile_Cat_Options table and Profile_Option_Application_Id

1445: **
1446: ** If the profile is moved to a different application, replace old
1447: ** application_id with the new value.
1448: **
1449: ** Check if Fnd_Profile_Cat_Options table and Profile_Option_Application_Id
1450: ** column exists. If so, update the Profile_Option_Application_Id for all the
1451: ** profiles in Fnd_Profile_Cat_Options table with the new value.
1452: */
1453: PROCEDURE UPDATE_CAT_OPTIONS_APPL_ID( x_profile_option_name varchar2,

Line 1451: ** profiles in Fnd_Profile_Cat_Options table with the new value.

1447: ** application_id with the new value.
1448: **
1449: ** Check if Fnd_Profile_Cat_Options table and Profile_Option_Application_Id
1450: ** column exists. If so, update the Profile_Option_Application_Id for all the
1451: ** profiles in Fnd_Profile_Cat_Options table with the new value.
1452: */
1453: PROCEDURE UPDATE_CAT_OPTIONS_APPL_ID( x_profile_option_name varchar2,
1454: x_profile_id varchar2,
1455: x_appl_id number)

Line 1478: FROM fnd_profile_cat_options

1474:
1475: begin
1476: SELECT profile_option_application_id
1477: INTO l_appl_id
1478: FROM fnd_profile_cat_options
1479: WHERE ROWNUM < 2;
1480: exception
1481: when COL_NOT_FOUND then
1482: return;

Line 1492: UPDATE fnd_profile_cat_options

1488:
1489: if (db_appl_id = x_appl_id) then
1490: return;
1491: else
1492: UPDATE fnd_profile_cat_options
1493: SET profile_option_application_id = x_appl_id
1494: WHERE profile_option_id = x_profile_id
1495: AND profile_option_application_id = db_appl_id;
1496: end if;