APPS.IBY_IMPORT_PMT_ACK_DATA_PUB SQL Statements

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

Line: 30

        SELECT count(1)
          FROM iby_payments_all
         WHERE (payment_reference_number = ci_payment_ref);

Line: 66

        SELECT count(1)
          FROM iby_bank_ack_statuses
	 WHERE bank_ack_status_code = p_bank_status_code
	   AND nvl(trunc(inactive_date), sysdate+10 )  > trunc (sysdate);

Line: 103

        SELECT payment_ack_status
          FROM iby_bank_ack_statuses
	 WHERE bank_ack_status_code = ci_bank_status;

Line: 140

        SELECT payment_id
          FROM iby_payments_all
	 WHERE payment_reference_number = ci_payment_ref;

Line: 217

 SELECT APPLICATION_SHORT_NAME
 FROM    FND_APPLICATION
 WHERE   APPLICATION_ID = FND_GLOBAL.resp_appl_id;

Line: 262

      SELECT 0
      INTO   l_access
      FROM   dual
      WHERE EXISTS
	   (SELECT NULL
	    FROM   iby_payments_all
	    WHERE  payment_reference_number = P_PAYMENT_REF_NUMBER
	    AND    org_id <> -1
	    AND    MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');

Line: 309

        select iby_ack_pmt_all_s.NEXTVAL into l_ack_pmt_id from dual;

Line: 311

        INSERT INTO iby_ack_pmt_all
        ( ack_pmt_id, payment_ref_number,payment_instruction_ref_number
	  ,bank_status_code,payment_ack_status,acknowledgement_date,bank_assigned_ref_code1, bank_assigned_ref_code2
	   ,payer_name,payer_bank_name,payer_bank_branch_name,payer_bank_swift_code,payer_bank_account_number,payer_bank_iban_number
	   ,payee_name,payee_bank_name,payee_bank_branch_name,payee_bank_swift_code,payee_bank_account_number,payee_bank_iban_number
	   ,payment_amount,bank_charge_amount,payment_currency_code
	   ,exchange_rate,calculated_payment_amount,calculated_bank_charge_amount
	   ,value_date,requested_execution_date
	   ,created_by,creation_date,last_updated_by,last_update_date,last_update_login
        )
        VALUES
         ( l_ack_pmt_id, P_PAYMENT_REF_NUMBER,P_PMT_INSTRUCTION_REF_NUMBER
	  ,P_BANK_STATUS_CODE,l_pmt_ack_status,P_ACKNOWLEDGEMENT_DATE,P_BANK_ASSIGNED_REF_CODE1, P_BANK_ASSIGNED_REF_CODE2
	   ,P_PAYER_NAME,P_PAYER_BANK_NAME,P_PAYER_BANK_BRANCH_NAME,P_PAYER_BANK_SWIFT_CODE,P_PAYER_BANK_ACCOUNT_NUMBER,P_PAYER_BANK_IBAN_NUMBER
	   ,P_PAYEE_NAME,P_PAYEE_BANK_NAME,P_PAYEE_BANK_BRANCH_NAME,P_PAYEE_BANK_SWIFT_CODE,P_PAYEE_BANK_ACCOUNT_NUMBER,P_PAYEE_BANK_IBAN_NUMBER
	   ,P_PAYMENT_AMOUNT,P_BANK_CHARGE_AMOUNT,P_PAYMENT_CURRENCY_CODE
	   ,P_EXCHANGE_RATE,l_calculated_amt,l_calculated_bank_charge_amt
	   ,P_VALUE_DATE,P_REQUESTED_EXECUTION_DATE
	   ,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id
        );

Line: 340

              INSERT INTO iby_ack_pmt_errors
	      ( ack_pmt_error_id , ack_pmt_id , bank_error_code ,bank_error_message , bank_error_location
	       , created_by,creation_date,last_updated_by,last_update_date,last_update_login
	        )
	        VALUES
               ( IBY_ACK_PMT_ERRORS_S.NEXTVAL, l_ack_pmt_id , P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_CODE
	         ,P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_MESSAGE ,P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_LOCATION
	         ,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id
		 );

Line: 358

        UPDATE iby_payments_all
	   SET acknowledged_flag = 'Y'
         WHERE (payment_reference_number = P_PAYMENT_REF_NUMBER);