The following lines contain the word 'select', 'insert', 'update' or 'delete':
* Get the next sequence number for this 'object' and insert
* into GEN_OBJECT_ID field : Object Genealogy
*/
SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL
INTO l_obj_seq_num FROM DUAL;
mdebug('Inserting row with SL NO '||l_serial_number);
INSERT INTO MTL_SERIAL_NUMBERS
(INVENTORY_ITEM_ID,
SERIAL_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
INITIALIZATION_DATE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
CURRENT_STATUS,
CURRENT_ORGANIZATION_ID,
GEN_OBJECT_ID)
VALUES
(P_Item_id, l_serial_number, sysdate,
l_user_id, sysdate, sysdate,
l_user_id, -1, 6, P_organization_id,l_obj_seq_num);
mdebug('Inserted row with SL NO '||l_serial_number);
mdebug('Inserted failure');
mdebug('Exception : Inserted failure:');
SELECT 'X'
INTO L_nothing
FROM MTL_SERIAL_NUMBERS
WHERE SERIAL_NUMBER = P_serial_number
AND CURRENT_ORGANIZATION_ID + 0 = P_org_id;
SELECT 'x'
INTO L_nothing
FROM MTL_SERIAL_NUMBERS S,
MTL_PARAMETERS P
WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
AND S.SERIAL_NUMBER = P_serial_number
AND P.SERIAL_NUMBER_TYPE = 3;
SELECT 'x'
INTO L_nothing
FROM MTL_SERIAL_NUMBERS
WHERE SERIAL_NUMBER = P_serial_number;
SELECT decode(current_status,6,1,current_status),
revision,
lot_number,
current_subinventory_code,
current_locator_id,
current_organization_id,
original_wip_entity_id
INTO L_current_status,
L_current_revision,
L_current_lot_number,
L_current_subinventory,
L_current_locator_id,
L_current_organization_id,
L_wip_entity_id
FROM MTL_SERIAL_NUMBERS
WHERE inventory_item_id = P_Item_id
AND serial_number = P_serial_number;