eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.WSH_SHIPPING_PARAMS_GRP

Source


1 PACKAGE WSH_SHIPPING_PARAMS_GRP AUTHID CURRENT_USER as
2 /* $Header: WSHSPGPS.pls 120.0.12010000.5 2009/06/12 10:56:15 mvudugul ship $ */
3 --
4 -- Package type declarations
5 --
6 
7 TYPE Shipping_Params_Rec IS RECORD (
8 
9 SHIP_CONFIRM_RULE_ID          WSH_SHIPPING_PARAMETERS.SHIP_CONFIRM_RULE_ID%TYPE,
10 AUTOPACK_LEVEL                WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
11 TASK_PLANNING_FLAG            WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
12 EXPORT_SCREENING_FLAG         WSH_SHIPPING_PARAMETERS.EXPORT_SCREENING_FLAG%TYPE,
13 APPENDING_LIMIT               WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
14 IGNORE_INBOUND_TRIP           WSH_SHIPPING_PARAMETERS.IGNORE_INBOUND_TRIP%TYPE,
15 PACK_SLIP_REQUIRED_FLAG       WSH_SHIPPING_PARAMETERS.PACK_SLIP_REQUIRED_FLAG%TYPE,
16 PICK_SEQUENCE_RULE_ID         WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
17 PICK_GROUPING_RULE_ID         WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
18 PRINT_PICK_SLIP_MODE          WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
19 PICK_RELEASE_REPORT_SET_ID    WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
20 AUTOCREATE_DEL_ORDERS_FLAG    WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_FLAG%TYPE,
21 DEFAULT_STAGE_SUBINVENTORY    WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
22 DEFAULT_STAGE_LOCATOR_ID      WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
23 AUTODETAIL_PR_FLAG            WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
24 ENFORCE_PACKING_FLAG          WSH_SHIPPING_PARAMETERS.ENFORCE_PACKING_FLAG%TYPE,
25 GROUP_BY_CUSTOMER_FLAG        WSH_SHIPPING_PARAMETERS.GROUP_BY_CUSTOMER_FLAG%TYPE,
26 GROUP_BY_FOB_FLAG             WSH_SHIPPING_PARAMETERS.GROUP_BY_FOB_FLAG%TYPE,
27 GROUP_BY_FREIGHT_TERMS_FLAG   WSH_SHIPPING_PARAMETERS.GROUP_BY_FREIGHT_TERMS_FLAG%TYPE,
28 GROUP_BY_INTMED_SHIP_TO_FLAG  WSH_SHIPPING_PARAMETERS.GROUP_BY_INTMED_SHIP_TO_FLAG%TYPE,
29 GROUP_BY_SHIP_METHOD_FLAG     WSH_SHIPPING_PARAMETERS.GROUP_BY_SHIP_METHOD_FLAG%TYPE,
30 GROUP_BY_CARRIER_FLAG         WSH_SHIPPING_PARAMETERS.GROUP_BY_CARRIER_FLAG%TYPE,
31 ATTRIBUTE_CATEGORY            WSH_SHIPPING_PARAMETERS.ATTRIBUTE_CATEGORY%TYPE,
32 ATTRIBUTE1                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE1%TYPE,
33 ATTRIBUTE2                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE2%TYPE,
34 ATTRIBUTE3                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE3%TYPE,
35 ATTRIBUTE4                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE4%TYPE,
36 ATTRIBUTE5                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE5%TYPE,
37 ATTRIBUTE6                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE6%TYPE,
38 ATTRIBUTE7                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE7%TYPE,
39 ATTRIBUTE8                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE8%TYPE,
40 ATTRIBUTE9                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE9%TYPE,
41 ATTRIBUTE10                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE10%TYPE,
42 ATTRIBUTE11                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE11%TYPE,
43 ATTRIBUTE12                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE12%TYPE,
44 ATTRIBUTE13                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE13%TYPE,
45 ATTRIBUTE14                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE14%TYPE,
46 ATTRIBUTE15                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE15%TYPE,
47 CREATION_DATE                 WSH_SHIPPING_PARAMETERS.CREATION_DATE%TYPE,
48 CREATED_BY                    WSH_SHIPPING_PARAMETERS.CREATED_BY%TYPE,
49 LAST_UPDATE_DATE              WSH_SHIPPING_PARAMETERS.LAST_UPDATE_DATE%TYPE,
50 LAST_UPDATED_BY               WSH_SHIPPING_PARAMETERS.LAST_UPDATED_BY%TYPE,
51 LAST_UPDATE_LOGIN             WSH_SHIPPING_PARAMETERS.LAST_UPDATE_LOGIN%TYPE,
52 PROGRAM_APPLICATION_ID        WSH_SHIPPING_PARAMETERS.PROGRAM_APPLICATION_ID%TYPE,
53 PROGRAM_ID                    WSH_SHIPPING_PARAMETERS.PROGRAM_ID%TYPE,
54 PROGRAM_UPDATE_DATE           WSH_SHIPPING_PARAMETERS.PROGRAM_UPDATE_DATE%TYPE,
55 REQUEST_ID                    WSH_SHIPPING_PARAMETERS.REQUEST_ID%TYPE,
56 PICK_SLIP_LINES               WSH_SHIPPING_PARAMETERS.PICK_SLIP_LINES%TYPE,
57 AUTOCREATE_DELIVERIES_FLAG    WSH_SHIPPING_PARAMETERS.AUTOCREATE_DELIVERIES_FLAG%TYPE,
58 FREIGHT_CLASS_CAT_SET_ID      WSH_SHIPPING_PARAMETERS.FREIGHT_CLASS_CAT_SET_ID%TYPE,
59 COMMODITY_CODE_CAT_SET_ID     WSH_SHIPPING_PARAMETERS.COMMODITY_CODE_CAT_SET_ID%TYPE,
60 ENFORCE_SHIP_SET_AND_SMC      WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
61 AUTO_SEND_DOC_FLAG            WSH_SHIPPING_PARAMETERS.AUTO_SEND_DOC_FLAG%TYPE,
62 ITM_ADDITIONAL_COUNTRY_CODE   WSH_SHIPPING_PARAMETERS.ITM_ADDITIONAL_COUNTRY_CODE%TYPE,
63 AUTO_SELECT_CARRIER           WSH_SHIPPING_PARAMETERS.AUTO_SELECT_CARRIER%TYPE,
64 GOODS_DISPATCHED_ACCOUNT      WSH_SHIPPING_PARAMETERS.GOODS_DISPATCHED_ACCOUNT%TYPE,
65 LOCATION_ID                   WSH_SHIPPING_PARAMETERS.LOCATION_ID%TYPE,
66 ORGANIZATION_ID               WSH_SHIPPING_PARAMETERS.ORGANIZATION_ID%TYPE,
67 WEIGHT_UOM_CLASS              WSH_SHIPPING_PARAMETERS.WEIGHT_UOM_CLASS%TYPE,
68 VOLUME_UOM_CLASS              WSH_SHIPPING_PARAMETERS.VOLUME_UOM_CLASS%TYPE,
69 WEIGHT_VOLUME_FLAG            WSH_SHIPPING_PARAMETERS.WEIGHT_VOLUME_FLAG%TYPE,
70 INV_CONTROLS_CONTAINER_FLAG   WSH_SHIPPING_PARAMETERS.INV_CONTROLS_CONTAINER_FLAG%TYPE,
71 PERCENT_FILL_BASIS_FLAG       WSH_SHIPPING_PARAMETERS.PERCENT_FILL_BASIS_FLAG%TYPE,
72 TRIP_REPORT_SET_ID            WSH_SHIPPING_PARAMETERS.TRIP_REPORT_SET_ID%TYPE,
73 DELIVERY_REPORT_SET_ID        WSH_SHIPPING_PARAMETERS.DELIVERY_REPORT_SET_ID%TYPE,
74 AUTOCREATE_DEL_ORDERS_PR_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
75 FPA_POSITIVE_TOL_AMT          WSH_SHIPPING_PARAMETERS.FPA_POSITIVE_TOL_AMT%TYPE,
76 FPA_NEGATIVE_TOL_AMT          WSH_SHIPPING_PARAMETERS.FPA_NEGATIVE_TOL_AMT%TYPE,
77 FPA_POSITIVE_TOL_PERCENTAGE   WSH_SHIPPING_PARAMETERS.FPA_POSITIVE_TOL_PERCENTAGE%TYPE,
78 FPA_NEGATIVE_TOL_PERCENTAGE   WSH_SHIPPING_PARAMETERS.FPA_NEGATIVE_TOL_PERCENTAGE%TYPE,
79 FPA_DEFAULT_FREIGHT_ACCOUNT   WSH_SHIPPING_PARAMETERS.FPA_DEFAULT_FREIGHT_ACCOUNT%TYPE,
80 AUTO_APPLY_ROUTING_RULES      WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
81 AUTO_CALC_FGT_RATE_CR_DEL     WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
82 AUTO_CALC_FGT_RATE_APPEND_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_APPEND_DEL%TYPE,
83 AUTO_CALC_FGT_RATE_SC_DEL     WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_SC_DEL%TYPE,
84 RAISE_BUSINESS_EVENTS         WSH_SHIPPING_PARAMETERS.RAISE_BUSINESS_EVENTS%TYPE,
85 ENABLE_TRACKING_WFS           WSH_SHIPPING_PARAMETERS.ENABLE_TRACKING_WFS%TYPE,
86 ENABLE_SC_WF                  WSH_SHIPPING_PARAMETERS.ENABLE_SC_WF%TYPE,
87 PROCESS_FLAG                  VARCHAR2(1),
88 -- HW OPMCONV - Added CHECK_ON_HAND
89 CHECK_ON_HAND                 VARCHAR2(1),
90 -- Bugfix 7194517 added below 3 columns
91 MAX_NET_WEIGHT		          WSH_SHIPPING_PARAMETERS.MAX_NET_WEIGHT%TYPE,
92 MAX_GROSS_WEIGHT	          WSH_SHIPPING_PARAMETERS.MAX_GROSS_WEIGHT%TYPE,
93 OTM_ENABLED                   WSH_SHIPPING_PARAMETERS.OTM_ENABLED%TYPE,
94 --Bug 7131800
95 RETAIN_NONSTAGED_DET_FLAG     WSH_SHIPPING_PARAMETERS.RETAIN_NONSTAGED_DET_FLAG%TYPE,
96 --Bug 7131800
97 -- Bug 8446283 (Added wt/vol UOM codes on shipping parameters forms)
98 WEIGHT_UOM_CODE               WSH_SHIPPING_PARAMETERS.WEIGHT_UOM_CODE%TYPE,
99 VOLUME_UOM_CODE               WSH_SHIPPING_PARAMETERS.VOLUME_UOM_CODE%TYPE
100 -- Bug 8446283 : end
101 );
102 
103 TYPE Global_Params_Rec IS RECORD (
104 AUTO_RATE_TP_REL_TRIPS        WSH_GLOBAL_PARAMETERS.AUTO_RATE_TP_REL_TRIPS%TYPE,
105 TL_PRIN_COST_ALLOC_BASIS      WSH_GLOBAL_PARAMETERS.TL_PRIN_COST_ALLOC_BASIS%TYPE,
106 TL_DISTANCE_ALLOC_BASIS       WSH_GLOBAL_PARAMETERS.TL_DISTANCE_ALLOC_BASIS%TYPE,
107 TL_STOP_COST_ALLOC_BASIS      WSH_GLOBAL_PARAMETERS.TL_STOP_COST_ALLOC_BASIS%TYPE,
108 AUTOFIRM_LOAD_TENDERED_TRIPS  WSH_GLOBAL_PARAMETERS.AUTOFIRM_LOAD_TENDERED_TRIPS%TYPE,
109 CONSOLIDATE_BO_LINES          WSH_GLOBAL_PARAMETERS.CONSOLIDATE_BO_LINES%TYPE,
110 GU_WEIGHT_CLASS               WSH_GLOBAL_PARAMETERS.GU_WEIGHT_CLASS%TYPE,
111 GU_WEIGHT_UOM                 WSH_GLOBAL_PARAMETERS.GU_WEIGHT_UOM%TYPE,
112 GU_VOLUME_UOM                 WSH_GLOBAL_PARAMETERS.GU_VOLUME_UOM%TYPE,
113 GU_VOLUME_CLASS               WSH_GLOBAL_PARAMETERS.GU_VOLUME_CLASS%TYPE,
114 GU_DISTANCE_CLASS             WSH_GLOBAL_PARAMETERS.GU_DISTANCE_CLASS%TYPE,
115 GU_DISTANCE_UOM               WSH_GLOBAL_PARAMETERS.GU_DISTANCE_UOM%TYPE,
116 GU_DIMENSION_CLASS            WSH_GLOBAL_PARAMETERS.GU_DIMENSION_CLASS%TYPE,
117 GU_DIMENSION_UOM              WSH_GLOBAL_PARAMETERS.GU_DIMENSION_UOM%TYPE,
118 GU_CURRENCY_COUNTRY           WSH_GLOBAL_PARAMETERS.GU_CURRENCY_COUNTRY%TYPE,
119 GU_CURRENCY_UOM               WSH_GLOBAL_PARAMETERS.GU_CURRENCY_UOM%TYPE,
120 GU_TIME_CLASS                 WSH_GLOBAL_PARAMETERS.GU_TIME_CLASS%TYPE,
121 GU_TIME_UOM                   WSH_GLOBAL_PARAMETERS.GU_TIME_UOM%TYPE,
122 DEF_MILE_CALC_ON_CUST_FAC     WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_CUST_FAC%TYPE,
123 DEF_MILE_CALC_ON_SUPP_FAC     WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_SUPP_FAC%TYPE,
124 DEF_MILE_CALC_ON_ORG_FAC      WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_ORG_FAC%TYPE,
125 DEF_MILE_CALC_ON_CARR_FAC     WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_CARR_FAC%TYPE,
126 TL_HWAY_DIS_EMP_CONSTANT      WSH_GLOBAL_PARAMETERS.TL_HWAY_DIS_EMP_CONSTANT%TYPE,
127 AVG_HWAY_SPEED                WSH_GLOBAL_PARAMETERS.AVG_HWAY_SPEED%TYPE,
128 DISTANCE_UOM                  WSH_GLOBAL_PARAMETERS.DISTANCE_UOM%TYPE,
129 TIME_UOM                      WSH_GLOBAL_PARAMETERS.TIME_UOM%TYPE,
130 UOM_FOR_NUM_OF_UNITS	      WSH_GLOBAL_PARAMETERS.UOM_FOR_NUM_OF_UNITS%TYPE,
131 PALLET_ITEM_TYPE              WSH_GLOBAL_PARAMETERS.PALLET_ITEM_TYPE%TYPE,
132 ATTRIBUTE_CATEGORY            WSH_GLOBAL_PARAMETERS.ATTRIBUTE_CATEGORY%TYPE,
133 ATTRIBUTE1                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE1%TYPE,
134 ATTRIBUTE2                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE2%TYPE,
135 ATTRIBUTE3                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE3%TYPE,
136 ATTRIBUTE4                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE4%TYPE,
137 ATTRIBUTE5                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE5%TYPE,
138 ATTRIBUTE6                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE6%TYPE,
139 ATTRIBUTE7                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE7%TYPE,
140 ATTRIBUTE8                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE8%TYPE,
141 ATTRIBUTE9                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE9%TYPE,
142 ATTRIBUTE10                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE10%TYPE,
143 ATTRIBUTE11                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE11%TYPE,
144 ATTRIBUTE12                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE12%TYPE,
145 ATTRIBUTE13                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE13%TYPE,
146 ATTRIBUTE14                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE14%TYPE,
147 ATTRIBUTE15                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE15%TYPE,
148 CREATION_DATE                 WSH_GLOBAL_PARAMETERS.CREATION_DATE%TYPE,
149 CREATED_BY                    WSH_GLOBAL_PARAMETERS.CREATED_BY%TYPE,
150 LAST_UPDATE_DATE              WSH_GLOBAL_PARAMETERS.LAST_UPDATE_DATE%TYPE,
151 LAST_UPDATED_BY               WSH_GLOBAL_PARAMETERS.LAST_UPDATED_BY%TYPE,
152 LAST_UPDATE_LOGIN             WSH_GLOBAL_PARAMETERS.LAST_UPDATE_LOGIN%TYPE,
153 DEFER_INTERFACE               WSH_GLOBAL_PARAMETERS.DEFER_INTERFACE%TYPE,
154 ENFORCE_SHIP_METHOD           WSH_GLOBAL_PARAMETERS.ENFORCE_SHIP_METHOD%TYPE,
155 ALLOW_FUTURE_SHIP_DATE        WSH_GLOBAL_PARAMETERS.ALLOW_FUTURE_SHIP_DATE%TYPE,
156 RATE_IB_DELS_FGT_TERM         WSH_GLOBAL_PARAMETERS.RATE_IB_DELS_FGT_TERM%TYPE,
157 SKIP_RATE_OB_DELS_FGT_TERM    WSH_GLOBAL_PARAMETERS.SKIP_RATE_OB_DELS_FGT_TERM%TYPE,
158 DEL_DATE_CALC_METHOD	      WSH_GLOBAL_PARAMETERS.DEL_DATE_CALC_METHOD%TYPE,
159 RATE_DS_DELS_FGT_TERM_ID      WSH_GLOBAL_PARAMETERS.RATE_DS_DELS_FGT_TERM_ID%TYPE,
160 RAISE_BUSINESS_EVENTS         WSH_GLOBAL_PARAMETERS.RAISE_BUSINESS_EVENTS%TYPE,
161 ENABLE_TRACKING_WFS           WSH_GLOBAL_PARAMETERS.ENABLE_TRACKING_WFS%TYPE,
162 ENABLE_SC_WF                  WSH_GLOBAL_PARAMETERS.ENABLE_SC_WF%TYPE,
163 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
164 DEFER_PLAN_SHIPMENT_INTERFACE     WSH_GLOBAL_PARAMETERS.DEFER_PLAN_SHIPMENT_INTERFACE%TYPE
165 );
166 
167 --
168 -- Procedure:		Get_Shipping_Parameters
169 -- Parameters:		p_organization_id - Organization's parameters
170 --			x_param_info - Record of all parameter info
171 --			x_return_status - return status of the API
172 
173 PROCEDURE Get_Shipping_Parameters
174 	(p_organization_id	IN	NUMBER,
175 	 x_param_info		 OUT	NOCOPY Shipping_Params_Rec,
176 	 x_return_status	OUT NOCOPY 	VARCHAR2);
177 
178 --
179 -- Procedure:		Get_Global_Parameters
180 -- Parameters:		x_global_param_info - Record of all parameter info
181 --			x_return_status - return status of the API
182 
183 PROCEDURE Get_Global_Parameters
184 	  (x_global_param_info  OUT  NOCOPY  Global_Params_Rec,
185 	   x_return_status	    OUT NOCOPY   VARCHAR2);
186 
187 
188 END WSH_SHIPPING_PARAMS_GRP;