APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_METRIC_RATINGS

Line 88: FROM iex_metric_ratings

84: RETURN NUMBER
85: IS
86: CURSOR c_low_from IS
87: SELECT low_from
88: FROM iex_metric_ratings
89: WHERE score_comp_type_id = p_score_comp_type_id;
90:
91: CURSOR c_medium_from IS
92: SELECT medium_from

Line 93: FROM iex_metric_ratings

89: WHERE score_comp_type_id = p_score_comp_type_id;
90:
91: CURSOR c_medium_from IS
92: SELECT medium_from
93: FROM iex_metric_ratings
94: WHERE score_comp_type_id = p_score_comp_type_id;
95:
96: CURSOR c_high_from IS
97: SELECT high_from

Line 98: FROM iex_metric_ratings

94: WHERE score_comp_type_id = p_score_comp_type_id;
95:
96: CURSOR c_high_from IS
97: SELECT high_from
98: FROM iex_metric_ratings
99: WHERE score_comp_type_id = p_score_comp_type_id;
100:
101: l_value NUMBER;
102: BEGIN

Line 130: FROM iex_metric_ratings

126: p_lookup_code IN VARCHAR2) RETURN NUMBER
127: IS
128: CURSOR c_low_to IS
129: SELECT low_to
130: FROM iex_metric_ratings
131: WHERE score_comp_type_id = p_score_comp_type_id;
132:
133: CURSOR c_medium_to IS
134: SELECT medium_to

Line 135: FROM iex_metric_ratings

131: WHERE score_comp_type_id = p_score_comp_type_id;
132:
133: CURSOR c_medium_to IS
134: SELECT medium_to
135: FROM iex_metric_ratings
136: WHERE score_comp_type_id = p_score_comp_type_id;
137:
138: CURSOR c_high_to IS
139: SELECT high_to

Line 140: FROM iex_metric_ratings

136: WHERE score_comp_type_id = p_score_comp_type_id;
137:
138: CURSOR c_high_to IS
139: SELECT high_to
140: FROM iex_metric_ratings
141: WHERE score_comp_type_id = p_score_comp_type_id;
142:
143: l_value NUMBER;
144: BEGIN

Line 177: FROM iex_metric_ratings

173: p_high_to IN NUMBER)
174: IS
175: CURSOR c_rating IS
176: SELECT '1'
177: FROM iex_metric_ratings
178: WHERE score_comp_type_id = p_score_comp_type_id;
179: l_metric_rating_id NUMBER;
180: l_dummy VARCHAR2(1);
181: BEGIN

Line 185: UPDATE iex_metric_ratings

181: BEGIN
182: OPEN c_rating;
183: FETCH c_rating INTO l_dummy;
184: IF c_rating%FOUND THEN
185: UPDATE iex_metric_ratings
186: SET low_from = p_low_from, low_to = p_low_to,
187: medium_from = p_medium_from, medium_to = p_medium_to,
188: high_from = p_high_from, high_to = p_high_to,
189: last_update_date = SYSDATE, last_updated_by = fnd_global.user_id, last_update_login = fnd_global.login_id

Line 192: SELECT iex_metric_ratings_s.nextval

188: high_from = p_high_from, high_to = p_high_to,
189: last_update_date = SYSDATE, last_updated_by = fnd_global.user_id, last_update_login = fnd_global.login_id
190: WHERE score_comp_type_id = p_score_comp_type_id;
191: ELSE
192: SELECT iex_metric_ratings_s.nextval
193: INTO l_metric_rating_id
194: FROM dual;
195:
196: INSERT INTO iex_metric_ratings(metric_rating_id, score_comp_type_id, low_from, low_to,

Line 196: INSERT INTO iex_metric_ratings(metric_rating_id, score_comp_type_id, low_from, low_to,

192: SELECT iex_metric_ratings_s.nextval
193: INTO l_metric_rating_id
194: FROM dual;
195:
196: INSERT INTO iex_metric_ratings(metric_rating_id, score_comp_type_id, low_from, low_to,
197: medium_from, medium_to, high_from, high_to,
198: creation_date, created_by, last_update_date, last_updated_by, last_update_login)
199: VALUES (l_metric_rating_id, p_score_comp_type_id, p_low_from, p_low_to,
200: p_medium_from, p_medium_to, p_high_from, p_high_to,