APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_CS_DATA_DS

Line 643: delete from msd_cs_Data_ds

639:
640: delete from msd_level_values_ds
641: where demand_plan_id = p_demand_plan_id;
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;

Line 1469: -- insert into msd_cs_data_ds

1465:
1466: -- This Procedure Produces and executes a dynamic sql statement
1467: -- to insert data into the fact stripe table. Here's an example
1468: -- of what the sql looks like :
1469: -- insert into msd_cs_data_ds
1470: -- (
1471: -- demand_plan_id,
1472: -- cs_data_id,
1473: -- cs_definition_id,

Line 1599: delete from msd_cs_data_ds

1595: if (stripe_refresh is not null) then
1596:
1597: /* check if delete by parameter_name is necesary */
1598: if (c1_rec.multiple_stream_flag = C_YES_FLAG) then
1599: delete from msd_cs_data_ds
1600: where demand_plan_id = p_demand_plan_id
1601: and cs_definition_id = c1_rec.cs_definition_id
1602: and cs_name = c0_rec.parameter_name;
1603: else

Line 1604: delete from msd_cs_data_ds

1600: where demand_plan_id = p_demand_plan_id
1601: and cs_definition_id = c1_rec.cs_definition_id
1602: and cs_name = c0_rec.parameter_name;
1603: else
1604: delete from msd_cs_data_ds
1605: where demand_plan_id = p_demand_plan_id
1606: and cs_definition_id = c1_rec.cs_definition_id;
1607: end if;
1608: end if;

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

1610:
1611:
1612:
1613:
1614: v_sql_stmt := v_sql_stmt || ' insert into msd_cs_data_ds ';
1615: v_sql_stmt := v_sql_stmt || ' (demand_plan_id, cs_data_id, cs_definition_id, cs_name, ';
1616: v_sql_stmt := v_sql_stmt || ' last_update_date, last_updated_by, creation_date, created_by) ';
1617: 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 ';
1618: v_sql_stmt := v_sql_stmt || ' from (select demand_plan_id from msd_dp_session) mds, ';

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

1888: where demand_plan_id = p_demand_plan_id;
1889:
1890: /* Bug# 5078878
1891: Calling analyze table MSD_LEVEL_VALUES_DS so that the statistics
1892: are upto date when insert into msd_cs_data_ds is done.
1893: */
1894: commit;
1895: MSD_ANALYZE_TABLES.analyze_table('MSD_LEVEL_VALUES_DS',null);
1896:

Line 2132: delete from msd_cs_data_ds

2128: for c1_rec in c1 loop
2129:
2130: if (c1_rec.parameter_name is not null) then
2131:
2132: delete from msd_cs_data_ds
2133: where cs_definition_id = (select cs_definition_id
2134: from msd_cs_definitions
2135: where name = c1_rec.parameter_type)
2136: and cs_name = c1_rec.parameter_name

Line 2141: delete from msd_cs_data_ds

2137: and demand_plan_id = p_demand_plan_id;
2138:
2139: else
2140:
2141: delete from msd_cs_data_ds
2142: where cs_definition_id = (select cs_definition_id
2143: from msd_cs_definitions
2144: where name = c1_rec.parameter_type)
2145: and demand_plan_id = p_demand_plan_id;