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 131: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,

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

Line 454: p_payee_id IN iby_bepkeys.OwnerId%TYPE,

450:
451: END listbep;
452:
453: PROCEDURE listbep (
454: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
455: p_bepkey IN iby_bepkeys.KEY%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,

Line 455: p_bepkey IN iby_bepkeys.KEY%TYPE,

451: END listbep;
452:
453: PROCEDURE listbep (
454: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
455: p_bepkey IN iby_bepkeys.KEY%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,

Line 490: FROM iby_bepkeys

486: -- do not modify setnoninit_flag as it is used only for the SET protocol
487:
488: SELECT count(Key)
489: INTO l_key_count
490: FROM iby_bepkeys
491: WHERE (OwnerId = p_payee_id) AND (BEPId = x_bepid_out) AND (Key = p_bepkey);
492: --
493: -- safeguard from the user providing a wrong bep key
494: --

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

1173:
1174: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
1175: i_payeeid IN iby_payee.payeeid%type,
1176: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1177: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1178: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2)
1179: IS
1180: CURSOR c_getBepIdByPmtName(ci_paymentmethodname VARCHAR2)
1181: IS

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

1205:
1206: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1207: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1208: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1209: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1210: o_fndcpt_user_profile_code OUT NOCOPY
1211: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE)
1212: IS
1213: -- *** R12 Modification *** ---

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

1218: IS
1219: SELECT a.bepid,
1220: c.key,
1221: a.fndcpt_user_profile_code
1222: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
1223: WHERE a.payment_channel_code = ci_payment_channel_code
1224: AND a.mpayeeid = ci_mpayeeid
1225: AND a.bepid = b.bepid
1226: AND UPPER(b.activeStatus) = 'Y'