APPS.INV_COPY_ITEM_CP dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 559: l_process_flag mtl_item_revisions_interface.process_flag%TYPE; --myerrams, Bug: 4892069

555: l_expense_Account mtl_parameters.expense_Account%TYPE;
556: l_sales_account mtl_parameters.sales_account%TYPE;
557: l_cost_of_sales_account mtl_parameters.cost_of_sales_account%TYPE;
558: l_encumbrance_account mtl_parameters.encumbrance_account%TYPE;
559: l_process_flag mtl_item_revisions_interface.process_flag%TYPE; --myerrams, Bug: 4892069
560:
561: -- Define a record type to contain required details from mtl_system_items_b.
562: TYPE mtl_system_items_rec IS RECORD
563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type

Line 603: Following Query is added to update mtl_item_revisions_interface table with Revision Id when ValidateItems is No.

599: AND ((base_item_id is null and p_copy_base_models = 'Y') or (base_item_id is not null and p_copy_base_models = 'N'))
600: AND eng_item_flag = p_copy_eng_items;
601:
602: /* myerrams,
603: Following Query is added to update mtl_item_revisions_interface table with Revision Id when ValidateItems is No.
604: Bug: 4892069
605: */
606: --myerrams, Bug: 5624219.
607: CURSOR c_item_rev_update_cursor(c_set_process_id_in NUMBER)

Line 612: FROM mtl_item_revisions_interface

608: IS
609: SELECT organization_id
610: , inventory_item_id
611: , revision
612: FROM mtl_item_revisions_interface
613: WHERE set_process_id = c_set_process_id_in;
614:
615: l_org_id NUMBER;
616: l_inv_item_id NUMBER;

Line 888: INSERT INTO mtl_item_revisions_interface

884:
885: -- ===========================================================
886: -- Insert into Revisions interface table
887: -- ===========================================================
888: INSERT INTO mtl_item_revisions_interface
889: ( inventory_item_id
890: , organization_id
891: , revision
892: , revision_label --myerrams, Bug: 4892069

Line 935: Following code is to update mtl_item_revisions_interface table with Revision Id, which is generated using

931: and msi.set_process_id = l_set_process_id
932: ORDER BY mir.REVISION,effectivity_date ;
933:
934: /*myerrams,
935: Following code is to update mtl_item_revisions_interface table with Revision Id, which is generated using
936: the sequence 'MTL_ITEM_REVISIONS_B_S';
937: Bug: 4892069
938: */
939: IF p_validate = 'N'

Line 958: UPDATE mtl_item_revisions_interface

954: --Get the new Revision Id from Sequence.
955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;
956:
957: --Update Inferface table with mandatroy Revision Id Attribute.
958: UPDATE mtl_item_revisions_interface
959: SET revision_id = l_revision_id
960: WHERE ORGANIZATION_ID = l_org_id
961: AND INVENTORY_ITEM_ID = l_inv_item_id
962: AND REVISION = l_revision;