DBA Data[Home] [Help]

PACKAGE: APPS.INV_CONSIGN_UTIL

Source


1 PACKAGE INV_CONSIGN_UTIL AUTHID CURRENT_USER AS
2 /* $Header: invpcons.pls 115.0 2003/09/26 14:54:34 nesoni noship $ */
3 -- Start of comments
4 --	API name 	: Get_Asl_Id
5 --	Type		: Public
6 --	Pre-reqs	: None.
7 --	Function	: This function retrieves asl_id based on item, organization, vendor, vendorsite. Local ASL is given preference to global ASL. This ASL is not disabled and ASL status should allow action.
8 --	Parameters	:
9 --	IN		:	p_item_id           	IN NUMBER	Required
10 --			 	p_vendor_id		      IN NUMBER 	Required
11 --			 	p_vendor_site_id		IN NUMBER 	Required
12 --			 	p_using_organization_id	IN NUMBER 	Required
13 -- End of comments
14 -- RETURN Parameters:
15 --   NUMBER
16 
17 FUNCTION Get_Asl_Id (
18 		p_item_id		IN 	NUMBER,
19 		p_vendor_id		IN 	NUMBER,
20 	      p_vendor_site_id	IN	NUMBER,
21 		p_using_organization_id	IN      NUMBER
22 )
23 RETURN NUMBER;
24 
25 
26 END INV_CONSIGN_UTIL;
27