APPS.MSD_DEM_SOP dependencies on MSC_PLANS

Line 22: * This functions returns the plan_id in msc_plans given

18: */
19:
20:
21: /*
22: * This functions returns the plan_id in msc_plans given
23: * the member_id of a supply plan
24: * param: p_member_id - member_id of the supply plan level member
25: */
26: FUNCTION GET_PLAN_ID ( p_member_id IN NUMBER )

Line 83: from msc_plans

79: IS
80: cursor get_aggregation_info is
81: select curr_start_date, cutoff_date,
82: daily_mwo_aggr_lvl,weekly_mwo_aggr_lvl,period_mwo_aggr_lvl
83: from msc_plans
84: where plan_id = p_plan_id;
85:
86: l_start_date date:= NULL;
87: l_end_date date:= NULL;

Line 555: from msc_plans

551: WHERE series_id IN (112, 113);
552:
553: Cursor c_plan_start_date is
554: select curr_start_date
555: from msc_plans
556: where plan_id = p_plan_id;
557:
558:
559: /*** LOCAL VARIABLES - BEGIN ***/

Line 1183: from msc_plans

1179: is
1180:
1181: cursor get_plan_info is
1182: select sr_instance_id, compile_designator, plan_type, curr_start_date, cutoff_date
1183: from msc_plans
1184: where plan_id = p_plan_id;
1185:
1186: l_plan_type number;
1187:

Line 1200: from msc_plans

1196: l_retcode number;
1197:
1198: Cursor c_sup_plan is
1199: select compile_designator, curr_start_date, cutoff_date, sop_enabled, plan_type
1200: from msc_plans
1201: where plan_id=p_plan_id;
1202:
1203: Type all_sup_plans is Ref Cursor;
1204: c_all_sup_plans all_sup_plans;

Line 1231: from msc_plans

1227:
1228: If(p_plan_id is null) then
1229:
1230: l_stmt := 'select plan_id, compile_designator, curr_start_date, cutoff_date, sop_enabled, plan_type
1231: from msc_plans
1232: where sop_enabled = 1 ';
1233:
1234: -- BUG#9211268 syenamar
1235: --Enable download of RP plans into demantra (7.3 only)

Line 1390: from msc_plans

1386: is
1387:
1388: cursor get_plan_info is
1389: select sr_instance_id, compile_designator, plan_type, curr_start_date, cutoff_date
1390: from msc_plans
1391: where plan_id = p_plan_id;
1392:
1393: l_plan_type number;
1394:

Line 1518: from msc_plans

1514: retcode number;
1515:
1516: cursor get_instance_id is
1517: select sr_instance_id
1518: from msc_plans
1519: where plan_id = p_plan_id;
1520:
1521: l_instance_id number;
1522:

Line 1904: from msc_plans

1900: x_job_proc_name VARCHAR2(200) := NULL;
1901:
1902: cursor get_plan_info is
1903: select sr_instance_id, compile_designator, plan_type, curr_start_date, cutoff_date
1904: from msc_plans
1905: where plan_id = p_plan_id;
1906:
1907: Type dem_sched is Ref Cursor;
1908: c_dem_sched dem_sched;