APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS

Line 643: delete from msd_dp_parameters_ds

639:
640: delete from msd_cs_Data_ds
641: where demand_plan_id = p_demand_plan_id;
642:
643: delete from msd_dp_parameters_ds
644: where demand_plan_id = p_demand_plan_id;
645:
646: update msd_demand_plans
647: set build_stripe_level_pk = null,

Line 1496: from msd_dp_parameters

1492: cursor c0 is
1493: select distinct
1494: parameter_type,
1495: parameter_name
1496: from msd_dp_parameters
1497: where demand_plan_id = p_demand_plan_id;
1498:
1499: cursor c1(p_cs_defn_name in varchar2) is
1500: select cs_definition_id,

Line 1522: from msd_dp_parameters_ds

1518: order by last_refresh_num desc;
1519:
1520: cursor c5 (p_parameter_type in varchar2, p_parameter_name in varchar2) is
1521: select refresh_num
1522: from msd_dp_parameters_ds
1523: where demand_plan_id = p_demand_plan_id
1524: and parameter_type = p_parameter_type
1525: and nvl(parameter_name, '&*') = nvl(p_parameter_name, nvl(parameter_name, '&*'))
1526: and data_type = C_FACT;

Line 1908: from msd_dp_parameters_ds

1904: l_refresh_level_values varchar2(100) := C_TRUE;
1905:
1906: cursor c2 is
1907: select refresh_num
1908: from msd_dp_parameters_ds
1909: where demand_plan_id = C_LEVEL_PLAN
1910: and data_type = C_LVL_VAL;
1911:
1912: cursor c3 is

Line 1914: from msd_dp_parameters_ds

1910: and data_type = C_LVL_VAL;
1911:
1912: cursor c3 is
1913: select refresh_num
1914: from msd_dp_parameters_ds
1915: where demand_plan_id = p_demand_plan_id
1916: and data_type = C_LVL_VAL;
1917:
1918: begin

Line 1953: from msd_dp_parameters_ds

1949: where demand_plan_id = p_demand_plan_id
1950: and dimension_code in (C_REP_DIM_CODE,C_GEO_DIM_CODE)
1951: minus
1952: select parameter_type
1953: from msd_dp_parameters_ds
1954: where demand_plan_id = p_demand_plan_id
1955: and data_type = C_DIM
1956: and parameter_type in (C_REP_DIM_CODE,C_GEO_DIM_CODE);
1957:

Line 1960: from msd_dp_parameters_ds

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

Line 2107: from msd_dp_parameters_ds

2103: p_demand_plan_id in number) is
2104:
2105: cursor c1 is
2106: select parameter_type, parameter_name
2107: from msd_dp_parameters_ds
2108: where demand_plan_id = p_demand_plan_id
2109: and data_type = C_FACT
2110: minus
2111: select parameter_type, parameter_name

Line 2112: from msd_dp_parameters

2108: where demand_plan_id = p_demand_plan_id
2109: and data_type = C_FACT
2110: minus
2111: select parameter_type, parameter_name
2112: from msd_dp_parameters
2113: where demand_plan_id = p_demand_plan_id;
2114:
2115: begin
2116:

Line 2165: delete from msd_dp_parameters_ds

2161: end if;
2162:
2163:
2164:
2165: delete from msd_dp_parameters_ds
2166: where demand_plan_id = p_demand_plan_id;
2167:
2168: insert into msd_dp_parameters_ds
2169: ( DEMAND_PLAN_ID,

Line 2168: insert into msd_dp_parameters_ds

2164:
2165: delete from msd_dp_parameters_ds
2166: where demand_plan_id = p_demand_plan_id;
2167:
2168: insert into msd_dp_parameters_ds
2169: ( DEMAND_PLAN_ID,
2170: DATA_TYPE,
2171: PARAMETER_TYPE,
2172: PARAMETER_NAME,

Line 2188: from msd_dp_parameters_ds

2184: sysdate,
2185: fnd_global.user_id,
2186: sysdate,
2187: fnd_global.user_id
2188: from msd_dp_parameters_ds
2189: where demand_plan_id = C_LEVEL_PLAN
2190: and data_type = C_LVL_VAL
2191: union all
2192: select p_demand_plan_id,

Line 2201: from msd_dp_parameters mdp,

2197: sysdate,
2198: fnd_global.user_id,
2199: sysdate,
2200: fnd_global.user_id
2201: from msd_dp_parameters mdp,
2202: msd_cs_data_headers csh,
2203: msd_cs_definitions csd
2204: where mdp.parameter_type = csd.name
2205: and csd.cs_definition_id = csh.cs_definition_id