APPS.CE_PMT_CALLOUT_PKG dependencies on CE_PAYMENT_TRANSACTIONS

Line 17: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;

13: SELECT docs.calling_app_doc_ref_number
14: FROM iby_fd_docs_payable_v docs
15: WHERE docs.rejected_docs_group_id = cs_rejected_docs_group_id;
16:
17: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
18: l_result varchar2(100);
19: BEGIN
20: OPEN c_rejected_transfers(p_rejected_docs_group_id);
21: LOOP

Line 29: UPDATE ce_payment_transactions

25: c_rejected_transfers%NOTFOUND is NULL;
26:
27: CE_BAT_API.reject_transfer(l_trxn_reference_number,
28: l_result);
29: UPDATE ce_payment_transactions
30: SET trxn_status_code = 'FAILED'
31: WHERE trxn_reference_number = l_trxn_reference_number;
32: END LOOP;
33: CLOSE c_rejected_transfers;

Line 60: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;

56: iby_fd_payments_v pmts
57: WHERE docs.completed_pmts_group_id = cs_completed_pmts_group_id
58: AND docs.payment_id = pmts.payment_id;
59:
60: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
61: l_payment_reference_number IBY_FD_PAYMENTS_V.payment_reference_number%TYPE;
62: BEGIN
63: OPEN c_completed_transfers(p_completed_pmts_group_id);
64: LOOP

Line 102: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;

98: SELECT docs.calling_app_doc_ref_number
99: FROM iby_fd_docs_payable_v docs
100: WHERE docs.payment_id = cs_payment_id;
101:
102: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
103:
104: BEGIN
105: OPEN c_voided_transfers(p_payment_id);
106: LOOP

Line 112: UPDATE ce_payment_transactions

108: l_trxn_reference_number;
109: EXIT WHEN c_voided_transfers%NOTFOUND or
110: c_voided_transfers%NOTFOUND is NULL;
111:
112: UPDATE ce_payment_transactions
113: SET trxn_status_code = 'CANCELED'
114: WHERE trxn_reference_number = l_trxn_reference_number;
115:
116: END LOOP;