[Home] [Help]
1: PACKAGE BODY MTL_RELATED_ITEMS_PLN_INFO_PKG AS
2: /* $Header: INVTRIPB.pls 120.0 2011/03/08 20:17:51 mshirkol noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: P_INVENTORY_ITEM_ID IN NUMBER
19: ,X_PLN_INFO_ID OUT NOCOPY NUMBER) IS
20:
21: CURSOR C_CHECK_INSERT IS
22: SELECT 'Y'
23: FROM MTL_RELATED_ITEMS_PLN_INFO
24: WHERE PLN_INFO_ID = X_PLN_INFO_ID
25: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
26: AND ORGANIZATION_ID = P_ORGANIZATION_ID
27: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID
29:
30: l_exists VARCHAR2(1);
31:
32: BEGIN
33: INSERT INTO MTL_RELATED_ITEMS_PLN_INFO(
34: PLN_INFO_ID
35: ,INVENTORY_ITEM_ID
36: ,ORGANIZATION_ID
37: ,RELATED_ITEM_ID
97: ,PARTIAL_FULFILLMENT_FLAG
98: ,START_DATE
99: ,END_DATE
100: ,ALL_CUSTOMERS_FLAG
101: FROM MTL_RELATED_ITEMS_PLN_INFO
102: WHERE PLN_INFO_ID = P_PLN_INFO_ID
103: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
104: AND ORGANIZATION_ID = P_ORGANIZATION_ID
105: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID
157: ,P_LAST_UPDATE_DATE IN DATE
158: ,P_LAST_UPDATED_BY IN NUMBER
159: ,P_LAST_UPDATE_LOGIN IN NUMBER) IS
160: BEGIN
161: UPDATE MTL_RELATED_ITEMS_PLN_INFO
162: SET
163: INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
164: ,ORGANIZATION_ID = P_ORGANIZATION_ID
165: ,RELATED_ITEM_ID = P_RELATED_ITEM_ID
190: ,P_RELATED_ITEM_ID IN NUMBER
191: ,P_RELATIONSHIP_TYPE_ID IN NUMBER) IS
192:
193: BEGIN
194: DELETE FROM MTL_RELATED_ITEMS_PLN_INFO
195: WHERE PLN_INFO_ID = P_PLN_INFO_ID
196: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
197: AND ORGANIZATION_ID = P_ORGANIZATION_ID
198: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID
202: RAISE No_Data_Found;
203: END IF;
204: END DELETE_ROW;
205:
206: END MTL_RELATED_ITEMS_PLN_INFO_PKG;