APPS.CSP_NOTIFICATION_DETAILS_PKG dependencies on CSP_NOTIFICATION_DETAILS

Line 1: PACKAGE BODY CSP_NOTIFICATION_DETAILS_PKG AS

1: PACKAGE BODY CSP_NOTIFICATION_DETAILS_PKG AS
2: /* $Header: csptpndb.pls 115.4 2004/03/12 23:57:09 phegde noship $ */
3: -- Start of Comments
4: -- Package name : CSP_NOTIFICATION_DETAILS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_NOTIFICATION_DETAILS_PKG

1: PACKAGE BODY CSP_NOTIFICATION_DETAILS_PKG AS
2: /* $Header: csptpndb.pls 115.4 2004/03/12 23:57:09 phegde noship $ */
3: -- Start of Comments
4: -- Package name : CSP_NOTIFICATION_DETAILS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_NOTIFICATION_DETAILS_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_NOTIFICATION_DETAILS_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptndtb.pls';
12:
13: PROCEDURE Insert_Row(
14: px_NOTIFICATION_DETAIL_ID IN OUT NOCOPY NUMBER

Line 47: CURSOR C2 IS SELECT CSP_NOTIFICATION_DETAILS_S1.nextval FROM sys.dual;

43: ,p_REPAIR_SUPPLIER_ID NUMBER
44: ,p_ORDER_NUMBER NUMBER
45: )
46: IS
47: CURSOR C2 IS SELECT CSP_NOTIFICATION_DETAILS_S1.nextval FROM sys.dual;
48: BEGIN
49: If (px_NOTIFICATION_DETAIL_ID IS NULL) OR (px_NOTIFICATION_DETAIL_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_NOTIFICATION_DETAIL_ID;

Line 54: INSERT INTO CSP_NOTIFICATION_DETAILS(

50: OPEN C2;
51: FETCH C2 INTO px_NOTIFICATION_DETAIL_ID;
52: CLOSE C2;
53: End If;
54: INSERT INTO CSP_NOTIFICATION_DETAILS(
55: NOTIFICATION_DETAIL_ID
56: ,NOTIFICATION_ID
57: ,INVENTORY_ITEM_ID
58: ,AVAILABLE_QUANTITY

Line 156: Update CSP_NOTIFICATION_DETAILS

152: ,p_ORDER_NUMBER NUMBER
153: )
154: IS
155: BEGIN
156: Update CSP_NOTIFICATION_DETAILS
157: SET
158: NOTIFICATION_ID = decode( p_NOTIFICATION_ID, FND_API.G_MISS_NUM, NOTIFICATION_ID, p_NOTIFICATION_ID)
159: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
160: ,AVAILABLE_QUANTITY = decode( p_AVAILABLE_QUANTITY, FND_API.G_MISS_NUM, AVAILABLE_QUANTITY, p_AVAILABLE_QUANTITY)

Line 199: DELETE FROM CSP_NOTIFICATION_DETAILS

195: PROCEDURE Delete_Row(
196: p_NOTIFICATION_DETAIL_ID NUMBER)
197: IS
198: BEGIN
199: DELETE FROM CSP_NOTIFICATION_DETAILS
200: WHERE NOTIFICATION_DETAIL_ID = p_NOTIFICATION_DETAIL_ID;
201: If (SQL%NOTFOUND) then
202: RAISE NO_DATA_FOUND;
203: End If;

Line 242: FROM CSP_NOTIFICATION_DETAILS

238: )
239: IS
240: CURSOR C IS
241: SELECT *
242: FROM CSP_NOTIFICATION_DETAILS
243: WHERE NOTIFICATION_DETAIL_ID = p_NOTIFICATION_DETAIL_ID
244: FOR UPDATE of NOTIFICATION_DETAIL_ID NOWAIT;
245: Recinfo C%ROWTYPE;
246: BEGIN

Line 355: End CSP_NOTIFICATION_DETAILS_PKG;

351: APP_EXCEPTION.RAISE_EXCEPTION;
352: End If;
353: END Lock_Row;
354:
355: End CSP_NOTIFICATION_DETAILS_PKG;