DBA Data[Home] [Help]

APPS.FUN_MULTI_SYSTEM_WF_PKG dependencies on FUN_TRX_HEADERS

Line 84: FROM FUN_TRX_HEADERS

80:
81:
82: CURSOR c_recipient(p_batch_id IN NUMBER) IS
83: SELECT trx_id, recipient_id
84: FROM FUN_TRX_HEADERS
85: WHERE batch_id = p_batch_id;
86:
87:
88: BEGIN

Line 241: -- flag in fun_trx_headers table.

237: itemkey,
238: 'BATCH_ID');
239:
240: -- We only need to check if invoice is required and set the
241: -- flag in fun_trx_headers table.
242: fun_wf_common.set_invoice_reqd_flag(p_batch_id => l_batch_id,
243: x_return_status => l_sts);
244:
245: -- no result needed

Line 383: FROM FUN_TRX_HEADERS

379: -- obtain the initiator_id and recipient_id
380:
381: SELECT initiator_id, recipient_id
382: INTO l_initiator_id, l_recipient_id
383: FROM FUN_TRX_HEADERS
384: WHERE batch_id=l_batch_id
385: AND trx_id=l_trx_id;
386:
387: -- determine the TP ID