1: PACKAGE BODY WMS_SORT_CRITERIA_PKG AS
2: /* $Header: WMSHPCRB.pls 120.1 2005/06/21 02:06:21 appldev ship $ */
3:
4: PROCEDURE INSERT_ROW (
5: x_rowid IN OUT NOCOPY VARCHAR2
366: l_sequence_number :=
367: fnd_number.canonical_to_number(x_sequence_number);
368: l_order_code := fnd_number.canonical_to_number(x_order_code );
369:
370: wms_sort_criteria_pkg.update_row
371: (
372: x_rowid => NULL
373: ,x_rule_id => l_rule_id
374: ,x_sequence_number => l_sequence_number
395: ,x_attribute15 => x_attribute15
396: );
397: EXCEPTION
398: WHEN no_data_found THEN
399: wms_sort_criteria_pkg.insert_row
400: (
401: x_rowid => l_row_id
402: ,x_rule_id => l_rule_id
403: ,x_sequence_number => l_sequence_number
426: ,x_attribute15 => x_attribute15
427: );
428: END;
429: END load_row;
430: END WMS_SORT_CRITERIA_PKG;