APPS.WMS_SORT_CRITERIA_FORM_PKG dependencies on WMS_SORT_CRITERIA

Line 1: package body wms_sort_criteria_form_pkg AS

1: package body wms_sort_criteria_form_pkg AS
2: /* $Header: WMSFPCRB.pls 120.1 2005/06/20 05:37:14 appldev ship $ */
3:
4: g_pkg_name constant varchar2(30) := 'WMSSort_Criteria_Form_PKG';
5:

Line 13: CURSOR c IS SELECT rule_id FROM wms_sort_criteria

9: (
10: p_rule_id IN NUMBER
11: ,p_sequence_number IN NUMBER
12: ) RETURN BOOLEAN IS
13: CURSOR c IS SELECT rule_id FROM wms_sort_criteria
14: WHERE rule_id = p_rule_id
15: AND sequence_number = p_sequence_number;
16: l_rule_id NUMBER;
17: l_exist BOOLEAN;

Line 66: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_EXISTS');

62:
63: /* check existence */
64: IF check_existence(p_rule_id, p_sequence_number) THEN
65: IF p_action = 'INSERT' THEN
66: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_EXISTS');
67: fnd_msg_pub.ADD;
68: RAISE fnd_api.g_exc_error;
69: END IF;
70: ELSE

Line 72: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_NOT_FOUND');

68: RAISE fnd_api.g_exc_error;
69: END IF;
70: ELSE
71: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
72: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_NOT_FOUND');
73: fnd_msg_pub.ADD;
74: RAISE fnd_api.g_exc_error;
75: END IF;
76: END IF;

Line 215: wms_sort_criteria_pkg.insert_row

211: raise fnd_api.g_exc_error;
212: end if;
213:
214: /* call the table handler to do the insert */
215: wms_sort_criteria_pkg.insert_row
216: (
217: x_rowid => p_rowid
218: ,x_rule_id => p_rule_id
219: ,x_sequence_number => p_sequence_number

Line 347: wms_sort_criteria_pkg.lock_row (

343: elsif x_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: end if;
346:
347: wms_sort_criteria_pkg.lock_row (
348: x_rowid => p_rowid
349: ,x_rule_id => p_rule_id
350: ,x_sequence_number => p_sequence_number
351: ,x_parameter_id => p_parameter_id

Line 484: wms_sort_criteria_pkg.update_row

480: l_user_id := fnd_global.user_id;
481: l_login_id := fnd_global.login_id;
482:
483: /* call the table handler to do the update */
484: wms_sort_criteria_pkg.update_row
485: (
486: x_rowid => p_rowid
487: ,x_rule_id => p_rule_id
488: ,x_sequence_number => p_sequence_number

Line 598: wms_sort_criteria_pkg.delete_row(p_rowid);

594: elsif x_return_status = fnd_api.g_ret_sts_error then
595: raise fnd_api.g_exc_error;
596: end if;
597:
598: wms_sort_criteria_pkg.delete_row(p_rowid);
599: fnd_msg_pub.count_and_get( p_count => x_msg_count
600: ,p_data => x_msg_data );
601: x_return_status := l_return_status;
602:

Line 630: DELETE FROM wms_sort_criteria

626: procedure delete_sort_criterias (
627: p_rule_id IN NUMBER
628: ) is
629: BEGIN
630: DELETE FROM wms_sort_criteria
631: WHERE rule_id = p_rule_id;
632: END delete_sort_criterias;
633:
634: end WMS_SORT_CRITERIA_FORM_PKG;

Line 634: end WMS_SORT_CRITERIA_FORM_PKG;

630: DELETE FROM wms_sort_criteria
631: WHERE rule_id = p_rule_id;
632: END delete_sort_criterias;
633:
634: end WMS_SORT_CRITERIA_FORM_PKG;