The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_LAST_UPDATED_BY IN NUMBER,
p_LAST_UPDATE_DATE IN DATE,
p_LAST_UPDATE_LOGIN IN NUMBER,
p_PICKLIST_LINE_ID IN NUMBER,
p_ORGANIZATION_ID IN NUMBER,
p_INVENTORY_ITEM_ID IN NUMBER,
p_QUANTITY IN NUMBER,
p_LOT_NUMBER IN VARCHAR2,
p_SERIAL_NUMBER IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
-- csp standard declarations
l_api_version_number CONSTANT NUMBER := 1.0;
select organization_id into l_check_existence
from mtl_parameters
where organization_id = p_organization_id;
SELECT picklist_line_id INTO l_check_existence
FROM csp_picklist_lines
WHERE picklist_line_id = p_picklist_line_id;
SELECT picklist_serial_lot_id INTO l_check_existence
FROM CSP_Picklist_Serial_Lots
WHERE picklist_serial_lot_id = px_picklist_serial_lot_id
AND picklist_line_id = p_picklist_line_id;
l_psl_rec.LAST_UPDATED_BY := p_LAST_UPDATED_BY;
l_psl_rec.LAST_UPDATE_DATE := p_LAST_UPDATE_DATE;
l_psl_rec.LAST_UPDATE_LOGIN := p_LAST_UPDATE_LOGIN;
IF p_LAST_UPDATE_DATE IS NULL THEN
l_psl_rec.LAST_UPDATE_DATE := sysdate;
IF p_LAST_UPDATE_DATE IS NULL THEN
l_psl_rec.LAST_UPDATE_DATE := sysdate;
csp_pick_serial_lots_PVT.Update_pick_serial_lots(
P_Api_Version_Number => l_Api_Version_Number,
P_Init_Msg_List => p_Init_Msg_List,
P_Commit => l_Commit,
p_validation_level => l_validation_level,
P_Identity_Salesforce_Id => NULL,
P_psl_Rec => l_psl_rec,
X_Return_Status => l_return_status,
X_Msg_Count => l_msg_count,
X_Msg_Data => l_msg_data);
csp_pick_serial_lots_PVT.Delete_pick_serial_lots(
P_Api_Version_Number => l_Api_Version_Number,
P_Init_Msg_List => p_Init_Msg_List,
P_Commit => l_Commit,
p_validation_level => l_validation_level,
P_Identity_Salesforce_Id => NULL,
P_psl_Rec => l_psl_rec,
X_Return_Status => l_return_status,
X_Msg_Count => l_msg_count,
X_Msg_Data => l_msg_data);