PACKAGE BODY: APPS.WMS_CARTNZN_WRAP

Source

1 PACKAGE BODY WMS_CARTNZN_WRAP AS
2 /* $Header: WMSCRTWB.pls 120.2 2005/06/15 19:47:30 appldev  $*/
3 
4 
5 -- File        : INVCRTNB.pls
6 -- Content     : WMS_CARTNZN_WRAP package body
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 FUNCTION get_lpns_generated_tb
43   RETURN inv_label.transaction_id_rec_type IS
44 BEGIN
45    RETURN wms_cartnzn_pub.lpns_generated_tb;
46 END get_lpns_generated_tb;
47 
48 
49 PROCEDURE cartonize(
50 		    p_api_version           IN    NUMBER,
51 		    p_init_msg_list         IN    VARCHAR2 :=fnd_api.g_false,
52 		    p_commit                IN    VARCHAR2 :=fnd_api.g_false,
53 		    p_validation_level      IN    NUMBER   :=fnd_api.g_valid_level_full,
54                     x_return_status	    OUT NOCOPY  VARCHAR2,
55 		    x_msg_count       	    OUT NOCOPY  NUMBER,
56 		    x_msg_data        	    OUT NOCOPY  VARCHAR2,
57 		    p_out_bound             IN    VARCHAR2 DEFAULT 'Y',
58                     p_org_id                IN    NUMBER,
59 		    p_move_order_header_id  IN    NUMBER   DEFAULT  0,
60 		    p_disable_cartonization IN    VARCHAR2 DEFAULT 'N',
61 		    p_transaction_header_id IN    NUMBER   DEFAULT  0,
62 		    p_stop_level            IN    NUMBER   DEFAULT  -1,
63 		    p_PACKAGING_mode        IN    NUMBER   DEFAULT  1)
64   IS BEGIN
65      wms_cartnzn_pub.cartonize(p_api_version            => p_api_version
66 			       ,p_init_msg_list         => p_init_msg_list
67 			       ,p_commit                => p_commit
68 			       ,p_validation_level      => p_validation_level
69 			       ,x_return_status	        => x_return_status
70 			       ,x_msg_count       	=> x_msg_count
71 			       ,x_msg_data        	=> x_msg_data
72 			       ,p_out_bound             => p_out_bound
73 			       ,p_org_id                => p_org_id
74 			       ,p_move_order_header_id  => p_move_order_header_id
75 			       ,p_disable_cartonization => p_disable_cartonization
76 			       ,p_transaction_header_id => p_transaction_header_id
77 			       ,p_stop_level            => p_stop_level
78 			       ,p_PACKAGING_mode        => p_packaging_mode);
79 
80 
81 END cartonize;
82 
83 END WMS_CARTNZN_WRAP;