[Home] [Help]
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
387: l_tid NUMBER;
388: -- 0011 indicates PENDING status
389: l_status NUMBER := 0011;
390:
391: l_mpayeeid iby_payee.mpayeeid%type;
392: l_mbatchid iby_batches_all.mbatchid%type;
393: BEGIN
394: --if (upper(i_reqtype) = 'ORAPMTREQ') then
395: --if ( isPayeeRegistered(i_payeeid, i_bepid ) = false ) then
496: IS
497: l_mid NUMBER;
498: l_status NUMBER := 0011;
499:
500: l_mpayeeid iby_payee.mpayeeid%type;
501: BEGIN
502: -- Get the master transaction id sequence for all requests
503:
504: SELECT iby_trxnsumm_mid_s.NEXTVAL
568: l_tid NUMBER;
569: -- 0011 indicates PENDING status
570: l_status NUMBER := 0011;
571:
572: l_mpayeeid iby_payee.mpayeeid%type;
573: l_mbatchid iby_batches_all.mbatchid%type;
574: BEGIN
575: -- First check if this request is not duplicate
576: if (requestExists(i_payeeid,i_tangibleid, i_reqtype,i_bepid)) then
668: i_nlslang iby_batches_all.nlslang%type,
669: i_terminalid iby_batches_all.terminalid%type)
670: IS
671:
672: l_mpayeeid iby_payee.mpayeeid%type;
673: l_mbatchid iby_batches_all.mbatchid%type;
674: BEGIN
675: -- call procedure to check if this is duplicate request
676: if (batchExists(i_payeeid, i_batchid, i_reqtype)) then