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.ICX_CAT_R12_UPGRADE_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 6441: fnd_profile_option_values prf_vals, por_favorite_list_lines fav_lines

6437: CURSOR otherItemUpgradeCsr (p_profile_option_id NUMBER) IS
6438: SELECT fav_hdrs.favorite_list_id, fav_hdrs.employee_id, users.user_id,
6439: prf_vals.profile_option_value, COUNT(*)
6440: FROM por_favorite_list_headers fav_hdrs, fnd_user users,
6441: fnd_profile_option_values prf_vals, por_favorite_list_lines fav_lines
6442: WHERE fav_hdrs.favorite_list_id = fav_lines.favorite_list_id
6443: AND fav_lines.item_type <> 'CATALOG'
6444: AND fav_hdrs.employee_id = users.employee_id (+)
6445: AND users.user_id = prf_vals.level_value (+)

Line 6461: fnd_profile_option_values resp_profile,

6457: p_profile_option_id NUMBER) IS
6458: SELECT DISTINCT NVL(resp_profile.profile_option_value,
6459: NVL(app_profile.profile_option_value, -2)) org_id
6460: FROM fnd_responsibility resp,
6461: fnd_profile_option_values resp_profile,
6462: fnd_profile_option_values app_profile,
6463: fnd_user_resp_groups_all user_resp
6464: WHERE user_resp.user_id = p_user_id
6465: AND user_resp.responsibility_application_id IN (177, 178, 201, 396, 426)

Line 6462: fnd_profile_option_values app_profile,

6458: SELECT DISTINCT NVL(resp_profile.profile_option_value,
6459: NVL(app_profile.profile_option_value, -2)) org_id
6460: FROM fnd_responsibility resp,
6461: fnd_profile_option_values resp_profile,
6462: fnd_profile_option_values app_profile,
6463: fnd_user_resp_groups_all user_resp
6464: WHERE user_resp.user_id = p_user_id
6465: AND user_resp.responsibility_application_id IN (177, 178, 201, 396, 426)
6466: AND user_resp.responsibility_id = resp.responsibility_id

Line 6527: l_site_level_prf_opt_val fnd_profile_option_values.profile_option_value%TYPE;

6523: l_org_id_index PLS_INTEGER := 0;
6524: l_profile_option_id NUMBER;
6525: l_org_id_profile_value_exist VARCHAR2(1) := 'N';
6526: l_org_already_exists VARCHAR2(1) := 'N';
6527: l_site_level_prf_opt_val fnd_profile_option_values.profile_option_value%TYPE;
6528: l_is_site_prf_val_in_org_tbl VARCHAR2(1) := 'N';
6529:
6530: BEGIN
6531: l_err_loc := 100;

Line 7112: FROM fnd_profile_option_values

7108: IF ( l_site_level_prf_opt_val IS NULL ) THEN
7109: l_err_loc := 8500;
7110: SELECT profile_option_value
7111: INTO l_site_level_prf_opt_val
7112: FROM fnd_profile_option_values
7113: WHERE profile_option_id = l_profile_option_id
7114: AND level_id = 10001;
7115:
7116: l_err_loc := 8600;

Line 8024: FROM fnd_profile_options fpo, fnd_profile_option_values fpov

8020: l_err_loc := 100;
8021: BEGIN
8022: SELECT fpov.profile_option_value
8023: INTO l_relevance_profile_value
8024: FROM fnd_profile_options fpo, fnd_profile_option_values fpov
8025: WHERE fpo.profile_option_name = 'POR_SORT_BY_RELEVANCE'
8026: AND fpo.profile_option_id = fpov.profile_option_id
8027: AND fpov.level_id = 10001;
8028:

Line 8038: -- insert rows to fnd_profile_option_values only if the relevance profile value is 'Y'

8034:
8035: END;
8036:
8037: l_err_loc := 250;
8038: -- insert rows to fnd_profile_option_values only if the relevance profile value is 'Y'
8039: IF (l_relevance_profile_value = 'Y') THEN
8040: l_err_loc := 300;
8041: SELECT application_id, profile_option_id
8042: INTO l_application_id, l_profile_option_id

Line 8048: INSERT INTO fnd_profile_option_values

8044: WHERE profile_option_name = 'POR_DEFAULT_SHOPPING_SORT';
8045:
8046: l_err_loc := 350;
8047: -- insert only if row doesn't exist
8048: INSERT INTO fnd_profile_option_values
8049: (application_id, profile_option_id, level_id, level_value, last_update_date,
8050: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8051: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8052: sysdate, fnd_global.user_id, fnd_global.login_id, 'Relevance'

Line 8055: FROM fnd_profile_option_values

8051: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8052: sysdate, fnd_global.user_id, fnd_global.login_id, 'Relevance'
8053: FROM dual
8054: WHERE NOT EXISTS (SELECT 1
8055: FROM fnd_profile_option_values
8056: WHERE application_id = l_application_id
8057: AND profile_option_id = l_profile_option_id
8058: AND level_id = 10001
8059: AND level_value = 0);

Line 8069: INSERT INTO fnd_profile_option_values

8065: WHERE profile_option_name = 'POR_DEFAULT_SHOPPING_SORT_ORDER';
8066:
8067: l_err_loc := 450;
8068: -- insert only if row doesn't exist
8069: INSERT INTO fnd_profile_option_values
8070: (application_id, profile_option_id, level_id, level_value, last_update_date,
8071: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8072: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8073: sysdate, fnd_global.user_id, fnd_global.login_id, 'DESC'

Line 8076: FROM fnd_profile_option_values

8072: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8073: sysdate, fnd_global.user_id, fnd_global.login_id, 'DESC'
8074: FROM dual
8075: WHERE NOT EXISTS (SELECT 1
8076: FROM fnd_profile_option_values
8077: WHERE application_id = l_application_id
8078: AND profile_option_id = l_profile_option_id
8079: AND level_id = 10001
8080: AND level_value = 0);