1 PACKAGE inv_label_pvt3 AUTHID CURRENT_USER AS
2 /* $Header: INVLAP3S.pls 120.0.12010000.1 2008/07/24 01:37:40 appldev ship $ */
3 g_pkg_name CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT3';
4 g_lpn_id NUMBER := -1;
5
6 /* Patchset J Project Label enhancements for inbound - Label printing is now called
7 * with Group_Id rather than one RTI record, there may be multiple purchase orders
8 * for a group of RTI records. So we need a new record and a table of this record type
9 */
10 TYPE rcv_label_type_rec IS RECORD(
11 lpn_id NUMBER
12 , purchase_order VARCHAR2(20)
13 , subinventory_code VARCHAR2(30)
14 , locator_id NUMBER);
15
16 TYPE rcv_lpn_table_type IS TABLE OF rcv_label_type_rec
17 INDEX BY BINARY_INTEGER;
18
19 -- Record type to hold LPN information specific to iSupplierPortal
20 TYPE rcv_isp_header_rec is RECORD
21 (
22 asn_num VARCHAR2(30),
23 shipment_date DATE,
24 expected_receipt_date DATE,
25 freight_terms VARCHAR2(25),
26 freight_carrier VARCHAR2(25),
27 num_of_containers NUMBER,
28 bill_of_lading VARCHAR2(25),
29 waybill_airbill_num VARCHAR2(20),
30 packing_slip VARCHAR2(25),
31 packaging_code VARCHAR2(5),
32 special_handling_code VARCHAR2(3),
33 locator_id NUMBER,
34 receipt_num VARCHAR2(30),
35 comments VARCHAR2(240)
36 );
37
38 -- Added p_transaction_identifier, for flow
39 -- Depending on when it is called, the driving table might be different
40 -- 1 means MMTT is the driving table
41 -- 2 means MTI is the driving table
42 -- 3 means Mtl_txn_request_lines is the driving table
43
44 PROCEDURE get_variable_data(
45 x_variable_content OUT NOCOPY LONG
46 , x_msg_count OUT NOCOPY NUMBER
47 , x_msg_data OUT NOCOPY VARCHAR2
48 , x_return_status OUT NOCOPY VARCHAR2
49 , p_label_type_info IN inv_label.label_type_rec DEFAULT NULL
50 , p_transaction_id IN NUMBER DEFAULT NULL
51 , p_input_param IN mtl_material_transactions_temp%ROWTYPE
52 DEFAULT NULL
53 , p_transaction_identifier IN NUMBER DEFAULT 0
54 );
55
56 PROCEDURE get_variable_data(
57 x_variable_content OUT NOCOPY inv_label.label_tbl_type
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 END inv_label_pvt3;