PACKAGE: APPS.INV_KANBAN_LOVS

Source

1 PACKAGE inv_KANBAN_LOVS  AS
2 /* $Header: INVKBLVS.pls 120.2 2005/09/01 02:36:46 rsagar noship $ */
3 
4 TYPE t_genref IS REF CURSOR;
5 
6 --      Name: GET_KANBAN_NUMBER
7 --
8 --      Input parameters:
9 --       p_Organization_Id   which restricts LOV SQL to current org
10 --       p_kanban_number which restricts LOV SQL to the user input text
11 --                                e.g.  10%
12 --
13 --      Output parameters:
14 --       x_Revs      returns LOV rows as reference cursor
15 --
16 --      Functions: This procedure returns LOV rows for a given org,and
17 --                 user input text
18 --
19 
20 PROCEDURE GET_KANBAN_NUMBER(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref,
21                            p_Organization_Id IN NUMBER,
22                            p_Kanban_number IN VARCHAR2);
23 
24 PROCEDURE GET_KANBAN_NUMBER_FOR_INQ(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref,
25                            p_Organization_Id IN NUMBER,
26                            p_Kanban_number IN VARCHAR2);
27 
28 PROCEDURE GET_KANBAN_TYPE(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref);
29 
30 PROCEDURE GET_SUPPLIER(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref,
31                            p_supplier_name IN VARCHAR2);
32 
33 PROCEDURE GET_SUPPLIER_SITE(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref,
34                                 p_Organization_Id IN NUMBER,
35                                 p_supplier_id IN NUMBER);
36 
37 PROCEDURE GET_WIP_LINE(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref,
38                            p_Organization_Id IN NUMBER,
39                            p_line_code IN VARCHAR2);
40 
41 END inv_KANBAN_LOVS;