APPS.OCM_ADD_DATA_POINTS dependencies on AR_CMGT_CF_DTLS

Line 157: FROM ar_cmgt_cf_dtls

153: CURSOR getAllParentValues IS
154: SELECT case_folder_detail_id, case_folder_id,
155: data_point_id, data_point_value, sequence_number,
156: data_point_value_id
157: FROM ar_cmgt_cf_dtls
158: WHERE case_folder_id = l_case_folder_id
159: AND data_point_id = l_parent_data_point_id;
160:
161: /* Added for bug 9899841 */

Line 164: FROM ar_cmgt_cf_dtls

160:
161: /* Added for bug 9899841 */
162: CURSOR isDataPointExist(p_data_point_id IN NUMBER) IS
163: SELECT 'Y'
164: FROM ar_cmgt_cf_dtls
165: WHERE case_folder_id = l_case_folder_id
166: AND data_point_id = p_data_point_id;
167:
168: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

Line 168: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

164: FROM ar_cmgt_cf_dtls
165: WHERE case_folder_id = l_case_folder_id
166: AND data_point_id = p_data_point_id;
167:
168: l_return_value ar_cmgt_cf_dtls.data_point_value%type;
169: l_case_folder_detail_id NUMBER;
170: l_parent_cf_detail_id NUMBER;
171: l_mode VARCHAR2(30) := p_mode;
172: l_data_point_exist VARCHAR2(1) := 'N'; /* Added for bug 9899841 */

Line 368: FROM ar_cmgt_cf_dtls

364: CURSOR getAllValues IS
365: SELECT case_folder_detail_id, case_folder_id,
366: data_point_id,
367: data_point_value, sequence_number
368: FROM ar_cmgt_cf_dtls
369: WHERE case_folder_id = l_case_folder_id
370: AND data_point_id = l_data_point_id;
371:
372: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

Line 372: l_return_value ar_cmgt_cf_dtls.data_point_value%type;

368: FROM ar_cmgt_cf_dtls
369: WHERE case_folder_id = l_case_folder_id
370: AND data_point_id = l_data_point_id;
371:
372: l_return_value ar_cmgt_cf_dtls.data_point_value%type;
373: l_sequence_num NUMBER := 1;
374: l_case_folder_detail_id NUMBER;
375: l_dp_exists VARCHAR2(1) := 'N';
376: BEGIN

Line 479: FROM ar_cmgt_cf_dtls cfd

475: BEGIN
476:
477: SELECT 'Y'
478: INTO l_dp_exists
479: FROM ar_cmgt_cf_dtls cfd
480: WHERE cfd.case_folder_id =
481: pg_ocm_add_dp_param_rec.p_case_folder_id
482: AND cfd.data_point_id =
483: getParentDataPointsRec.data_point_id;

Line 691: DELETE FROM ar_cmgt_cf_dtls cfd

687: THEN
688: BEGIN
689: /* 7416921 - preserve non-function ADPs if
690: then are already visible from the checklist */
691: DELETE FROM ar_cmgt_cf_dtls cfd
692: WHERE cfd.case_folder_id = p_case_folder_id
693: AND cfd.data_point_id >= 20000
694: AND (cfd.included_in_checklist = 'N' OR
695: (cfd.included_in_checklist = 'Y' AND