PACKAGE: APPS.WMS_CONTAINER_GRP

Source

1 PACKAGE WMS_Container_GRP AUTHID CURRENT_USER 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;