APPS.CSP_STOCK_LISTS_PKG dependencies on CSP_STOCK_LISTS

Line 1: PACKAGE BODY CSP_STOCK_LISTS_PKG as

1: PACKAGE BODY CSP_STOCK_LISTS_PKG as
2: /* $Header: csptpslb.pls 115.3 2002/11/26 06:43:07 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_STOCK_LISTS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_STOCK_LISTS_PKG

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

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

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_STOCK_LISTS_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpslb.pls';
12: PROCEDURE Insert_Row(
13: p_ORGANIZATION_ID NUMBER
14: ,p_INVENTORY_ITEM_ID NUMBER

Line 26: INSERT INTO CSP_STOCK_LISTS(

22: ,p_LAST_UPDATE_LOGIN NUMBER
23: )
24: IS
25: BEGIN
26: INSERT INTO CSP_STOCK_LISTS(
27: ORGANIZATION_ID
28: ,INVENTORY_ITEM_ID
29: ,SUBINVENTORY_CODE
30: ,MANUAL_AUTO

Line 64: Update CSP_STOCK_LISTS

60: ,p_LAST_UPDATE_LOGIN NUMBER
61: )
62: IS
63: BEGIN
64: Update CSP_STOCK_LISTS
65: SET
66: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
67: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
68: ,SUBINVENTORY_CODE = decode( p_SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, p_SUBINVENTORY_CODE)

Line 91: DELETE FROM CSP_STOCK_LISTS

87: ,p_ORGANIZATION_ID NUMBER
88: ,p_SUBINVENTORY_CODE VARCHAR2)
89: IS
90: BEGIN
91: DELETE FROM CSP_STOCK_LISTS
92: WHERE INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
93: AND ORGANIZATION_ID = P_ORGANIZATION_ID
94: AND NVL(SUBINVENTORY_CODE,'X') = NVL(P_SUBINVENTORY_CODE,'X');
95:

Line 115: FROM CSP_STOCK_LISTS

111: )
112: IS
113: CURSOR C IS
114: SELECT *
115: FROM CSP_STOCK_LISTS
116: WHERE INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
117: FOR UPDATE of INVENTORY_ITEM_ID NOWAIT;
118: Recinfo C%ROWTYPE;
119: BEGIN

Line 164: End CSP_STOCK_LISTS_PKG;

160: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: End If;
163: END Lock_Row;
164: End CSP_STOCK_LISTS_PKG;