PACKAGE: APPS.INV_LABEL_PVT13

Source

1 PACKAGE inv_label_pvt13 AS
2   /* $Header: INVLA13S.pls 120.1 2006/05/08 22:41:32 rahugupt noship $ */
3 
4   g_pkg_name CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT13';
5   g_lpn_id            NUMBER       := -1;
6 
7 
8 -- Record type to get batch and product information.
9 
10 TYPE batch_label_type_rec is RECORD
11 (
12  	  organization     VARCHAR2(3),
13       subinventory_code     VARCHAR2(10),
14 	  locator            VARCHAR2(204) ,
15 	  item 	  			 VARCHAR2(40) ,
16 	  batch_no 			 VARCHAR2(32),
17 	  quantity 			 NUMBER ,
18       transaction_uom 	 VARCHAR2(3),
19       secondary_quantity NUMBER,
20 	  uom2 				 VARCHAR2(3) ,
21 	  reason_name        VARCHAR2(30),
22       org_id    		 NUMBER,
23 	  item_id  			 NUMBER,
24 	  locator_id         NUMBER,
25 	  reason_id  		 NUMBER,
26       batch_id 		     NUMBER,
27       formula_no         VARCHAR2(32),
28 	  routing_no         VARCHAR2(32),
29 	  creation_date 	 VARCHAR2(100),
30 	  planned_start_date VARCHAR2(100),
31 	  actual_start_date  VARCHAR2(100),
32 	  due_date   		 VARCHAR2(100),
33 	  planned_completion_date    VARCHAR2(100),
34 	  actual_completion_date     VARCHAR2(100),
35 	  batch_close_date   VARCHAR2(100),
36 	  material_detail_id NUMBER,
37 	  planned_quantity 	 NUMBER,
38 	  item_uom           VARCHAR2(3),
39 	  actual_quantity    NUMBER	,
40 	  hazard_class       VARCHAR2(40),
41 	  lot_number         VARCHAR2(80),
42 	  parent_lot_number  VARCHAR2(80),
43 	  grade_code         VARCHAR2(150),
44 	  status             VARCHAR2(250),
45 	  lot_creation_date  VARCHAR2(100),
46 	  lot_expiration_date 	 VARCHAR2(100),
47 	  lot_quantity	  NUMBER,
48 	  lot_quantity2	  NUMBER,
49 	  batch_line			varchar2(200)
50 );
51 
52   TYPE batch_table_type IS TABLE OF batch_label_type_rec
53     INDEX BY BINARY_INTEGER;
54 
55 
56   PROCEDURE get_variable_data(
57     x_variable_content       OUT NOCOPY    LONG
58   , x_msg_count              OUT NOCOPY    NUMBER
59   , x_msg_data               OUT NOCOPY    VARCHAR2
60   , x_return_status          OUT NOCOPY    VARCHAR2
61   , p_label_type_info        IN            inv_label.label_type_rec DEFAULT NULL
62   , p_transaction_id         IN            NUMBER DEFAULT NULL
63   , p_input_param            IN            mtl_material_transactions_temp%ROWTYPE
64         DEFAULT NULL
65   , p_transaction_identifier IN            NUMBER DEFAULT 0
66   );
67 
68   PROCEDURE get_variable_data(
69     x_variable_content       OUT NOCOPY    inv_label.label_tbl_type
70   , x_msg_count              OUT NOCOPY    NUMBER
71   , x_msg_data               OUT NOCOPY    VARCHAR2
72   , x_return_status          OUT NOCOPY    VARCHAR2
73   , p_label_type_info        IN            inv_label.label_type_rec DEFAULT NULL
74   , p_transaction_id         IN            NUMBER DEFAULT NULL
75   , p_input_param            IN            mtl_material_transactions_temp%ROWTYPE
76         DEFAULT NULL
77   , p_transaction_identifier IN            NUMBER DEFAULT 0
78   );
79 END inv_label_pvt13;