880: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
881: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
882: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
883: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
884: i_instrtype IN iby_accttype.instrtype%type )
885: IS
886:
887: BEGIN
888:
943: * Function: to make sure given instrument type is supported by payee
944: */
945:
946: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
947: i_instr_type iby_accttype.instrtype%type)
948: IS
949: l_instr_type iby_accttype.instrtype%type;
950: l_fin_payee_flag iby_payee.financing_payee_flag%type;
951:
945:
946: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
947: i_instr_type iby_accttype.instrtype%type)
948: IS
949: l_instr_type iby_accttype.instrtype%type;
950: l_fin_payee_flag iby_payee.financing_payee_flag%type;
951:
952: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
953: ci_instr_type iby_accttype.instrtype%type)
949: l_instr_type iby_accttype.instrtype%type;
950: l_fin_payee_flag iby_payee.financing_payee_flag%type;
951:
952: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
953: ci_instr_type iby_accttype.instrtype%type)
954: IS
955:
956: SELECT instrtype FROM iby_accttype a, iby_accppmtmthd b
957: WHERE a.accttypeid = b.accttypeid
952: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
953: ci_instr_type iby_accttype.instrtype%type)
954: IS
955:
956: SELECT instrtype FROM iby_accttype a, iby_accppmtmthd b
957: WHERE a.accttypeid = b.accttypeid
958: AND b.payeeid = ci_payeeid
959: AND b.status = 1
960: AND a.instrtype = ci_instr_type;
1065:
1066:
1067: -- Get payment scheme name for given bep based on instrtype
1068: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,
1069: i_instrtype IN iby_accttype.instrtype%type,
1070: o_pmtschemename OUT NOCOPY
1071: iby_pmtschemes.pmtschemename%type)
1072: IS
1073: