DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on WSH_SHIPPING_PARAMETER_VALUES

Line 172: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,

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,

Line 190: * wsh_shipping_parameter_values table */

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);

Line 197: * wsh_shipping_parameter_values table */

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);

Line 210: * wsh_shipping_parameter_values table */

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:

Line 216: * wsh_shipping_parameter_values table */

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);

Line 223: * wsh_shipping_parameter_values table */

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);

Line 229: /* Procedure to get all records from wsh_shipping_parameter_values

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(

Line 238: * and all records from wsh_shipping_parameter_values

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,