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 403: from msc_plans

399: WHERE series_id IN (112, 113);
400:
401: Cursor c_plan_start_date is
402: select curr_start_date
403: from msc_plans
404: where plan_id = p_plan_id;
405:
406:
407: /*** LOCAL VARIABLES - BEGIN ***/

Line 969: from msc_plans

965: is
966:
967: cursor get_plan_info is
968: select sr_instance_id, compile_designator, plan_type, curr_start_date, cutoff_date
969: from msc_plans
970: where plan_id = p_plan_id;
971:
972: l_plan_type number;
973:

Line 986: from msc_plans

982: l_retcode number;
983:
984: Cursor c_sup_plan is
985: select compile_designator, curr_start_date, cutoff_date, sop_enabled, plan_type
986: from msc_plans
987: where plan_id=p_plan_id;
988:
989: Type all_sup_plans is Ref Cursor;
990: c_all_sup_plans all_sup_plans;

Line 1015: from msc_plans

1011:
1012: If(p_plan_id is null) then
1013:
1014: l_stmt := 'select plan_id, compile_designator, curr_start_date, cutoff_date, sop_enabled, plan_type
1015: from msc_plans
1016: where sop_enabled = 1 ';
1017:
1018: /* Do not supply plan members which are already present inside Demantra */
1019: l_stmt := l_stmt || ' AND compile_designator NOT IN '

Line 1154: from msc_plans

1150: is
1151:
1152: cursor get_plan_info is
1153: select sr_instance_id, compile_designator, plan_type, curr_start_date, cutoff_date
1154: from msc_plans
1155: where plan_id = p_plan_id;
1156:
1157: l_plan_type number;
1158:

Line 1282: from msc_plans

1278: retcode number;
1279:
1280: cursor get_instance_id is
1281: select sr_instance_id
1282: from msc_plans
1283: where plan_id = p_plan_id;
1284:
1285: l_instance_id number;
1286: