1 PACKAGE INV_LABEL_PVT1 AS
2 /* $Header: INVLAP1S.pls 120.0.12010000.1 2008/07/24 01:37:35 appldev ship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT1';
4
5 -- Bug 2355294
6 -- When rti rows are split need to get the right qty for MSCA org
7 TYPE rcv_label_print_rec IS RECORD
8 ( interface_transaction_id NUMBER,
9 lot_number VARCHAR2(100),
10 item_rev VARCHAR2(3)
11 );
12
13 TYPE rcv_label_print_rec_tb_tp IS TABLE OF rcv_label_print_rec
14 INDEX BY BINARY_INTEGER;
15
16 g_rcv_label_print_rec_tb rcv_label_print_rec_tb_tp;
17 -- End Bug 2355294
18
19 -- Added p_transaction_identifier, for flow
20 -- Depending on when it is called, the driving table might be different
21 -- 1 means MMTT is the driving table
22 -- 2 means MTI is the driving table
23 -- 3 means Mtl_txn_request_lines is the driving table
24
25 /*****************************************************************************
26 * This function is used for printing labels at receiving *
27 * This function adds all the interface transaction ID's to the PL/SQL table*
28 * which means that any interface transaction ID existing in this table is *
29 * already printed. *
30 *****************************************************************************/
31 FUNCTION check_rti_id(p_rti_id IN NUMBER,
32 p_lot_number IN VARCHAR2 DEFAULT NULL,
33 p_rev IN VARCHAR2 DEFAULT NULL)
34 RETURN VARCHAR2;
35
36 PROCEDURE get_variable_data(
37 x_variable_content OUT NOCOPY LONG
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 , x_return_status OUT NOCOPY VARCHAR2
41 , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
42 , p_transaction_id IN NUMBER DEFAULT NULL
43 , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
44 , p_transaction_identifier IN NUMBER DEFAULT 0
45 );
46
47 PROCEDURE get_variable_data(
48 x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
49 , x_msg_count OUT NOCOPY NUMBER
50 , x_msg_data OUT NOCOPY VARCHAR2
51 , x_return_status OUT NOCOPY VARCHAR2
52 , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
53 , p_transaction_id IN NUMBER DEFAULT NULL
54 , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
55 ,p_transaction_identifier IN NUMBER DEFAULT 0
56 );
57
58 FUNCTION get_uom_code(
59 p_organization_id IN NUMBER
60 , p_inventory_item_id IN NUMBER
61 , p_unit_of_measure IN VARCHAR2) RETURN VARCHAR2;
62
63 FUNCTION get_uom2_code(
64 p_organization_id IN NUMBER
65 , p_inventory_item_id IN NUMBER) RETURN VARCHAR2;
66
67 FUNCTION get_origination_type(p_origination_type IN NUMBER) RETURN VARCHAR2;
68
69 END INV_LABEL_PVT1;