[Home] [Help]
292: AND organization_id = p_org_id;
293:
294: Cursor c_serial_exists(p_serial_number Varchar2,p_item_id number) Is
295: Select 'Y'
296: FROM mtl_serial_numbers
297: WHERE serial_number = p_serial_number
298: AND inventory_item_id = p_item_id;
299:
300: Cursor c_Subinventory(p_inv_loc_assignment_id number) Is
1929:
1930: /*----------------------------------------------------------------------------
1931: * PROCEDURE:
1932: * Description:
1933: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE
1934: * Generate transaction_interface_id if the parameter is NULL
1935: * Generate product_transaction_id if the parameter is NULL
1936: * The insert logic is based on the parameter p_att_exist.
1937: * If p_att_exist is "N" Then (attributes are not available in table)
2016: INTO l_transaction_interface_id
2017: FROM sys.dual;
2018: END IF;
2019:
2020: Insert into MTL_SERIAL_NUMBERS_INTERFACE
2021: (
2022: transaction_interface_id,
2023: Source_Code,
2024: Source_Line_Id,