The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
FROM iby_pmtmthd_conditions a
WHERE
i_entry_sequence=a.entry_sequence AND
i_paymentmethodId = a.paymentmethodId ;
INSERT INTO iby_pmtmthd_conditions
(paymentmethodid, parameter_code, operation_code, value, is_value_string,
entry_sequence, last_update_date, last_updated_by, creation_date,
created_by, last_update_login, condition_name, object_version_number)
VALUES ( i_paymentmethodid, i_parameter_code, i_operation_code, i_value,
i_is_value_string, i_entry_sequence, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
fnd_global.login_id, i_condition_name, 1);
SELECT *
FROM iby_pmtmthd_conditions a
WHERE i_version = a.object_version_number AND
i_entry_sequence=a.entry_sequence AND
i_paymentmethodId = a.paymentmethodId
FOR UPDATE;
UPDATE iby_pmtmthd_conditions
SET paymentmethodid = i_paymentmethodid, parameter_code = i_parameter_code,
operation_code = i_operation_code, value=i_value,
is_value_string = i_is_value_string, entry_sequence=i_entry_sequence,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id,
condition_name = i_condition_name,
object_version_number = object_version_number+1
WHERE CURRENT OF c_ruleCondt;
** Function: deleteCondition.
** Purpose: deletes rule condition in the database.
*/
procedure deleteCondition (
i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
i_operation_code in iby_pmtmthd_conditions.operation_code%type,
i_value in iby_pmtmthd_conditions.value%type,
i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
i_version in iby_pmtmthd_conditions.object_version_number%type)
is
-- Check whether this method name is already being used
CURSOR c_ruleCondt IS
SELECT *
FROM iby_pmtmthd_conditions a
WHERE i_version = a.object_version_number AND
i_entry_sequence=a.entry_sequence AND
i_paymentmethodId = a.paymentmethodId
FOR UPDATE;
DELETE FROM iby_pmtmthd_conditions
WHERE CURRENT OF c_ruleCondt;
SELECT COUNT(*) into l_count
FROM iby_pmtmthd_conditions a
WHERE UPPER(i_condition_name) = UPPER(a.condition_name)
AND i_paymentmethodId = a.paymentmethodId ;