DBA Data[Home] [Help]

APPS.IBY_QUERYSET_PKG dependencies on IBY_BEPINFO

Line 16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,

12: (merchant_id_in IN IBY_Payee.PayeeID%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: split_id_in IN iby_trxn_extended.SplitID%TYPE,
15: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,

Line 292: v_id IN OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,

288: /* -- no longer supported
289: PROCEDURE getVendorByPmtName
290: (payment_name_in IN iby_routinginfo.PaymentMethodName%TYPE,
291: p_id IN OUT NOCOPY iby_routinginfo.PaymentMethodID%TYPE,
292: v_id IN OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
293: v_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,
294: v_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
295: v_pmtscheme IN OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE)
296: IS

Line 293: v_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,

289: PROCEDURE getVendorByPmtName
290: (payment_name_in IN iby_routinginfo.PaymentMethodName%TYPE,
291: p_id IN OUT NOCOPY iby_routinginfo.PaymentMethodID%TYPE,
292: v_id IN OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
293: v_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,
294: v_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
295: v_pmtscheme IN OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE)
296: IS
297: BEGIN

Line 294: v_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

290: (payment_name_in IN iby_routinginfo.PaymentMethodName%TYPE,
291: p_id IN OUT NOCOPY iby_routinginfo.PaymentMethodID%TYPE,
292: v_id IN OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
293: v_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,
294: v_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
295: v_pmtscheme IN OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE)
296: IS
297: BEGIN
298:

Line 302: FROM iby_bepinfo BEP, iby_routinginfo ROUT

298:
299: -- Get bep info based on paymentmethod name
300: SELECT ROUT.bepid , BEP.baseurl, BEP.suffix
301: INTO v_id, v_base_url, v_suffix
302: FROM iby_bepinfo BEP, iby_routinginfo ROUT
303: WHERE UPPER(ROUT.paymentmethodname) = UPPER(payment_name_in)
304: AND BEP.bepid = ROUT.bepid
305: AND ROUT.configured = 1;
306: