APPS.MSC_RP_PUB dependencies on MSC_DESIGNATORS

Line 440: from msc_plans mp, msc_designators desig where mp.compile_designator=arg_plan_name

436: l_sr_instance_id number:=RP_NULL_VALUE;
437:
438: cursor plan_exists(arg_plan_name varchar2) is
439: select mp.plan_id,nvl(mp.ascp_plan_version,RP_NULL_VALUE), mp.plan_type, desig.designator_id, ascp_plan_id
440: from msc_plans mp, msc_designators desig where mp.compile_designator=arg_plan_name
441: and mp.compile_designator=desig.designator;
442:
443: cursor assert_user_access(arg_plan_id number) is
444: select 1

Line 461: from msc_plans mp, msc_designators desig where mp.plan_id=arg_plan_id

457: and mp.plan_id=arg_plan_id;
458:
459: cursor get_options(arg_plan_id number) is
460: select mp.description,mp.category_set_id,mp.daily_cutoff_bucket
461: from msc_plans mp, msc_designators desig where mp.plan_id=arg_plan_id
462: and mp.compile_designator=desig.designator;
463:
464: /*l_prog_seq number;
465: cursor prog_seq is

Line 471: From Msc_Designators

467: */
468: Cursor Desig_Cur(p_plan_id in number) Is
469: Select
470: Inventory_Atp_Flag, Production, launch_workflow_flag, Disable_Date, organization_id, sr_instance_id
471: From Msc_Designators
472: Where (Designator, Organization_Id, Sr_Instance_Id) =
473: (Select
474: Compile_Designator, Organization_Id, Sr_Instance_Id
475: From

Line 806: update MSC_DESIGNATORS

802: BEGIN
803: EXIT WHEN l_Counter > l_max_tries;
804: l_Counter := l_Counter + 1;
805:
806: update MSC_DESIGNATORS
807: set
808: copy_Designator_id=null
809: where designator_id = rp_designator_id;
810: exit;