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 226: (SELECT 1 from bom_inventory_components

222: X_bill_or_eco NUMBER) IS
223: dummy NUMBER;
224: BEGIN
225: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
226: (SELECT 1 from bom_inventory_components
227: WHERE bill_sequence_id = X_Bill_Sequence_Id
228: AND component_item_id = X_Component_Item_Id
229: AND operation_seq_num = X_Operation_Seq_Num
230: AND effectivity_date = X_Effectivity_Date

Line 255: (SELECT 1 from bom_inventory_components

251: X_bill_or_eco NUMBER) IS
252: dummy NUMBER;
253: BEGIN
254: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
255: (SELECT 1 from bom_inventory_components
256: WHERE bill_sequence_id = X_Bill_Sequence_Id
257: AND component_item_id = X_Component_Item_Id
258: AND operation_seq_num = X_Operation_Seq_Num
259: AND from_end_item_unit_number = X_From_Unit_Number

Line 344: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS

340: ,X_Vendor_Id NUMBER DEFAULT NULL
341: ,X_Unit_Price NUMBER DEFAULT NULL
342: , X_basis_type NUMBER
343: ) IS
344: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS
345: WHERE component_sequence_id = X_Component_Sequence_Id;
346: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
347:
348: l_object_revision_id NUMBER;

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

342: , X_basis_type NUMBER
343: ) IS
344: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS
345: WHERE component_sequence_id = X_Component_Sequence_Id;
346: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
347:
348: l_object_revision_id NUMBER;
349: l_minor_revision_id NUMBER;
350: l_comp_revision_id NUMBER;

Line 398: INSERT INTO BOM_INVENTORY_COMPONENTS(

394: , x_comp_minor_revision_id => l_comp_minor_revision_id
395: );
396:
397:
398: INSERT INTO BOM_INVENTORY_COMPONENTS(
399: operation_seq_num,
400: component_item_id,
401: last_update_date,
402: last_updated_by,