1 PACKAGE WMS_CARTNZN_WRAP AS
2 /* $Header: WMSCRTWS.pls 120.1 2005/06/15 19:51:21 appldev $*/
3
4
5 -- File : INVCRTNS.pls
6 -- Content : WMS_CARTNZN_WRAP package specification
7 -- Description : INV wrapper to WMS cartonization API
8 -- Notes :
9 -- Modified : 09/12/2000 cjandhya created
10
11 -- MOdified : 03/13/2002 cjandhya Added Multilevel Cartonization
12
13 -- Parameters :
14 -- p_api_version Standard Input Parameter
15 -- p_init_msg_list Standard Input Parameter
16 -- p_commit Standard Input Parameter
17 -- p_validation_level Standard Input Parameter
18 -- p_out_bound 'Y' if called in outboun mode 'N' otherwise
19 -- p_org_id Organization Id
20 -- p_move_order_header_id Move Order Header Id, passed when called from
21 -- pick release
22 -- p_disable_cartonization Disables cartonization, used by component
23 -- pick release and move order transfers for
24 -- task splitting, task consolidation and task
25 -- type assignment
26 -- p_transaction_header_id transaction header Id from mtl_material
27 -- transactions temp, used by bulk pack and prepack
28 -- p_stop_level Number of levels you want to cartonize
29 -- p_PACKAGING_mode parameter used to determine the function for
30 -- which the call is made
31
32 -- Output Parameters
33 -- x_return_status Standard Output Parameter
34 -- x_msg_count Standard Output Parameter
35 -- x_msg_data Standard Output Parameter
36
37 -- Version
38 -- Currently version is 1.0
39
40
41
42 -- Package constants for different modes in which cartonization is called
43
44 PR_pKG_mode NUMBER := 1;--Pick Release Mode
45 int_bP_pkg_mode NUMBER := 2;--Bulk Pack mode, invoked from interface tables
46 mob_bP_pKG_mode NUMBER := 3;--Bulk Pack mode, invoked from mobile forms
47 prepack_pkg_mode NUMBER := 4;--Prepack mode, invoked by prepack conc prog
48 mfg_pr_pkg_mode NUMBER := 5;--Manufacturing Pick Release Mode.
49
50
51 FUNCTION get_lpns_generated_tb RETURN inv_label.transaction_id_rec_type;
52
53 PROCEDURE cartonize(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
56 p_commit IN VARCHAR2 :=fnd_api.g_false,
57 p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_out_bound IN VARCHAR2 DEFAULT 'Y',
62 p_org_id IN NUMBER,
63 p_move_order_header_id IN NUMBER DEFAULT 0,
64 p_disable_cartonization IN VARCHAR2 DEFAULT 'N',
65 p_transaction_header_id IN NUMBER DEFAULT 0,
66 p_stop_level IN NUMBER DEFAULT -1,
67 p_PACKAGING_mode IN NUMBER DEFAULT 1);
68
69 END WMS_CARTNZN_WRAP;