APPS.ENG_WORKFLOW_API_PKG dependencies on BOM_COMPONENTS_B

Line 796: Select bill_sequence_id, component_item_id from bom_components_b

792: AND eri1.status_type <> 5;
793:
794: Cursor c_comp_on_rev_item (c_rev_item_seq_id NUMBER)
795: IS
796: Select bill_sequence_id, component_item_id from bom_components_b
797: where revised_item_sequence_id = c_rev_item_seq_id;
798:
799: Cursor c_comp_on_rev_item_dup (c_rev_item_seq_id NUMBER)
800: IS

Line 801: Select bill_sequence_id, component_item_id from bom_components_b

797: where revised_item_sequence_id = c_rev_item_seq_id;
798:
799: Cursor c_comp_on_rev_item_dup (c_rev_item_seq_id NUMBER)
800: IS
801: Select bill_sequence_id, component_item_id from bom_components_b
802: where revised_item_sequence_id = c_rev_item_seq_id;
803: --changes for bug 9726856 end
804:
805: BEGIN

Line 838: Select count(*) into num_comp_rev_item from bom_components_b

834: loop
835: fetch c_rev_items into l_rev_seq_id;
836: exit when c_rev_items%NOTFOUND;
837:
838: Select count(*) into num_comp_rev_item from bom_components_b
839: where revised_item_sequence_id = l_rev_seq_id;
840:
841: open c_dup_rev_items (l_rev_seq_id, X_change_notice, X_org_id);
842: loop

Line 850: Select count(*) into num_comp_other_rev_item from bom_components_b

846: --if neither revised_item has any components then we cannot allow
847: --duplication of revised items since the quantity of revised item will
848: -- be inflated due to multiple unimplemented ecos
849:
850: Select count(*) into num_comp_other_rev_item from bom_components_b
851: where revised_item_sequence_id = other_rev_seq_id;
852:
853: --our revised item under consideration has no components
854: --and there exists at least another revised item that has no components