[Home] [Help]
PACKAGE: APPS.WMS_GLOBALS
Source
1 PACKAGE WMS_GLOBALS AUTHID CURRENT_USER AS
2 /* $Header: WMSGLOBS.pls 115.11 2004/05/10 20:20:59 piwong ship $ */
3
4 /*----------------------------------------------------------------*
5 * Global constants representing all possible LPN context values
6 *----------------------------------------------------------------*/
7 -- Resides in Inventory
8 LPN_CONTEXT_INV CONSTANT NUMBER := 1;
9 -- Resides in WIP
10 LPN_CONTEXT_WIP CONSTANT NUMBER := 2;
11 -- Resides in Receiving
12 LPN_CONTEXT_RCV CONSTANT NUMBER := 3;
13 -- Issued out of Stores
14 LPN_CONTEXT_STORES CONSTANT NUMBER := 4;
15 -- Pre-generated
16 LPN_CONTEXT_PREGENERATED CONSTANT NUMBER := 5;
17 -- Resides in intransit
18 LPN_CONTEXT_INTRANSIT CONSTANT NUMBER := 6;
19 -- Resides at vendor site
20 LPN_CONTEXT_VENDOR CONSTANT NUMBER := 7;
21 -- Packing context, used as a temporary context value
22 -- when the user wants to reassociate the LPN with a
23 -- different license plate number and/or container item ID
24 LPN_CONTEXT_PACKING CONSTANT NUMBER := 8;
25 -- Loaded for shipment
26 LPN_LOADED_FOR_SHIPMENT CONSTANT NUMBER := 9;
27 -- Prepack of WIP
28 LPN_PREPACK_FOR_WIP CONSTANT NUMBER := 10;
29 -- LPN Picked
30 LPN_CONTEXT_PICKED CONSTANT NUMBER := 11;
31
32 -- WMS TASK TYPES
33 --Picking
34 g_wms_task_type_pick CONSTANT NUMBER := 1;
35
36 --Putaway
37 g_wms_task_type_putaway CONSTANT NUMBER := 2;
38
39 --Cycle Count
40 g_wms_task_type_cycle_count CONSTANT NUMBER := 3;
41
42 --Replenishment
43 g_wms_task_type_replenish CONSTANT NUMBER := 4;
44
45 --Move Order Transfer
46 g_wms_task_type_moxfer CONSTANT NUMBER := 5;
47
48 --Move Order Issue
49 g_wms_task_type_moissue CONSTANT NUMBER := 6;
50
51 --Staging Move
52 g_wms_task_type_stg_move CONSTANT NUMBER := 7;
53
54 --Inspect
55 g_wms_task_type_inspect CONSTANT NUMBER:=8;
56 --WMS_TASK_TYPES
57
58 g_lpn_controlled_sub CONSTANT NUMBER := 1;
59 g_non_lpn_controlled_sub CONSTANT NUMBER := 2;
60
61
62 -- WMS_OPERATION_TYPE
63
64 G_OP_TYPE_LOAD CONSTANT NUMBER := 1;
65 G_OP_TYPE_DROP CONSTANT NUMBER:=2;
66 G_OP_TYPE_SORT CONSTANT NUMBER:=3;
67 G_OP_TYPE_CONSOLIDATE CONSTANT NUMBER:=4;
68 G_OP_TYPE_PACK CONSTANT NUMBER:=5;
69 G_OP_TYPE_LOAD_SHIP CONSTANT NUMBER:=6;
70 G_OP_TYPE_SHIP CONSTANT NUMBER:= 7;
71 G_OP_TYPE_CYCLE_COUNT CONSTANT NUMBER := 8;
72 G_OP_TYPE_INSPECT CONSTANT NUMBER := 9;
73 G_OP_TYPE_CROSSDOCK CONSTANT NUMBER:=10;
74
75 -- WMS_OPERATION_TYPE
76
77
78 -- WMS_OP_DEST_SELECTION_MODE
79
80 G_OP_DEST_PRE_SPECIFIED CONSTANT NUMBER :=1;
81 G_OP_DEST_API CONSTANT NUMBER := 2; -- seed API
82 G_OP_DEST_CUSTOM_API CONSTANT NUMBER := 3; -- custom API
83 G_OP_DEST_SYS_SUGGESTED NUMBER :=4;
84 G_OP_DEST_RULES_ENGINE NUMBER :=5; -- not currently used, not referred in WMSOPPBB.pls
85
86 -- WMS_OP_DEST_SELECTION_MODE
87
88
89
90 -- WMS_OP_PLAN_INSTANCE_STATUS
91
92 G_OP_INS_STAT_PENDING CONSTANT NUMBER :=1;
93 G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := 2;
94 G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := 3;
95 G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := 4;
96 G_OP_INS_STAT_ABORTED CONSTANT NUMBER:=5;
97 G_OP_INS_STAT_IN_PROGRESS CONSTANT NUMBER:=6;
98 G_OP_INS_STAT_ON_HOLD CONSTANT NUMBER:=7;
99
100
101 -- WMS_DROP_LPN_OPTION
102 G_OP_DROP_LPN_NO_LPN CONSTANT NUMBER :=1;
103 G_OP_DROP_LPN_OPTIONAL CONSTANT NUMBER := 2;
104 G_OP_DROP_LPN_MANDATORY CONSTANT NUMBER :=3;
105
106 /*Patchset J Enhancements: Added more ATF specific constants*/
107 --WMS_ACTIVITY_TYPES
108 G_OP_ACTIVITY_INBOUND CONSTANT NUMBER:=1;
109 G_OP_ACTIVITY_OUTBOUND CONSTANT NUMBER:=2;
110 G_OP_ACTIVITY_WAREHOUSING CONSTANT NUMBER:=3;
111
112 --WMS_OP_INBOUND_TYPES
113 G_OP_INBOUND_STANDARD CONSTANT NUMBER:=1;
114 G_OP_INBOUND_INSPECTION CONSTANT NUMBER:=2;
115 G_OP_INBOUND_CROSS_DOCK CONSTANT NUMBER:=3;
116
117 --WMS_OP_OUTBOUND_TYPES
118 G_OP_OUTBOUND_STANDARD CONSTANT NUMBER:=1;
119
120 /*----------------------------------------------------------------*
121 * Global constants representing all possible picking methodologies
122 *----------------------------------------------------------------*/
123 -- order picking
124 PICK_METHOD_ORDER CONSTANT NUMBER := 1;
125 -- Zone picking
126 PICK_METHOD_ZONE CONSTANT NUMBER := 2;
127 -- wave picking
128 PICK_METHOD_WAVE CONSTANT NUMBER := 3;
129 -- bulk picking
130 PICK_METHOD_BULK CONSTANT NUMBER := 4;
131 -- user defined picking
132 PICK_METHOD_USER_DEFINED CONSTANT NUMBER := 99;
133 /*----------------------------------------------------------------*
134 * Global constants representing all possible bulk picking options
135 *----------------------------------------------------------------*/
136 -- Bulk entire wave
137 BULK_PICK_ENTIRE_WAVE CONSTANT NUMBER := 1;
138 -- bulk picking honors the sub/item flag
139 BULK_PICK_SUB_ITEM CONSTANT NUMBER := 2;
140 -- bulk disabled
141 BULK_PICK_DISABLED CONSTANT NUMBER := 3;
142
143 --Keep track of which ship confirm method (Direct Ship, LPN Ship, or Desktop)
144 --So far, only value will be 'DIRECT', which indicates direct ship
145 g_ship_confirm_method VARCHAR2(10) := NULL;
146
147 END wms_globals;