[Home] [Help]
484: begin
485:
486: if (p_demand_plan_id is not null) then
487:
488: delete from msd_dp_session;
489:
490: insert into msd_dp_session
491: ( demand_plan_id )
492: values
486: if (p_demand_plan_id is not null) then
487:
488: delete from msd_dp_session;
489:
490: insert into msd_dp_session
491: ( demand_plan_id )
492: values
493: ( p_demand_plan_id );
494:
492: values
493: ( p_demand_plan_id );
494:
495: -- Incorporate later into msd_analyze
496: --fnd_stats.gather_table_stats('MSD', 'MSD_DP_SESSION', 10, 4);
497:
498: end if;
499:
500: end;
1484: -- sysdate,
1485: -- fnd_global.user_id,
1486: -- sysdate,
1487: -- fnd_global.user_id
1488: -- from (select demand_plan_id from msd_dp_session) mds,
1489: -- msd_cs_data_v1 csd,
1490: -- msd_level_values_ds mld
1491: -- where csd.cs_definition_id = 21
1492: -- and mld.level_pk = csd.product_lvl_pk
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, ';
1619: v_sql_stmt := v_sql_stmt || ' msd_cs_data_v1 cdv ';
1620: 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;
1621:
1622: for c2_rec in c2(c1_rec.cs_definition_id) loop