APPS.BOM_INV_COMPS1_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 14: (SELECT 1 FROM bom_inventory_components

10: dummy NUMBER;
11: BEGIN
12: SELECT 1 INTO dummy FROM sys.dual
13: WHERE NOT EXISTS
14: (SELECT 1 FROM bom_inventory_components
15: WHERE bill_sequence_id = X_Bill_Sequence_Id
16: AND component_item_id = X_Component_Item_Id
17: AND operation_seq_num = X_Operation_Seq_Num
18: AND (X_Disable_Date IS NULL

Line 41: (SELECT 1 FROM bom_inventory_components

37: dummy NUMBER;
38: BEGIN
39: SELECT 1 INTO dummy FROM sys.dual
40: WHERE NOT EXISTS
41: (SELECT 1 FROM bom_inventory_components
42: WHERE bill_sequence_id = X_Bill_Sequence_Id
43: AND component_item_id = X_Component_Item_Id
44: AND operation_seq_num = X_Operation_Seq_Num
45: AND (X_To_Unit_Number IS NULL

Line 218: (SELECT 1 from bom_inventory_components

214: X_bill_or_eco NUMBER) IS
215: dummy NUMBER;
216: BEGIN
217: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
218: (SELECT 1 from bom_inventory_components
219: WHERE bill_sequence_id = X_Bill_Sequence_Id
220: AND component_item_id = X_Component_Item_Id
221: AND operation_seq_num = X_Operation_Seq_Num
222: AND effectivity_date = X_Effectivity_Date

Line 247: (SELECT 1 from bom_inventory_components

243: X_bill_or_eco NUMBER) IS
244: dummy NUMBER;
245: BEGIN
246: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
247: (SELECT 1 from bom_inventory_components
248: WHERE bill_sequence_id = X_Bill_Sequence_Id
249: AND component_item_id = X_Component_Item_Id
250: AND operation_seq_num = X_Operation_Seq_Num
251: AND from_end_item_unit_number = X_From_Unit_Number

Line 336: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS

332: ,X_Vendor_Id NUMBER DEFAULT NULL
333: ,X_Unit_Price NUMBER DEFAULT NULL
334: , X_basis_type NUMBER
335: ) IS
336: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS
337: WHERE component_sequence_id = X_Component_Sequence_Id;
338: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
339:
340: l_object_revision_id NUMBER;

Line 338: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;

334: , X_basis_type NUMBER
335: ) IS
336: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS
337: WHERE component_sequence_id = X_Component_Sequence_Id;
338: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
339:
340: l_object_revision_id NUMBER;
341: l_minor_revision_id NUMBER;
342: l_comp_revision_id NUMBER;

Line 390: INSERT INTO BOM_INVENTORY_COMPONENTS(

386: , x_comp_minor_revision_id => l_comp_minor_revision_id
387: );
388:
389:
390: INSERT INTO BOM_INVENTORY_COMPONENTS(
391: operation_seq_num,
392: component_item_id,
393: last_update_date,
394: last_updated_by,