APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTER_TEMPLATE_VL

Line 226: FROM csi_counter_template_vl

222: --Changed for Bug 7462345, validating the name while update
223: BEGIN
224: SELECT 'x'
225: INTO l_exists
226: FROM csi_counter_template_vl
227: WHERE upper(name) = upper(p_name)
228: AND COUNTER_ID <> Nvl(p_counter_id, FND_API.G_MISS_NUM);
229: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_DUP_NAME','CTR_NAME',p_name);
230: EXCEPTION

Line 4092: FROM csi_counter_template_vl

4088: comments,
4089: association_type,
4090: time_based_manual_entry,
4091: eam_required_flag
4092: FROM csi_counter_template_vl
4093: WHERE counter_id = p_counter_id
4094: FOR UPDATE OF OBJECT_VERSION_NUMBER;
4095: l_old_counter_template_rec cur_ctr_template_rec%ROWTYPE;
4096:

Line 6007: FROM csi_counter_template_vl

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
6008: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6009:
6010: UPDATE csi_counter_template_b
6011: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')

Line 6939: FROM csi_counter_template_vl

6935: used_in_scheduling,
6936: security_group_id,
6937: nvl(time_based_manual_entry, 'N') tm_based_manual_entry,
6938: eam_required_flag
6939: FROM csi_counter_template_vl
6940: WHERE counter_id = p_counter_id;
6941:
6942: CURSOR fmla_ctr_cur(p_counter_id NUMBER) IS
6943: SELECT counter_id,

Line 7485: FROM csi_counter_template_vl ctr,

7481: csi_ctr_gen_utility_pvt.put_line('Inside the ctr_der_filter_cur_rec ');
7482:
7483: SELECT counter_property_id
7484: INTO l_new_der_ctr_prop_id
7485: FROM csi_counter_template_vl ctr,
7486: csi_ctr_prop_template_vl ctrprop
7487: WHERE ctrprop.counter_property_id = ctr_der_filter_cur_rec.counter_property_id
7488: AND ctrprop.counter_id = l_new_ctr_id;
7489:

Line 7851: FROM csi_counter_template_vl

7847: used_in_scheduling,
7848: security_group_id,
7849: nvl(time_based_manual_entry, 'N') tm_based_manual_entry,
7850: eam_required_flag
7851: FROM csi_counter_template_vl
7852: WHERE group_id = p_counter_group_id;
7853:
7854: CURSOR fmla_ctr_cur(p_counter_group_id NUMBER) IS
7855: SELECT counter_id,

Line 8383: FROM csi_counter_template_vl ctr,

8379: csi_ctr_gen_utility_pvt.put_line('Inside the ctr_der_filter_cur_rec ');
8380:
8381: SELECT counter_property_id
8382: INTO l_new_der_ctr_prop_id
8383: FROM csi_counter_template_vl ctr,
8384: csi_ctr_prop_template_vl ctrprop
8385: WHERE ctrprop.counter_property_id = ctr_der_filter_cur_rec.counter_property_id
8386: AND ctrprop.counter_id = l_new_ctr_id;
8387: