APPS.MTL_RELATED_ITEMS_CUST_REF_PKG dependencies on MTL_RELATED_ITEMS_CUST_REF

Line 1: PACKAGE BODY mtl_related_items_cust_ref_pkg AS

1: PACKAGE BODY mtl_related_items_cust_ref_pkg AS
2: /* $Header: INVTRICB.pls 120.0 2011/03/08 20:13:26 mshirkol noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: P_PLN_INFO_ID IN NUMBER

Line 22: FROM MTL_RELATED_ITEMS_CUST_REF

18: ,P_LAST_UPDATE_LOGIN IN NUMBER) IS
19:
20: CURSOR C_CHECK_INSERT IS
21: SELECT 'Y'
22: FROM MTL_RELATED_ITEMS_CUST_REF
23: WHERE PLN_INFO_ID = P_PLN_INFO_ID
24: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
25: AND ORGANIZATION_ID = P_ORGANIZATION_ID
26: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID

Line 35: INSERT INTO MTL_RELATED_ITEMS_CUST_REF(

31: l_exists VARCHAR2(1);
32:
33: BEGIN
34:
35: INSERT INTO MTL_RELATED_ITEMS_CUST_REF(
36: PLN_INFO_ID
37: ,INVENTORY_ITEM_ID
38: ,ORGANIZATION_ID
39: ,RELATED_ITEM_ID

Line 97: FROM MTL_RELATED_ITEMS_CUST_REF

93: ,CUSTOMER_ID
94: ,SITE_USE_ID
95: ,START_DATE
96: ,END_DATE
97: FROM MTL_RELATED_ITEMS_CUST_REF
98: WHERE PLN_INFO_ID = P_PLN_INFO_ID
99: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
100: AND ORGANIZATION_ID = P_ORGANIZATION_ID
101: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID

Line 161: UPDATE MTL_RELATED_ITEMS_CUST_REF

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_CUST_REF
162: SET
163: PLN_INFO_ID = P_PLN_INFO_ID
164: ,INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
165: ,ORGANIZATION_ID = P_ORGANIZATION_ID

Line 199: DELETE FROM MTL_RELATED_ITEMS_CUST_REF

195: ,P_CUSTOMER_ID IN NUMBER
196: ,P_SITE_USE_ID IN NUMBER) IS
197:
198: BEGIN
199: DELETE FROM MTL_RELATED_ITEMS_CUST_REF
200: WHERE PLN_INFO_ID = P_PLN_INFO_ID
201: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
202: AND ORGANIZATION_ID = P_ORGANIZATION_ID
203: AND RELATED_ITEM_ID = P_RELATED_ITEM_ID

Line 213: END MTL_RELATED_ITEMS_CUST_REF_PKG;

209: RAISE No_Data_Found;
210: END IF;
211: END DELETE_ROW;
212:
213: END MTL_RELATED_ITEMS_CUST_REF_PKG;