PACKAGE: APPS.WIP_LOT_NUMBER_DEFAULT

Source

1 PACKAGE WIP_LOT_NUMBER_DEFAULT AUTHID CURRENT_USER AS
2 /* $Header: wiplndfs.pls 115.6 2002/12/12 15:01:41 rmahidha ship $ */
3 
4 /* LOT_NUMBER
5 
6    This function returns the correct lot number for the given item and
7    organization.
8 
9    If a potential lot number is already inputed, this can be passed as a
10    parameter.  The function will return this value unless the item is not
11    under lot control, in which case it returns NULL
12 
13    The Job Name is also entered as a parameter.  This value will be returned
14    if the item is under lot control and WIP Parameters are set to Based on
15    Job Name.
16 
17    If P_Default_Flag is 1, the routine will default a lot number if necessary.
18    If P_Default_Flag is anything else, the routine will return NULL if
19    the item is not under lot control, P_Lot_Number otherwise.
20  */
21 
22    FUNCTION LOT_NUMBER(	P_Item_Id IN NUMBER,
23 			P_Organization_Id IN NUMBER,
24 			P_Lot_Number IN VARCHAR2,
25 			P_Job_Name IN VARCHAR2,
26 			P_Default_Flag IN NUMBER) return VARCHAR2;
27 
28 END WIP_LOT_NUMBER_DEFAULT;