APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS_DS

Line 646: delete from msd_dp_parameters_ds

642:
643: delete from msd_cs_Data_ds
644: where demand_plan_id = p_demand_plan_id;
645:
646: delete from msd_dp_parameters_ds
647: where demand_plan_id = p_demand_plan_id;
648:
649: update msd_demand_plans
650: set build_stripe_level_pk = null,

Line 1528: from msd_dp_parameters_ds

1524: order by last_refresh_num desc;
1525:
1526: cursor c5 (p_parameter_type in varchar2, p_parameter_name in varchar2) is
1527: select refresh_num
1528: from msd_dp_parameters_ds
1529: where demand_plan_id = p_demand_plan_id
1530: and parameter_type = p_parameter_type
1531: and nvl(parameter_name, '&*') = nvl(p_parameter_name, nvl(parameter_name, '&*'))
1532: and data_type = C_FACT;

Line 1914: from msd_dp_parameters_ds

1910: l_refresh_level_values varchar2(100) := C_TRUE;
1911:
1912: cursor c2 is
1913: select refresh_num
1914: from msd_dp_parameters_ds
1915: where demand_plan_id = C_LEVEL_PLAN
1916: and data_type = C_LVL_VAL;
1917:
1918: cursor c3 is

Line 1920: from msd_dp_parameters_ds

1916: and data_type = C_LVL_VAL;
1917:
1918: cursor c3 is
1919: select refresh_num
1920: from msd_dp_parameters_ds
1921: where demand_plan_id = p_demand_plan_id
1922: and data_type = C_LVL_VAL;
1923:
1924: begin

Line 1959: from msd_dp_parameters_ds

1955: where demand_plan_id = p_demand_plan_id
1956: and dimension_code in (C_REP_DIM_CODE,C_GEO_DIM_CODE)
1957: minus
1958: select parameter_type
1959: from msd_dp_parameters_ds
1960: where demand_plan_id = p_demand_plan_id
1961: and data_type = C_DIM
1962: and parameter_type in (C_REP_DIM_CODE,C_GEO_DIM_CODE);
1963:

Line 1966: from msd_dp_parameters_ds

1962: and parameter_type in (C_REP_DIM_CODE,C_GEO_DIM_CODE);
1963:
1964: cursor chk_change_dim2 is
1965: select parameter_type
1966: from msd_dp_parameters_ds
1967: where demand_plan_id = p_demand_plan_id
1968: and data_type = C_DIM
1969: and parameter_type in (C_REP_DIM_CODE,C_GEO_DIM_CODE)
1970: minus

Line 2113: from msd_dp_parameters_ds

2109: p_demand_plan_id in number) is
2110:
2111: cursor c1 is
2112: select parameter_type, parameter_name
2113: from msd_dp_parameters_ds
2114: where demand_plan_id = p_demand_plan_id
2115: and data_type = C_FACT
2116: minus
2117: select parameter_type, parameter_name

Line 2171: delete from msd_dp_parameters_ds

2167: end if;
2168:
2169:
2170:
2171: delete from msd_dp_parameters_ds
2172: where demand_plan_id = p_demand_plan_id;
2173:
2174: insert into msd_dp_parameters_ds
2175: ( DEMAND_PLAN_ID,

Line 2174: insert into msd_dp_parameters_ds

2170:
2171: delete from msd_dp_parameters_ds
2172: where demand_plan_id = p_demand_plan_id;
2173:
2174: insert into msd_dp_parameters_ds
2175: ( DEMAND_PLAN_ID,
2176: DATA_TYPE,
2177: PARAMETER_TYPE,
2178: PARAMETER_NAME,

Line 2194: from msd_dp_parameters_ds

2190: sysdate,
2191: fnd_global.user_id,
2192: sysdate,
2193: fnd_global.user_id
2194: from msd_dp_parameters_ds
2195: where demand_plan_id = C_LEVEL_PLAN
2196: and data_type = C_LVL_VAL
2197: union all
2198: select p_demand_plan_id,