DBA Data[Home] [Help]

PACKAGE: APPS.WMS_CARTNZN_WRAP

Source


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;