APPS.OCM_ADD_DATA_POINTS dependencies on AR_CMGT_CF_DTLS

Line 147: FROM ar_cmgt_cf_dtls

143: CURSOR getAllParentValues IS
144: SELECT case_folder_detail_id, case_folder_id,
145: data_point_id, data_point_value, sequence_number,
146: data_point_value_id
147: FROM ar_cmgt_cf_dtls
148: WHERE case_folder_id = l_case_folder_id
149: AND data_point_id = l_parent_data_point_id;
150:
151: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

Line 151: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

147: FROM ar_cmgt_cf_dtls
148: WHERE case_folder_id = l_case_folder_id
149: AND data_point_id = l_parent_data_point_id;
150:
151: l_return_value ar_cmgt_cf_dtls.data_point_value%type;
152: l_case_folder_detail_id NUMBER;
153: l_parent_cf_detail_id NUMBER;
154: l_mode VARCHAR2(30) := p_mode;
155:

Line 299: FROM ar_cmgt_cf_dtls

295: CURSOR getAllValues IS
296: SELECT case_folder_detail_id, case_folder_id,
297: data_point_id,
298: data_point_value, sequence_number
299: FROM ar_cmgt_cf_dtls
300: WHERE case_folder_id = l_case_folder_id
301: AND data_point_id = l_data_point_id;
302:
303: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

Line 303: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

299: FROM ar_cmgt_cf_dtls
300: WHERE case_folder_id = l_case_folder_id
301: AND data_point_id = l_data_point_id;
302:
303: l_return_value ar_cmgt_cf_dtls.data_point_value%type;
304: l_sequence_num NUMBER := 1;
305: l_case_folder_detail_id NUMBER;
306: BEGIN
307: p_resultout := 0;

Line 499: DELETE FROM ar_cmgt_cf_dtls

495: -- unique record for updation.
496: IF p_mode = 'REFRESH' OR p_mode = 'CREATE'
497: THEN
498: BEGIN
499: DELETE FROM ar_cmgt_cf_dtls
500: WHERE case_folder_id = p_case_folder_id
501: AND data_point_id >= 20000;
502: EXCEPTION
503: WHEN OTHERS THEN