[Home] [Help]
PACKAGE: APPS.WSH_SHIPPING_PARAMS_PVT
Source
1 PACKAGE WSH_SHIPPING_PARAMS_PVT as
2 /* $Header: WSHSPRMS.pls 120.4.12010000.3 2008/10/23 14:15:32 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,
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,
50 LAST_UPDATE_LOGIN WSH_SHIPPING_PARAMETERS.LAST_UPDATE_LOGIN%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 );
99
100 TYPE Global_Parameters_Rec_Typ IS RECORD(
101 AUTO_RATE_TP_REL_TRIPS WSH_GLOBAL_PARAMETERS.AUTO_RATE_TP_REL_TRIPS%TYPE,
102 TL_PRIN_COST_ALLOC_BASIS WSH_GLOBAL_PARAMETERS.TL_PRIN_COST_ALLOC_BASIS%TYPE,
103 TL_DISTANCE_ALLOC_BASIS WSH_GLOBAL_PARAMETERS.TL_DISTANCE_ALLOC_BASIS%TYPE,
104 TL_STOP_COST_ALLOC_BASIS WSH_GLOBAL_PARAMETERS.TL_STOP_COST_ALLOC_BASIS%TYPE,
105 AUTOFIRM_LOAD_TENDERED_TRIPS WSH_GLOBAL_PARAMETERS.AUTOFIRM_LOAD_TENDERED_TRIPS%TYPE,
106 CONSOLIDATE_BO_LINES WSH_GLOBAL_PARAMETERS.CONSOLIDATE_BO_LINES%TYPE,
107 GU_WEIGHT_CLASS WSH_GLOBAL_PARAMETERS.GU_WEIGHT_CLASS%TYPE,
108 GU_WEIGHT_UOM WSH_GLOBAL_PARAMETERS.GU_WEIGHT_UOM%TYPE,
109 GU_VOLUME_UOM WSH_GLOBAL_PARAMETERS.GU_VOLUME_UOM%TYPE,
110 GU_VOLUME_CLASS WSH_GLOBAL_PARAMETERS.GU_VOLUME_CLASS%TYPE,
111 GU_DISTANCE_CLASS WSH_GLOBAL_PARAMETERS.GU_DISTANCE_CLASS%TYPE,
112 GU_DISTANCE_UOM WSH_GLOBAL_PARAMETERS.GU_DISTANCE_UOM%TYPE,
113 GU_DIMENSION_CLASS WSH_GLOBAL_PARAMETERS.GU_DIMENSION_CLASS%TYPE,
114 GU_DIMENSION_UOM WSH_GLOBAL_PARAMETERS.GU_DIMENSION_UOM%TYPE,
115 GU_CURRENCY_COUNTRY WSH_GLOBAL_PARAMETERS.GU_CURRENCY_COUNTRY%TYPE,
116 GU_CURRENCY_UOM WSH_GLOBAL_PARAMETERS.GU_CURRENCY_UOM%TYPE,
117 GU_TIME_CLASS WSH_GLOBAL_PARAMETERS.GU_TIME_CLASS%TYPE,
118 GU_TIME_UOM WSH_GLOBAL_PARAMETERS.GU_TIME_UOM%TYPE,
119 DEF_MILE_CALC_ON_CUST_FAC WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_CUST_FAC%TYPE,
120 DEF_MILE_CALC_ON_SUPP_FAC WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_SUPP_FAC%TYPE,
121 DEF_MILE_CALC_ON_ORG_FAC WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_ORG_FAC%TYPE,
122 DEF_MILE_CALC_ON_CARR_FAC WSH_GLOBAL_PARAMETERS.DEF_MILE_CALC_ON_CARR_FAC%TYPE,
123 TL_HWAY_DIS_EMP_CONSTANT WSH_GLOBAL_PARAMETERS.TL_HWAY_DIS_EMP_CONSTANT%TYPE,
124 AVG_HWAY_SPEED WSH_GLOBAL_PARAMETERS.AVG_HWAY_SPEED%TYPE,
125 DISTANCE_UOM WSH_GLOBAL_PARAMETERS.DISTANCE_UOM%TYPE,
126 TIME_UOM WSH_GLOBAL_PARAMETERS.TIME_UOM%TYPE,
127 UOM_FOR_NUM_OF_UNITS WSH_GLOBAL_PARAMETERS.UOM_FOR_NUM_OF_UNITS%TYPE,
128 PALLET_ITEM_TYPE WSH_GLOBAL_PARAMETERS.PALLET_ITEM_TYPE%TYPE,
129 ATTRIBUTE_CATEGORY WSH_GLOBAL_PARAMETERS.ATTRIBUTE_CATEGORY%TYPE,
130 ATTRIBUTE1 WSH_GLOBAL_PARAMETERS.ATTRIBUTE1%TYPE,
131 ATTRIBUTE2 WSH_GLOBAL_PARAMETERS.ATTRIBUTE2%TYPE,
132 ATTRIBUTE3 WSH_GLOBAL_PARAMETERS.ATTRIBUTE3%TYPE,
133 ATTRIBUTE4 WSH_GLOBAL_PARAMETERS.ATTRIBUTE4%TYPE,
134 ATTRIBUTE5 WSH_GLOBAL_PARAMETERS.ATTRIBUTE5%TYPE,
135 ATTRIBUTE6 WSH_GLOBAL_PARAMETERS.ATTRIBUTE6%TYPE,
136 ATTRIBUTE7 WSH_GLOBAL_PARAMETERS.ATTRIBUTE7%TYPE,
137 ATTRIBUTE8 WSH_GLOBAL_PARAMETERS.ATTRIBUTE8%TYPE,
138 ATTRIBUTE9 WSH_GLOBAL_PARAMETERS.ATTRIBUTE9%TYPE,
139 ATTRIBUTE10 WSH_GLOBAL_PARAMETERS.ATTRIBUTE10%TYPE,
140 ATTRIBUTE11 WSH_GLOBAL_PARAMETERS.ATTRIBUTE11%TYPE,
141 ATTRIBUTE12 WSH_GLOBAL_PARAMETERS.ATTRIBUTE12%TYPE,
142 ATTRIBUTE13 WSH_GLOBAL_PARAMETERS.ATTRIBUTE13%TYPE,
143 ATTRIBUTE14 WSH_GLOBAL_PARAMETERS.ATTRIBUTE14%TYPE,
144 ATTRIBUTE15 WSH_GLOBAL_PARAMETERS.ATTRIBUTE15%TYPE,
145 CREATION_DATE WSH_GLOBAL_PARAMETERS.CREATION_DATE%TYPE,
146 CREATED_BY WSH_GLOBAL_PARAMETERS.CREATED_BY%TYPE,
147 LAST_UPDATE_DATE WSH_GLOBAL_PARAMETERS.LAST_UPDATE_DATE%TYPE,
148 LAST_UPDATED_BY WSH_GLOBAL_PARAMETERS.LAST_UPDATED_BY%TYPE,
149 LAST_UPDATE_LOGIN WSH_GLOBAL_PARAMETERS.LAST_UPDATE_LOGIN%TYPE,
150 DEFER_INTERFACE WSH_GLOBAL_PARAMETERS.DEFER_INTERFACE%TYPE,
151 ENFORCE_SHIP_METHOD WSH_GLOBAL_PARAMETERS.ENFORCE_SHIP_METHOD%TYPE,
152 ALLOW_FUTURE_SHIP_DATE WSH_GLOBAL_PARAMETERS.ALLOW_FUTURE_SHIP_DATE%TYPE,
153 RATE_IB_DELS_FGT_TERM WSH_GLOBAL_PARAMETERS.RATE_IB_DELS_FGT_TERM%TYPE,
154 SKIP_RATE_OB_DELS_FGT_TERM WSH_GLOBAL_PARAMETERS.SKIP_RATE_OB_DELS_FGT_TERM%TYPE,
155 DEL_DATE_CALC_METHOD WSH_GLOBAL_PARAMETERS.DEL_DATE_CALC_METHOD%TYPE,
156 RATE_DS_DELS_FGT_TERM_ID WSH_GLOBAL_PARAMETERS.RATE_DS_DELS_FGT_TERM_ID%TYPE,
157 RAISE_BUSINESS_EVENTS WSH_GLOBAL_PARAMETERS.RAISE_BUSINESS_EVENTS%TYPE,
158 ENABLE_TRACKING_WFS WSH_GLOBAL_PARAMETERS.ENABLE_TRACKING_WFS%TYPE,
159 ENABLE_SC_WF WSH_GLOBAL_PARAMETERS.ENABLE_SC_WF%TYPE,
160 EXPAND_CARRIER_RANKINGS WSH_GLOBAL_PARAMETERS.EXPAND_CARRIER_RANKINGS%TYPE,
161 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
162 DEFER_PLAN_SHIPMENT_INTERFACE WSH_GLOBAL_PARAMETERS.DEFER_PLAN_SHIPMENT_INTERFACE%TYPE
163 );
164
165 -- The following record structure added as part of shipping parameter form
166 -- changes for 11.5.12
167 TYPE parameter_value_rec_Typ IS RECORD(
168 ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,
169 CLASS_CODE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
170 PARAM_NAME WSH_UTIL_CORE.COLUMN_TAB_TYPE,
171 PARAM_DATA_TYPE WSH_UTIL_CORE.COLUMN_TAB_TYPE,
172 PARAM_VALUE_NUM WSH_UTIL_CORE.ID_TAB_TYPE,
173 PARAM_VALUE_CHR WSH_UTIL_CORE.TBL_VARCHAR,
174 PARAM_VALUE_DATE WSH_UTIL_CORE.DATE_TAB_TYPE);
175
176 type row_id_tbl is table of varchar2(50) index by binary_integer;
177
178 /* Procedure to get the Template Names */
179 Procedure get_layout_template (
180 p_concprg_name IN VARCHAR2,
181 p_code_field IN VARCHAR2,
182 x_name_field OUT NOCOPY VARCHAR2,
183 x_return_status OUT NOCOPY VARCHAR );
184
185 /* Procedure to create records in wsh_shipping parameter and
186 * wsh_shipping_parameter_values table */
187 Procedure create_parameter (
188 p_ship_par_rec IN parameter_rec_typ,
189 p_ship_par_val_rec IN parameter_value_rec_typ,
190 x_return_status OUT NOCOPY VARCHAR2);
191
192 /* Procedure to update records in wsh_shipping parameter and
193 * wsh_shipping_parameter_values table */
194 Procedure update_parameter (
195 p_ship_par_rec IN parameter_rec_typ,
196 p_ship_par_val_rec IN parameter_value_rec_typ,
197 x_return_status OUT NOCOPY VARCHAR2);
198
199 /* Procedure to lock records in wsh_shipping parameter table */
200 Procedure lock_record(
201 p_organization_id IN NUMBER,
202 p_last_update_date IN DATE,
203 x_return_status OUT NOCOPY VARCHAR2);
204
205 /* Procedure to create freight term records in
206 * wsh_shipping_parameter_values table */
207 Procedure create_freight_terms(
208 p_freight_terms_rec IN parameter_value_rec_typ,
209 x_return_status OUT NOCOPY VARCHAR2);
210
211 /* Procedure to update freight term records in
212 * wsh_shipping_parameter_values table */
213 Procedure update_freight_terms(
214 p_freight_terms_rec IN parameter_value_rec_typ,
215 row_id IN row_id_tbl,
216 x_return_status OUT NOCOPY VARCHAR2);
217
218 /* Procedure to delete freight term records from
219 * wsh_shipping_parameter_values table */
220 Procedure delete_freight_terms(
221 p_freight_terms_rec IN parameter_value_rec_typ,
222 row_id IN row_id_tbl,
223 x_return_status OUT NOCOPY VARCHAR2);
224
225 /* Procedure to get all records from wsh_shipping_parameter_values
226 * table for a given oraganization_id. If organization_id and parameter_name
227 * are passed, only the values corresponding to specified parameter_name
228 * for that organization_id is returned */
229 Procedure Get(
230 x_param_value_info IN OUT NOCOPY parameter_value_rec_typ,
231 x_return_status OUT NOCOPY VARCHAR2);
232
233 /* Procedure to get values from wsh_shipping_parameters
234 * and all records from wsh_shipping_parameter_values
235 * table for a given oraganization_id*/
236 Procedure get(
237 p_organization_id IN NUMBER,
238 x_param_info OUT NOCOPY parameter_rec_typ,
239 x_param_value_info OUT NOCOPY parameter_value_rec_typ,
240 x_return_status OUT NOCOPY VARCHAR2);
241
242
243 /*======================================================================================+
244 API name : Get
245 Type : Private.
246 IN Parameters : Organization_id
247 OUT Parameters : Shipping Parameter Record for individual Organization passed. In addition
248 it also tells if the organization is a process organization.
249 Description : This procedure caches the shipping Parameters in the Record Type
250 Collection for Reference.
251 +=======================================================================================*/
252
253 PROCEDURE Get
254 (p_organization_id IN NUMBER,
255 x_param_info OUT NOCOPY Parameter_Rec_Typ,
256 x_return_status OUT NOCOPY VARCHAR2);
257
258 /*======================================================================================+
259 API name : Get_Global_Parameters
260 Type : Private.
261 IN Parameters : None.
262 OUT Parameters : record for global parameters.
263 Description : This procedure caches the global Parameters in the Record Type
264 Collection for Reference.
265 +=======================================================================================*/
266
267 Procedure Get_Global_Parameters(
268 x_param_info OUT NOCOPY Global_Parameters_Rec_Typ,
269 x_return_status OUT NOCOPY VARCHAR2);
270
271 END WSH_SHIPPING_PARAMS_PVT;