APPS.MTL_CUSTOMER_ITEMS_PKG dependencies on MTL_CUSTOMER_ITEMS

Line 1: PACKAGE BODY MTL_CUSTOMER_ITEMS_PKG as

1: PACKAGE BODY MTL_CUSTOMER_ITEMS_PKG as
2: /* $Header: INVICITB.pls 120.1 2005/07/01 12:23:34 appldev ship $ */
3:
4: PROCEDURE CHECK_UNIQUE (X_Rowid VARCHAR2,
5: X_Customer_Id NUMBER,

Line 17: FROM MTL_CUSTOMER_ITEMS

13: BEGIN
14:
15: SELECT COUNT(1)
16: INTO Dummy
17: FROM MTL_CUSTOMER_ITEMS
18: WHERE Customer_Id = X_Customer_Id
19: AND NVL(Customer_Category_Code,'JUNK') = NVL(X_Customer_Category_Code,'JUNK')
20: AND NVL(Address_Id,-1000) = NVL(X_Address_Id,-1000)
21: AND Customer_Item_Number = X_Customer_Item_Number

Line 35: END MTL_CUSTOMER_ITEMS_PKG;

31:
32: END CHECK_UNIQUE;
33:
34:
35: END MTL_CUSTOMER_ITEMS_PKG;