APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSC_SUPPLIES

Line 2159: -- Desc: Insert planned supply into msc_supplies table.

2155: END ValidatePlanType;
2156:
2157:
2158: -- =============================================================
2159: -- Desc: Insert planned supply into msc_supplies table.
2160: --
2161: -- Input:
2162: -- PlanId Plan id.
2163: -- SrInstId Source instance id.

Line 2176: SELECT msc_supplies_s.nextval INTO l_TransactionId FROM DUAL;

2172: ) AS
2173: l_TransactionId NUMBER;
2174: BEGIN
2175: -- generate an unique demand id
2176: SELECT msc_supplies_s.nextval INTO l_TransactionId FROM DUAL;
2177:
2178: -- insert data
2179: INSERT INTO msc_supplies
2180: (

Line 2179: INSERT INTO msc_supplies

2175: -- generate an unique demand id
2176: SELECT msc_supplies_s.nextval INTO l_TransactionId FROM DUAL;
2177:
2178: -- insert data
2179: INSERT INTO msc_supplies
2180: (
2181: plan_id, transaction_id, organization_id,
2182: sr_instance_id, inventory_item_id, new_schedule_date,
2183: disposition_status_type, order_type, new_order_quantity,

Line 2254: -- supply into msc_supplies table.

2250: RETURN 'INVALID_QUANTITY';
2251: END IF;
2252:
2253: -- All parametera pass the validation, insert/update the planned
2254: -- supply into msc_supplies table.
2255: InsertPlannedSupply(PlanId, SrInstanceId, PlannedSupplyData);
2256:
2257: RETURN 'OK';
2258:

Line 2943: -- Desc: Upload firmed plan orders into msc_supplies table.

2939: END DOWNLOAD_SAFETY_STOCKS;
2940:
2941:
2942: -- =============================================================
2943: -- Desc: Upload firmed plan orders into msc_supplies table.
2944: --
2945: -- Input:
2946: -- UserName User name.
2947: -- RespName Responsibility name.

Line 2954: -- PlannedSupplyTbl List of safety stocks to be uploaded to msc_supplies.

2950: -- Language Language.
2951: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.
2952: -- OwningOrgId Owning organization id for the plan.
2953: -- SrInstanceId Source instance id.
2954: -- PlannedSupplyTbl List of safety stocks to be uploaded to msc_supplies.
2955: -- OrganizationId Organization id.
2956: -- ItemId Item id.
2957: -- Quantity Quantity.
2958: -- FirmDate Firm date.

Line 3057: -- purge all firmed plan orders in msc_supplies table

3053: Status := 'NO_DATA';
3054: RETURN;
3055: END IF;
3056:
3057: -- purge all firmed plan orders in msc_supplies table
3058: -- for l_PlanId + order_type (5) + firm_planned_type .
3059: BEGIN
3060: DELETE FROM msc_supplies
3061: WHERE

Line 3060: DELETE FROM msc_supplies

3056:
3057: -- purge all firmed plan orders in msc_supplies table
3058: -- for l_PlanId + order_type (5) + firm_planned_type .
3059: BEGIN
3060: DELETE FROM msc_supplies
3061: WHERE
3062: plan_id = l_PlanId AND
3063: order_type = 5 AND
3064: firm_planned_type = 1;