API Procedure to inactive Items in oracle apps
--API to update the item status. /**** STEP 1) Insert data into pending interface table ****/ insert into mtl_pending_item_status (inventory_item_id, organization_id, status_code, effective_date, implemented_date, pending_flag, last_update_date, last_updated_by, creation_date, created_by) values( 6760202, -- Item Segment 114, -- Organization Id 'Inactive', -- status sysdate, sysdate, 'Y', sysdate, 14654, sysdate, 14654); /**** STEP 2) Call below API code to do the actual change ****/ declare x_return_status VARCHAR2(100); x_msg_count NUMBER; x_msg_data VARCHAR2(1000); begin inv_item_status_pub.Update_Pending_Status ( p_api_version => 1.0 ,p_Org_Id => 114 -- Organi
Comments
Post a Comment