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 dependencies on FND_PROFILE_OPTIONS

Line 179: FROM fnd_profile_options

175: profileRowId ROWID := NULL;
176: BEGIN
177: SELECT ROWID
178: INTO profileRowId
179: FROM fnd_profile_options
180: WHERE profile_option_name = profileName
181: AND start_date_active <= SYSDATE
182: AND nvl(end_date_active, SYSDATE) >= SYSDATE;
183: -- Log that the profile exists in fnd_profile_options

Line 183: -- Log that the profile exists in fnd_profile_options

179: FROM fnd_profile_options
180: WHERE profile_option_name = profileName
181: AND start_date_active <= SYSDATE
182: AND nvl(end_date_active, SYSDATE) >= SYSDATE;
183: -- Log that the profile exists in fnd_profile_options
184: corelog_using_name(profileName, 'EXISTS in FND_PROFILE_OPTIONS');
185: RETURN profileRowId;
186: EXCEPTION
187: WHEN no_data_found THEN

Line 184: corelog_using_name(profileName, 'EXISTS in FND_PROFILE_OPTIONS');

180: WHERE profile_option_name = profileName
181: AND start_date_active <= SYSDATE
182: AND nvl(end_date_active, SYSDATE) >= SYSDATE;
183: -- Log that the profile exists in fnd_profile_options
184: corelog_using_name(profileName, 'EXISTS in FND_PROFILE_OPTIONS');
185: RETURN profileRowId;
186: EXCEPTION
187: WHEN no_data_found THEN
188: -- Log that profile does not exist

Line 190: 'DOES NOT EXIST in FND_PROFILE_OPTIONS');

186: EXCEPTION
187: WHEN no_data_found THEN
188: -- Log that profile does not exist
189: corelog_using_name(profileName,
190: 'DOES NOT EXIST in FND_PROFILE_OPTIONS');
191: RETURN NULL;
192: END get_profile_rowid;
193:
194: /*

Line 209: FROM fnd_profile_options

205: profileName VARCHAR2(80) := NULL;
206: BEGIN
207: SELECT profile_option_name
208: INTO profileName
209: FROM fnd_profile_options
210: WHERE profile_option_id = profileOptionId
211: AND application_id = applicationId;
212: -- Log the profile_option_name given the profileOptionId + applicationId
213: corelog_using_name(profileName,

Line 241: FROM fnd_profile_options

237: profileId NUMBER := NULL;
238: BEGIN
239: SELECT profile_option_id
240: INTO profileId
241: FROM fnd_profile_options
242: WHERE ROWID = profileOptionRowId;
243: -- Log the profile_option_id given the profileOptionRowId
244: corelog_using_name(profileName, 'PROFILE_OPTION_ID = ' || profileId);
245: RETURN profileId;

Line 268: FROM fnd_profile_options

264: profileApplId NUMBER := NULL;
265: BEGIN
266: SELECT application_id
267: INTO profileApplId
268: FROM fnd_profile_options
269: WHERE ROWID = profileOptionRowId;
270: -- Log the application_id given the profileOptionRowId
271: corelog_using_name(profileName, 'APPLICATION_ID = ' || profileApplId);
272: RETURN profileApplId;

Line 310: FROM fnd_profile_options

306: serverresp_enabled_flag,
307: 'SITE',
308: site_enabled_flag)
309: INTO profileLevelEnabled
310: FROM fnd_profile_options
311: WHERE ROWID = profileOptionRowId;
312: -- Log the site_enabled_flag given the profileOptionRowId
313: corelog_using_name(profileName,
314: levelName||'_ENABLED_FLAG = ' || profileLevelEnabled);

Line 340: FROM fnd_profile_options

336: profileHierarchyType VARCHAR2(8) := NULL;
337: BEGIN
338: SELECT hierarchy_type
339: INTO profileHierarchyType
340: FROM fnd_profile_options
341: WHERE ROWID = profileOptionRowId;
342: -- Log the hierarchy_type given the profileOptionRowId
343: corelog_using_name(profileName,
344: 'HIERARCHY_TYPE = ' || profileHierarchyType);

Line 369: FROM fnd_profile_options

365: profileUserChangeable VARCHAR2(1) := NULL;
366: BEGIN
367: SELECT user_changeable_flag
368: INTO profileUserChangeable
369: FROM fnd_profile_options
370: WHERE ROWID = profileOptionRowId;
371: -- Log the user_changeable_flag given the profileOptionRowId
372: corelog_using_name(profileName,
373: 'USER_CHANGEABLE_FLAG = ' || profileUserChangeable);

Line 1019: ** determine if the profile exists in FND_PROFILE_OPTIONS. If it does

1015: ** cross-session function result caching mechanism.
1016: **
1017: ** The algorithm is such:
1018: ** 1. Using the profile option information acquired at declaration,
1019: ** determine if the profile exists in FND_PROFILE_OPTIONS. If it does
1020: ** not, return NULL.
1021: ** 2. If it exists and the user_enabled_flag is Y, get user level value.
1022: ** 3. If there was no user-level value, proceed to check the applicable
1023: ** levels based on the profile option hierarchy.

Line 1082: -- FND_PROFILE_OPTIONS. This is different from value() and get() since

1078: -- is placed in Public Put Cache. Since this API does not check Public Put
1079: -- Cache when evaluating a profile option, it would be best not to perform
1080: -- any action related to Public Put Cache. Hence, if profileRowId is NULL,
1081: -- then this API will return NULL for a profile that does not exist in
1082: -- FND_PROFILE_OPTIONS. This is different from value() and get() since
1083: -- profiles that do not exist in FND_PROFILE_OPTIONS are categorized as
1084: -- TRANSIENT and may have values in Public Put Cache.
1085: IF profileRowId IS NULL THEN
1086: -- Log that profile option was not found

Line 1083: -- profiles that do not exist in FND_PROFILE_OPTIONS are categorized as

1079: -- Cache when evaluating a profile option, it would be best not to perform
1080: -- any action related to Public Put Cache. Hence, if profileRowId is NULL,
1081: -- then this API will return NULL for a profile that does not exist in
1082: -- FND_PROFILE_OPTIONS. This is different from value() and get() since
1083: -- profiles that do not exist in FND_PROFILE_OPTIONS are categorized as
1084: -- TRANSIENT and may have values in Public Put Cache.
1085: IF profileRowId IS NULL THEN
1086: -- Log that profile option was not found
1087: corelog_using_name(profileName,

Line 1089: 'does not exist in FND_PROFILE_OPTIONS, returning NULL');

1085: IF profileRowId IS NULL THEN
1086: -- Log that profile option was not found
1087: corelog_using_name(profileName,
1088: profileName ||
1089: 'does not exist in FND_PROFILE_OPTIONS, returning NULL');
1090: RETURN NULL;
1091: ELSE
1092: -- If profile exists, then retrieve the definition
1093: profileOptionId := get_profile_id(profileRowId, profileName);

Line 1568: ** profile option exists in FND_PROFILE_OPTIONS using

1564: ** The algorithm is such:
1565: ** 1. Check Public Put Cache to see if a value has already been placed for
1566: ** the profile.
1567: ** 2. If no value was found in Public Put Cache, check to see if the
1568: ** profile option exists in FND_PROFILE_OPTIONS using
1569: ** get_profile_rowid().
1570: ** 3. If the profile option does not exist, then return NULL.
1571: ** If the profile option exists, call get_specific_value() to get a
1572: ** profile option value.

Line 1735: ** profile option exists in FND_PROFILE_OPTIONS using

1731: ** The algorithm is such:
1732: ** 1. Check Public Put Cache to see if a value has already been placed for
1733: ** the profile.
1734: ** 2. If no value was found in Public Put Cache, check to see if the
1735: ** profile option exists in FND_PROFILE_OPTIONS using
1736: ** get_profile_rowid().
1737: ** 3. If the profile option does not exist, then return NULL.
1738: ** If the profile option exists, call get_specific_value() to get a
1739: ** profile option value.

Line 1915: ** defined in FND_PROFILE_OPTIONS. It just means that no value was

1911: ** RETURNS: TRUE, if the profile option has a value
1912: ** FALSE, otherwise.
1913: **
1914: ** NOTE: A return of FALSE does not imply that the profile option is not
1915: ** defined in FND_PROFILE_OPTIONS. It just means that no value was
1916: ** found in Public Put cache or FND_PROFILE_OPTION_VALUES.
1917: */
1918: FUNCTION defined(NAME IN VARCHAR2) RETURN BOOLEAN IS
1919: profileValue VARCHAR2(240);