PACKAGE: APPS.MTL_SAFETY_STOCKS_PKG

Source

1 PACKAGE MTL_SAFETY_STOCKS_PKG as
2 /* $Header: INVDDFSS.pls 120.1.12000000.1 2007/01/17 16:13:29 appldev ship $ */
3 
4 procedure SafetyStock(X_ORGANIZATION_ID NUMBER,
5                       X_SELECTION NUMBER,
6                       X_INVENTORY_ITEM_ID NUMBER,
7 		      X_SAFETY_STOCK_CODE NUMBER,
8                       X_FORECAST_NAME VARCHAR2,
9                       X_CATEGORY_SET_ID NUMBER,
10                       X_CATEGORY_ID NUMBER,
11                       X_PERCENT NUMBER,
12                       X_SERVICE_LEVEL NUMBER,
13                       X_START_DATE DATE,
14                       login_id NUMBER,
15                       user_id NUMBER);
16 
17 procedure Init(org_id IN NUMBER,
18                srv_level IN NUMBER,
19                srv_factor OUT NOCOPY NUMBER,
20                cal_code OUT NOCOPY VARCHAR2,
21                except_id OUT NOCOPY NUMBER);
22 
23 procedure Main(org_id NUMBER,
24                item_id NUMBER,
25 	       ss_code NUMBER,
26                forc_name VARCHAR2,
27                ss_percent NUMBER,
28                srv_level NUMBER,
29                effect_date DATE,
30                srv_factor NUMBER,
31                cal_code VARCHAR2,
32                except_id NUMBER,
33                login_id NUMBER,
34                user_id NUMBER);
35 
36 procedure Insert_Safety_Stocks (org_id NUMBER,
37 	    		        item_id NUMBER,
38 				ss_code NUMBER,
39 				forc_name VARCHAR2,
40                       		ss_percent NUMBER,
41                       		srv_level NUMBER,
42                       		ss_date DATE,
43                                 ss_qty NUMBER,
44                                 login_id NUMBER,
45                                 user_id NUMBER);
46 
47 FUNCTION CalSF(service_level NUMBER) RETURN NUMBER;
48 
49 /********************************************
50  *Enhancement bug#2231655   GLOBAL VARIABLES*
51  ********************************************/
52 
53  g_debug_level NUMBER := FND_PROFILE.VALUE('INV_DEBUG_LEVEL');
54 
55 END MTL_SAFETY_STOCKS_PKG;