APPS.OCM_GET_EXTRL_DECSN_PUB dependencies on AR_CMGT_CF_DTLS

Line 87: update ar_cmgt_cf_dtls

83: where sc.SCORE_MODEL_ID = p_score_model_id
84: and sc.data_point_id = dp.data_point_id
85: and dp.data_point_code = 'OCM_EXTERNAL_SCORE';
86:
87: update ar_cmgt_cf_dtls
88: set score = p_score,
89: data_point_value = p_score
90: where CASE_FOLDER_ID = p_case_folder_id
91: and DATA_POINT_ID = l_data_point_id;

Line 93: update ar_cmgt_cf_dtls

89: data_point_value = p_score
90: where CASE_FOLDER_ID = p_case_folder_id
91: and DATA_POINT_ID = l_data_point_id;
92:
93: update ar_cmgt_cf_dtls
94: set score = p_score,
95: data_point_value = p_score
96: where CASE_FOLDER_ID = ( select CASE_FOLDER_ID
97: from ar_cmgt_case_folders

Line 180: l_data_point_id ar_cmgt_cf_dtls.DATA_POINT_ID%type;

176: p_data_point_id IN data_point_id_varray
177: ) IS
178: l_case_folder_type ar_cmgt_case_folders.type%type;
179: l_case_folder_status ar_cmgt_case_folders.status%type;
180: l_data_point_id ar_cmgt_cf_dtls.DATA_POINT_ID%type;
181: BEGIN
182: /* The following validation will be placed into the procedure
183: 1. Case folder Id must be of typed 'CASE'
184: 2. The case folder status must be in 'CREATED' or 'SAVED' status.

Line 220: from ar_cmgt_cf_dtls

216: LOOP
217: BEGIN
218: select DATA_POINT_ID
219: into l_data_point_id
220: from ar_cmgt_cf_dtls
221: where case_folder_id = p_case_folder_id
222: and DATA_POINT_ID = p_data_point_id(i);
223:
224: update ar_cmgt_cf_dtls

Line 224: update ar_cmgt_cf_dtls

220: from ar_cmgt_cf_dtls
221: where case_folder_id = p_case_folder_id
222: and DATA_POINT_ID = p_data_point_id(i);
223:
224: update ar_cmgt_cf_dtls
225: set included_in_checklist = 'Y'
226: where case_folder_id = p_case_folder_id
227: and data_point_id = l_data_point_id;
228: