APPS.MSD_WF dependencies on MSD_DEMAND_PLANS

Line 161: update msd_demand_plans

157: Itemkey => ItemKey,
158: aname => 'DPPROBLEM',
159: avalue => substr(SQLERRM, 1, 200));
160:
161: update msd_demand_plans
162: set DP_BUILD_ERROR_FLAG = 'YES'
163: where demand_plan_id = to_number(PlanID);
164: commit;
165:

Line 207: from msd_demand_plans_v

203:
204: SELECT demand_plan_name, code_location, shared_db_prefix,
205: shared_db_location, express_connect_string INTO PlName,
206: CodeLoc, DBName, SharedLoc, express_server
207: from msd_demand_plans_v
208: where demand_plan_id=to_number(inPlan);
209:
210:
211: wf_engine.CreateProcess(ItemType => ItemType,

Line 400: update msd_demand_plans

396: Itemkey => ItemKey,
397: aname => 'DPPROBLEM',
398: avalue => substr(SQLERRM, 1, 200));
399:
400: update msd_demand_plans
401: set DP_BUILD_ERROR_FLAG = 'YES'
402: where demand_plan_id = to_number(PlanID);
403: commit;
404:

Line 496: update msd_demand_plans

492:
493: planID:=wf_engine.GetItemAttrText(Itemtype => ItemType,
494: Itemkey => ItemKey,
495: aname => 'ODPPLAN');
496: update msd_demand_plans
497: set DP_BUILD_ERROR_FLAG = 'YES'
498: where demand_plan_id = to_number(planID);
499: commit;
500:

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

839: -- Concurrent program that is used to run the ODP master WF process
840: --
841: --
842: -- IN
843: -- PlanName - A valid plan name from msd_demand_plans_v
844: -- NumDays_to_collect - Number of days to run the collection
845: -- OUT
846: -- errbuf - error message : process or PL/SQL error.
847: -- retcode - return code (0 = success, 2 = error).

Line 889: from msd_demand_plans_v

885: errbuf := ' ';
886:
887: -- Get needed plan information
888: SELECT demand_plan_id, code_location, shared_db_prefix, shared_db_location, express_connect_string INTO PlanID, CodeLoc, DBName, SharedLoc, express_server
889: from msd_demand_plans_v
890: where demand_plan_name=PlanName;
891:
892: -- Get organiztion code and instance
893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code

Line 895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v

891:
892: -- Get organiztion code and instance
893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3

Line 896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND

892: -- Get organiztion code and instance
893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

Line 897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id

893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
901:

Line 898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id

894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
901:
902: --get MSD code database name

Line 900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;

896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
901:
902: --get MSD code database name
903: select fnd_profile.value('MSD_CODE_AW') into codeDBName from dual;
904: