DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CS_CSI_COUNTER_GROUPS

Line 23: FROM cs_csi_counter_groups

19: IF nvl(p_template_flag,'N') = 'Y' THEN
20: BEGIN
21: SELECT 'x'
22: INTO l_dummy
23: FROM cs_csi_counter_groups
24: WHERE name = p_name
25: AND template_flag = p_template_flag;
26:
27: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_GRP_DUPLICATE');

Line 267: from cs_csi_counter_groups

263: if p_group_id is not null then
264: begin
265: select 'x'
266: into l_dummy
267: from cs_csi_counter_groups
268: where counter_group_id = p_group_id;
269: exception
270: when no_data_found then
271: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_GRP_INVALID');

Line 893: from cs_csi_counter_groups

889: l_valid_start_date DATE;
890:
891: CURSOR c1_group(p_group_id NUMBER) IS
892: select start_date_active
893: from cs_csi_counter_groups
894: where counter_group_id = p_group_id;
895:
896: CURSOR c2_counter(p_counter_id NUMBER) IS
897: select start_date_active

Line 1425: from cs_csi_counter_groups

1421: l_valid_start_date DATE;
1422:
1423: CURSOR c1_group(p_group_id NUMBER) IS
1424: select start_date_active
1425: from cs_csi_counter_groups
1426: where counter_group_id = p_group_id;
1427:
1428: BEGIN
1429: -- Standard Start of API savepoint

Line 3224: FROM cs_csi_counter_groups

3220: ,source_object_code
3221: ,source_object_id
3222: ,source_counter_group_id
3223: ,security_group_id
3224: FROM cs_csi_counter_groups
3225: WHERE counter_group_id = p_counter_group_id
3226: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3227: l_old_counter_groups_rec cur_group_rec%ROWTYPE;
3228:

Line 8096: FROM cs_csi_counter_groups

8092: l_ctr_grp_rec.attribute14,
8093: l_ctr_grp_rec.attribute15,
8094: l_ctr_grp_rec.context,
8095: l_ctr_grp_rec.template_flag
8096: FROM cs_csi_counter_groups
8097: WHERE counter_group_id = l_counter_group_id;
8098:
8099: csi_ctr_gen_utility_pvt.put_line('Counter group Id = '||to_char(l_counter_group_id));
8100: csi_ctr_gen_utility_pvt.put_line('Template Flag = '||l_ctr_grp_rec.template_flag);