APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_PAYEE

Line 305: RETURN iby_payee.payeeid%TYPE

301: --
302: -- Use: Gets the internal payee id from a payee context
303: --
304: FUNCTION Get_Internal_Payee(p_payee IN PayeeContext_rec_type)
305: RETURN iby_payee.payeeid%TYPE
306: IS
307: l_payeeid iby_payee.payeeid%TYPE;
308:
309: CURSOR c_payeeid

Line 307: l_payeeid iby_payee.payeeid%TYPE;

303: --
304: FUNCTION Get_Internal_Payee(p_payee IN PayeeContext_rec_type)
305: RETURN iby_payee.payeeid%TYPE
306: IS
307: l_payeeid iby_payee.payeeid%TYPE;
308:
309: CURSOR c_payeeid
310: (ci_org_type IN iby_fndcpt_payee_appl.org_type%TYPE,
311: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE

Line 315: FROM iby_payee p, iby_fndcpt_payee_appl a

311: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE
312: )
313: IS
314: SELECT p.payeeid
315: FROM iby_payee p, iby_fndcpt_payee_appl a
316: WHERE (p.mpayeeid = a.mpayeeid)
317: AND ((a.org_type = ci_org_type) AND (a.org_id = ci_org_id));
318: BEGIN
319: IF (c_payeeid%ISOPEN) THEN CLOSE c_payeeid; END IF;

Line 4048: lx_payeeid iby_payee.payeeid%TYPE;

4044: print_debuginfo(l_module_name, 'rerouting trxn:=' ||
4045: l_settlement_trxn_rec.TRXNMID);
4046:
4047: DECLARE
4048: lx_payeeid iby_payee.payeeid%TYPE;
4049: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4050: lx_pmt_name VARCHAR2(100);
4051: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4052: lx_payee_user_name iby_payee.username%TYPE;

Line 4052: lx_payee_user_name iby_payee.username%TYPE;

4048: lx_payeeid iby_payee.payeeid%TYPE;
4049: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4050: lx_pmt_name VARCHAR2(100);
4051: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4052: lx_payee_user_name iby_payee.username%TYPE;
4053: lx_payee_passwd iby_payee.password%TYPE;
4054: lx_payee_opt NUMBER;
4055: lx_bep_suffix iby_bepinfo.suffix%TYPE;
4056: lx_bep_url iby_bepinfo.baseurl%TYPE;

Line 4053: lx_payee_passwd iby_payee.password%TYPE;

4049: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4050: lx_pmt_name VARCHAR2(100);
4051: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4052: lx_payee_user_name iby_payee.username%TYPE;
4053: lx_payee_passwd iby_payee.password%TYPE;
4054: lx_payee_opt NUMBER;
4055: lx_bep_suffix iby_bepinfo.suffix%TYPE;
4056: lx_bep_url iby_bepinfo.baseurl%TYPE;
4057: lx_bep_pmtscheme iby_pmtschemes.pmtschemename%TYPE;