APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTERS_VL

Line 6003: csi_ctr_gen_utility_pvt.put_line('before updating csi_counters_vl');

5999: RAISE FND_API.G_EXC_ERROR;
6000: END IF;
6001:
6002: -- l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER := l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER+1;
6003: csi_ctr_gen_utility_pvt.put_line('before updating csi_counters_vl');
6004: BEGIN
6005: SELECT 'x'
6006: INTO l_found
6007: FROM csi_counter_template_vl

Line 6013: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');

6009:
6010: UPDATE csi_counter_template_b
6011: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
6012: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6013: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6014: EXCEPTION
6015: WHEN NO_DATA_FOUND THEN
6016: UPDATE csi_counters_b
6017: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')

Line 6019: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');

6015: WHEN NO_DATA_FOUND THEN
6016: UPDATE csi_counters_b
6017: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
6018: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6019: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6020: END;
6021: END IF;
6022: END IF;
6023: END LOOP;

Line 7002: FROM csi_counters_vl

6998: attribute29,
6999: attribute30,
7000: attribute_category,
7001: eam_required_flag
7002: FROM csi_counters_vl
7003: WHERE counter_id = p_counter_id
7004: AND counter_type = 'FORMULA';
7005:
7006: CURSOR ctr_prop_cur(p_counter_id NUMBER) IS

Line 7914: FROM csi_counters_vl

7910: attribute29,
7911: attribute30,
7912: attribute_category,
7913: eam_required_flag
7914: FROM csi_counters_vl
7915: WHERE group_id = p_counter_group_id
7916: AND counter_type = 'FORMULA';
7917:
7918: CURSOR ctr_prop_cur(p_counter_id NUMBER) IS