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 36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,
34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,

Line 48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,

Line 114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 116: auth_cust_account_id IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID%TYPE,

112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 117: auth_acct_site_use_id IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID%TYPE,

113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%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,

Line 118: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,

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

Line 119: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,

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

Line 148: l_party_id iby_external_payers_all.party_id%TYPE;

144: RETURN VARCHAR2
145: IS
146: l_msg VARCHAR2(100);
147: l_payer_id iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE;
148: l_party_id iby_external_payers_all.party_id%TYPE;
149:
150: l_count NUMBER;
151:
152: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Payer_Instr_Assgn_Fail';

Line 183: FROM iby_external_payers_all

179:
180: l_msg := 'IBY_20491';
181: SELECT party_id
182: INTO l_party_id
183: FROM iby_external_payers_all
184: WHERE (ext_payer_id = l_payer_id);
185:
186: iby_debug_pub.add('external payer count:=' || SQL%ROWCOUNT,
187: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 564: FROM iby_external_payers_all

560: AND (pm.payment_flow = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
561: AND pm.ext_pmt_party_id IN
562: (
563: SELECT ext_payer_id
564: FROM iby_external_payers_all
565: WHERE (payment_function = ci_payer.Payment_Function)
566: AND (party_id = ci_payer.Party_Id)
567: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
568: (ci_payer.org_type, ci_payer.org_id,

Line 708: FROM iby_external_payers_all

704: (instr_assignment_id = ci_instr_assign)
705: AND ext_payer_id IN
706: (
707: SELECT ext_payer_id
708: FROM iby_external_payers_all
709: WHERE (payment_function = ci_payer.Payment_Function)
710: AND (party_id = ci_payer.Party_Id)
711: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
712: (ci_payer.org_type, ci_payer.org_id,

Line 826: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

822: l_module CONSTANT VARCHAR2(30) := 'Create_Transaction_Extension';
823: l_prev_msg_count NUMBER;
824:
825: l_payer_level VARCHAR2(30);
826: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
827: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
828:
829: l_msg_count NUMBER;
830: l_msg_data VARCHAR2(300);

Line 1112: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1108: l_module CONSTANT VARCHAR2(30) := 'Update_Transaction_Extension';
1109: l_prev_msg_count NUMBER;
1110:
1111: l_payer_level VARCHAR2(30);
1112: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1113: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1114:
1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;

Line 1147: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p

1143: SELECT
1144: x.trxn_extension_id, x.payment_channel_code, x.instr_assignment_id,
1145: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
1146: x.origin_application_id, x.instr_code_sec_segment_id
1147: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p
1148: WHERE (x.ext_payer_id = p.ext_payer_id)
1149: AND (x.trxn_extension_id = ci_extension_id)
1150: AND (p.party_id = ci_payer.Party_Id)
1151: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer

Line 1460: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1456: l_module CONSTANT VARCHAR2(30) := 'Get_Transaction_Extension';
1457: l_prev_msg_count NUMBER;
1458:
1459: l_payer_level VARCHAR2(30);
1460: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1461: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1462:
1463: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1464:

Line 1600: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1596: l_module CONSTANT VARCHAR2(30) := 'Delete_Transaction_Extension';
1597: l_prev_msg_count NUMBER;
1598:
1599: l_payer_level VARCHAR2(30);
1600: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1601: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1602:
1603: l_extension_id NUMBER;
1604: l_copy_count NUMBER;

Line 1616: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,

1612: ci_payer_equiv IN VARCHAR2
1613: )
1614: IS
1615: SELECT x.trxn_extension_id
1616: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,
1617: iby_pmt_instr_uses_all i
1618: WHERE (x.trxn_extension_id = ci_extension_id)
1619: AND (x.instr_assignment_id = i.instrument_payment_use_id(+))
1620: AND (NVL(x.ext_payer_id,i.ext_pmt_party_id) = p.ext_payer_id)

Line 1768: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1764: l_module CONSTANT VARCHAR2(30) := 'Copy_Transaction_Extension';
1765: l_prev_msg_count NUMBER;
1766:
1767: l_payer_level VARCHAR2(30);
1768: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1769: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1770:
1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;

Line 1811: iby_pmt_instr_uses_all cpi, iby_external_payers_all p

1807: x.instrument_security_code, x.instr_sec_code_length,
1808: x.voice_authorization_flag, x.voice_authorization_code,
1809: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id
1810: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
1811: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
1812: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
1813: -- can assume this assignment is for funds capture
1814: -- bug 7017004 - use the payer information on the trxn extension
1815: --AND (i.ext_pmt_party_id = p.ext_payer_id)

Line 2297: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

2293: l_module CONSTANT VARCHAR2(30) := 'Create_Authorization';
2294: l_prev_msg_count NUMBER;
2295:
2296: l_payer_level VARCHAR2(30);
2297: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2298: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2299:
2300: l_copy_count NUMBER;
2301: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

Line 2345: iby_external_payers_all p, fnd_application a,

2341: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2342: x.voice_authorization_date, i.card_single_use_flag,
2343: NVL(x.instr_assignment_id,0), x.payment_channel_code
2344: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2345: iby_external_payers_all p, fnd_application a,
2346: iby_fndcpt_pmt_chnnls_b pc
2347: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2348: AND (x.payment_channel_code = pc.payment_channel_code)
2349: AND (x.origin_application_id = a.application_id)

Line 3027: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

3023: l_module CONSTANT VARCHAR2(30) := 'Create_Settlement';
3024: l_prev_msg_count NUMBER;
3025:
3026: l_payer_level VARCHAR2(30);
3027: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3028: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3029:
3030: l_extension_count NUMBER;
3031: l_transactionid iby_fndcpt_tx_operations.transactionid%TYPE;

Line 3074: iby_external_payers_all p, fnd_application a,

3070: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
3071: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3072: x.payment_channel_code
3073: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3074: iby_external_payers_all p, fnd_application a,
3075: iby_fndcpt_pmt_chnnls_b pc
3076: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3077: AND (x.payment_channel_code = pc.payment_channel_code)
3078: -- can assume this assignment is for funds capture

Line 3951: IBY_EXTERNAL_PAYERS_ALL payer,

3947: orders.PAYMENT_TRXN_EXTENSION_ID) auth_count,
3948: auth.dirdeb_instruction_code auth_dirdeb_instruction_code
3949: FROM '||l_view_name||' orders,
3950: IBY_FNDCPT_TX_EXTENSIONS trxnext,
3951: IBY_EXTERNAL_PAYERS_ALL payer,
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,

Line 3955: IBY_EXTERNAL_PAYERS_ALL auth_payer,

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

Line 4538: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

4534: l_module CONSTANT VARCHAR2(30) := 'Create_Return';
4535: l_prev_msg_count NUMBER;
4536:
4537: l_payer_level VARCHAR2(30);
4538: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
4539: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
4540: l_settled_flag VARCHAR2(1);
4541: l_returned_flag VARCHAR2(1);
4542: l_extension_found BOOLEAN;

Line 4579: iby_external_payers_all p, fnd_application a

4575: x.origin_application_id, a.application_short_name,
4576: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
4577: x.payment_channel_code
4578: FROM iby_trxn_extensions_v x, iby_pmt_instr_uses_all i,
4579: iby_external_payers_all p, fnd_application a
4580: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
4581: -- can assume this assignment is for funds capture
4582: AND (x.origin_application_id = a.application_id)
4583: AND (i.ext_pmt_party_id = p.ext_payer_id)