DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_PMTSCHEMES

Line 45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
45: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
46: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
47: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
48: x_security_out OUT NOCOPY NUMBER,
49: x_setnoinit_flag_out OUT NOCOPY NUMBER,

Line 133: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

129: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
130: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
131: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
132: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
133: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
134: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
135: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
136: x_security_out OUT NOCOPY NUMBER,
137: x_setnoinit_flag_out OUT NOCOPY NUMBER,

Line 478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

474: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
475: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
479: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
480: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
481: x_security_out OUT NOCOPY NUMBER,
482: x_setnoinit_flag_out OUT NOCOPY NUMBER,

Line 952: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

948: PROCEDURE getBepBySuffix
949: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
950: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
951: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
952: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
953: i_instrtype IN iby_accttype.instrtype%type )
954: IS
955:
956: BEGIN

Line 1141: iby_pmtschemes.pmtschemename%type)

1137: -- Get payment scheme name for given bep based on instrtype
1138: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,
1139: i_instrtype IN iby_accttype.instrtype%type,
1140: o_pmtschemename OUT NOCOPY
1141: iby_pmtschemes.pmtschemename%type)
1142: IS
1143:
1144: l_scheme_not_found BOOLEAN := TRUE;
1145: l_bankpay_bep VARCHAR2(10);

Line 1149: ci_name1 iby_pmtschemes.pmtschemename%type,

1145: l_bankpay_bep VARCHAR2(10);
1146: l_trxn_bep VARCHAR2(10);
1147:
1148: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1149: ci_name1 iby_pmtschemes.pmtschemename%type,
1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1152: IS
1153: SELECT p.PmtSchemename

Line 1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,

1146: l_trxn_bep VARCHAR2(10);
1147:
1148: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1149: ci_name1 iby_pmtschemes.pmtschemename%type,
1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1152: IS
1153: SELECT p.PmtSchemename
1154: FROM iby_pmtschemes p, iby_bepinfo b

Line 1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)

1147:
1148: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1149: ci_name1 iby_pmtschemes.pmtschemename%type,
1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1152: IS
1153: SELECT p.PmtSchemename
1154: FROM iby_pmtschemes p, iby_bepinfo b
1155: WHERE p.bepid = b.bepid

Line 1154: FROM iby_pmtschemes p, iby_bepinfo b

1150: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1151: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1152: IS
1153: SELECT p.PmtSchemename
1154: FROM iby_pmtschemes p, iby_bepinfo b
1155: WHERE p.bepid = b.bepid
1156: AND b.bepid = ci_bepid
1157: AND p.PMTSCHEMENAME IN (ci_name1, ci_name2, ci_name3);
1158:

Line 1218: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,

1214:
1215:
1216: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
1217: i_payment_op IN VARCHAR2,
1218: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
1219: i_suffix IN iby_bepinfo.suffix%type,
1220: o_bep_url OUT NOCOPY VARCHAR2)
1221: IS
1222: BEGIN