[Home] [Help]
PACKAGE: APPS.WMS_CONTAINER_GRP
Source
1 PACKAGE WMS_Container_GRP AS
2 /* $Header: WMSGCNTS.pls 120.3 2005/12/16 02:26:27 amohamme noship $ */
3
4 /* Automatic generate LPNs */
5 PROCEDURE Auto_Create_LPNs (
6 p_api_version IN NUMBER
7 , p_init_msg_list IN VARCHAR2
8 , p_commit IN VARCHAR2
9 , x_return_status OUT NOCOPY VARCHAR2
10 , x_msg_count OUT NOCOPY NUMBER
11 , x_msg_data OUT NOCOPY VARCHAR2
12 , p_caller IN VARCHAR2
13 , p_gen_lpn_rec IN WMS_Data_Type_Definitions_PUB.AutoCreateLPNRecordType
14 , p_lpn_table OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
15 );
16
17 /* Create new LPNs as given in the p_lpn_table */
18 PROCEDURE Create_LPNs (
19 p_api_version IN NUMBER
20 , p_init_msg_list IN VARCHAR2
21 , p_commit IN VARCHAR2
22 , x_return_status OUT NOCOPY VARCHAR2
23 , x_msg_count OUT NOCOPY NUMBER
24 , x_msg_data OUT NOCOPY VARCHAR2
25 , p_caller IN VARCHAR2
26 , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
27 );
28
29 /* Modify LPNs as given in the p_lpn_table
30 Columns that can be modified are
31 , organization_id
32 , license_plate_number
33 , parent_lpn_id
34 , outermost_lpn_id
35 , inventory_item_id
36 , subinventory_code
37 , locator_id
38 , tare_weight
39 , tare_weight_uom_code
40 , gross_weight_uom_code
41 , gross_weight
42 , container_volume
43 , container_volume_uom
44 , content_volume_uom_code
45 , content_volume
46 , lpn_context
47 , attribute_category
48 , attribute1
49 , attribute2
50 , attribute3
51 , attribute4
52 , attribute5
53 , attribute6
54 , attribute7
55 , attribute8
56 , attribute9
57 , attribute10
58 , attribute11
59 , attribute12
60 , attribute13
61 , attribute14
62 , attribute15
63 , source_type_id
64 , source_header_id
65 , source_line_id
66 , source_line_detail_id
67 , source_name
68 */
69 PROCEDURE Modify_LPNs (
70 p_api_version IN NUMBER
71 , p_init_msg_list IN VARCHAR2
72 , p_commit IN VARCHAR2
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , p_caller IN VARCHAR2
77 , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
78 );
79
80 G_LPN_PURGE_ACTION_VALIDATE CONSTANT VARCHAR2(50) := 'VALIDATE';
81 G_LPN_PURGE_ACTION_DELETE CONSTANT VARCHAR2(50) := 'VALIDATE_AND_DELETE';
82
83 PROCEDURE LPN_Purge_Actions (
84 p_api_version IN NUMBER
85 , p_init_msg_list IN VARCHAR2
86 , p_commit IN VARCHAR2
87 , x_return_status OUT NOCOPY VARCHAR2
88 , x_msg_count OUT NOCOPY NUMBER
89 , x_msg_data OUT NOCOPY VARCHAR2
90 , p_caller IN VARCHAR2
91 , p_action IN VARCHAR2
92 , p_lpn_purge_rec IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType
93 );
94
95 END WMS_Container_GRP;