APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_DEMAND_PLANS

Line 386: FROM msd_demand_plans

382: stripe_stream_desig,
383: build_stripe_stream_name,
384: build_stripe_stream_desig,
385: build_stripe_stream_ref_num
386: FROM msd_demand_plans
387: WHERE demand_plan_id = p_demand_plan_id;
388:
389: --
390: -- get last refresh num

Line 646: update msd_demand_plans

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,
648: build_stripe_stream_name = null,
649: build_stripe_stream_desig = null,
650: build_stripe_stream_ref_num = null

Line 1753: update msd_demand_plans

1749: l_c1_rec.system_attribute2,
1750: l_c1_rec.dp_enabled_flag
1751: );
1752:
1753: update msd_demand_plans
1754: set build_stripe_level_pk = l_c1_rec.level_pk,
1755: build_stripe_stream_name = null,
1756: build_stripe_stream_desig = null,
1757: build_stripe_stream_ref_num = null

Line 2445: update msd_demand_plans

2441: open get_refresh_num(p_stripe_stream_name, p_stripe_stream_desig);
2442: fetch get_refresh_num into x_refresh_num;
2443: close get_refresh_num;
2444:
2445: update msd_demand_plans
2446: set build_stripe_stream_name = p_stripe_stream_name,
2447: build_stripe_stream_desig = p_stripe_stream_desig,
2448: build_stripe_stream_ref_num = x_refresh_num,
2449: build_stripe_level_pk = null

Line 2542: update msd_demand_plans

2538: open get_refresh_num(p_stripe_stream_name, p_stripe_stream_desig);
2539: fetch get_refresh_num into x_refresh_num;
2540: close get_refresh_num;
2541:
2542: update msd_demand_plans
2543: set build_stripe_level_pk = l_c1_rec.level_pk,
2544: build_stripe_stream_name = p_stripe_stream_name,
2545: build_stripe_stream_desig = p_stripe_stream_desig,
2546: build_stripe_stream_ref_num = x_refresh_num