[Home] [Help]
91:
92: BEGIN
93:
94: select count(*) into lv_desig_count
95: from (select distinct cs_name from msd_cs_data where cs_definition_id=p_cs_definition_id);
96:
97:
98: return lv_desig_count;
99:
120: IS
121:
122: CURSOR a(p_cs_definition_id NUMBER,p_dimension_code VARCHAR2) IS
123: select to_number(decode(p_dimension_code,'PRD',attribute_2,'GEO',attribute_6,'ORG',attribute_10,'REP',attribute_18,'CHN',attribute_22,'UD1',attribute_26,'UD2',attribute_30,'DCS',attribute_45))
124: from msd_cs_data
125: where cs_definition_id= p_cs_definition_id
126: and cs_data_id = (select min(cs_data_id) from msd_cs_data where cs_definition_id=p_cs_definition_id);
127:
128: lv_collect_level_id NUMBER;
122: CURSOR a(p_cs_definition_id NUMBER,p_dimension_code VARCHAR2) IS
123: select to_number(decode(p_dimension_code,'PRD',attribute_2,'GEO',attribute_6,'ORG',attribute_10,'REP',attribute_18,'CHN',attribute_22,'UD1',attribute_26,'UD2',attribute_30,'DCS',attribute_45))
124: from msd_cs_data
125: where cs_definition_id= p_cs_definition_id
126: and cs_data_id = (select min(cs_data_id) from msd_cs_data where cs_definition_id=p_cs_definition_id);
127:
128: lv_collect_level_id NUMBER;
129: lv_error_text VARCHAR2(2000);
130:
803: x.attribute_28,
804: x.attribute_32,
805: x.attribute_47,
806: x.cs_definition_id
807: FROM msd_cs_data x;
808:
809: CURSOR c1 IS
810: SELECT a.cs_definition_id,a.dimension_code,a.collect_level_id
811: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
815: AND b.strict_flag='Y'
816: AND b.valid_flag='Y'
817: AND b.enable_flag='Y'
818: AND ( ( b.multiple_stream_flag='N') OR ( b.multiple_stream_flag='Y' and MSD_COMPOSITE_GROUPING.number_of_designators(b.cs_definition_id)=1 ))
819: AND EXISTS (select 1 from msd_cs_data where cs_definition_id=a.cs_definition_id) ;
820: --need to elimintate custom streams having multiple streams with more than one designator.
821:
822: CURSOR c2 IS
823: SELECT cs_definition_id,dimension_code