DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_BEPINFO

Line 120: bep_type IBY_BEPINFO.bep_type%TYPE,

116: auth_cust_account_id IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID%TYPE,
117: auth_acct_site_use_id IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID%TYPE,
118: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,
119: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
120: bep_type IBY_BEPINFO.bep_type%TYPE,
121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,

Line 3656: lx_bep_id iby_bepinfo.bepid%TYPE;

3652: rec_limit NUMBER := 1000;
3653:
3654: -- routing out parameters
3655:
3656: lx_bep_id iby_bepinfo.bepid%TYPE;
3657: lx_process_profile iby_fndcpt_user_cc_pf_b.USER_CC_PROFILE_CODE %TYPE;
3658: lx_bep_key iby_bepkeys.key%TYPE;
3659: l_routing_failure BOOLEAN;
3660:

Line 3956: IBY_BEPINFO bep,

3952: IBY_TRXN_SUMMARIES_ALL auth,
3953: IBY_FNDCPT_TX_OPERATIONS trxnop,
3954: IBY_TRXN_SUMMARIES_ALL captures,
3955: IBY_EXTERNAL_PAYERS_ALL auth_payer,
3956: IBY_BEPINFO bep,
3957: IBY_FNDCPT_USER_EFT_PF_B eft_user,
3958: IBY_FNDCPT_SYS_EFT_PF_B eft_sys,
3959: CE_BANK_ACCOUNTS int_ba,
3960: --CE_BANK_BRANCHES_V branch

Line 4051: lx_bep_lang iby_bepinfo.nls_language%TYPE;

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;
4053: lx_payee_passwd iby_payee.password%TYPE;
4054: lx_payee_opt NUMBER;
4055: lx_bep_suffix iby_bepinfo.suffix%TYPE;

Line 4055: lx_bep_suffix iby_bepinfo.suffix%TYPE;

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

Line 4056: lx_bep_url iby_bepinfo.baseurl%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;
4058: lx_bep_username iby_bepinfo.bepusername%TYPE;
4059: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4060: lx_bep_security NUMBER;

Line 4058: lx_bep_username iby_bepinfo.bepusername%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;
4058: lx_bep_username iby_bepinfo.bepusername%TYPE;
4059: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4060: lx_bep_security NUMBER;
4061: lx_bep_setinit NUMBER;
4062: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;

Line 4059: lx_bep_passwd iby_bepinfo.beppassword%TYPE;

4055: lx_bep_suffix iby_bepinfo.suffix%TYPE;
4056: lx_bep_url iby_bepinfo.baseurl%TYPE;
4057: lx_bep_pmtscheme iby_pmtschemes.pmtschemename%TYPE;
4058: lx_bep_username iby_bepinfo.bepusername%TYPE;
4059: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4060: lx_bep_security NUMBER;
4061: lx_bep_setinit NUMBER;
4062: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;
4063: lx_bep_type iby_bepinfo.bep_type%TYPE;

Line 4062: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;

4058: lx_bep_username iby_bepinfo.bepusername%TYPE;
4059: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4060: lx_bep_security NUMBER;
4061: lx_bep_setinit NUMBER;
4062: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;
4063: lx_bep_type iby_bepinfo.bep_type%TYPE;
4064: BEGIN
4065:
4066: IBY_PAYMENTMANAGERDB_PKG.LISTBEP

Line 4063: lx_bep_type iby_bepinfo.bep_type%TYPE;

4059: lx_bep_passwd iby_bepinfo.beppassword%TYPE;
4060: lx_bep_security NUMBER;
4061: lx_bep_setinit NUMBER;
4062: lx_bep_leadtime iby_bepinfo.leadtime%TYPE;
4063: lx_bep_type iby_bepinfo.bep_type%TYPE;
4064: BEGIN
4065:
4066: IBY_PAYMENTMANAGERDB_PKG.LISTBEP
4067: (l_settlement_trxn_rec.SETTLEMENT_AMOUNT,