[Home] [Help]
116: PROCEDURE UpdateSafetyStock(PlanId IN NUMBER, SafetyStockData IN MscSafetyStockRec);
117: FUNCTION ProcessSafetyStock(PlanId IN NUMBER, OwningOrgId IN NUMBER, SrInstId IN NUMBER, SafetyStockData IN MscSafetyStockRec) RETURN VARCHAR2;
118:
119: -- Private helper functions used by DOWNLOAD_SAFETY_STOCKS only.
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);
2019: --
2020: -- Output: No output.
2021: -- =============================================================
2022: PROCEDURE QuerySafetyStocks(
2023: SafetyStockTbl OUT NOCOPY MscSafetyStockTbl,
2024: WhereClause IN VARCHAR2
2025: ) AS
2026: TYPE SSCurType IS REF CURSOR;
2027: ss_cursor SSCurType;
2045: l_TransitLTVarSSPct NUMBER;
2046: l_SupLTVarSSPct NUMBER;
2047: l_TotalUnpooledSS NUMBER;
2048: BEGIN
2049: SafetyStockTbl := MscSafetyStockTbl();
2050: l_Sql := 'SELECT ' ||
2051: 'organization_id, ' ||
2052: 'sr_instance_id, ' ||
2053: 'inventory_item_id, ' ||
2710: -- BadRecTbl List of forecasts that are failed the validation.
2711: -- =============================================================
2712: PROCEDURE UPLOAD_SAFETY_STOCKS(
2713: Status OUT NOCOPY VARCHAR2,
2714: BadRecTbl OUT NOCOPY MscSafetyStockTbl,
2715: -- UserId IN NUMBER,
2716: -- ResponsibilityId IN NUMBER,
2717: UserName IN VARCHAR2,
2718: RespName IN VARCHAR2,
2722: PlanName IN VARCHAR2,
2723: OwningOrgId IN NUMBER,
2724: SrInstanceId IN NUMBER,
2725: PurgeAllFlag IN VARCHAR2,
2726: SafetyStockTbl IN MscSafetyStockTbl
2727: ) AS
2728: l_String VARCHAR2(100);
2729: l_ResponsibilityId NUMBER;
2730: l_SecurityGroupId NUMBER;
2737: -- init global variables
2738: g_ErrorCode := '';
2739:
2740: -- init bad record table
2741: BadRecTbl := MscSafetyStockTbl();
2742:
2743: -- query user id, responsibility id and security group id
2744: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
2745: IF (l_String <> 'OK') THEN
2860: -- ForecastTbl List of safety stocks that are downloaded.
2861: -- =============================================================
2862: PROCEDURE DOWNLOAD_SAFETY_STOCKS(
2863: Status OUT NOCOPY VARCHAR2,
2864: SafetyStockTbl OUT NOCOPY MscSafetyStockTbl,
2865: -- UserId IN NUMBER,
2866: -- ResponsibilityId IN NUMBER,
2867: UserName IN VARCHAR2,
2868: RespName IN VARCHAR2,
2882: l_SubClause VARCHAR2(1024);
2883: l_PlanId NUMBER;
2884: BEGIN
2885: -- init output table
2886: SafetyStockTbl := MscSafetyStockTbl();
2887:
2888: -- query user id, responsibility id and security group id
2889: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
2890: IF (l_String <> 'OK') THEN