APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_REVISED_ITEMS_S

Line 23: UPDATE ENG_REVISED_ITEMS SET NEW_ITEM_DESCRIPTION = p_new_description WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;

19: , p_new_description mtl_system_items_b.description%TYPE
20: ) IS
21:
22: BEGIN
23: UPDATE ENG_REVISED_ITEMS SET NEW_ITEM_DESCRIPTION = p_new_description WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;
24: END;
25: -- Code changes for enhancement 6084027 end
26:
27: /*****************************************************************************

Line 2705: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;

2701: --
2702: -- Generate a sequence_number for the new revised item
2703: -- Copy only attributes required for creation of revised item context
2704: --
2705: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;
2706: l_revised_item_rec.eco_name := l_old_revised_item_rec.change_notice;
2707: l_rev_item_unexp_rec.organization_id := l_old_revised_item_rec.organization_id;
2708: l_rev_item_unexp_rec.revised_item_id := l_old_revised_item_rec.revised_item_id;
2709: l_revised_item_rec.disposition_type := l_old_revised_item_rec.disposition_type;