1 PACKAGE INV_LABEL_PVT2 AUTHID CURRENT_USER AS
2 /* $Header: INVLAP2S.pls 120.0 2005/05/25 05:35:09 appldev noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT2';
4
5
6 -- Added p_transaction_identifier, for flow
7 -- Depending on when it is called, the driving table might be different
8 -- 1 means MMTT is the driving table
9 -- 2 means MTI is the driving table
10 -- 3 means Mtl_txn_request_lines is the driving table
11
12
13 PROCEDURE get_variable_data(
14 x_variable_content OUT NOCOPY LONG
15 , x_msg_count OUT NOCOPY NUMBER
16 , x_msg_data OUT NOCOPY VARCHAR2
17 , x_return_status OUT NOCOPY VARCHAR2
18 , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
19 , p_transaction_id IN NUMBER DEFAULT NULL
20 , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
21 ,p_transaction_identifier IN NUMBER DEFAULT 0);
22
23 PROCEDURE get_variable_data(
24 x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
25 , x_msg_count OUT NOCOPY NUMBER
26 , x_msg_data OUT NOCOPY VARCHAR2
27 , x_return_status OUT NOCOPY VARCHAR2
28 , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
29 , p_transaction_id IN NUMBER DEFAULT NULL
30 , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
31 ,p_transaction_identifier IN NUMBER DEFAULT 0);
32
33 END INV_LABEL_PVT2;
[Home] [Help]