544: -- Though Payment Channel Code will be the driving parameter in the Procedure
545: -- listbep, keeping the the instrument type and instrument subtype as the driving
546: -- parameters in the main query below
547: --- *** --
548: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
549: p_instrtype iby_routinginfo.instr_type%TYPE,
550: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE,
551: p_payment_channel_code iby_routinginfo.payment_channel_code%TYPE) IS
552: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
545: -- listbep, keeping the the instrument type and instrument subtype as the driving
546: -- parameters in the main query below
547: --- *** --
548: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
549: p_instrtype iby_routinginfo.instr_type%TYPE,
550: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE,
551: p_payment_channel_code iby_routinginfo.payment_channel_code%TYPE) IS
552: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
553: WHERE a.configured = 1
546: -- parameters in the main query below
547: --- *** --
548: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
549: p_instrtype iby_routinginfo.instr_type%TYPE,
550: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE,
551: p_payment_channel_code iby_routinginfo.payment_channel_code%TYPE) IS
552: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
553: WHERE a.configured = 1
554: -- Once financing supports multiple payees, the payee condition should
547: --- *** --
548: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
549: p_instrtype iby_routinginfo.instr_type%TYPE,
550: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE,
551: p_payment_channel_code iby_routinginfo.payment_channel_code%TYPE) IS
552: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
553: WHERE a.configured = 1
554: -- Once financing supports multiple payees, the payee condition should
555: -- be changed from 'like' back to '='
548: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
549: p_instrtype iby_routinginfo.instr_type%TYPE,
550: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE,
551: p_payment_channel_code iby_routinginfo.payment_channel_code%TYPE) IS
552: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
553: WHERE a.configured = 1
554: -- Once financing supports multiple payees, the payee condition should
555: -- be changed from 'like' back to '='
556: -- AND a.payeeid = p_payeeid
559: AND ((a.instr_sub_type IS NULL) OR (a.instr_sub_type = NVL(p_instr_subtype, ' ')))
560: AND a.payment_channel_code = p_payment_channel_code
561: ORDER BY a.priority;
562:
563: CURSOR c_ruleCondt(p_key iby_routinginfo.paymentmethodid%TYPE) IS
564: SELECT * FROM iby_pmtmthd_conditions x
565: WHERE x.paymentmethodid = p_key order by x.parameter_code,x.entry_sequence ;
566:
567: BEGIN
902: -- would retrieve two records instead of one.
903: -- So, added payment method id in the where clause.
904: SELECT hitcounter
905: INTO l_hitcounter
906: FROM iby_routinginfo
907: WHERE paymentmethodname = px_pmt_name_in_out
908: AND paymentmethodid= l_paymentmethodid;
909:
910: l_hitcounter := NVL(l_hitcounter,0) + 1;
908: AND paymentmethodid= l_paymentmethodid;
909:
910: l_hitcounter := NVL(l_hitcounter,0) + 1;
911:
912: UPDATE iby_routinginfo
913: SET hitcounter = l_hitcounter
914: WHERE paymentmethodname = px_pmt_name_in_out
915: AND paymentmethodid= l_paymentmethodid;
916: COMMIT;
1249: IS
1250: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)
1251: IS
1252: SELECT b.bepid, r.bepkey, r.fndcpt_user_profile_code
1253: FROM iby_routinginfo r, iby_bepinfo b
1254: WHERE r.paymentmethodname = ci_paymentmethodname
1255: AND r.configured = 1
1256: AND r.bepid = b.bepid;
1257: