APPS.IBY_BANKPAYMENT_UPDT_PUB dependencies on IBY_PAY_PAYMENTS_ALL

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

61: /* ========================================================================
62: -- Procedure Name: updateTrxnStatus
63: --
64: -- Purpose: This procedure updates the transaction status field
65: -- in the iby_pay_payments_all table with the new transaction
66: -- status value. For a particular batch, all the
67: -- transactions will be updated with the same status value.
68: -- Since the batch acknowledgment is not considered at
69: -- present this condition is sufficient.

Line 97: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,

93: -- =======================================================================*/
94:
95: PROCEDURE updateTrxnStatus(
96:
97: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
98: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
99: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
100: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
101: p_error_message IN iby_pay_payments_all.bep_message%TYPE

Line 98: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,

94:
95: PROCEDURE updateTrxnStatus(
96:
97: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
98: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
99: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
100: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
101: p_error_message IN iby_pay_payments_all.bep_message%TYPE
102: );

Line 99: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,

95: PROCEDURE updateTrxnStatus(
96:
97: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
98: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
99: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
100: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
101: p_error_message IN iby_pay_payments_all.bep_message%TYPE
102: );
103:

Line 100: p_error_code IN iby_pay_payments_all.bep_code%TYPE,

96:
97: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
98: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
99: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
100: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
101: p_error_message IN iby_pay_payments_all.bep_message%TYPE
102: );
103:
104:

Line 101: p_error_message IN iby_pay_payments_all.bep_message%TYPE

97: p_batch_id IN iby_pay_payments_all.batch_id%TYPE,
98: p_trxn_id IN iby_pay_payments_all.pmt_trxn_id%TYPE,
99: p_new_status IN iby_pay_payments_all.pmt_status%TYPE,
100: p_error_code IN iby_pay_payments_all.bep_code%TYPE,
101: p_error_message IN iby_pay_payments_all.bep_message%TYPE
102: );
103:
104:
105: /* ========================================================================