APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_CS_DATA_DS

Line 640: delete from msd_cs_Data_ds

636:
637: delete from msd_level_values_ds
638: where demand_plan_id = p_demand_plan_id;
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;

Line 1463: -- insert into msd_cs_data_ds

1459:
1460: -- This Procedure Produces and executes a dynamic sql statement
1461: -- to insert data into the fact stripe table. Here's an example
1462: -- of what the sql looks like :
1463: -- insert into msd_cs_data_ds
1464: -- (
1465: -- demand_plan_id,
1466: -- cs_data_id,
1467: -- cs_definition_id,

Line 1593: delete from msd_cs_data_ds

1589: if (stripe_refresh is not null) then
1590:
1591: /* check if delete by parameter_name is necesary */
1592: if (c1_rec.multiple_stream_flag = C_YES_FLAG) then
1593: delete from msd_cs_data_ds
1594: where demand_plan_id = p_demand_plan_id
1595: and cs_definition_id = c1_rec.cs_definition_id
1596: and cs_name = c0_rec.parameter_name;
1597: else

Line 1598: delete from msd_cs_data_ds

1594: where demand_plan_id = p_demand_plan_id
1595: and cs_definition_id = c1_rec.cs_definition_id
1596: and cs_name = c0_rec.parameter_name;
1597: else
1598: delete from msd_cs_data_ds
1599: where demand_plan_id = p_demand_plan_id
1600: and cs_definition_id = c1_rec.cs_definition_id;
1601: end if;
1602: end if;

Line 1608: v_sql_stmt := v_sql_stmt || ' insert into msd_cs_data_ds ';

1604:
1605:
1606:
1607:
1608: v_sql_stmt := v_sql_stmt || ' insert into msd_cs_data_ds ';
1609: v_sql_stmt := v_sql_stmt || ' (demand_plan_id, cs_data_id, cs_definition_id, cs_name, ';
1610: v_sql_stmt := v_sql_stmt || ' last_update_date, last_updated_by, creation_date, created_by) ';
1611: v_sql_stmt := v_sql_stmt || ' select /*+ ORDERED */ mds.demand_plan_id, cdv.cs_data_id, cdv.cs_definition_id, cdv.cs_name, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id ';
1612: v_sql_stmt := v_sql_stmt || ' from (select demand_plan_id from msd_dp_session) mds, ';

Line 1886: are upto date when insert into msd_cs_data_ds is done.

1882: where demand_plan_id = p_demand_plan_id;
1883:
1884: /* Bug# 5078878
1885: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics
1886: are upto date when insert into msd_cs_data_ds is done.
1887: */
1888: commit;
1889: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);
1890:

Line 2126: delete from msd_cs_data_ds

2122: for c1_rec in c1 loop
2123:
2124: if (c1_rec.parameter_name is not null) then
2125:
2126: delete from msd_cs_data_ds
2127: where cs_definition_id = (select cs_definition_id
2128: from msd_cs_definitions
2129: where name = c1_rec.parameter_type)
2130: and cs_name = c1_rec.parameter_name

Line 2135: delete from msd_cs_data_ds

2131: and demand_plan_id = p_demand_plan_id;
2132:
2133: else
2134:
2135: delete from msd_cs_data_ds
2136: where cs_definition_id = (select cs_definition_id
2137: from msd_cs_definitions
2138: where name = c1_rec.parameter_type)
2139: and demand_plan_id = p_demand_plan_id;