APPS.B_INV_COMP_INT_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 62: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPS_INTERFACE

58: -- This table has no primary key
59:
60: l_Basis_Type NUMBER; -- 5214239
61:
62: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPS_INTERFACE
63: WHERE component_sequence_id = X_Component_Sequence_Id;
64:
65: BEGIN
66:

Line 72: INSERT INTO BOM_INVENTORY_COMPS_INTERFACE(

68: l_Basis_Type := FND_API.G_MISS_NUM;
69: ELSE l_Basis_Type := X_Basis_Type;
70: END IF;
71:
72: INSERT INTO BOM_INVENTORY_COMPS_INTERFACE(
73: operation_seq_num,
74: component_item_id,
75: last_update_date,
76: last_updated_by,

Line 283: FROM bom_inventory_comps_interface

279: Supply_Subinventory,
280: Supply_Locator_Id,
281: Revised_Item_Sequence_Id,
282: Cost_Factor
283: FROM bom_inventory_comps_interface
284: WHERE rowid = X_Rowid
285: FOR UPDATE OF Acd_Type NOWAIT;
286: Recinfo C%ROWTYPE;
287:

Line 506: UPDATE BOM_INVENTORY_COMPS_INTERFACE

502: l_Basis_Type := FND_API.G_MISS_NUM;
503: ELSE l_Basis_Type := X_Basis_Type;
504: END IF;
505:
506: UPDATE BOM_INVENTORY_COMPS_INTERFACE
507: SET
508: operation_seq_num = X_Operation_Seq_Num,
509: component_item_id = X_Component_Item_Id,
510: last_update_date = X_Last_Update_Date,

Line 566: DELETE FROM BOM_INVENTORY_COMPS_INTERFACE

562: END Update_Row;
563:
564: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
565: BEGIN
566: DELETE FROM BOM_INVENTORY_COMPS_INTERFACE
567: WHERE rowid = X_Rowid;
568:
569: if (SQL%NOTFOUND) then
570: Raise NO_DATA_FOUND;