APPS.PRODUCT_FAMILY_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 37: DELETE FROM Bom_Inventory_Components

33: X_Err_Msg VARCHAR2(2000);
34: X_Err_Code NUMBER; -- These local variables are for the call made to the other func.
35: BEGIN
36:
37: DELETE FROM Bom_Inventory_Components
38: WHERE Component_Item_Id = X_Member_Item_Id
39: AND Bill_Sequence_Id = X_Bill_Sequence_Id; -- This will delete all the records under
40: -- that Bill_Sequence_Id.
41:

Line 66: SELECT 1 from BOM_Inventory_Components

62: X_Count NUMBER := 0;
63: CURSOR X_All_Dates IS
64: SELECT 'X' date_available FROM sys.dual
65: WHERE EXISTS (
66: SELECT 1 from BOM_Inventory_Components
67: WHERE Component_Item_Id = X_Member_Item_Id
68: AND Bill_Sequence_Id = X_Bill_Sequence_Id
69: AND (( RowId <> X_RowID ) or (X_RowId IS NULL))
70: AND ( X_Disable_Date IS NULL