413: ** get_appl_value
414: ** get the profile option's application-level value based on the profile
415: ** option's id and level_value. The results are cached using the PL/SQL
416: ** cross-session function result caching mechanism. This has a
417: ** dependency on the view fnd_profile_values_appl_v
418: */
419: FUNCTION get_appl_value
420: (
421: profileOptionId IN NUMBER,
427: applicationId);
428: BEGIN
429: SELECT profile_option_value
430: INTO applLevelValue
431: FROM fnd_profile_values_appl_v
432: WHERE profile_option_id = profileOptionId
433: AND application_id = applicationId
434: AND level_value = applId
435: AND profile_option_value IS NOT NULL;