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 132: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

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

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

456: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
461: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
462: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
463: x_security_out OUT NOCOPY NUMBER,
464: x_setnoinit_flag_out OUT NOCOPY NUMBER,

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

879: PROCEDURE getBepBySuffix
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

Line 1071: iby_pmtschemes.pmtschemename%type)

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:
1074: l_scheme_not_found BOOLEAN := TRUE;
1075: l_bankpay_bep VARCHAR2(10);

Line 1079: ci_name1 iby_pmtschemes.pmtschemename%type,

1075: l_bankpay_bep VARCHAR2(10);
1076: l_trxn_bep VARCHAR2(10);
1077:
1078: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1079: ci_name1 iby_pmtschemes.pmtschemename%type,
1080: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1081: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1082: IS
1083: SELECT p.PmtSchemename

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

1076: l_trxn_bep VARCHAR2(10);
1077:
1078: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1079: ci_name1 iby_pmtschemes.pmtschemename%type,
1080: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1081: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1082: IS
1083: SELECT p.PmtSchemename
1084: FROM iby_pmtschemes p, iby_bepinfo b

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

1077:
1078: CURSOR c_getPmtSchemeName(ci_bepid iby_bepinfo.bepid%type,
1079: ci_name1 iby_pmtschemes.pmtschemename%type,
1080: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1081: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1082: IS
1083: SELECT p.PmtSchemename
1084: FROM iby_pmtschemes p, iby_bepinfo b
1085: WHERE p.bepid = b.bepid

Line 1084: FROM iby_pmtschemes p, iby_bepinfo b

1080: ci_name2 iby_pmtschemes.pmtschemename%type DEFAULT NULL,
1081: ci_name3 iby_pmtschemes.pmtschemename%type DEFAULT NULL)
1082: IS
1083: SELECT p.PmtSchemename
1084: FROM iby_pmtschemes p, iby_bepinfo b
1085: WHERE p.bepid = b.bepid
1086: AND b.bepid = ci_bepid
1087: AND p.PMTSCHEMENAME IN (ci_name1, ci_name2, ci_name3);
1088:

Line 1148: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,

1144:
1145:
1146: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
1147: i_payment_op IN VARCHAR2,
1148: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
1149: i_suffix IN iby_bepinfo.suffix%type,
1150: o_bep_url OUT NOCOPY VARCHAR2)
1151: IS
1152: BEGIN