APPS.IBY_PMTMTHD_CONDITIONS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

  SELECT COUNT(*)
    FROM iby_pmtmthd_conditions  a
    WHERE
      i_entry_sequence=a.entry_sequence AND
      i_paymentmethodId = a.paymentmethodId ;

Line: 48

    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);

Line: 80

  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;

Line: 110

  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;

Line: 135

** 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;

Line: 173

    DELETE FROM iby_pmtmthd_conditions
      WHERE CURRENT OF c_ruleCondt;

Line: 200

  SELECT COUNT(*) into l_count
  FROM iby_pmtmthd_conditions  a
  WHERE UPPER(i_condition_name) = UPPER(a.condition_name)
  AND i_paymentmethodId = a.paymentmethodId ;