eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_BEPINFO

Line 133: bep_type IBY_BEPINFO.bep_type%TYPE,

129: auth_cust_account_id IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID%TYPE,
130: auth_acct_site_use_id IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID%TYPE,
131: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,
132: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
133: bep_type IBY_BEPINFO.bep_type%TYPE,
134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,

Line 4451: lx_bep_id iby_bepinfo.bepid%TYPE;

4447: rec_limit NUMBER := 1000;
4448:
4449: -- routing out parameters
4450:
4451: lx_bep_id iby_bepinfo.bepid%TYPE;
4452: lx_process_profile iby_fndcpt_user_cc_pf_b.USER_CC_PROFILE_CODE %TYPE;
4453: lx_bep_key iby_bepkeys.key%TYPE;
4454: l_routing_failure BOOLEAN;
4455: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || 'Create_Settlements(2)';

Line 4482: CURSOR c_setup(ci_bepid iby_bepinfo.bepid%TYPE,

4478: AND TX.TRXNMID=CORE.TRXNMID
4479: AND TX.TRXNTYPEID=2
4480: AND TX.STATUS=0;
4481:
4482: CURSOR c_setup(ci_bepid iby_bepinfo.bepid%TYPE,
4483: ci_issuer IBY_CREDITCARD_ISSUERS_B.CARD_ISSUER_CODE%TYPE
4484: )
4485: IS
4486: SELECT NVL(B.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') BEP_FLAG,

Line 4488: FROM IBY_BEPINFO B, IBY_CREDITCARD_ISSUERS_B I

4484: )
4485: IS
4486: SELECT NVL(B.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') BEP_FLAG,
4487: NVL(i.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') card_issuer_flag
4488: FROM IBY_BEPINFO B, IBY_CREDITCARD_ISSUERS_B I
4489: WHERE B.BEPID=ci_bepid
4490: AND I.CARD_ISSUER_CODE=ci_issuer;
4491:
4492: BEGIN

Line 4793: IBY_BEPINFO bep,

4789: IBY_TRXN_SUMMARIES_ALL auth,
4790: IBY_FNDCPT_TX_OPERATIONS trxnop,
4791: IBY_TRXN_SUMMARIES_ALL captures,
4792: IBY_EXTERNAL_PAYERS_ALL auth_payer,
4793: IBY_BEPINFO bep,
4794: IBY_FNDCPT_USER_EFT_PF_B eft_user,
4795: IBY_FNDCPT_SYS_EFT_PF_B eft_sys,
4796: CE_BANK_ACCOUNTS int_ba,
4797: --CE_BANK_BRANCHES_V branch

Line 4893: lx_bep_lang iby_bepinfo.nls_language%TYPE;

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;
4895: lx_payee_passwd iby_payee.password%TYPE;
4896: lx_payee_opt NUMBER;
4897: lx_bep_suffix iby_bepinfo.suffix%TYPE;

Line 4897: lx_bep_suffix iby_bepinfo.suffix%TYPE;

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;
4900: lx_bep_username iby_bepinfo.bepusername%TYPE;
4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;

Line 4898: lx_bep_url iby_bepinfo.baseurl%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;
4900: lx_bep_username iby_bepinfo.bepusername%TYPE;
4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4902: lx_bep_security NUMBER;

Line 4900: lx_bep_username iby_bepinfo.bepusername%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;
4900: lx_bep_username iby_bepinfo.bepusername%TYPE;
4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4902: lx_bep_security NUMBER;
4903: lx_bep_setinit NUMBER;
4904: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;

Line 4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;

4897: lx_bep_suffix iby_bepinfo.suffix%TYPE;
4898: lx_bep_url iby_bepinfo.baseurl%TYPE;
4899: lx_bep_pmtscheme iby_pmtschemes.pmtschemename%TYPE;
4900: lx_bep_username iby_bepinfo.bepusername%TYPE;
4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4902: lx_bep_security NUMBER;
4903: lx_bep_setinit NUMBER;
4904: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;
4905: lx_bep_type iby_bepinfo.bep_type%TYPE;

Line 4904: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;

4900: lx_bep_username iby_bepinfo.bepusername%TYPE;
4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4902: lx_bep_security NUMBER;
4903: lx_bep_setinit NUMBER;
4904: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;
4905: lx_bep_type iby_bepinfo.bep_type%TYPE;
4906: lx_countrycode VARCHAR2(2);
4907: BEGIN
4908:

Line 4905: lx_bep_type iby_bepinfo.bep_type%TYPE;

4901: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4902: lx_bep_security NUMBER;
4903: lx_bep_setinit NUMBER;
4904: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;
4905: lx_bep_type iby_bepinfo.bep_type%TYPE;
4906: lx_countrycode VARCHAR2(2);
4907: BEGIN
4908:
4909: --13997087: ROUTING RULES USING "PAYER BANK COUNTRY" CRITERION ON PAYEE SCREEN DOESN'T WORK

Line 5128: FROM iby_bepinfo b, iby_creditcard_issuers_b i

5124: G_LEVEL_STATEMENT,l_module_name);
5125:
5126: SELECT DECODE(b.auth_reversal_flag, 'M', DECODE(i.auth_reversal_flag,'M','Y','N'), 'N')
5127: INTO l_rev_allowed
5128: FROM iby_bepinfo b, iby_creditcard_issuers_b i
5129: WHERE b.bepid = l_settlement_trxn_rec.auth_bepid
5130: AND i.card_issuer_code = l_settlement_trxn_rec.auth_instrsubtype;
5131:
5132: iby_debug_pub.add('l_rev_allowed = '|| l_rev_allowed, G_LEVEL_STATEMENT,l_module_name);

Line 6150: iby_bepinfo bep,

6146: iby_fndcpt_tx_operations op,
6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,
6151: iby_creditcard_issuers_b brand
6152: WHERE (xt.trxn_extension_id = ci_extension_id)
6153: AND (xt.trxn_extension_id = op.trxn_extension_id)
6154: AND (op.transactionid = auth.transactionid)