DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_BEPKEYS

Line 44: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,

40: x_payee_operation_out OUT NOCOPY NUMBER,
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,

Line 132: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,

128: x_payee_operation_out OUT NOCOPY NUMBER,
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,

Line 472: p_payee_id IN iby_bepkeys.OwnerId%TYPE,

468:
469: END listbep;
470:
471: PROCEDURE listbep (
472: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
473: p_bepkey IN iby_bepkeys.KEY%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,

Line 473: p_bepkey IN iby_bepkeys.KEY%TYPE,

469: END listbep;
470:
471: PROCEDURE listbep (
472: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
473: p_bepkey IN iby_bepkeys.KEY%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,

Line 508: FROM iby_bepkeys

504: -- do not modify setnoninit_flag as it is used only for the SET protocol
505:
506: SELECT count(Key)
507: INTO l_key_count
508: FROM iby_bepkeys
509: WHERE (OwnerId = p_payee_id) AND (BEPId = x_bepid_out) AND (Key = p_bepkey);
510: --
511: -- safeguard from the user providing a wrong bep key
512: --

Line 1247: o_bepkey OUT NOCOPY iby_bepkeys.key%type,

1243:
1244: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
1245: i_payeeid IN iby_payee.payeeid%type,
1246: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1247: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1248: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2)
1249: IS
1250: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)
1251: IS

Line 1279: o_bepkey OUT NOCOPY iby_bepkeys.key%type,

1275:
1276: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1277: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1278: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1279: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1280: o_fndcpt_user_profile_code OUT NOCOPY
1281: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE)
1282: IS
1283: -- *** R12 Modification *** ---

Line 1292: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c

1288: IS
1289: SELECT a.bepid,
1290: c.key,
1291: a.fndcpt_user_profile_code
1292: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
1293: WHERE a.payment_channel_code = ci_payment_channel_code
1294: AND a.mpayeeid = ci_mpayeeid
1295: AND a.bepid = b.bepid
1296: AND UPPER(b.activeStatus) = 'Y'