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.

[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on WSH_SHIPPING_PARAMETER_VALUES

Line 168: ORGANIZATION_ID WSH_SHIPPING_PARAMETER_VALUES.ORGANIZATION_ID%TYPE,

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,

Line 186: * wsh_shipping_parameter_values table */

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

Line 193: * wsh_shipping_parameter_values table */

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

Line 206: * wsh_shipping_parameter_values table */

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:

Line 212: * wsh_shipping_parameter_values table */

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

Line 219: * wsh_shipping_parameter_values table */

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

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

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(

Line 234: * and all records from wsh_shipping_parameter_values

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,