APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on FND_PROFILE_OPTIONS

Line 6947: FROM fnd_profile_options

6943:
6944: l_err_loc := 5200;
6945: SELECT profile_option_id
6946: INTO l_profile_option_id
6947: FROM fnd_profile_options
6948: WHERE profile_option_name = 'ORG_ID';
6949:
6950: l_err_loc := 5300;
6951: l_prev_favorite_list_id := -1;

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 8043: FROM fnd_profile_options

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
8043: FROM fnd_profile_options
8044: WHERE profile_option_name = 'POR_DEFAULT_SHOPPING_SORT';
8045:
8046: l_err_loc := 350;
8047: -- insert only if row doesn't exist

Line 8064: FROM fnd_profile_options

8060:
8061: l_err_loc := 400;
8062: SELECT application_id, profile_option_id
8063: INTO l_application_id, l_profile_option_id
8064: FROM fnd_profile_options
8065: WHERE profile_option_name = 'POR_DEFAULT_SHOPPING_SORT_ORDER';
8066:
8067: l_err_loc := 450;
8068: -- insert only if row doesn't exist