PACKAGE: APPS.INV_STATUS_LOVS

Source

1 PACKAGE inv_STATUS_LOVS AUTHID CURRENT_USER AS
2 /* $Header: INVMSLVS.pls 120.5 2011/12/28 14:25:22 sadibhat 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 			     p_organization_id NUMBER default null); /* Material Status Enhancement - Tracking bug: 13519864*/
36 
37 /* Bug 7319616 */
38 PROCEDURE GET_SERIAL_ATT_STATUS(x_status OUT NOCOPY /* file.sql.39 change */ t_genref,
39                                 p_status_code IN VARCHAR2,
40                                 p_trx_type_id NUMBER);
41 
42 
43 END inv_STATUS_LOVS;