APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DEFN_COLUMN_DTLS

Line 546: FROM msd_cs_defn_column_dtls a

542: and mdp.demand_plan_id = p_demand_plan_id;
543:
544: CURSOR param_cs_wgt (p_cs_def_id NUMBER) IS
545: SELECT count(1)
546: FROM msd_cs_defn_column_dtls a
547: WHERE a.cs_definition_id = p_cs_def_id
548: AND ((a.allocation_type IN ('AVG', 'WGT'))
549: OR (a.aggregation_type = 'WGT')
550: OR exists (select 1

Line 655: FROM msd_cs_defn_column_dtls_v

651: --
652: CURSOR get_lvl_column_name(p_dim_code Varchar2,p_cs_id NUMBER) IS
653: SELECT decode(planning_view_column_name,'TIM_LEVEL_ID','TIME_LEVEL_ID',
654: planning_view_column_name)
655: FROM msd_cs_defn_column_dtls_v
656: WHERE column_identifier = upper(p_dim_code)||'_LEVEL_ID'
657: AND identifier_type = 'DIMENSION_ID'
658: AND cs_definition_id = p_cs_id;
659:

Line 2887: lv_date_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;

2883: --
2884: Procedure chk_composite_group_level (p_demand_plan_id in number) is
2885: lv_level_id1 msd_levels.level_id%TYPE := 0;
2886: lv_level_id2 msd_levels.level_id%TYPE := 0;
2887: lv_date_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;
2888: lv_previous_stream msd_cs_definitions.name%TYPE := '##'; --Previous stream verified
2889: lv_level_differ Number :=2; --1-Yes and 2-No
2890:
2891: Begin

Line 2979: lv_level_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;

2975: Function get_level_column_name (p_dim_code in varchar2,
2976: p_cs_id in number)
2977: return Varchar2 is
2978:
2979: lv_level_column_name msd_cs_defn_column_dtls.planning_view_column_name%TYPE;
2980:
2981: Begin
2982: OPEN get_lvl_column_name(p_dim_code,p_cs_id);
2983: FETCH get_lvl_column_name INTO lv_level_column_name;

Line 3188: FROM msd_cs_defn_column_dtls_v

3184: function get_desig_clmn_name (p_cs_id in number) return VARCHAR2 IS
3185:
3186: CURSOR get_str_name (p_id NUMBER) IS
3187: SELECT planning_view_column_name
3188: FROM msd_cs_defn_column_dtls_v
3189: WHERE cs_definition_id = p_id
3190: AND identifier_type = 'CSIDEN';
3191:
3192: x_str_name varchar2(30);