APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_ROUTINGINFO

Line 528: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,

524: -- Though Payment Channel Code will be the driving parameter in the Procedure
525: -- listbep, keeping the the instrument type and instrument subtype as the driving
526: -- parameters in the main query below
527: --- *** --
528: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
529: p_instrtype iby_routinginfo.instr_type%TYPE,
530: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE) IS
531: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
532: WHERE a.configured = 1

Line 529: p_instrtype iby_routinginfo.instr_type%TYPE,

525: -- listbep, keeping the the instrument type and instrument subtype as the driving
526: -- parameters in the main query below
527: --- *** --
528: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
529: p_instrtype iby_routinginfo.instr_type%TYPE,
530: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE) IS
531: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
532: WHERE a.configured = 1
533: -- Once financing supports multiple payees, the payee condition should

Line 530: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE) IS

526: -- parameters in the main query below
527: --- *** --
528: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
529: p_instrtype iby_routinginfo.instr_type%TYPE,
530: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE) IS
531: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
532: WHERE a.configured = 1
533: -- Once financing supports multiple payees, the payee condition should
534: -- be changed from 'like' back to '='

Line 531: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a

527: --- *** --
528: CURSOR c_routingRules (p_payeeid iby_routinginfo.payeeid%TYPE,
529: p_instrtype iby_routinginfo.instr_type%TYPE,
530: p_instr_subtype iby_routinginfo.instr_sub_type%TYPE) IS
531: SELECT a.paymentmethodname, a.paymentmethodid FROM iby_routinginfo a
532: WHERE a.configured = 1
533: -- Once financing supports multiple payees, the payee condition should
534: -- be changed from 'like' back to '='
535: -- AND a.payeeid = p_payeeid

Line 541: CURSOR c_ruleCondt(p_key iby_routinginfo.paymentmethodid%TYPE) IS

537: AND a.instr_type = p_instrtype
538: AND NVL(a.instr_sub_type, ' ') = NVL(p_instr_subtype, ' ')
539: ORDER BY a.priority;
540:
541: CURSOR c_ruleCondt(p_key iby_routinginfo.paymentmethodid%TYPE) IS
542: SELECT * FROM iby_pmtmthd_conditions x
543: WHERE x.paymentmethodid = p_key order by x.entry_sequence ;
544:
545: BEGIN

Line 839: FROM iby_routinginfo

835:
836: -- increment the hitCounter for this rule before leaving this method.
837: SELECT hitcounter
838: INTO l_hitcounter
839: FROM iby_routinginfo
840: WHERE paymentmethodname = px_pmt_name_in_out;
841:
842: l_hitcounter := NVL(l_hitcounter,0) + 1;
843:

Line 844: UPDATE iby_routinginfo

840: WHERE paymentmethodname = px_pmt_name_in_out;
841:
842: l_hitcounter := NVL(l_hitcounter,0) + 1;
843:
844: UPDATE iby_routinginfo
845: SET hitcounter = l_hitcounter
846: WHERE paymentmethodname = px_pmt_name_in_out;
847: COMMIT;
848:

Line 1183: FROM iby_routinginfo r, iby_bepinfo b

1179: IS
1180: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)
1181: IS
1182: SELECT b.bepid, r.bepkey, r.fndcpt_user_profile_code
1183: FROM iby_routinginfo r, iby_bepinfo b
1184: WHERE r.paymentmethodname = ci_paymentmethodname
1185: AND r.configured = 1
1186: AND r.bepid = b.bepid;
1187: