APPS.CSP_STOCK_LISTS_PVT dependencies on CSP_STOCK_LISTS

Line 1: PACKAGE BODY CSP_STOCK_LISTS_PVT AS

1: PACKAGE BODY CSP_STOCK_LISTS_PVT AS
2: /* $Header: cspvstlb.pls 120.0.12020000.5 2013/03/24 12:46:33 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name :CSP_STOCK_LISTS_PVT
5: -- Purpose :

Line 4: -- Package name :CSP_STOCK_LISTS_PVT

1: PACKAGE BODY CSP_STOCK_LISTS_PVT AS
2: /* $Header: cspvstlb.pls 120.0.12020000.5 2013/03/24 12:46:33 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name :CSP_STOCK_LISTS_PVT
5: -- Purpose :
6: -- History :
7: -- 01-Mar-13, sunarasi
8: --

Line 24: FROM csp_stock_lists

20: ,p_LAST_UPDATE_LOGIN NUMBER
21: ,x_return_status out NOCOPY VARCHAR2) AS
22: CURSOR get_items IS
23: SELECT *
24: FROM csp_stock_lists
25: where INVENTORY_ITEM_ID = p_inventory_item_id
26: and ORGANIZATION_ID = p_organization_id
27: and nvl(SUBINVENTORY_CODE,'X') = nvl(p_subinventory_code,'X');
28:

Line 29: l_rec CSP_STOCK_LISTS%ROWTYPE;

25: where INVENTORY_ITEM_ID = p_inventory_item_id
26: and ORGANIZATION_ID = p_organization_id
27: and nvl(SUBINVENTORY_CODE,'X') = nvl(p_subinventory_code,'X');
28:
29: l_rec CSP_STOCK_LISTS%ROWTYPE;
30: BEGIN
31: OPEN get_items;
32: FETCH get_items INTO l_rec;
33: IF get_items%FOUND THEN

Line 34: CSP_STOCK_LISTS_PKG.update_Row(p_ORGANIZATION_ID

30: BEGIN
31: OPEN get_items;
32: FETCH get_items INTO l_rec;
33: IF get_items%FOUND THEN
34: CSP_STOCK_LISTS_PKG.update_Row(p_ORGANIZATION_ID
35: ,p_INVENTORY_ITEM_ID
36: ,p_SUBINVENTORY_CODE
37: ,p_MANUAL_AUTO
38: ,p_REASON_CODE

Line 45: CSP_STOCK_LISTS_PKG.Insert_Row( p_ORGANIZATION_ID

41: ,p_LAST_UPDATED_BY
42: ,p_LAST_UPDATE_DATE
43: ,p_LAST_UPDATE_LOGIN);
44: ELSE
45: CSP_STOCK_LISTS_PKG.Insert_Row( p_ORGANIZATION_ID
46: ,p_INVENTORY_ITEM_ID
47: ,p_SUBINVENTORY_CODE
48: ,p_MANUAL_AUTO
49: ,p_REASON_CODE

Line 210: FROM CSP_STOCK_LISTS

206: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
207: ln_count NUMBER :=0;
208: BEGIN
209: SELECT count(*) into ln_count
210: FROM CSP_STOCK_LISTS
211: WHERE INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
212: AND ORGANIZATION_ID = P_ORGANIZATION_ID
213: AND nvl(SUBINVENTORY_CODE,'X') = nvl(P_SUBINVENTORY_CODE,'X');
214: IF ln_count > 0 THEN

Line 215: CSP_STOCK_LISTS_PKG.DELETE_ROW(p_INVENTORY_ITEM_ID,p_ORGANIZATION_ID,P_SUBINVENTORY_CODE );

211: WHERE INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
212: AND ORGANIZATION_ID = P_ORGANIZATION_ID
213: AND nvl(SUBINVENTORY_CODE,'X') = nvl(P_SUBINVENTORY_CODE,'X');
214: IF ln_count > 0 THEN
215: CSP_STOCK_LISTS_PKG.DELETE_ROW(p_INVENTORY_ITEM_ID,p_ORGANIZATION_ID,P_SUBINVENTORY_CODE );
216: END IF;
217: END;
218: END CSP_STOCK_LISTS_PVT;

Line 218: END CSP_STOCK_LISTS_PVT;

214: IF ln_count > 0 THEN
215: CSP_STOCK_LISTS_PKG.DELETE_ROW(p_INVENTORY_ITEM_ID,p_ORGANIZATION_ID,P_SUBINVENTORY_CODE );
216: END IF;
217: END;
218: END CSP_STOCK_LISTS_PVT;