APPS.OCM_RECOMMENDATIONS_PUB dependencies on AR_CMGT_CF_RECOMMENDS

Line 39: FROM ar_cmgt_cf_recommends

35: status,
36: credit_type,
37: recommendation_name,
38: appealed_flag
39: FROM ar_cmgt_cf_recommends
40: WHERE credit_request_id = nvl(p_credit_request_id, credit_request_id)
41: AND nvl(appealed_flag, 'N') = p_appealed_flag
42: AND case_folder_id = nvl(p_case_folder_id, case_folder_id );
43:

Line 153: UPDATE ar_cmgt_cf_recommends

149: END;
150: l_check_rec_exists := p_appealing_reco_tbl.first;
151: --fist updates all records to null
152: BEGIN
153: UPDATE ar_cmgt_cf_recommends
154: SET appealed_flag = NULL
155: WHERE case_folder_id = l_case_folder_id;
156:
157: EXCEPTION

Line 180: UPDATE ar_cmgt_cf_recommends

176: debug ( 'Recommendation Id ' || p_appealing_reco_tbl(i).recommendation_id);
177: END IF;
178: IF p_appealing_reco_tbl(i).recommendation_id IS NOT NULL
179: THEN
180: UPDATE ar_cmgt_cf_recommends
181: SET appealed_flag = 'Y'
182: WHERE recommendation_id = p_appealing_reco_tbl(i).recommendation_id;
183: END IF;
184: END LOOP;

Line 187: UPDATE ar_cmgt_cf_recommends

183: END IF;
184: END LOOP;
185: ELSE -- table is not pupoltaed. Update all of the recommendations
186: -- first updates all of
187: UPDATE ar_cmgt_cf_recommends
188: SET appealed_flag = 'Y'
189: WHERE case_folder_id = l_case_folder_id;
190:
191: END IF;