APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTERS_VL

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

6020: RAISE FND_API.G_EXC_ERROR;
6021: END IF;
6022:
6023: -- l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER := l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER+1;
6024: csi_ctr_gen_utility_pvt.put_line('before updating csi_counters_vl');
6025: BEGIN
6026: SELECT 'x'
6027: INTO l_found
6028: FROM csi_counter_template_vl

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

6030:
6031: UPDATE csi_counter_template_b
6032: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
6033: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6034: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6035: EXCEPTION
6036: WHEN NO_DATA_FOUND THEN
6037: UPDATE csi_counters_b
6038: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')

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

6036: WHEN NO_DATA_FOUND THEN
6037: UPDATE csi_counters_b
6038: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
6039: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6040: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6041: END;
6042: END IF;
6043: END IF;
6044: END LOOP;

Line 7024: FROM csi_counters_vl

7020: attribute29,
7021: attribute30,
7022: attribute_category,
7023: eam_required_flag
7024: FROM csi_counters_vl
7025: WHERE counter_id = p_counter_id
7026: AND counter_type = 'FORMULA';
7027:
7028: CURSOR ctr_prop_cur(p_counter_id NUMBER) IS

Line 7958: FROM csi_counters_vl

7954: attribute29,
7955: attribute30,
7956: attribute_category,
7957: eam_required_flag
7958: FROM csi_counters_vl
7959: WHERE group_id = p_counter_group_id
7960: AND counter_type = 'FORMULA';
7961:
7962: CURSOR ctr_prop_cur(p_counter_id NUMBER) IS