DBA Data[Home] [Help]

PACKAGE: APPS.GMI_AUTOLOT

Source


1 PACKAGE gmi_autolot AUTHID CURRENT_USER AS
2 /* $Header: gmialots.pls 115.1 2003/03/18 14:56:41 jdiiorio noship $ */
3 
4 
5 PROCEDURE generate_lot_number(p_item_id                    IN   NUMBER,
6                              p_in_lot_no                   IN   VARCHAR2,
7                              p_orgn_code                   IN   VARCHAR2,
8                              p_doc_id                      IN   NUMBER,
9                              p_line_id                     IN   NUMBER,
10                              p_doc_type                    IN   VARCHAR2,
11                              p_out_lot_no                  OUT  NOCOPY VARCHAR2,
12                              p_sublot_no                   OUT  NOCOPY VARCHAR2,
13                              p_return_status               OUT  NOCOPY NUMBER);
14 
15 
16 FUNCTION check_for_autolot(p_item_id IN NUMBER)
17      RETURN NUMBER;
18 
19 END gmi_autolot;