81:
82:
83: CURSOR c_recipient(p_batch_id IN NUMBER) IS
84: SELECT trx_id, recipient_id
85: FROM FUN_TRX_HEADERS
86: WHERE batch_id = p_batch_id;
87:
88:
89: BEGIN
246: itemkey,
247: 'BATCH_ID');
248:
249: -- We only need to check if invoice is required and set the
250: -- flag in fun_trx_headers table.
251: fun_wf_common.set_invoice_reqd_flag(p_batch_id => l_batch_id,
252: x_return_status => l_sts);
253:
254: -- no result needed
388: -- obtain the initiator_id and recipient_id
389:
390: SELECT initiator_id, recipient_id
391: INTO l_initiator_id, l_recipient_id
392: FROM FUN_TRX_HEADERS
393: WHERE batch_id=l_batch_id
394: AND trx_id=l_trx_id;
395:
396: -- determine the TP ID