c_allocation_no.sql

来自「Java写的ERP系统」· SQL 代码 · 共 29 行

CREATE OR REPLACE FUNCTION C_Allocation_No
(
	p_C_Client_ID	IN	NUMBER
)
RETURN NUMBER
/*************************************************************************
 * The contents of this file are subject to the Compiere License.  You may
 * obtain a copy of the License at    http://www.compiere.org/license.html
 * Software is on an  "AS IS" basis,  WITHOUT WARRANTY OF ANY KIND, either
 * express or implied. See the License for details. Code: Compiere ERP+CRM
 * Copyright (C) 1999-2002 Jorg Janke, ComPiere, Inc. All Rights Reserved.
 *************************************************************************
 * $Id: C_Allocation_No.sql,v 1.2 2002/08/13 05:27:36 jjanke Exp $
 ***
 * Title:   Return Allocation Number
 * Description:
 *      (Parameter for future expansion)
 ************************************************************************/
AS
	No			NUMBER;
BEGIN
	SELECT 	C_Allocation_Seq.NextVal 
	  INTO	No 
	FROM 	DUAL;
	--
	RETURN	No;
END C_Allocation_No;
/