The following lines contain the word 'select', 'insert', 'update' or 'delete':
CURSOR c IS SELECT rule_id FROM wms_sort_criteria
WHERE rule_id = p_rule_id
AND sequence_number = p_sequence_number;
IF p_action NOT IN ('INSERT', 'UPDATE', 'LOCK', 'DELETE') THEN
-- unknown exception
RAISE fnd_api.g_exc_unexpected_error;
IF p_action = 'INSERT' THEN
fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_EXISTS');
IF p_action IN ('DELETE','LOCK','UPDATE') THEN
fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_NOT_FOUND');
/* more input validation update and insert */
IF p_action IN ('UPDATE', 'INSERT') THEN
/* check foreign keys */
wms_rule_form_pkg.find_rule
(
p_api_version => 1.0
,p_init_msg_list => fnd_api.g_false
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_rule_id => p_rule_id
,x_found => l_found
);
procedure insert_sort_criteria
(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,p_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,p_rule_id IN NUMBER
,p_sequence_number IN NUMBER
,p_parameter_id IN NUMBER
,p_order_code IN NUMBER
,p_attribute_category IN VARCHAR2
,p_attribute1 IN VARCHAR2
,p_attribute2 IN VARCHAR2
,p_attribute3 IN VARCHAR2
,p_attribute4 IN VARCHAR2
,p_attribute5 IN VARCHAR2
,p_attribute6 IN VARCHAR2
,p_attribute7 IN VARCHAR2
,p_attribute8 IN VARCHAR2
,p_attribute9 IN VARCHAR2
,p_attribute10 IN VARCHAR2
,p_attribute11 IN VARCHAR2
,p_attribute12 IN VARCHAR2
,p_attribute13 IN VARCHAR2
,p_attribute14 IN VARCHAR2
,p_attribute15 IN VARCHAR2
) IS
-- API standard variables
l_api_version constant number := 1.0;
l_api_name constant varchar2(30) := 'Insert_Sort_criteria';
SELECT Sysdate INTO l_date FROM dual;
,p_action => 'INSERT'
,p_rule_id => p_rule_id
,p_sequence_number => p_sequence_number
,p_parameter_id => p_parameter_id
,p_order_code => p_order_code
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
);
/* call the table handler to do the insert */
wms_sort_criteria_pkg.insert_row
(
x_rowid => p_rowid
,x_rule_id => p_rule_id
,x_sequence_number => p_sequence_number
,x_last_updated_by => l_user_id
,x_last_update_date => l_date
,x_created_by => l_user_id
,x_creation_date => l_date
,x_last_update_login => l_login_id
,x_parameter_id => p_parameter_id
,x_order_code => p_order_code
,x_attribute_category => p_attribute_category
,x_attribute1 => p_attribute1
,x_attribute2 => p_attribute2
,x_attribute3 => p_attribute3
,x_attribute4 => p_attribute4
,x_attribute5 => p_attribute5
,x_attribute6 => p_attribute6
,x_attribute7 => p_attribute7
,x_attribute8 => p_attribute8
,x_attribute9 => p_attribute9
,x_attribute10 => p_attribute10
,x_attribute11 => p_attribute11
,x_attribute12 => p_attribute12
,x_attribute13 => p_attribute13
,x_attribute14 => p_attribute14
,x_attribute15 => p_attribute15
);
end insert_sort_criteria;
procedure update_sort_criteria (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,p_rowid IN VARCHAR2
,p_rule_id IN NUMBER
,p_sequence_number IN NUMBER
,p_parameter_id IN NUMBER
,p_order_code IN NUMBER
,p_attribute_category IN VARCHAR2
,p_attribute1 IN VARCHAR2
,p_attribute2 IN VARCHAR2
,p_attribute3 IN VARCHAR2
,p_attribute4 IN VARCHAR2
,p_attribute5 IN VARCHAR2
,p_attribute6 IN VARCHAR2
,p_attribute7 IN VARCHAR2
,p_attribute8 IN VARCHAR2
,p_attribute9 IN VARCHAR2
,p_attribute10 IN VARCHAR2
,p_attribute11 IN VARCHAR2
,p_attribute12 IN VARCHAR2
,p_attribute13 IN VARCHAR2
,p_attribute14 IN VARCHAR2
,p_attribute15 IN VARCHAR2
) is
-- API standard variables
l_api_version constant number := 1.0;
l_api_name constant varchar2(30) := 'Update_Sort_criteria';
,p_action => 'UPDATE'
,p_rule_id => p_rule_id
,p_sequence_number => p_sequence_number
,p_parameter_id => p_parameter_id
,p_order_code => p_order_code
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
);
SELECT Sysdate INTO l_date FROM dual;
/* call the table handler to do the update */
wms_sort_criteria_pkg.update_row
(
x_rowid => p_rowid
,x_rule_id => p_rule_id
,x_sequence_number => p_sequence_number
,x_last_updated_by => l_user_id
,x_last_update_date => l_date
,x_last_update_login => l_login_id
,x_parameter_id => p_parameter_id
,x_order_code => p_order_code
,x_attribute_category => p_attribute_category
,x_attribute1 => p_attribute1
,x_attribute2 => p_attribute2
,x_attribute3 => p_attribute3
,x_attribute4 => p_attribute4
,x_attribute5 => p_attribute5
,x_attribute6 => p_attribute6
,x_attribute7 => p_attribute7
,x_attribute8 => p_attribute8
,x_attribute9 => p_attribute9
,x_attribute10 => p_attribute10
,x_attribute11 => p_attribute11
,x_attribute12 => p_attribute12
,x_attribute13 => p_attribute13
,x_attribute14 => p_attribute14
,x_attribute15 => p_attribute15
);
end update_sort_criteria ;
procedure delete_sort_criteria (
p_api_version in NUMBER,
p_init_msg_list in varchar2 := fnd_api.g_false,
p_validation_level in number := fnd_api.g_valid_level_full,
x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
p_rowid IN VARCHAR2,
p_rule_id IN NUMBER,
p_sequence_number IN NUMBER
) is
-- API standard variables
l_api_version constant number := 1.0;
l_api_name constant varchar2(30) := 'Delete_Sort_criteria';
,p_action => 'DELETE'
,p_rule_id => p_rule_id
,p_sequence_number => p_sequence_number
,p_parameter_id => fnd_api.g_miss_num -- dont care
,p_order_code => fnd_api.g_miss_num
,p_attribute_category => fnd_api.g_miss_char
,p_attribute1 => fnd_api.g_miss_char
,p_attribute2 => fnd_api.g_miss_char
,p_attribute3 => fnd_api.g_miss_char
,p_attribute4 => fnd_api.g_miss_char
,p_attribute5 => fnd_api.g_miss_char
,p_attribute6 => fnd_api.g_miss_char
,p_attribute7 => fnd_api.g_miss_char
,p_attribute8 => fnd_api.g_miss_char
,p_attribute9 => fnd_api.g_miss_char
,p_attribute10 => fnd_api.g_miss_char
,p_attribute11 => fnd_api.g_miss_char
,p_attribute12 => fnd_api.g_miss_char
,p_attribute13 => fnd_api.g_miss_char
,p_attribute14 => fnd_api.g_miss_char
,p_attribute15 => fnd_api.g_miss_char
);
wms_sort_criteria_pkg.delete_row(p_rowid);
end delete_sort_criteria ;
procedure delete_sort_criterias (
p_rule_id IN NUMBER
) is
BEGIN
DELETE FROM wms_sort_criteria
WHERE rule_id = p_rule_id;
END delete_sort_criterias;