APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 302: from eng_engineering_changes

298:
299: delete from eng_attachment_changes
300: where
301: change_id IN (select change_id
302: from eng_engineering_changes
303: where change_notice = x_change_notice
304: and organization_id = x_organization_id) and --change_id is required for index
305: revised_item_sequence_id = x_revised_item_sequence_id and
306: entity_name = 'MTL_ITEM_REVISIONS' and

Line 502: FROM eng_engineering_changes

498:
499: -- Fetch the change id
500: SELECT change_id
501: INTO l_change_id
502: FROM eng_engineering_changes
503: WHERE change_notice = x_change_notice
504: AND organization_id = x_organization_id;
505:
506: -- Calling API to copy attachments to the detination entity (new revision)

Line 598: cp_change_notice eng_engineering_changes.change_notice%TYPE

594: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
595: -- Cursor to Fetch all source bill's component changes that are being updated
596: -- by reschedule
597: CURSOR c_source_components(
598: cp_change_notice eng_engineering_changes.change_notice%TYPE
599: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
600: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
601: SELECT bcb.component_sequence_id
602: FROM bom_components_b bcb