eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_BANKPAYMENT_UPDT_PUB SQL Statements

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

Line: 44


procedure updateBatchStatus(
    p_batch_id         IN   iby_pay_batches_all.batch_id%TYPE,
    p_new_status       IN   iby_pay_batches_all.batch_status%TYPE,
    p_error_code       IN   iby_pay_batches_all.bep_code%TYPE,
    p_error_message    IN   iby_pay_batches_all.bep_message%TYPE
)
IS

 begin

  update iby_pay_batches_all
  set batch_status = p_new_status,
  bep_code = p_error_code,
  bep_message = p_error_message,
  last_update_date = sysdate,
  last_updated_by = fnd_global.user_id,
  object_version_number = object_version_number + 1
  where batch_id = p_batch_id;

Line: 65


end updateBatchStatus;

Line: 74


PROCEDURE updateECBatches
(
      payerid_in		IN	iby_pay_batches_all.payer_id%TYPE,
      bepid_in		IN	iby_pay_batches_all.bepid%TYPE,
      bepkey_in		IN	iby_pay_batches_all.bepkey%TYPE,
      oldstatus_in	IN	iby_pay_batches_all.batch_status%TYPE,
      newstatus_in	IN	iby_pay_batches_all.batch_status%TYPE,
      oldbatchid_in	IN	iby_pay_batches_all.iby_batch_id%TYPE,
      newbatchid_in	IN	iby_pay_batches_all.iby_batch_id%TYPE
)
IS

BEGIN
      UPDATE iby_pay_batches_all
      SET
            batch_status = newstatus_in,
            iby_batch_id = newbatchid_in,
            last_update_date = sysdate,
            last_updated_by = fnd_global.user_id,
            object_version_number = object_version_number + 1

      WHERE bepid = bepid_in
      AND bepkey = bepkey_in
      AND payer_id = payerid_in
      AND batch_status = oldstatus_in
      AND ((iby_batch_id IS NULL AND oldbatchid_in IS NULL) OR (iby_batch_id = oldbatchid_in));

Line: 103


END updateECBatches;

Line: 140


PROCEDURE updateTrxnStatus(

            p_batch_id        IN    iby_pay_payments_all.batch_id%TYPE,
            p_trxn_id         IN    iby_pay_payments_all.pmt_trxn_id%TYPE,
            p_new_status      IN    iby_pay_payments_all.pmt_status%TYPE,
            p_error_code      IN    iby_pay_payments_all.bep_code%TYPE,
            p_error_message   IN    iby_pay_payments_all.bep_message%TYPE
 )
IS

begin

IF (p_trxn_id <> 0) THEN

     update iby_pay_payments_all
     set pmt_status = p_new_status,
     bep_code = p_error_code,
     bep_message = p_error_message,
     last_update_date = sysdate,
     last_updated_by = fnd_global.user_id,
     object_version_number = object_version_number + 1
     where batch_id = p_batch_id and pmt_trxn_id = p_trxn_id;

Line: 165


     update iby_pay_payments_all
     set pmt_status = p_new_status,
     bep_code = p_error_code,
     bep_message = p_error_message,
     last_update_date = sysdate,
     last_updated_by = fnd_global.user_id,
     object_version_number = object_version_number + 1
     where batch_id = p_batch_id;

Line: 178


end updateTrxnStatus;

Line: 220


  SELECT pb.batch_id
    FROM IBY_PAY_BATCHES_ALL pb,
         IBY_BATCHES_ALL   ibyb
   WHERE ibyb.batchid = p_iby_batchid
     AND ibyb.payeeid = p_payerid;

Line: 232


    UPDATE iby_pay_payments_all
    SET
           pmt_status = G_STATUS_QRY_TRXN_FAIL,
           bep_code = p_error_code,
           bep_message = p_error_message,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id,
           last_update_login = fnd_global.conc_login_id,
           object_version_number = object_version_number + 1
    WHERE batch_id = l_ec_batch_rec.batch_id;

Line: 244


    UPDATE iby_pay_batches_all
    SET
           batch_status = G_STATUS_QRY_BATCH_FAIL,
           bep_code = p_error_code,
           bep_message = p_error_message,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id,
           last_update_login = fnd_global.conc_login_id,
           object_version_number = object_version_number + 1
    WHERE batch_id = l_ec_batch_rec.batch_id;

Line: 258


  UPDATE iby_batches_all
  SET
         batchstatus = G_STATUS_QRY_BATCH_FAIL,
         bepcode = p_error_code,
         bepmessage = p_error_message,
         last_update_date = sysdate,
         last_updated_by = fnd_global.user_id,
         last_update_login = fnd_global.conc_login_id,
         object_version_number = object_version_number + 1
   WHERE batchid = p_iby_batchid
     AND payeeid = p_payerid;

Line: 313


PROCEDURE updateQueryStatus (
            p_payerid          IN    VARCHAR2,
            p_iby_batchid      IN    VARCHAR2
)

IS

  l_unfinished_ecbatch_notfound   BOOLEAN := TRUE;

Line: 336


  SELECT pb.batch_id, pb.batch_status
    FROM IBY_PAY_BATCHES_ALL pb,
         IBY_BATCHES_ALL   ibyb
   WHERE ibyb.batchid   = p_iby_batchid
     AND ibyb.payeeid   = p_payerid
     AND pb.batch_status not in (G_STATUS_SUCCESS, G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);

Line: 344


  SELECT pb.batch_id
    FROM IBY_PAY_BATCHES_ALL pb,
         IBY_BATCHES_ALL   ibyb
   WHERE ibyb.batchid   = p_iby_batchid
     AND ibyb.payeeid   = p_payerid
     AND pb.batch_status in (G_STATUS_SUCCESS, G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);

Line: 353


  SELECT count(pb.batch_id)
    FROM IBY_PAY_BATCHES_ALL pb,
         IBY_BATCHES_ALL   ibyb
   WHERE ibyb.batchid   = p_iby_batchid
     AND ibyb.payeeid   = p_payerid;

Line: 361


  SELECT count(pb.batch_id)
    FROM IBY_PAY_BATCHES_ALL pb,
         IBY_BATCHES_ALL   ibyb
   WHERE ibyb.batchid   = p_iby_batchid
     AND ibyb.payeeid   = p_payerid
     AND pb.batch_status in (G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);

Line: 369


  SELECT pt.pmt_trxn_id
    FROM IBY_PAY_PAYMENTS_ALL pt
   WHERE pt.batch_id    = p_batch_id
     AND pt.pmt_status not in (G_STATUS_SUCCESS, G_STATUS_BEP_ERROR, G_STATUS_QRY_TRXN_FAIL);

Line: 375


  SELECT pt.pmt_trxn_id
    FROM IBY_PAY_PAYMENTS_ALL pt
   WHERE pt.batch_id    = p_batch_id
     AND pt.pmt_status in (G_STATUS_SUCCESS, G_STATUS_BEP_ERROR, G_STATUS_QRY_TRXN_FAIL);

Line: 382


  SELECT count(pt.pmt_trxn_id)
    FROM IBY_PAY_PAYMENTS_ALL pt
   WHERE pt.batch_id    = p_batch_id;

Line: 388


  SELECT count(pt.pmt_trxn_id)
    FROM IBY_PAY_PAYMENTS_ALL pt
   WHERE pt.batch_id    = p_batch_id
   --AND pt.pmt_status <> G_STATUS_SUCCESS;

Line: 449


      UPDATE iby_pay_batches_all
      SET
             batch_status = l_batch_status,
             bep_code = null,
             bep_message = null,
             last_update_date = sysdate,
             last_updated_by = fnd_global.user_id,
             last_update_login = fnd_global.conc_login_id,
             object_version_number = object_version_number + 1
      WHERE batch_id = l_ec_batch_rec.batch_id;

Line: 485


    UPDATE iby_batches_all
    SET
           batchstatus = l_batch_status,
           bepcode = null,
           bepmessage = null,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id,
           last_update_login = fnd_global.conc_login_id,
           object_version_number = object_version_number + 1
    WHERE batchid = p_iby_batchid
      AND payeeid = p_payerid;

Line: 512


    UPDATE iby_batches_all
    SET
           batchstatus = l_batch_status,
           bepcode = null,
           bepmessage = null,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id,
           last_update_login = fnd_global.conc_login_id,
           object_version_number = object_version_number + 1
    WHERE batchid = p_iby_batchid
      AND payeeid = p_payerid;