APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTER_DERIVED_FILTERS

Line 3035: p_desc_flex_name => 'CSI_COUNTER_DERIVED_FILTERS',

3031: csi_ctr_gen_utility_pvt.Is_DescFlex_Valid
3032: (
3033: p_api_name => l_api_name,
3034: p_appl_short_name => 'CSI',
3035: p_desc_flex_name => 'CSI_COUNTER_DERIVED_FILTERS',
3036: p_seg_partial_name => 'ATTRIBUTE',
3037: p_num_of_attributes => 15,
3038: p_seg_values => l_desc_flex
3039: );

Line 3049: FROM CSI_COUNTER_DERIVED_FILTERS

3045:
3046: IF l_ctr_derived_filters_rec.SEQ_NO IS NULL THEN
3047: SELECT nvl(max(seq_no), 0) + 1
3048: into l_seq_no
3049: FROM CSI_COUNTER_DERIVED_FILTERS
3050: WHERE counter_id = l_ctr_derived_filters_rec.COUNTER_ID;
3051: ELSE
3052: BEGIN
3053: SELECT 'x'

Line 3055: FROM CSI_COUNTER_DERIVED_FILTERS

3051: ELSE
3052: BEGIN
3053: SELECT 'x'
3054: into l_dummy
3055: FROM CSI_COUNTER_DERIVED_FILTERS
3056: WHERE counter_id = l_ctr_derived_filters_rec.COUNTER_ID
3057: AND seq_no = l_ctr_derived_filters_rec.SEQ_NO;
3058:
3059: -- this means that for this counter, there is one another

Line 4119: FROM csi_counter_derived_filters

4115: AND relationship_type_code = 'FORMULA';
4116:
4117: CURSOR derived_filters_cur(p_counter_id NUMBER) IS
4118: SELECT counter_derived_filter_id
4119: FROM csi_counter_derived_filters
4120: WHERE counter_id = p_counter_id;
4121:
4122: CURSOR target_counter_cur(p_counter_id NUMBER) IS
4123: SELECT relationship_id

Line 5857: FROM CSI_COUNTER_DERIVED_FILTERS

5853: l_old_ctr_derived_filters_rec.attribute13,
5854: l_old_ctr_derived_filters_rec.attribute14,
5855: l_old_ctr_derived_filters_rec.attribute15,
5856: l_old_ctr_derived_filters_rec.attribute_category
5857: FROM CSI_COUNTER_DERIVED_FILTERS
5858: -- WHERE COUNTER_DERIVED_FILTER_ID = l_ctr_derived_filters_rec.COUNTER_DERIVED_FILTER_ID;
5859: WHERE COUNTER_DERIVED_FILTER_ID = p_ctr_derived_filters_tbl(tab_row).counter_derived_filter_id;
5860:
5861: IF SQL%NOTFOUND THEN

Line 5948: FROM CSI_COUNTER_DERIVED_FILTERS

5944: IF p_ctr_derived_filters_tbl(tab_row).SEQ_NO <> FND_API.G_MISS_NUM THEN
5945: BEGIN
5946: SELECT 'x'
5947: INTO l_dummy
5948: FROM CSI_COUNTER_DERIVED_FILTERS
5949: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).counter_id
5950: AND seq_no = p_ctr_derived_filters_tbl(tab_row).seq_no
5951: AND counter_derived_filter_id <> p_ctr_derived_filters_tbl(tab_row).counter_derived_filter_id;
5952:

Line 7120: FROM csi_counter_derived_filters

7116: attribute13,
7117: attribute14,
7118: attribute15,
7119: attribute_category
7120: FROM csi_counter_derived_filters
7121: WHERE counter_id = p_counter_id;
7122:
7123: BEGIN
7124: -- Standard Start of API savepoint

Line 8054: FROM csi_counter_derived_filters

8050: attribute13,
8051: attribute14,
8052: attribute15,
8053: attribute_category
8054: FROM csi_counter_derived_filters
8055: WHERE counter_id = p_counter_id;
8056:
8057: BEGIN
8058: -- Standard Start of API savepoint