[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
2043:
2044: /*----------------------------------------------------------------------------
2045: * PROCEDURE:
2046: * Description:
2047: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE
2048: * Generate transaction_interface_id if the parameter is NULL
2049: * Generate product_transaction_id if the parameter is NULL
2050: * The insert logic is based on the parameter p_att_exist.
2051: * If p_att_exist is "N" Then (attributes are not available in table)
2130: INTO l_transaction_interface_id
2131: FROM sys.dual;
2132: END IF;
2133:
2134: Insert into MTL_SERIAL_NUMBERS_INTERFACE
2135: (
2136: transaction_interface_id,
2137: Source_Code,
2138: Source_Line_Id,