APPS.FEM_OBJECT_CATALOG_UTIL_PKG dependencies on FND_LOOKUP_VALUES

Line 123: /* Validate that the Object Origin exists in FND_LOOKUP_VALUES */

119: IF v_count = 0 THEN
120: RAISE e_invalid_object_type;
121: END IF; /* object_type_code validation */
122:
123: /* Validate that the Object Origin exists in FND_LOOKUP_VALUES */
124: SELECT count(*)
125: INTO v_count
126: FROM fnd_lookup_values
127: WHERE lookup_type = 'FEM_OBJECT_ORIGIN_DSC'

Line 126: FROM fnd_lookup_values

122:
123: /* Validate that the Object Origin exists in FND_LOOKUP_VALUES */
124: SELECT count(*)
125: INTO v_count
126: FROM fnd_lookup_values
127: WHERE lookup_type = 'FEM_OBJECT_ORIGIN_DSC'
128: AND lookup_code = p_object_origin_code;
129:
130: IF v_count = 0 THEN

Line 134: /* Validate that the Object Access Code exists in FND_LOOKUP_VALUES */

130: IF v_count = 0 THEN
131: RAISE e_invalid_object_origin;
132: END IF; /* object_origin_code validation */
133:
134: /* Validate that the Object Access Code exists in FND_LOOKUP_VALUES */
135: SELECT count(*)
136: INTO v_count
137: FROM fnd_lookup_values
138: WHERE lookup_type = 'FEM_OBJECT_ACCESS_DSC'

Line 137: FROM fnd_lookup_values

133:
134: /* Validate that the Object Access Code exists in FND_LOOKUP_VALUES */
135: SELECT count(*)
136: INTO v_count
137: FROM fnd_lookup_values
138: WHERE lookup_type = 'FEM_OBJECT_ACCESS_DSC'
139: AND lookup_code = p_object_access_code;
140:
141: IF v_count = 0 THEN

Line 462: -- Validate that the Object Origin exists in FND_LOOKUP_VALUES

458:
459: -- Initialize API return status to success
460: x_return_status := pc_ret_sts_success;
461:
462: -- Validate that the Object Origin exists in FND_LOOKUP_VALUES
463: SELECT count(*)
464: INTO v_count
465: FROM fnd_lookup_values
466: WHERE lookup_type = 'FEM_OBJECT_ORIGIN_DSC'

Line 465: FROM fnd_lookup_values

461:
462: -- Validate that the Object Origin exists in FND_LOOKUP_VALUES
463: SELECT count(*)
464: INTO v_count
465: FROM fnd_lookup_values
466: WHERE lookup_type = 'FEM_OBJECT_ORIGIN_DSC'
467: AND lookup_code = p_object_origin_code;
468:
469: IF v_count = 0 THEN