APPS.WMS_SORT_CRITERIA_PKG dependencies on WMS_SORT_CRITERIA

Line 1: PACKAGE BODY WMS_SORT_CRITERIA_PKG AS

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

Line 32: CURSOR C IS SELECT ROWID FROM WMS_SORT_CRITERIA

28: ,x_attribute13 IN VARCHAR2
29: ,x_attribute14 IN VARCHAR2
30: ,x_attribute15 IN VARCHAR2
31: )IS
32: CURSOR C IS SELECT ROWID FROM WMS_SORT_CRITERIA
33: WHERE rule_id = x_rule_id
34: AND sequence_number = x_sequence_number;
35: BEGIN
36:

Line 37: INSERT INTO WMS_SORT_CRITERIA (

33: WHERE rule_id = x_rule_id
34: AND sequence_number = x_sequence_number;
35: BEGIN
36:
37: INSERT INTO WMS_SORT_CRITERIA (
38: rule_id
39: ,sequence_number
40: ,last_updated_by
41: ,last_update_date

Line 149: FROM WMS_SORT_CRITERIA

145: ,attribute12
146: ,attribute13
147: ,attribute14
148: ,attribute15
149: FROM WMS_SORT_CRITERIA
150: WHERE rowid = x_rowid
151: FOR UPDATE OF rule_id NOWAIT;
152:
153: recinfo c%ROWTYPE;

Line 252: UPDATE WMS_SORT_CRITERIA SET

248: )IS
249: BEGIN
250: IF (x_rowid IS NOT NULL) THEN
251:
252: UPDATE WMS_SORT_CRITERIA SET
253: rule_id = x_rule_id
254: ,sequence_number = x_sequence_number
255: ,last_updated_by = x_last_updated_by
256: ,last_update_date = x_last_update_date

Line 278: UPDATE WMS_SORT_CRITERIA SET

274: ,attribute14 = x_attribute14
275: ,attribute15 = x_attribute15
276: WHERE rowid = x_rowid;
277: ELSE
278: UPDATE WMS_SORT_CRITERIA SET
279: rule_id = x_rule_id
280: ,sequence_number = x_sequence_number
281: ,last_updated_by = x_last_updated_by
282: ,last_update_date = x_last_update_date

Line 316: DELETE FROM WMS_SORT_CRITERIA

312: x_rowid IN VARCHAR2
313: )IS
314: BEGIN
315:
316: DELETE FROM WMS_SORT_CRITERIA
317: WHERE rowid = x_rowid;
318:
319: IF (SQL%NOTFOUND) THEN
320: RAISE NO_DATA_FOUND;

Line 370: wms_sort_criteria_pkg.update_row

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

Line 399: wms_sort_criteria_pkg.insert_row

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

Line 430: END WMS_SORT_CRITERIA_PKG;

426: ,x_attribute15 => x_attribute15
427: );
428: END;
429: END load_row;
430: END WMS_SORT_CRITERIA_PKG;