APPS.INVICXRF dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 33: CURSOR C IS SELECT rowid FROM mtl_customer_item_xrefs

29: X_Attribute14 VARCHAR2,
30: X_Attribute15 VARCHAR2
31: ) IS
32:
33: CURSOR C IS SELECT rowid FROM mtl_customer_item_xrefs
34: WHERE customer_item_id = X_Customer_Item_Id
35: AND inventory_item_id = X_Inventory_Item_Id
36: AND master_organization_id = X_Master_Organization_Id;
37:

Line 40: INSERT INTO mtl_customer_item_xrefs(

36: AND master_organization_id = X_Master_Organization_Id;
37:
38: BEGIN
39:
40: INSERT INTO mtl_customer_item_xrefs(
41: Customer_Item_Id,
42: Inventory_Item_Id,
43: Master_Organization_Id,
44: Preference_Number,

Line 138: FROM mtl_customer_item_xrefs

134:
135: CURSOR C IS
136:
137: SELECT *
138: FROM mtl_customer_item_xrefs
139: WHERE rowid = X_Rowid
140: FOR UPDATE of Customer_Item_Id, Inventory_Item_Id,
141: Master_Organization_Id NOWAIT;
142:

Line 262: UPDATE mtl_customer_item_xrefs

258: X_Attribute15 VARCHAR2
259: ) IS
260: BEGIN
261:
262: UPDATE mtl_customer_item_xrefs
263: SET
264:
265: Customer_Item_Id = X_Customer_Item_Id,
266: Inventory_Item_Id = X_Inventory_Item_Id,

Line 314: FROM MTL_CUSTOMER_ITEM_XREFS

310: BEGIN
311:
312: SELECT COUNT(1)
313: INTO Dummy
314: FROM MTL_CUSTOMER_ITEM_XREFS
315: WHERE Customer_Item_Id = X_Customer_Item_Id
316: AND Inventory_Item_Id = X_Inventory_Item_Id
317: AND Master_Organization_Id = X_Master_Organization_Id
318: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid));

Line 341: FROM MTL_CUSTOMER_ITEM_XREFS

337: BEGIN
338:
339: SELECT COUNT(1)
340: INTO Dummy
341: FROM MTL_CUSTOMER_ITEM_XREFS
342: WHERE Customer_Item_Id = X_Customer_Item_Id
343: AND Master_Organization_Id = X_Master_Organization_Id
344: AND Preference_Number = X_Rank
345: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid));