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_SETUP_PUB dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 264: x_payer_id OUT NOCOPY iby_external_payers_all.ext_payer_id%TYPE,

260: (
261: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
262: p_validation_level IN VARCHAR2,
263: x_payer_level OUT NOCOPY VARCHAR2,
264: x_payer_id OUT NOCOPY iby_external_payers_all.ext_payer_id%TYPE,
265: x_payer_attribs OUT NOCOPY PayerAttributes_rec_type
266: )
267: IS
268:

Line 279: FROM iby_external_payers_all

275: ci_org_id IN p_payer.Org_Id%TYPE,
276: ci_payer_level IN VARCHAR2)
277: IS
278: SELECT ext_payer_id, bank_charge_bearer_code, dirdeb_instruction_code
279: FROM iby_external_payers_all
280: WHERE (payment_function = ci_pmt_function)
281: AND (party_id = ci_party_id)
282: AND ((cust_account_id = ci_account_id)
283: OR (cust_account_id IS NULL AND ci_account_id IS NULL))

Line 361: SELECT iby_external_payers_all_s.nextval

357: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
358: x_response.Result_Code := l_payer_level;
359: ELSIF (x_payer_attribs_id IS NULL) THEN
360:
361: SELECT iby_external_payers_all_s.nextval
362: INTO x_payer_attribs_id
363: FROM dual;
364:
365: INSERT INTO iby_external_payers_all

Line 365: INSERT INTO iby_external_payers_all

361: SELECT iby_external_payers_all_s.nextval
362: INTO x_payer_attribs_id
363: FROM dual;
364:
365: INSERT INTO iby_external_payers_all
366: (ext_payer_id, payment_function, party_id, org_type, org_id,
367: cust_account_id, acct_site_use_id, bank_charge_bearer_code,
368: dirdeb_instruction_code, created_by, creation_date, last_updated_by,
369: last_update_date, last_update_login, object_version_number,

Line 383: UPDATE iby_external_payers_all

379: fnd_global.login_id, 1 ,p_payer.Debit_Advice_Delivery_Method,
380: p_payer.Debit_Advice_Email, p_payer.Debit_Advice_Fax
381: );
382: ELSE
383: UPDATE iby_external_payers_all
384: SET
385: dirdeb_instruction_code =
386: DECODE(p_payer_attributes.DirectDebit_BankInstruction,
387: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.DirectDebit_BankInstruction),

Line 696: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

692: IS
693: l_api_version CONSTANT NUMBER := 1.0;
694: l_module CONSTANT VARCHAR2(30) := 'Set_Payer_Default_Pmt_Channel';
695: l_payer_level VARCHAR2(30);
696: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
697: l_payer_attribs PayerAttributes_rec_type;
698:
699: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
700: l_prev_msg_count NUMBER;

Line 866: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

862: IS
863: l_api_version CONSTANT NUMBER := 1.0;
864: l_module CONSTANT VARCHAR2(30) := 'Get_Payer_Default_Pmt_Channel';
865: l_payer_level VARCHAR2(30);
866: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
867: l_payer_attribs PayerAttributes_rec_type;
868: l_prev_msg_count NUMBER;
869:
870: CURSOR c_chnnl_assign

Line 981: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

977: IS
978: l_api_version CONSTANT NUMBER := 1.0;
979: l_module CONSTANT VARCHAR2(30) := 'Get_Trxn_Appl_Pmt_Channels';
980: l_payer_level VARCHAR2(30);
981: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
982: l_payer_attribs PayerAttributes_rec_type;
983: l_prev_msg_count NUMBER;
984:
985: l_channel_count NUMBER;

Line 1005: FROM iby_external_payers_all

1001: AND (pm.payment_flow = G_PMT_FLOW_FNDCPT)
1002: AND pm.ext_pmt_party_id IN
1003: (
1004: SELECT ext_payer_id
1005: FROM iby_external_payers_all
1006: WHERE (payment_function = ci_payer.Payment_Function)
1007: AND (party_id = ci_payer.Party_Id)
1008: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
1009: (ci_payer.org_type, ci_payer.org_id,

Line 1117: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1113: IS
1114: l_api_version CONSTANT NUMBER := 1.0;
1115: l_module CONSTANT VARCHAR2(30) := 'Set_Payer_Instr_Assignment';
1116: l_payer_level VARCHAR2(30);
1117: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1118: l_payer_attribs PayerAttributes_rec_type;
1119: l_prev_msg_count NUMBER;
1120:
1121: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 1510: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1506: IS
1507: l_api_version CONSTANT NUMBER := 1.0;
1508: l_module CONSTANT VARCHAR2(30) := 'Get_Payer_Instr_Assignments';
1509: l_payer_level VARCHAR2(30);
1510: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1511: l_payer_attribs PayerAttributes_rec_type;
1512: l_assign_count NUMBER := 0;
1513: l_prev_msg_count NUMBER;
1514:

Line 1634: (ci_party_id IN iby_external_payers_all.party_id%TYPE)

1630:
1631: l_instr_count NUMBER := 0;
1632:
1633: CURSOR c_instr_assignments
1634: (ci_party_id IN iby_external_payers_all.party_id%TYPE)
1635: IS
1636: SELECT DISTINCT u.instrument_type, u.instrument_id
1637: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p
1638: WHERE (u.payment_flow = G_PMT_FLOW_FNDCPT)

Line 1637: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p

1633: CURSOR c_instr_assignments
1634: (ci_party_id IN iby_external_payers_all.party_id%TYPE)
1635: IS
1636: SELECT DISTINCT u.instrument_type, u.instrument_id
1637: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p
1638: WHERE (u.payment_flow = G_PMT_FLOW_FNDCPT)
1639: AND (u.ext_pmt_party_id = p.ext_payer_id)
1640: AND (p.party_id = ci_party_id);
1641:

Line 1748: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1744: l_module CONSTANT VARCHAR2(30) := 'Get_Trxn_Appl_Instr_Assign';
1745: l_prev_msg_count NUMBER;
1746:
1747: l_payer_level VARCHAR2(30);
1748: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1749: l_payer_attribs PayerAttributes_rec_type;
1750:
1751: l_assign_count NUMBER;
1752:

Line 1782: IBY_EXTERNAL_PAYERS_ALL payer

1778: RANK() OVER (PARTITION BY INSTRUMENT_TYPE, INSTRUMENT_ID
1779: ORDER BY ACCT_SITE_USE_ID, CUST_ACCOUNT_ID,ORDER_OF_PREFERENCE,INSTRUMENT_PAYMENT_USE_ID) DUP_RANK
1780: FROM
1781: IBY_PMT_INSTR_USES_ALL inst,
1782: IBY_EXTERNAL_PAYERS_ALL payer
1783: WHERE
1784: (inst.PAYMENT_FLOW = G_PMT_FLOW_FNDCPT)
1785: AND inst.INSTRUMENT_TYPE = NVL(ci_instrument_type ,INSTRUMENT_TYPE)
1786: AND SYSDATE >= inst.START_DATE

Line 3127: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

3123: )
3124: IS
3125:
3126: l_payer_level VARCHAR2(30);
3127: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3128: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3129:
3130: CURSOR l_payer_attr_cur (
3131: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 3137: FROM iby_external_payers_all p

3133: ci_payer_equiv IN VARCHAR2
3134: )
3135: IS
3136: SELECT bank_charge_bearer_code, dirdeb_instruction_code
3137: FROM iby_external_payers_all p
3138: WHERE p.party_id = ci_payer.Party_Id
3139: AND IBY_FNDCPT_COMMON_PUB.Compare_Payer
3140: (ci_payer.org_type, ci_payer.org_id,
3141: ci_payer.Cust_Account_Id, ci_payer.Account_Site_Id,