[Home] [Help]
PACKAGE: APPS.INV_LABEL_PVT13
Source
1 PACKAGE inv_label_pvt13 AUTHID CURRENT_USER 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;