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_EXTERNAL_PAYERS_ALL

Line 49: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

45: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
46: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
47: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
48: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
49: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
50: -- From the ORDERS View
51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,

Line 61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
59: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
60: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,

Line 127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 129: auth_cust_account_id IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID%TYPE,

125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 130: auth_acct_site_use_id IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID%TYPE,

126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 131: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,

127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 132: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,

128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 166: l_party_id iby_external_payers_all.party_id%TYPE;

162: RETURN VARCHAR2
163: IS
164: l_msg VARCHAR2(100);
165: l_payer_id iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE;
166: l_party_id iby_external_payers_all.party_id%TYPE;
167:
168: l_count NUMBER;
169:
170: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Payer_Instr_Assgn_Fail';

Line 209: FROM iby_external_payers_all

205:
206: l_msg := 'IBY_20491';
207: SELECT party_id
208: INTO l_party_id
209: FROM iby_external_payers_all
210: WHERE (ext_payer_id = l_payer_id);
211:
212: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
213: iby_debug_pub.add('external payer count:=' || SQL%ROWCOUNT,G_LEVEL_STATEMENT,l_dbg_mod);

Line 731: FROM iby_external_payers_all

727: AND (pm.payment_flow = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
728: AND pm.ext_pmt_party_id IN
729: (
730: SELECT ext_payer_id
731: FROM iby_external_payers_all
732: WHERE (payment_function = ci_payer.Payment_Function)
733: AND (party_id = ci_payer.Party_Id)
734: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
735: (ci_payer.org_type, ci_payer.org_id,

Line 904: FROM iby_external_payers_all

900: (instr_assignment_id = ci_instr_assign)
901: AND ext_payer_id IN
902: (
903: SELECT ext_payer_id
904: FROM iby_external_payers_all
905: WHERE (payment_function = ci_payer.Payment_Function)
906: AND (party_id = ci_payer.Party_Id)
907: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
908: (ci_payer.org_type, ci_payer.org_id,

Line 1043: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1039: l_module CONSTANT VARCHAR2(30) := 'Create_Transaction_Extension';
1040: l_prev_msg_count NUMBER;
1041:
1042: l_payer_level VARCHAR2(30);
1043: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1044: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1045:
1046: l_msg_count NUMBER;
1047: l_msg_data VARCHAR2(300);

Line 1387: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1383: l_module CONSTANT VARCHAR2(30) := 'Update_Transaction_Extension';
1384: l_prev_msg_count NUMBER;
1385:
1386: l_payer_level VARCHAR2(30);
1387: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1388: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1389:
1390: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1391: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;

Line 1424: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p

1420: SELECT
1421: x.trxn_extension_id, x.payment_channel_code, x.instr_assignment_id,
1422: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
1423: x.origin_application_id, x.instr_code_sec_segment_id
1424: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p
1425: WHERE (x.ext_payer_id = p.ext_payer_id)
1426: AND (x.trxn_extension_id = ci_extension_id)
1427: AND (p.party_id = ci_payer.Party_Id)
1428: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer

Line 1828: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1824: l_module CONSTANT VARCHAR2(30) := 'Get_Transaction_Extension';
1825: l_prev_msg_count NUMBER;
1826:
1827: l_payer_level VARCHAR2(30);
1828: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1829: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1830:
1831: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1832:

Line 1985: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1981: l_module CONSTANT VARCHAR2(30) := 'Delete_Transaction_Extension';
1982: l_prev_msg_count NUMBER;
1983:
1984: l_payer_level VARCHAR2(30);
1985: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1986: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1987:
1988: l_extension_id NUMBER;
1989: l_copy_count NUMBER;

Line 2001: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,

1997: ci_payer_equiv IN VARCHAR2
1998: )
1999: IS
2000: SELECT x.trxn_extension_id
2001: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,
2002: iby_pmt_instr_uses_all i
2003: WHERE (x.trxn_extension_id = ci_extension_id)
2004: AND (x.instr_assignment_id = i.instrument_payment_use_id(+))
2005: AND (NVL(x.ext_payer_id,i.ext_pmt_party_id) = p.ext_payer_id)

Line 2171: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

2167: l_module CONSTANT VARCHAR2(30) := 'Copy_Transaction_Extension';
2168: l_prev_msg_count NUMBER;
2169:
2170: l_payer_level VARCHAR2(30);
2171: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2172: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2173:
2174: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
2175: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;

Line 2228: iby_pmt_instr_uses_all cpi, iby_external_payers_all p

2224: x.voice_authorization_flag, x.voice_authorization_code,
2225: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id,
2226: x.payment_system_order_number
2227: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
2228: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
2229: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
2230: -- bug 11675835 - kept an outer join for instrument details
2231: -- can assume this assignment is for funds capture
2232: -- bug 7017004 - use the payer information on the trxn extension

Line 2804: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

2800: l_module CONSTANT VARCHAR2(30) := 'Create_Authorization';
2801: l_prev_msg_count NUMBER;
2802:
2803: l_payer_level VARCHAR2(30);
2804: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2805: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2806:
2807: l_copy_count NUMBER;
2808: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

Line 2860: iby_external_payers_all p, fnd_application a,

2856: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2857: x.voice_authorization_date, i.card_single_use_flag,
2858: NVL(x.instr_assignment_id,0), x.payment_channel_code
2859: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2860: iby_external_payers_all p, fnd_application a,
2861: iby_fndcpt_pmt_chnnls_b pc
2862: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2863: AND (x.payment_channel_code = pc.payment_channel_code)
2864: AND (x.origin_application_id = a.application_id)

Line 3778: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

3774: l_module CONSTANT VARCHAR2(30) := 'Create_Settlement';
3775: l_prev_msg_count NUMBER;
3776:
3777: l_payer_level VARCHAR2(30);
3778: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3779: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3780:
3781: l_extension_count NUMBER;
3782: l_transactionid iby_fndcpt_tx_operations.transactionid%TYPE;

Line 3825: iby_external_payers_all p, fnd_application a,

3821: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
3822: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3823: x.payment_channel_code
3824: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3825: iby_external_payers_all p, fnd_application a,
3826: iby_fndcpt_pmt_chnnls_b pc
3827: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3828: AND (x.payment_channel_code = pc.payment_channel_code)
3829: -- can assume this assignment is for funds capture

Line 4788: IBY_EXTERNAL_PAYERS_ALL payer,

4784: auth_trxn_core.card_subtype_code card_subtype_code,
4785: auth_trxn_core.card_data_level card_data_level
4786: FROM '||l_view_name||' orders,
4787: IBY_FNDCPT_TX_EXTENSIONS trxnext,
4788: IBY_EXTERNAL_PAYERS_ALL payer,
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,

Line 4792: IBY_EXTERNAL_PAYERS_ALL auth_payer,

4788: IBY_EXTERNAL_PAYERS_ALL payer,
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,

Line 5615: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

5611: l_module CONSTANT VARCHAR2(30) := 'Create_Return';
5612: l_prev_msg_count NUMBER;
5613: l_rec_mth_id NUMBER;
5614: l_payer_level VARCHAR2(30);
5615: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
5616: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
5617: l_settled_flag VARCHAR2(1);
5618: l_returned_flag VARCHAR2(1);
5619: l_extension_found BOOLEAN;

Line 5660: iby_external_payers_all p,

5656: x.payment_channel_code
5657: FROM iby_trxn_extensions_v x,
5658: iby_fndcpt_tx_extensions xt,
5659: -- iby_pmt_instr_uses_all i,
5660: iby_external_payers_all p,
5661: fnd_application a
5662: -- [lmallick] - Validate the payer context against the payer
5663: -- stamped on the extension. Not the assignment.
5664: WHERE --(x.instr_assignment_id = i.instrument_payment_use_id)

Line 6060: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

6056: l_api_version CONSTANT NUMBER := 1.0;
6057: l_prev_msg_count NUMBER;
6058:
6059: l_payer_level VARCHAR2(30);
6060: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
6061: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
6062: l_instrtype IBY_FNDCPT_PMT_CHNNLS_B.instrument_type%TYPE;
6063: l_encrypted VARCHAR2(1);
6064: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;

Line 6121: iby_external_payers_all p,

6117: a.application_short_name, xt.payment_channel_code,
6118: xt.instrument_security_code, xt.encrypted,
6119: xt.instr_code_sec_segment_id, xt.instr_sec_code_length
6120: FROM iby_fndcpt_tx_extensions xt,
6121: iby_external_payers_all p,
6122: fnd_application a,
6123: iby_fndcpt_pmt_chnnls_b chnl
6124: WHERE (xt.origin_application_id = a.application_id)
6125: AND (xt.EXT_PAYER_ID = p.ext_payer_id)