APPS.MSDWF dependencies on MSD_DEMAND_PLANS_V

Line 177: from msd_demand_plans_v

173: BEGIN
174: SELECT demand_plan_name, code_location, shared_db_prefix,
175: shared_db_location, express_connect_string INTO PlName,
176: CodeLoc, DBName, SharedLoc, express_server
177: from msd_demand_plans_v
178: where demand_plan_id=to_number(inPlan);
179: wf_engine.CreateProcess(ItemType => ItemType,
180: itemKey => ItemKey,
181: process => WorkflowProcess);

Line 831: -- PlanName - A valid plan name from msd_demand_plans_v

827: -- Concurrent program that is used to run the ODP master WF process
828: --
829: --
830: -- IN
831: -- PlanName - A valid plan name from msd_demand_plans_v
832: -- NumDays_to_collect - Number of days to run the collection
833: -- OUT
834: -- errbuf - error message : process or PL/SQL error.
835: -- retcode - return code (0 = success, 2 = error).

Line 863: from msd_demand_plans_v

859: errbuf := ' ';
860:
861: -- Get needed plan information
862: SELECT demand_plan_id, code_location, shared_db_prefix, shared_db_location, express_connect_string INTO PlanID, CodeLoc, DBName, SharedLoc, express_server
863: from msd_demand_plans_v
864: where demand_plan_name=PlanName;
865:
866: -- Get organiztion code and instance
867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code

Line 869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v

865:
866: -- Get organiztion code and instance
867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
868: INTO orgcode, instcode
869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
872:
873: numDaysToCol := to_number(NumDays_to_collect);

Line 870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND

866: -- Get organiztion code and instance
867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
868: INTO orgcode, instcode
869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
872:
873: numDaysToCol := to_number(NumDays_to_collect);
874: -- Set item key

Line 871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

867: SELECT msd_organization_definitions.organization_code, msc_apps_instances.instance_code
868: INTO orgcode, instcode
869: FROM msd_organization_definitions, msc_apps_instances, msd_demand_plans_v
870: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
871: msd_demand_plans_v.ORGANIZATION_ID = msd_organization_definitions.ORGANIZATION_ID AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
872:
873: numDaysToCol := to_number(NumDays_to_collect);
874: -- Set item key
875: org := orgcode || ':' || instcode;