APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_PAYEE

Line 436: RETURN iby_payee.payeeid%TYPE

432: --
433: -- Use: Gets the internal payee id from a payee context
434: --
435: FUNCTION Get_Internal_Payee(p_payee IN PayeeContext_rec_type)
436: RETURN iby_payee.payeeid%TYPE
437: IS
438: l_payeeid iby_payee.payeeid%TYPE;
439:
440: CURSOR c_payeeid

Line 438: l_payeeid iby_payee.payeeid%TYPE;

434: --
435: FUNCTION Get_Internal_Payee(p_payee IN PayeeContext_rec_type)
436: RETURN iby_payee.payeeid%TYPE
437: IS
438: l_payeeid iby_payee.payeeid%TYPE;
439:
440: CURSOR c_payeeid
441: (ci_org_type IN iby_fndcpt_payee_appl.org_type%TYPE,
442: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE

Line 446: FROM iby_payee p, iby_fndcpt_payee_appl a

442: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE
443: )
444: IS
445: SELECT p.payeeid
446: FROM iby_payee p, iby_fndcpt_payee_appl a
447: WHERE (p.mpayeeid = a.mpayeeid)
448: AND ((a.org_type = ci_org_type) AND (a.org_id = ci_org_id));
449:
450: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Internal_Payee';

Line 4890: lx_payeeid iby_payee.payeeid%TYPE;

4886: print_debuginfo(l_module_name, 'rerouting trxn:=' ||
4887: l_settlement_trxn_rec.TRXNMID);
4888:
4889: DECLARE
4890: lx_payeeid iby_payee.payeeid%TYPE;
4891: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4892: lx_pmt_name VARCHAR2(100);
4893: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4894: lx_payee_user_name iby_payee.username%TYPE;

Line 4894: lx_payee_user_name iby_payee.username%TYPE;

4890: lx_payeeid iby_payee.payeeid%TYPE;
4891: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4892: lx_pmt_name VARCHAR2(100);
4893: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4894: lx_payee_user_name iby_payee.username%TYPE;
4895: lx_payee_passwd iby_payee.password%TYPE;
4896: lx_payee_opt NUMBER;
4897: lx_bep_suffix iby_bepinfo.suffix%TYPE;
4898: lx_bep_url iby_bepinfo.baseurl%TYPE;

Line 4895: lx_payee_passwd iby_payee.password%TYPE;

4891: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4892: lx_pmt_name VARCHAR2(100);
4893: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4894: lx_payee_user_name iby_payee.username%TYPE;
4895: lx_payee_passwd iby_payee.password%TYPE;
4896: lx_payee_opt NUMBER;
4897: lx_bep_suffix iby_bepinfo.suffix%TYPE;
4898: lx_bep_url iby_bepinfo.baseurl%TYPE;
4899: lx_bep_pmtscheme iby_pmtschemes.pmtschemename%TYPE;