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 268: from cs_csi_counter_groups

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

Line 901: from cs_csi_counter_groups

897: l_valid_start_date DATE;
898:
899: CURSOR c1_group(p_group_id NUMBER) IS
900: select start_date_active
901: from cs_csi_counter_groups
902: where counter_group_id = p_group_id;
903:
904: CURSOR c2_counter(p_counter_id NUMBER) IS
905: select start_date_active

Line 1433: from cs_csi_counter_groups

1429: l_valid_start_date DATE;
1430:
1431: CURSOR c1_group(p_group_id NUMBER) IS
1432: select start_date_active
1433: from cs_csi_counter_groups
1434: where counter_group_id = p_group_id;
1435:
1436: BEGIN
1437: -- Standard Start of API savepoint

Line 3237: FROM cs_csi_counter_groups

3233: ,source_object_code
3234: ,source_object_id
3235: ,source_counter_group_id
3236: ,security_group_id
3237: FROM cs_csi_counter_groups
3238: WHERE counter_group_id = p_counter_group_id
3239: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3240: l_old_counter_groups_rec cur_group_rec%ROWTYPE;
3241:

Line 8139: FROM cs_csi_counter_groups

8135: l_ctr_grp_rec.attribute14,
8136: l_ctr_grp_rec.attribute15,
8137: l_ctr_grp_rec.context,
8138: l_ctr_grp_rec.template_flag
8139: FROM cs_csi_counter_groups
8140: WHERE counter_group_id = l_counter_group_id;
8141:
8142: csi_ctr_gen_utility_pvt.put_line('Counter group Id = '||to_char(l_counter_group_id));
8143: csi_ctr_gen_utility_pvt.put_line('Template Flag = '||l_ctr_grp_rec.template_flag);