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_PVT

Source


1 PACKAGE WSH_SHIPPING_PARAMS_PVT AUTHID CURRENT_USER as
2 /* $Header: WSHSPRMS.pls 120.4.12010000.6 2009/12/03 10:54:14 mvudugul ship $ */
3 
4 --
5 -- Package type declarations
6 --
7 TYPE Parameter_Rec_Typ IS RECORD(
8 SHIP_CONFIRM_RULE_ID          WSH_SHIPPING_PARAMETERS.SHIP_CONFIRM_RULE_ID%TYPE,
9 AUTOPACK_LEVEL                WSH_SHIPPING_PARAMETERS.AUTOPACK_LEVEL%TYPE,
10 TASK_PLANNING_FLAG            WSH_SHIPPING_PARAMETERS.TASK_PLANNING_FLAG%TYPE,
11 EXPORT_SCREENING_FLAG         WSH_SHIPPING_PARAMETERS.EXPORT_SCREENING_FLAG%TYPE,
12 APPENDING_LIMIT               WSH_SHIPPING_PARAMETERS.APPENDING_LIMIT%TYPE,
13 IGNORE_INBOUND_TRIP           WSH_SHIPPING_PARAMETERS.IGNORE_INBOUND_TRIP%TYPE,
14 PACK_SLIP_REQUIRED_FLAG       WSH_SHIPPING_PARAMETERS.PACK_SLIP_REQUIRED_FLAG%TYPE,
15 PICK_SEQUENCE_RULE_ID         WSH_SHIPPING_PARAMETERS.PICK_SEQUENCE_RULE_ID%TYPE,
16 PICK_GROUPING_RULE_ID         WSH_SHIPPING_PARAMETERS.PICK_GROUPING_RULE_ID%TYPE,
17 PRINT_PICK_SLIP_MODE          WSH_SHIPPING_PARAMETERS.PRINT_PICK_SLIP_MODE%TYPE,
18 PICK_RELEASE_REPORT_SET_ID    WSH_SHIPPING_PARAMETERS.PICK_RELEASE_REPORT_SET_ID%TYPE,
19 AUTOCREATE_DEL_ORDERS_FLAG    WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_FLAG%TYPE,
20 DEFAULT_STAGE_SUBINVENTORY    WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_SUBINVENTORY%TYPE,
21 DEFAULT_STAGE_LOCATOR_ID      WSH_SHIPPING_PARAMETERS.DEFAULT_STAGE_LOCATOR_ID%TYPE,
22 AUTODETAIL_PR_FLAG            WSH_SHIPPING_PARAMETERS.AUTODETAIL_PR_FLAG%TYPE,
23 ENFORCE_PACKING_FLAG          WSH_SHIPPING_PARAMETERS.ENFORCE_PACKING_FLAG%TYPE,
24 GROUP_BY_CUSTOMER_FLAG        WSH_SHIPPING_PARAMETERS.GROUP_BY_CUSTOMER_FLAG%TYPE,
25 GROUP_BY_FOB_FLAG             WSH_SHIPPING_PARAMETERS.GROUP_BY_FOB_FLAG%TYPE,
26 GROUP_BY_FREIGHT_TERMS_FLAG   WSH_SHIPPING_PARAMETERS.GROUP_BY_FREIGHT_TERMS_FLAG%TYPE,
27 GROUP_BY_INTMED_SHIP_TO_FLAG  WSH_SHIPPING_PARAMETERS.GROUP_BY_INTMED_SHIP_TO_FLAG%TYPE,
28 GROUP_BY_SHIP_METHOD_FLAG     WSH_SHIPPING_PARAMETERS.GROUP_BY_SHIP_METHOD_FLAG%TYPE,
29 GROUP_BY_CARRIER_FLAG         WSH_SHIPPING_PARAMETERS.GROUP_BY_CARRIER_FLAG%TYPE,
30 ATTRIBUTE_CATEGORY            WSH_SHIPPING_PARAMETERS.ATTRIBUTE_CATEGORY%TYPE,
31 ATTRIBUTE1                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE1%TYPE,
32 ATTRIBUTE2                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE2%TYPE,
33 ATTRIBUTE3                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE3%TYPE,
34 ATTRIBUTE4                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE4%TYPE,
35 ATTRIBUTE5                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE5%TYPE,
36 ATTRIBUTE6                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE6%TYPE,
37 ATTRIBUTE7                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE7%TYPE,
38 ATTRIBUTE8                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE8%TYPE,
39 ATTRIBUTE9                    WSH_SHIPPING_PARAMETERS.ATTRIBUTE9%TYPE,
40 ATTRIBUTE10                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE10%TYPE,
41 ATTRIBUTE11                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE11%TYPE,
42 ATTRIBUTE12                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE12%TYPE,
43 ATTRIBUTE13                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE13%TYPE,
44 ATTRIBUTE14                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE14%TYPE,
45 ATTRIBUTE15                   WSH_SHIPPING_PARAMETERS.ATTRIBUTE15%TYPE,
46 CREATION_DATE                 WSH_SHIPPING_PARAMETERS.CREATION_DATE%TYPE,
50 LAST_UPDATE_LOGIN             WSH_SHIPPING_PARAMETERS.LAST_UPDATE_LOGIN%TYPE,
47 CREATED_BY                    WSH_SHIPPING_PARAMETERS.CREATED_BY%TYPE,
48 LAST_UPDATE_DATE              WSH_SHIPPING_PARAMETERS.LAST_UPDATE_DATE%TYPE,
49 LAST_UPDATED_BY               WSH_SHIPPING_PARAMETERS.LAST_UPDATED_BY%TYPE,
51 PROGRAM_APPLICATION_ID        WSH_SHIPPING_PARAMETERS.PROGRAM_APPLICATION_ID%TYPE,
52 PROGRAM_ID                    WSH_SHIPPING_PARAMETERS.PROGRAM_ID%TYPE,
53 PROGRAM_UPDATE_DATE           WSH_SHIPPING_PARAMETERS.PROGRAM_UPDATE_DATE%TYPE,
54 REQUEST_ID                    WSH_SHIPPING_PARAMETERS.REQUEST_ID%TYPE,
55 PICK_SLIP_LINES               WSH_SHIPPING_PARAMETERS.PICK_SLIP_LINES%TYPE,
56 AUTOCREATE_DELIVERIES_FLAG    WSH_SHIPPING_PARAMETERS.AUTOCREATE_DELIVERIES_FLAG%TYPE,
57 FREIGHT_CLASS_CAT_SET_ID      WSH_SHIPPING_PARAMETERS.FREIGHT_CLASS_CAT_SET_ID%TYPE,
58 COMMODITY_CODE_CAT_SET_ID     WSH_SHIPPING_PARAMETERS.COMMODITY_CODE_CAT_SET_ID%TYPE,
59 ENFORCE_SHIP_SET_AND_SMC      WSH_SHIPPING_PARAMETERS.ENFORCE_SHIP_SET_AND_SMC%TYPE,
60 AUTO_SEND_DOC_FLAG            WSH_SHIPPING_PARAMETERS.AUTO_SEND_DOC_FLAG%TYPE,
61 ITM_ADDITIONAL_COUNTRY_CODE   WSH_SHIPPING_PARAMETERS.ITM_ADDITIONAL_COUNTRY_CODE%TYPE,
62 AUTO_SELECT_CARRIER           WSH_SHIPPING_PARAMETERS.AUTO_SELECT_CARRIER%TYPE,
63 GOODS_DISPATCHED_ACCOUNT      WSH_SHIPPING_PARAMETERS.GOODS_DISPATCHED_ACCOUNT%TYPE,
64 LOCATION_ID                   WSH_SHIPPING_PARAMETERS.LOCATION_ID%TYPE,
65 ORGANIZATION_ID               WSH_SHIPPING_PARAMETERS.ORGANIZATION_ID%TYPE,
66 WEIGHT_UOM_CLASS              WSH_SHIPPING_PARAMETERS.WEIGHT_UOM_CLASS%TYPE,
67 VOLUME_UOM_CLASS              WSH_SHIPPING_PARAMETERS.VOLUME_UOM_CLASS%TYPE,
68 WEIGHT_VOLUME_FLAG            WSH_SHIPPING_PARAMETERS.WEIGHT_VOLUME_FLAG%TYPE,
69 INV_CONTROLS_CONTAINER_FLAG   WSH_SHIPPING_PARAMETERS.INV_CONTROLS_CONTAINER_FLAG%TYPE,
70 PERCENT_FILL_BASIS_FLAG       WSH_SHIPPING_PARAMETERS.PERCENT_FILL_BASIS_FLAG%TYPE,
71 TRIP_REPORT_SET_ID            WSH_SHIPPING_PARAMETERS.TRIP_REPORT_SET_ID%TYPE,
72 DELIVERY_REPORT_SET_ID        WSH_SHIPPING_PARAMETERS.DELIVERY_REPORT_SET_ID%TYPE,
73 AUTOCREATE_DEL_ORDERS_PR_FLAG WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE,
74 FPA_POSITIVE_TOL_AMT          WSH_SHIPPING_PARAMETERS.FPA_POSITIVE_TOL_AMT%TYPE,
75 FPA_NEGATIVE_TOL_AMT          WSH_SHIPPING_PARAMETERS.FPA_NEGATIVE_TOL_AMT%TYPE,
76 FPA_POSITIVE_TOL_PERCENTAGE   WSH_SHIPPING_PARAMETERS.FPA_POSITIVE_TOL_PERCENTAGE%TYPE,
77 FPA_NEGATIVE_TOL_PERCENTAGE   WSH_SHIPPING_PARAMETERS.FPA_NEGATIVE_TOL_PERCENTAGE%TYPE,
78 FPA_DEFAULT_FREIGHT_ACCOUNT   WSH_SHIPPING_PARAMETERS.FPA_DEFAULT_FREIGHT_ACCOUNT%TYPE,
79 AUTO_APPLY_ROUTING_RULES      WSH_SHIPPING_PARAMETERS.AUTO_APPLY_ROUTING_RULES%TYPE,
80 AUTO_CALC_FGT_RATE_CR_DEL     WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_CR_DEL%TYPE,
81 AUTO_CALC_FGT_RATE_APPEND_DEL WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_APPEND_DEL%TYPE,
82 AUTO_CALC_FGT_RATE_SC_DEL     WSH_SHIPPING_PARAMETERS.AUTO_CALC_FGT_RATE_SC_DEL%TYPE,
83 RAISE_BUSINESS_EVENTS         WSH_SHIPPING_PARAMETERS.RAISE_BUSINESS_EVENTS%TYPE,
84 ENABLE_TRACKING_WFS           WSH_SHIPPING_PARAMETERS.ENABLE_TRACKING_WFS%TYPE,
85 ENABLE_SC_WF                  WSH_SHIPPING_PARAMETERS.ENABLE_SC_WF%TYPE,
86 PROCESS_FLAG                  VARCHAR2(1),
87 -- HW OPMCONV - Added CHECK_ON_HAND
88 CHECK_ON_HAND                 VARCHAR2(1),
89 --OTM R12
90 MAX_NET_WEIGHT	              WSH_SHIPPING_PARAMETERS.MAX_NET_WEIGHT%TYPE,
91 MAX_GROSS_WEIGHT	      WSH_SHIPPING_PARAMETERS.MAX_GROSS_WEIGHT%TYPE,
92 OTM_ENABLED                   WSH_SHIPPING_PARAMETERS.OTM_ENABLED%TYPE,  --OTM R12 Org-Specific
93 DYNAMIC_REPLENISHMENT_FLAG    WSH_SHIPPING_PARAMETERS.DYNAMIC_REPLENISHMENT_FLAG%TYPE, --bug# 6689448 (replenishment project)
94 DOCK_APPT_SCHEDULING_FLAG     WSH_SHIPPING_PARAMETERS.DOCK_APPT_SCHEDULING_FLAG%TYPE, --bug 6700792 (OTM Dock Door Sched Proj)
95 --Bug 7131800
96 RETAIN_NONSTAGED_DET_FLAG     WSH_SHIPPING_PARAMETERS.RETAIN_NONSTAGED_DET_FLAG%TYPE,
97 --Bug 7131800
98 -- Bug 8446283 (Added wt/vol UOM codes on shipping parameters forms)
99 WEIGHT_UOM_CODE               WSH_SHIPPING_PARAMETERS.WEIGHT_UOM_CODE%TYPE,
100 VOLUME_UOM_CODE               WSH_SHIPPING_PARAMETERS.VOLUME_UOM_CODE%TYPE
101 -- Bug 8446283 : end
102 );
103 
104 TYPE Global_Parameters_Rec_Typ IS RECORD(
105 AUTO_RATE_TP_REL_TRIPS        WSH_GLOBAL_PARAMETERS.AUTO_RATE_TP_REL_TRIPS%TYPE,
106 TL_PRIN_COST_ALLOC_BASIS      WSH_GLOBAL_PARAMETERS.TL_PRIN_COST_ALLOC_BASIS%TYPE,
107 TL_DISTANCE_ALLOC_BASIS       WSH_GLOBAL_PARAMETERS.TL_DISTANCE_ALLOC_BASIS%TYPE,
108 TL_STOP_COST_ALLOC_BASIS      WSH_GLOBAL_PARAMETERS.TL_STOP_COST_ALLOC_BASIS%TYPE,
109 AUTOFIRM_LOAD_TENDERED_TRIPS  WSH_GLOBAL_PARAMETERS.AUTOFIRM_LOAD_TENDERED_TRIPS%TYPE,
110 CONSOLIDATE_BO_LINES          WSH_GLOBAL_PARAMETERS.CONSOLIDATE_BO_LINES%TYPE,
111 GU_WEIGHT_CLASS               WSH_GLOBAL_PARAMETERS.GU_WEIGHT_CLASS%TYPE,
112 GU_WEIGHT_UOM                 WSH_GLOBAL_PARAMETERS.GU_WEIGHT_UOM%TYPE,
113 GU_VOLUME_UOM                 WSH_GLOBAL_PARAMETERS.GU_VOLUME_UOM%TYPE,
114 GU_VOLUME_CLASS               WSH_GLOBAL_PARAMETERS.GU_VOLUME_CLASS%TYPE,
115 GU_DISTANCE_CLASS             WSH_GLOBAL_PARAMETERS.GU_DISTANCE_CLASS%TYPE,
116 GU_DISTANCE_UOM               WSH_GLOBAL_PARAMETERS.GU_DISTANCE_UOM%TYPE,
117 GU_DIMENSION_CLASS            WSH_GLOBAL_PARAMETERS.GU_DIMENSION_CLASS%TYPE,
118 GU_DIMENSION_UOM              WSH_GLOBAL_PARAMETERS.GU_DIMENSION_UOM%TYPE,
119 GU_CURRENCY_COUNTRY           WSH_GLOBAL_PARAMETERS.GU_CURRENCY_COUNTRY%TYPE,
120 GU_CURRENCY_UOM               WSH_GLOBAL_PARAMETERS.GU_CURRENCY_UOM%TYPE,
121 GU_TIME_CLASS                 WSH_GLOBAL_PARAMETERS.GU_TIME_CLASS%TYPE,
122 GU_TIME_UOM                   WSH_GLOBAL_PARAMETERS.GU_TIME_UOM%TYPE,
123 DEF_MILE_CALC_ON_CUST_FAC     WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_CUST_FAC%TYPE,
124 DEF_MILE_CALC_ON_SUPP_FAC     WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_SUPP_FAC%TYPE,
125 DEF_MILE_CALC_ON_ORG_FAC      WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_ORG_FAC%TYPE,
126 DEF_MILE_CALC_ON_CARR_FAC     WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_CARR_FAC%TYPE,
127 TL_HWAY_DIS_EMP_CONSTANT      WSH_GLOBAL_PARAMETERS.TL_HWAY_DIS_EMP_CONSTANT%TYPE,
128 AVG_HWAY_SPEED                WSH_GLOBAL_PARAMETERS.AVG_HWAY_SPEED%TYPE,
129 DISTANCE_UOM                  WSH_GLOBAL_PARAMETERS.DISTANCE_UOM%TYPE,
130 TIME_UOM                      WSH_GLOBAL_PARAMETERS.TIME_UOM%TYPE,
131 UOM_FOR_NUM_OF_UNITS	      WSH_GLOBAL_PARAMETERS.UOM_FOR_NUM_OF_UNITS%TYPE,
132 PALLET_ITEM_TYPE              WSH_GLOBAL_PARAMETERS.PALLET_ITEM_TYPE%TYPE,
133 ATTRIBUTE_CATEGORY            WSH_GLOBAL_PARAMETERS.ATTRIBUTE_CATEGORY%TYPE,
134 ATTRIBUTE1                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE1%TYPE,
135 ATTRIBUTE2                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE2%TYPE,
136 ATTRIBUTE3                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE3%TYPE,
137 ATTRIBUTE4                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE4%TYPE,
138 ATTRIBUTE5                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE5%TYPE,
139 ATTRIBUTE6                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE6%TYPE,
140 ATTRIBUTE7                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE7%TYPE,
141 ATTRIBUTE8                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE8%TYPE,
142 ATTRIBUTE9                    WSH_GLOBAL_PARAMETERS.ATTRIBUTE9%TYPE,
143 ATTRIBUTE10                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE10%TYPE,
144 ATTRIBUTE11                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE11%TYPE,
145 ATTRIBUTE12                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE12%TYPE,
146 ATTRIBUTE13                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE13%TYPE,
147 ATTRIBUTE14                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE14%TYPE,
148 ATTRIBUTE15                   WSH_GLOBAL_PARAMETERS.ATTRIBUTE15%TYPE,
149 CREATION_DATE                 WSH_GLOBAL_PARAMETERS.CREATION_DATE%TYPE,
150 CREATED_BY                    WSH_GLOBAL_PARAMETERS.CREATED_BY%TYPE,
151 LAST_UPDATE_DATE              WSH_GLOBAL_PARAMETERS.LAST_UPDATE_DATE%TYPE,
152 LAST_UPDATED_BY               WSH_GLOBAL_PARAMETERS.LAST_UPDATED_BY%TYPE,
153 LAST_UPDATE_LOGIN             WSH_GLOBAL_PARAMETERS.LAST_UPDATE_LOGIN%TYPE,
154 DEFER_INTERFACE               WSH_GLOBAL_PARAMETERS.DEFER_INTERFACE%TYPE,
155 ENFORCE_SHIP_METHOD           WSH_GLOBAL_PARAMETERS.ENFORCE_SHIP_METHOD%TYPE,
156 ALLOW_FUTURE_SHIP_DATE        WSH_GLOBAL_PARAMETERS.ALLOW_FUTURE_SHIP_DATE%TYPE,
157 RATE_IB_DELS_FGT_TERM         WSH_GLOBAL_PARAMETERS.RATE_IB_DELS_FGT_TERM%TYPE,
158 SKIP_RATE_OB_DELS_FGT_TERM    WSH_GLOBAL_PARAMETERS.SKIP_RATE_OB_DELS_FGT_TERM%TYPE,
159 DEL_DATE_CALC_METHOD	      WSH_GLOBAL_PARAMETERS.DEL_DATE_CALC_METHOD%TYPE,
160 RATE_DS_DELS_FGT_TERM_ID      WSH_GLOBAL_PARAMETERS.RATE_DS_DELS_FGT_TERM_ID%TYPE,
161 RAISE_BUSINESS_EVENTS         WSH_GLOBAL_PARAMETERS.RAISE_BUSINESS_EVENTS%TYPE,
162 ENABLE_TRACKING_WFS           WSH_GLOBAL_PARAMETERS.ENABLE_TRACKING_WFS%TYPE,
163 ENABLE_SC_WF                  WSH_GLOBAL_PARAMETERS.ENABLE_SC_WF%TYPE,
164 EXPAND_CARRIER_RANKINGS       WSH_GLOBAL_PARAMETERS.EXPAND_CARRIER_RANKINGS%TYPE,
165 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
166 DEFER_PLAN_SHIPMENT_INTERFACE     WSH_GLOBAL_PARAMETERS.DEFER_PLAN_SHIPMENT_INTERFACE%TYPE
167 );
168 
169 -- The following record structure added as part of shipping parameter form
170 -- changes for 11.5.12
171 TYPE parameter_value_rec_Typ IS RECORD(
172 ORGANIZATION_ID              WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
173 CLASS_CODE                   WSH_UTIL_CORE.COLUMN_TAB_TYPE,
174 PARAM_NAME                   WSH_UTIL_CORE.COLUMN_TAB_TYPE,
175 PARAM_DATA_TYPE              WSH_UTIL_CORE.COLUMN_TAB_TYPE,
176 PARAM_VALUE_NUM              WSH_UTIL_CORE.ID_TAB_TYPE,
177 PARAM_VALUE_CHR              WSH_UTIL_CORE.TBL_VARCHAR,
178 PARAM_VALUE_DATE             WSH_UTIL_CORE.DATE_TAB_TYPE);
179 
180 type row_id_tbl is table of varchar2(50) index by binary_integer;
181 
182 /* Procedure to get the Template Names */
183 Procedure get_layout_template (
184   p_concprg_name  IN VARCHAR2,
185   p_code_field    IN VARCHAR2,
186   x_name_field    OUT NOCOPY VARCHAR2,
187   x_return_status OUT NOCOPY VARCHAR );
188 
189 /* Procedure to create records in wsh_shipping parameter and
190  * wsh_shipping_parameter_values table */
191 Procedure create_parameter (
192   p_ship_par_rec     IN parameter_rec_typ,
193   p_ship_par_val_rec IN parameter_value_rec_typ,
194   x_return_status    OUT NOCOPY VARCHAR2);
195 
196 /* Procedure to update records in wsh_shipping parameter and
197  * wsh_shipping_parameter_values table */
198 Procedure update_parameter (
199   p_ship_par_rec     IN parameter_rec_typ,
200   p_ship_par_val_rec IN parameter_value_rec_typ,
201   x_return_status    OUT NOCOPY VARCHAR2);
202 
203 /* Procedure to lock records in wsh_shipping parameter table */
204 Procedure lock_record(
205    p_organization_id  IN NUMBER,
206    p_last_update_date IN DATE,
207    x_return_status    OUT NOCOPY VARCHAR2);
208 
209 /* Procedure to create freight term records in
210  * wsh_shipping_parameter_values table */
211 Procedure create_freight_terms(
212   p_freight_terms_rec IN parameter_value_rec_typ,
213   x_return_status     OUT NOCOPY VARCHAR2);
214 
215 /* Procedure to update freight term records in
216  * wsh_shipping_parameter_values table */
217 Procedure update_freight_terms(
218   p_freight_terms_rec IN parameter_value_rec_typ,
219   row_id              IN row_id_tbl,
220   x_return_status     OUT NOCOPY VARCHAR2);
221 
222 /* Procedure to delete freight term records from
223  * wsh_shipping_parameter_values table */
224 Procedure delete_freight_terms(
225   p_freight_terms_rec IN parameter_value_rec_typ,
226   row_id              IN row_id_tbl,
227   x_return_status     OUT NOCOPY VARCHAR2);
228 
229 /* Procedure to get all records from wsh_shipping_parameter_values
230  * table for a given oraganization_id. If organization_id and parameter_name
231  * are passed, only the values corresponding to specified parameter_name
232  * for that organization_id is returned */
233 Procedure Get(
234    x_param_value_info IN OUT NOCOPY  parameter_value_rec_typ,
235    x_return_status    OUT NOCOPY  VARCHAR2);
236 
237 /* Procedure to get values from wsh_shipping_parameters
238  * and all records from wsh_shipping_parameter_values
239  * table for a given oraganization_id*/
240 Procedure get(
241    p_organization_id  IN  NUMBER,
242    x_param_info       OUT NOCOPY  parameter_rec_typ,
243    x_param_value_info OUT NOCOPY  parameter_value_rec_typ,
244    x_return_status    OUT NOCOPY  VARCHAR2);
245 
246 
247 /*======================================================================================+
248  API name        : Get
249  Type            : Private.
250  IN Parameters   : Organization_id
251                    P_client_id : Client Id.
252  OUT Parameters  : Shipping Parameter Record for individual Organization and client_id passed.
253                    In addition it also tells if the organization is a process organization.
254  Description     : This procedure caches the shipping Parameters in the Record Type
255                    Collection for Reference.
256 +=======================================================================================*/
257 
258   PROCEDURE Get
259   (p_organization_id IN  NUMBER,
260    p_client_id       IN NUMBER DEFAULT NULL, -- LSP PROJECT.
261    x_param_info      OUT NOCOPY  Parameter_Rec_Typ,
262    x_return_status   OUT NOCOPY  VARCHAR2);
263 
264 /*======================================================================================+
265  API name        : Get_Global_Parameters
266  Type            : Private.
267  IN Parameters   : None.
268  OUT Parameters  : record for global parameters.
269  Description     : This procedure caches the global Parameters in the Record Type
270                    Collection for Reference.
271 +=======================================================================================*/
272 
273 Procedure Get_Global_Parameters(
274 x_param_info OUT NOCOPY Global_Parameters_Rec_Typ,
275 x_return_status OUT NOCOPY VARCHAR2);
276 
277 END WSH_SHIPPING_PARAMS_PVT;