1: PACKAGE INV_LABEL_PVT8 AS
2: /* $Header: INVLAP8S.pls 120.1 2005/11/16 17:24:57 qxliu noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT8';
4:
5: TYPE all_lpn_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1: PACKAGE INV_LABEL_PVT8 AS
2: /* $Header: INVLAP8S.pls 120.1 2005/11/16 17:24:57 qxliu noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_LABEL_PVT8';
4:
5: TYPE all_lpn_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6:
7: PROCEDURE get_variable_data(
8: x_variable_content OUT NOCOPY LONG
9: , x_msg_count OUT NOCOPY NUMBER
10: , x_msg_data OUT NOCOPY VARCHAR2
11: , x_return_status OUT NOCOPY VARCHAR2
12: , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
13: , p_transaction_id IN NUMBER DEFAULT NULL
14: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
15: , p_transaction_identifier IN NUMBER DEFAULT 0
16: );
15: , p_transaction_identifier IN NUMBER DEFAULT 0
16: );
17:
18: PROCEDURE get_variable_data(
19: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
20: , x_msg_count OUT NOCOPY NUMBER
21: , x_msg_data OUT NOCOPY VARCHAR2
22: , x_return_status OUT NOCOPY VARCHAR2
23: , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
19: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
20: , x_msg_count OUT NOCOPY NUMBER
21: , x_msg_data OUT NOCOPY VARCHAR2
22: , x_return_status OUT NOCOPY VARCHAR2
23: , p_label_type_info IN INV_LABEL.label_type_rec DEFAULT NULL
24: , p_transaction_id IN NUMBER DEFAULT NULL
25: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE DEFAULT NULL
26: , p_transaction_identifier IN NUMBER DEFAULT 0
27: );
28:
29: PROCEDURE set_carton_count(p_cartonization_id NUMBER) ;
30: PROCEDURE clear_carton_count;
31:
32: END INV_LABEL_PVT8;