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 dependencies on IBY_PAY_PAYMENTS_ALL

Line 110: -- in the iby_pay_payments_all table with the new transaction

106: /* ========================================================================
107: -- Procedure Name: updateTrxnStatus
108: --
109: -- Purpose: This procedure updates the transaction status field
110: -- in the iby_pay_payments_all table with the new transaction
111: -- status value. For a particular batch, all the
112: -- transactions will be updated with the same status value.
113: -- Since the batch acknowledgment is not considered at
114: -- present this condition is sufficient.

Line 142: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,

138: -- =======================================================================*/
139:
140: PROCEDURE updateTrxnStatus(
141:
142: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
143: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
144: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
145: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
146: p_error_message IN iby_pay_payments_all.bep_message%TYPE

Line 143: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,

139:
140: PROCEDURE updateTrxnStatus(
141:
142: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
143: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
144: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
145: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
146: p_error_message IN iby_pay_payments_all.bep_message%TYPE
147: )

Line 144: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,

140: PROCEDURE updateTrxnStatus(
141:
142: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
143: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
144: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
145: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
146: p_error_message IN iby_pay_payments_all.bep_message%TYPE
147: )
148: IS

Line 145: p_error_code IN iby_pay_payments_all.bep_code%TYPE,

141:
142: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
143: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
144: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
145: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
146: p_error_message IN iby_pay_payments_all.bep_message%TYPE
147: )
148: IS
149:

Line 146: p_error_message IN iby_pay_payments_all.bep_message%TYPE

142: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
143: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
144: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
145: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
146: p_error_message IN iby_pay_payments_all.bep_message%TYPE
147: )
148: IS
149:
150: begin

Line 154: update iby_pay_payments_all

150: begin
151:
152: IF (p_trxn_id <> 0) THEN
153:
154: update iby_pay_payments_all
155: set pmt_status = p_new_status,
156: bep_code = p_error_code,
157: bep_message = p_error_message,
158: last_update_date = sysdate,

Line 165: update iby_pay_payments_all

161: where batch_id = p_batch_id and pmt_trxn_id = p_trxn_id;
162:
163: ELSE
164:
165: update iby_pay_payments_all
166: set pmt_status = p_new_status,
167: bep_code = p_error_code,
168: bep_message = p_error_message,
169: last_update_date = sysdate,

Line 232: UPDATE iby_pay_payments_all

228: FOR l_ec_batch_rec IN l_ec_batch_csr(p_payerid, p_iby_batchid) LOOP
229:
230: -- update child trxns
231: -- of the EC batch
232: UPDATE iby_pay_payments_all
233: SET
234: pmt_status = G_STATUS_QRY_TRXN_FAIL,
235: bep_code = p_error_code,
236: bep_message = p_error_message,

Line 370: FROM IBY_PAY_PAYMENTS_ALL pt

366: AND pb.batch_status in (G_STATUS_QRY_BATCH_PARTIAL, G_STATUS_QRY_BATCH_FAIL);
367:
368: CURSOR l_unfinished_trxn_csr (p_batch_id IN NUMBER) IS
369: SELECT pt.pmt_trxn_id
370: FROM IBY_PAY_PAYMENTS_ALL pt
371: WHERE pt.batch_id = p_batch_id
372: AND pt.pmt_status not in (G_STATUS_SUCCESS, G_STATUS_BEP_ERROR, G_STATUS_QRY_TRXN_FAIL);
373:
374: CURSOR l_finished_trxn_csr (p_batch_id IN NUMBER) IS

Line 376: FROM IBY_PAY_PAYMENTS_ALL pt

372: AND pt.pmt_status not in (G_STATUS_SUCCESS, G_STATUS_BEP_ERROR, G_STATUS_QRY_TRXN_FAIL);
373:
374: CURSOR l_finished_trxn_csr (p_batch_id IN NUMBER) IS
375: SELECT pt.pmt_trxn_id
376: FROM IBY_PAY_PAYMENTS_ALL pt
377: WHERE pt.batch_id = p_batch_id
378: AND pt.pmt_status in (G_STATUS_SUCCESS, G_STATUS_BEP_ERROR, G_STATUS_QRY_TRXN_FAIL);
379:
380: -- all trxns of an EC batch

Line 383: FROM IBY_PAY_PAYMENTS_ALL pt

379:
380: -- all trxns of an EC batch
381: CURSOR l_trxn_cnt_csr (p_batch_id IN NUMBER) IS
382: SELECT count(pt.pmt_trxn_id)
383: FROM IBY_PAY_PAYMENTS_ALL pt
384: WHERE pt.batch_id = p_batch_id;
385:
386: -- unsuccessful trxns of an EC batch
387: CURSOR l_failed_trxn_cnt_csr (p_batch_id IN NUMBER) IS

Line 389: FROM IBY_PAY_PAYMENTS_ALL pt

385:
386: -- unsuccessful trxns of an EC batch
387: CURSOR l_failed_trxn_cnt_csr (p_batch_id IN NUMBER) IS
388: SELECT count(pt.pmt_trxn_id)
389: FROM IBY_PAY_PAYMENTS_ALL pt
390: WHERE pt.batch_id = p_batch_id
391: --AND pt.pmt_status <> G_STATUS_SUCCESS;
392: AND pt.pmt_status in (G_STATUS_BEP_ERROR, G_STATUS_QRY_TRXN_FAIL);
393: