DBA Data[Home] [Help]

APPS.FUN_MULTI_SYSTEM_WF_PKG dependencies on FUN_TRX_HEADERS

Line 85: FROM FUN_TRX_HEADERS

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

Line 250: -- flag in fun_trx_headers table.

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

Line 392: FROM FUN_TRX_HEADERS

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