DBA Data[Home] [Help]

APPS.MSC_RP_PUB dependencies on MSC_PLAN_ORGANIZATION_S

Line 466: select msc_plan_organization_s.nextval from dual;

462: and mp.compile_designator=desig.designator;
463:
464: /*l_prog_seq number;
465: cursor prog_seq is
466: select msc_plan_organization_s.nextval from dual;
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

Line 748: program_id= msc_plan_organization_s.nextval

744: l_Counter := l_Counter + 1;
745:
746: update MSC_plan_organizations
747: set
748: program_id= msc_plan_organization_s.nextval
749: where plan_id = rp_id;
750: exit;
751: EXCEPTION
752: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 777: program_id= msc_plan_organization_s.nextval

773: l_Counter := l_Counter + 1;
774:
775: update MSC_plan_schedules
776: set
777: program_id= msc_plan_organization_s.nextval
778: where plan_id = rp_id;
779: exit;
780: EXCEPTION
781: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN