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
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
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,
201: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id, fnd_global.user_id);
202: END IF;
203: CLOSE c_rating;
204: --EXCEPTION
205: --WHEN OTHERS THEN
1356: fnd_msg_pub.add;
1357: END UPDATE_CHECKLIST_ITEM_BY_NAME;
1358: BEGIN
1359: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1360: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1361: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1362: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1363: G_USER_ID := FND_GLOBAL.User_Id;
1364: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1357: END UPDATE_CHECKLIST_ITEM_BY_NAME;
1358: BEGIN
1359: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1360: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1361: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1362: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1363: G_USER_ID := FND_GLOBAL.User_Id;
1364: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1365: END IEX_CHECKLIST_UTILITY;
1358: BEGIN
1359: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1360: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1361: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1362: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1363: G_USER_ID := FND_GLOBAL.User_Id;
1364: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1365: END IEX_CHECKLIST_UTILITY;
1359: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1360: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1361: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1362: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1363: G_USER_ID := FND_GLOBAL.User_Id;
1364: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1365: END IEX_CHECKLIST_UTILITY;
1360: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1361: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1362: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1363: G_USER_ID := FND_GLOBAL.User_Id;
1364: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1365: END IEX_CHECKLIST_UTILITY;