76: l_tmid iby_trxn_summaries_all.mtangibleid%type;
77:
78: l_instrid iby_trxn_summaries_all.payerinstrid%type;
79:
80: l_mpayeeid iby_payee.mpayeeid%type;
81:
82: BEGIN
83:
84: -- First check if this request is not duplicate
229: l_mid NUMBER;
230: l_status NUMBER := 0014;
231: l_tmid iby_trxn_summaries_all.mtangibleid%type;
232: l_instrid iby_trxn_summaries_all.payerinstrid%type;
233: l_mpayeeid iby_payee.mpayeeid%type;
234: BEGIN
235: -- Get the master transaction id sequence for all requests
236:
237: SELECT iby_trxnsumm_mid_s.NEXTVAL
297: i_schedDate iby_batches_all.batchopendate%type)
298: IS
299: -- 0011 indicates PENDING status
300: l_status NUMBER := 0011;
301: l_mpayeeid iby_payee.mpayeeid%type;
302: l_mbatchid iby_batches_all.mbatchid%type;
303:
304: BEGIN
305: -- call procedure to check if this is duplicate request
389: l_tid NUMBER;
390: -- 0011 indicates PENDING status
391: l_status NUMBER := 0011;
392:
393: l_mpayeeid iby_payee.mpayeeid%type;
394: l_mbatchid iby_batches_all.mbatchid%type;
395: BEGIN
396: --if (upper(i_reqtype) = 'ORAPMTREQ') then
397: --if ( isPayeeRegistered(i_payeeid, i_bepid ) = false ) then
498: IS
499: l_mid NUMBER;
500: l_status NUMBER := 0011;
501:
502: l_mpayeeid iby_payee.mpayeeid%type;
503: BEGIN
504: -- Get the master transaction id sequence for all requests
505:
506: SELECT iby_trxnsumm_mid_s.NEXTVAL
570: l_tid NUMBER;
571: -- 0011 indicates PENDING status
572: l_status NUMBER := 0011;
573:
574: l_mpayeeid iby_payee.mpayeeid%type;
575: l_mbatchid iby_batches_all.mbatchid%type;
576: BEGIN
577: -- First check if this request is not duplicate
578: if (requestExists(i_payeeid,i_tangibleid, i_reqtype,i_bepid)) then
670: i_nlslang iby_batches_all.nlslang%type,
671: i_terminalid iby_batches_all.terminalid%type)
672: IS
673:
674: l_mpayeeid iby_payee.mpayeeid%type;
675: l_mbatchid iby_batches_all.mbatchid%type;
676: BEGIN
677: -- call procedure to check if this is duplicate request
678: if (batchExists(i_payeeid, i_batchid, i_reqtype)) then