[Home] [Help]
5726: -- Description: Implementation of ECO doesnot refelect regenerated item description at master org, in all organization item entries.
5727: -- Synching description of all org items to the description of the master item.
5728: BEGIN
5729: FOR rec IN (SELECT inventory_item_id, description , LANGUAGE FROM mtl_system_items_tl WHERE
5730: inventory_item_id = (SELECT DISTINCT INVENTORY_ITEM_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id)
5731: AND ORGANIZATION_ID = (SELECT DISTINCT ORGANIZATION_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id))
5732: LOOP
5733: Write_Debug('Synching Item description at all organization levels for item: ' || rec.inventory_item_id );
5734: Write_Debug('New Description: ' || rec.description );
5727: -- Synching description of all org items to the description of the master item.
5728: BEGIN
5729: FOR rec IN (SELECT inventory_item_id, description , LANGUAGE FROM mtl_system_items_tl WHERE
5730: inventory_item_id = (SELECT DISTINCT INVENTORY_ITEM_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id)
5731: AND ORGANIZATION_ID = (SELECT DISTINCT ORGANIZATION_ID FROM EGO_ITEMS_ATTRS_CHANGES_B WHERE change_line_id = p_change_line_id))
5732: LOOP
5733: Write_Debug('Synching Item description at all organization levels for item: ' || rec.inventory_item_id );
5734: Write_Debug('New Description: ' || rec.description );
5735: UPDATE mtl_system_items_tl
6019: p_api_version => 1.0
6020: ,p_object_name => 'EGO_ITEM'
6021: ,p_production_b_table_name => 'EGO_MTL_SY_ITEMS_EXT_B'
6022: ,p_production_tl_table_name => 'EGO_MTL_SY_ITEMS_EXT_TL'
6023: ,p_change_b_table_name => 'EGO_ITEMS_ATTRS_CHANGES_B'
6024: ,p_change_tl_table_name => 'EGO_ITEMS_ATTRS_CHANGES_TL'
6025: ,p_tables_application_id => 431
6026: ,p_change_line_id => l_change_line_id
6027: ,p_old_data_level_nv_pairs => l_old_data_level_nv_pairs