APPS.IBY_PAYEE_PKG SQL Statements

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

Line: 12

			-- otherwise it's update for an existing one
return boolean
is
l_flag boolean := false;

Line: 21

SELECT name
FROM  iby_payee
WHERE name = ci_name AND
	payeeid <> ci_payeeid;

Line: 29

SELECT name
FROM  iby_payee
WHERE name = ci_name;

Line: 77

  SELECT payeeid
  FROM iby_payee
  WHERE payeeid = ci_payeeid;   -- no longer touches ecappid

Line: 113

select payeeid from iby_payee
where payeeid = ci_payeeid
and upper(activestatus) = 'Y';

Line: 187

       select iby_payee_s.NEXTVAL
       into mpayeeid
       from dual;

Line: 191

        INSERT INTO iby_payee ( mpayeeid,ecappid, payeeid, name, supportedop,
                               username, password, activestatus,
				threshold, risk_enabled, mcc_code, security_enabled,
				last_update_date, last_updated_by,
				creation_date, created_by,
			last_update_login, object_version_number)
        VALUES (mpayeeid, i_ecappid, i_payeeid, i_payeename, i_supportedop,
                 i_username, i_password, i_activestatus,
		 i_threshold, i_risk_enabled, i_mcc, i_secenable,
		 sysdate, fnd_global.user_id,
		 sysdate, fnd_global.user_id,
		fnd_global.login_id, 1);

Line: 236

        UPDATE iby_payee
        SET activestatus = i_activestatus,
	    last_update_date = sysdate,
	    last_updated_by = fnd_global.user_id,
	    last_update_login = fnd_global.login_id
        WHERE  payeeid = i_payeeid;

Line: 294

        UPDATE iby_payee
        SET name= i_payeename,
            supportedOp = i_supportedOp,
            username = i_username,
            password = i_password,
            activestatus = i_activestatus,
	    threshold = i_threshold,
	    risk_enabled = i_risk_enabled,
            mcc_code = i_mcc,
	    security_enabled = i_secenable,
	    last_update_date = sysdate,
	    last_updated_by = fnd_global.user_id,
	    last_update_login = fnd_global.login_id,
	    object_version_number = object_version_number + 1
        WHERE payeeid = i_payeeid
	 AND object_version_number = i_object_version;

Line: 320

    iby_bepkeys_pkg.deleteBEPKeys(i_payeeid, 'PAYEE');