PACKAGE: APPS.INV_STATUS_LOVS

Source

1 PACKAGE inv_STATUS_LOVS  AS
2 /* $Header: INVMSLVS.pls 120.2.12010000.2 2008/10/21 20:23:15 musinha ship $ */
3 
4 TYPE t_genref IS REF CURSOR;
5 
6 --      Name: GET_SUB_STATUS
7 --
8 --      Input parameters:
9 --       p_status_code  which restricts LOV SQL to the user input text
10 --                                e.g.  10%
11 --
12 --      Output parameters:
13 --       x_Revs      returns LOV rows as reference cursor
14 --
15 --      Functions: This procedure returns LOV rows for a given
16 --                 user input text
17 --
18 
19 PROCEDURE GET_SUB_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
20                            p_status_code IN VARCHAR2);
21 PROCEDURE GET_LOC_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
22                            p_status_code IN VARCHAR2);
23 PROCEDURE GET_LOT_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
24                            p_status_code IN VARCHAR2);
25 PROCEDURE GET_SERIAL_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
26                            p_status_code IN VARCHAR2);
27 -- Added for # 6633612
28 PROCEDURE GET_ONHAND_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
29                            p_status_code IN VARCHAR2);
30 
31 /* Bug 7239026 */
32 PROCEDURE GET_LOT_ATT_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
33                              p_status_code IN VARCHAR2,
34                              p_trx_type_id NUMBER);
35 
36 
37 END inv_STATUS_LOVS;