APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 304: from eng_engineering_changes

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

Line 504: FROM eng_engineering_changes

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

Line 600: cp_change_notice eng_engineering_changes.change_notice%TYPE

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