1 PACKAGE CSP_FAILURE_RATES_PKG AUTHID CURRENT_USER as
2 /* $Header: csptfras.pls 115.3 2002/11/26 07:19:03 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_FAILURE_RATES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_FAILURE_RATE_ID IN OUT NOCOPY NUMBER
12 ,p_PRODUCT_ID NUMBER
13 ,p_INVENTORY_ITEM_ID NUMBER
14 ,p_CALCULATED_FAILURE_RATE NUMBER
15 ,p_MANUAL_FAILURE_RATE NUMBER
16 ,p_LAST_UPDATE_DATE DATE
17 ,p_LAST_UPDATED_BY NUMBER
18 ,p_CREATION_DATE DATE
19 ,p_CREATED_BY NUMBER
20 ,p_LAST_UPDATE_LOGIN NUMBER
21 ,p_PLANNING_PARAMETERS_ID NUMBER);
22 PROCEDURE Update_Row(
23 p_FAILURE_RATE_ID NUMBER
24 ,p_PRODUCT_ID NUMBER
25 ,p_INVENTORY_ITEM_ID NUMBER
26 ,p_CALCULATED_FAILURE_RATE NUMBER
27 ,p_MANUAL_FAILURE_RATE NUMBER
28 ,p_LAST_UPDATE_DATE DATE
29 ,p_LAST_UPDATED_BY NUMBER
30 ,p_CREATION_DATE DATE
31 ,p_CREATED_BY NUMBER
32 ,p_LAST_UPDATE_LOGIN NUMBER
33 ,p_PLANNING_PARAMETERS_ID NUMBER);
34 PROCEDURE Lock_Row(
35 p_FAILURE_RATE_ID NUMBER
36 ,p_PRODUCT_ID NUMBER
37 ,p_INVENTORY_ITEM_ID NUMBER
38 ,p_CALCULATED_FAILURE_RATE NUMBER
39 ,p_MANUAL_FAILURE_RATE NUMBER
40 ,p_LAST_UPDATE_DATE DATE
41 ,p_LAST_UPDATED_BY NUMBER
42 ,p_CREATION_DATE DATE
43 ,p_CREATED_BY NUMBER
44 ,p_LAST_UPDATE_LOGIN NUMBER
45 ,p_PLANNING_PARAMETERS_ID NUMBER);
46 PROCEDURE Delete_Row(
47 p_FAILURE_RATE_ID NUMBER);
48 End CSP_FAILURE_RATES_PKG;