APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSCPLANNEDSUPPLYREC

Line 124: PROCEDURE InsertPlannedSupply(PlanId IN NUMBER, SrInstId IN NUMBER, PlannedSupplyData IN MscPlannedSupplyRec);

120: PROCEDURE QuerySafetyStocks(SafetyStockTbl OUT NOCOPY MscSafetyStockTbl, WhereClause IN VARCHAR2);
121:
122: -- Private helper functions used by UPLOAD_PLANNED_SUPPLIES only.
123: FUNCTION ValidatePlanType(PlanId IN NUMBER) RETURN VARCHAR2;
124: PROCEDURE InsertPlannedSupply(PlanId IN NUMBER, SrInstId IN NUMBER, PlannedSupplyData IN MscPlannedSupplyRec);
125: FUNCTION ProcessPlannedSupply(PlanId IN NUMBER, SrInstanceId IN NUMBER, PlannedSupplyData IN MscPlannedSupplyRec) RETURN VARCHAR2;
126:
127: -- =============================================================
128: -- Desc: Create a new scenario.

Line 125: FUNCTION ProcessPlannedSupply(PlanId IN NUMBER, SrInstanceId IN NUMBER, PlannedSupplyData IN MscPlannedSupplyRec) RETURN VARCHAR2;

121:
122: -- Private helper functions used by UPLOAD_PLANNED_SUPPLIES only.
123: FUNCTION ValidatePlanType(PlanId IN NUMBER) RETURN VARCHAR2;
124: PROCEDURE InsertPlannedSupply(PlanId IN NUMBER, SrInstId IN NUMBER, PlannedSupplyData IN MscPlannedSupplyRec);
125: FUNCTION ProcessPlannedSupply(PlanId IN NUMBER, SrInstanceId IN NUMBER, PlannedSupplyData IN MscPlannedSupplyRec) RETURN VARCHAR2;
126:
127: -- =============================================================
128: -- Desc: Create a new scenario.
129: --

Line 2171: PlannedSupplyData IN MscPlannedSupplyRec

2167: -- =============================================================
2168: PROCEDURE InsertPlannedSupply(
2169: PlanId IN NUMBER,
2170: SrInstId IN NUMBER,
2171: PlannedSupplyData IN MscPlannedSupplyRec
2172: ) AS
2173: l_TransactionId NUMBER;
2174: BEGIN
2175: -- generate an unique demand id

Line 2221: PlannedSupplyData IN MscPlannedSupplyRec

2217: -- =============================================================
2218: FUNCTION ProcessPlannedSupply(
2219: PlanId IN NUMBER,
2220: SrInstanceId IN NUMBER,
2221: PlannedSupplyData IN MscPlannedSupplyRec
2222: ) RETURN VARCHAR2 AS
2223: l_String VARCHAR2(100);
2224: BEGIN
2225: -- check organization id

Line 2995: l_BadData MscPlannedSupplyRec;

2991: l_PlanId NUMBER;
2992: l_CompletionDate DATE;
2993: l_GoodRecCount NUMBER;
2994: l_BadRecCount NUMBER;
2995: l_BadData MscPlannedSupplyRec;
2996: BEGIN
2997: -- init global variables
2998: g_ErrorCode := '';
2999: