APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTER_DERIVED_FILTERS

Line 3022: p_desc_flex_name => 'CSI_COUNTER_DERIVED_FILTERS',

3018: csi_ctr_gen_utility_pvt.Is_DescFlex_Valid
3019: (
3020: p_api_name => l_api_name,
3021: p_appl_short_name => 'CSI',
3022: p_desc_flex_name => 'CSI_COUNTER_DERIVED_FILTERS',
3023: p_seg_partial_name => 'ATTRIBUTE',
3024: p_num_of_attributes => 15,
3025: p_seg_values => l_desc_flex
3026: );

Line 3036: FROM CSI_COUNTER_DERIVED_FILTERS

3032:
3033: IF l_ctr_derived_filters_rec.SEQ_NO IS NULL THEN
3034: SELECT nvl(max(seq_no), 0) + 1
3035: into l_seq_no
3036: FROM CSI_COUNTER_DERIVED_FILTERS
3037: WHERE counter_id = l_ctr_derived_filters_rec.COUNTER_ID;
3038: ELSE
3039: BEGIN
3040: SELECT 'x'

Line 3042: FROM CSI_COUNTER_DERIVED_FILTERS

3038: ELSE
3039: BEGIN
3040: SELECT 'x'
3041: into l_dummy
3042: FROM CSI_COUNTER_DERIVED_FILTERS
3043: WHERE counter_id = l_ctr_derived_filters_rec.COUNTER_ID
3044: AND seq_no = l_ctr_derived_filters_rec.SEQ_NO;
3045:
3046: -- this means that for this counter, there is one another

Line 4106: FROM csi_counter_derived_filters

4102: AND relationship_type_code = 'FORMULA';
4103:
4104: CURSOR derived_filters_cur(p_counter_id NUMBER) IS
4105: SELECT counter_derived_filter_id
4106: FROM csi_counter_derived_filters
4107: WHERE counter_id = p_counter_id;
4108:
4109: CURSOR target_counter_cur(p_counter_id NUMBER) IS
4110: SELECT relationship_id

Line 5836: FROM CSI_COUNTER_DERIVED_FILTERS

5832: l_old_ctr_derived_filters_rec.attribute13,
5833: l_old_ctr_derived_filters_rec.attribute14,
5834: l_old_ctr_derived_filters_rec.attribute15,
5835: l_old_ctr_derived_filters_rec.attribute_category
5836: FROM CSI_COUNTER_DERIVED_FILTERS
5837: -- WHERE COUNTER_DERIVED_FILTER_ID = l_ctr_derived_filters_rec.COUNTER_DERIVED_FILTER_ID;
5838: WHERE COUNTER_DERIVED_FILTER_ID = p_ctr_derived_filters_tbl(tab_row).counter_derived_filter_id;
5839:
5840: IF SQL%NOTFOUND THEN

Line 5927: FROM CSI_COUNTER_DERIVED_FILTERS

5923: IF p_ctr_derived_filters_tbl(tab_row).SEQ_NO <> FND_API.G_MISS_NUM THEN
5924: BEGIN
5925: SELECT 'x'
5926: INTO l_dummy
5927: FROM CSI_COUNTER_DERIVED_FILTERS
5928: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).counter_id
5929: AND seq_no = p_ctr_derived_filters_tbl(tab_row).seq_no
5930: AND counter_derived_filter_id <> p_ctr_derived_filters_tbl(tab_row).counter_derived_filter_id;
5931:

Line 7098: FROM csi_counter_derived_filters

7094: attribute13,
7095: attribute14,
7096: attribute15,
7097: attribute_category
7098: FROM csi_counter_derived_filters
7099: WHERE counter_id = p_counter_id;
7100:
7101: BEGIN
7102: -- Standard Start of API savepoint

Line 8010: FROM csi_counter_derived_filters

8006: attribute13,
8007: attribute14,
8008: attribute15,
8009: attribute_category
8010: FROM csi_counter_derived_filters
8011: WHERE counter_id = p_counter_id;
8012:
8013: BEGIN
8014: -- Standard Start of API savepoint