APPS.CSP_FAILURE_RATES_PKG dependencies on CSP_FAILURE_RATES

Line 1: PACKAGE BODY CSP_FAILURE_RATES_PKG as

1: PACKAGE BODY CSP_FAILURE_RATES_PKG as
2: /* $Header: csptfrab.pls 115.3 2002/11/26 07:19:57 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_FAILURE_RATES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_FAILURE_RATES_PKG

1: PACKAGE BODY CSP_FAILURE_RATES_PKG as
2: /* $Header: csptfrab.pls 115.3 2002/11/26 07:19:57 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_FAILURE_RATES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_FAILURE_RATES_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_FAILURE_RATES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptfrab.pls';
13:
14: PROCEDURE Insert_Row(
15: px_FAILURE_RATE_ID IN OUT NOCOPY NUMBER

Line 27: CURSOR C2 IS SELECT CSP_FAILURE_RATES_S1.nextval FROM sys.dual;

23: ,p_CREATED_BY NUMBER
24: ,p_LAST_UPDATE_LOGIN NUMBER
25: ,p_PLANNING_PARAMETERS_ID NUMBER)
26: IS
27: CURSOR C2 IS SELECT CSP_FAILURE_RATES_S1.nextval FROM sys.dual;
28: BEGIN
29: If (px_FAILURE_RATE_ID IS NULL) OR (px_FAILURE_RATE_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;
31: FETCH C2 INTO px_FAILURE_RATE_ID;

Line 34: INSERT INTO CSP_FAILURE_RATES(

30: OPEN C2;
31: FETCH C2 INTO px_FAILURE_RATE_ID;
32: CLOSE C2;
33: End If;
34: INSERT INTO CSP_FAILURE_RATES(
35: FAILURE_RATE_ID
36: ,PRODUCT_ID
37: ,INVENTORY_ITEM_ID
38: ,CALCULATED_FAILURE_RATE

Line 73: Update CSP_FAILURE_RATES

69: ,p_LAST_UPDATE_LOGIN NUMBER
70: ,p_PLANNING_PARAMETERS_ID NUMBER)
71: IS
72: BEGIN
73: Update CSP_FAILURE_RATES
74: SET
75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)
76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)

Line 94: DELETE FROM CSP_FAILURE_RATES

90: PROCEDURE Delete_Row(
91: p_FAILURE_RATE_ID NUMBER)
92: IS
93: BEGIN
94: DELETE FROM CSP_FAILURE_RATES
95: WHERE FAILURE_RATE_ID = p_FAILURE_RATE_ID;
96: If (SQL%NOTFOUND) then
97: RAISE NO_DATA_FOUND;
98: End If;

Line 115: FROM CSP_FAILURE_RATES

111: ,p_PLANNING_PARAMETERS_ID NUMBER)
112: IS
113: CURSOR C IS
114: SELECT *
115: FROM CSP_FAILURE_RATES
116: WHERE FAILURE_RATE_ID = p_FAILURE_RATE_ID
117: FOR UPDATE of FAILURE_RATE_ID NOWAIT;
118: Recinfo C%ROWTYPE;
119: BEGIN

Line 167: End CSP_FAILURE_RATES_PKG;

163: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: End If;
166: END Lock_Row;
167: End CSP_FAILURE_RATES_PKG;