DBA Data[Home] [Help]

APPS.CSP_STOCK_LISTS_PVT dependencies on CSP_STOCK_LISTS_PKG

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 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;