[Home] [Help]
481: begin
482:
483: if (p_demand_plan_id is not null) then
484:
485: delete from msd_dp_session;
486:
487: insert into msd_dp_session
488: ( demand_plan_id )
489: values
483: if (p_demand_plan_id is not null) then
484:
485: delete from msd_dp_session;
486:
487: insert into msd_dp_session
488: ( demand_plan_id )
489: values
490: ( p_demand_plan_id );
491:
489: values
490: ( p_demand_plan_id );
491:
492: -- Incorporate later into msd_analyze
493: --fnd_stats.gather_table_stats('MSD', 'MSD_DP_SESSION', 10, 4);
494:
495: end if;
496:
497: end;
1478: -- sysdate,
1479: -- fnd_global.user_id,
1480: -- sysdate,
1481: -- fnd_global.user_id
1482: -- from (select demand_plan_id from msd_dp_session) mds,
1483: -- msd_cs_data_v1 csd,
1484: -- msd_level_values_ds mld
1485: -- where csd.cs_definition_id = 21
1486: -- and mld.level_pk = csd.product_lvl_pk
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, ';
1613: v_sql_stmt := v_sql_stmt || ' msd_cs_data_v1 cdv ';
1614: v_sql_where_stmt := v_sql_where_stmt || ' where cdv.cs_definition_id = ' || c1_rec.cs_definition_id || ' and mds.demand_plan_id = ' || p_demand_plan_id;
1615:
1616: for c2_rec in c2(c1_rec.cs_definition_id) loop