APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_DEMAND_PLANS

Line 389: FROM msd_demand_plans

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

Line 649: update msd_demand_plans

645:
646: delete from msd_dp_parameters_ds
647: where demand_plan_id = p_demand_plan_id;
648:
649: update msd_demand_plans
650: set build_stripe_level_pk = null,
651: build_stripe_stream_name = null,
652: build_stripe_stream_desig = null,
653: build_stripe_stream_ref_num = null

Line 1759: update msd_demand_plans

1755: l_c1_rec.system_attribute2,
1756: l_c1_rec.dp_enabled_flag
1757: );
1758:
1759: update msd_demand_plans
1760: set build_stripe_level_pk = l_c1_rec.level_pk,
1761: build_stripe_stream_name = null,
1762: build_stripe_stream_desig = null,
1763: build_stripe_stream_ref_num = null

Line 2451: update msd_demand_plans

2447: open get_refresh_num(p_stripe_stream_name, p_stripe_stream_desig);
2448: fetch get_refresh_num into x_refresh_num;
2449: close get_refresh_num;
2450:
2451: update msd_demand_plans
2452: set build_stripe_stream_name = p_stripe_stream_name,
2453: build_stripe_stream_desig = p_stripe_stream_desig,
2454: build_stripe_stream_ref_num = x_refresh_num,
2455: build_stripe_level_pk = null

Line 2548: update msd_demand_plans

2544: open get_refresh_num(p_stripe_stream_name, p_stripe_stream_desig);
2545: fetch get_refresh_num into x_refresh_num;
2546: close get_refresh_num;
2547:
2548: update msd_demand_plans
2549: set build_stripe_level_pk = l_c1_rec.level_pk,
2550: build_stripe_stream_name = p_stripe_stream_name,
2551: build_stripe_stream_desig = p_stripe_stream_desig,
2552: build_stripe_stream_ref_num = x_refresh_num