315: )
316: IS
317:
318: numrows NUMBER;
319: l_mpayeeid iby_payee.mpayeeid%type;
320: l_mbatchid iby_batches_all.mbatchid%type;
321:
322: BEGIN
323:
462: )
463: IS
464:
465: numrows NUMBER;
466: l_mpayeeid iby_payee.mpayeeid%type;
467: l_mbatchid iby_batches_all.mbatchid%type;
468: l_module_name CONSTANT VARCHAR2(200) :=
469: G_PKG_NAME || '.createBatchCloseTrxnsNew';
470:
877: )
878: IS
879:
880: numrows NUMBER;
881: l_mpayeeid iby_payee.mpayeeid%type;
882: l_mbatchid iby_batches_all.mbatchid%type;
883: l_module_name CONSTANT VARCHAR2(200) :=
884: G_PKG_NAME || '.createBatchCloseTrxnsNew2';
885:
1472: )
1473: IS
1474: l_mtangibleid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1475: l_trxnmid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1476: l_mpayeeid iby_payee.mpayeeid%TYPE;
1477: l_count NUMBER;
1478:
1479: CURSOR c_trxnmid IS
1480: SELECT iby_trxnsumm_mid_s.nextval
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1737: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1739: l_mpayeeid iby_payee.mpayeeid%TYPE;
1740: l_trxn_exists VARCHAR2(1);
1741:
1742: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;
1743: l_bep_type iby_bepinfo.bep_type%TYPE;