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 175: x_payer_id OUT NOCOPY iby_external_payers_all.ext_payer_id%TYPE,

171: (
172: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
173: p_validation_level IN VARCHAR2,
174: x_payer_level OUT NOCOPY VARCHAR2,
175: x_payer_id OUT NOCOPY iby_external_payers_all.ext_payer_id%TYPE,
176: x_payer_attribs OUT NOCOPY PayerAttributes_rec_type
177: )
178: IS
179:

Line 190: FROM iby_external_payers_all

186: ci_org_id IN p_payer.Org_Id%TYPE,
187: ci_payer_level IN VARCHAR2)
188: IS
189: SELECT ext_payer_id, bank_charge_bearer_code, dirdeb_instruction_code
190: FROM iby_external_payers_all
191: WHERE (payment_function = ci_pmt_function)
192: AND (party_id = ci_party_id)
193: AND ((cust_account_id = ci_account_id)
194: OR (cust_account_id IS NULL AND ci_account_id IS NULL))

Line 272: SELECT iby_external_payers_all_s.nextval

268: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
269: x_response.Result_Code := l_payer_level;
270: ELSIF (x_payer_attribs_id IS NULL) THEN
271:
272: SELECT iby_external_payers_all_s.nextval
273: INTO x_payer_attribs_id
274: FROM dual;
275:
276: INSERT INTO iby_external_payers_all

Line 276: INSERT INTO iby_external_payers_all

272: SELECT iby_external_payers_all_s.nextval
273: INTO x_payer_attribs_id
274: FROM dual;
275:
276: INSERT INTO iby_external_payers_all
277: (ext_payer_id, payment_function, party_id, org_type, org_id,
278: cust_account_id, acct_site_use_id, bank_charge_bearer_code,
279: dirdeb_instruction_code, created_by, creation_date, last_updated_by,
280: last_update_date, last_update_login, object_version_number

Line 296: UPDATE iby_external_payers_all

292: AND (p_payer_attributes.Bank_Charge_Bearer IS NULL)
293: )
294: THEN
295:
296: UPDATE iby_external_payers_all
297: SET
298: dirdeb_instruction_code =
299: DECODE(p_payer_attributes.DirectDebit_BankInstruction,
300: FND_API.G_MISS_CHAR,NULL, dirdeb_instruction_code),

Line 606: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

602: IS
603: l_api_version CONSTANT NUMBER := 1.0;
604: l_module CONSTANT VARCHAR2(30) := 'Set_Payer_Default_Pmt_Channel';
605: l_payer_level VARCHAR2(30);
606: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
607: l_payer_attribs PayerAttributes_rec_type;
608:
609: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
610: l_prev_msg_count NUMBER;

Line 776: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

772: IS
773: l_api_version CONSTANT NUMBER := 1.0;
774: l_module CONSTANT VARCHAR2(30) := 'Get_Payer_Default_Pmt_Channel';
775: l_payer_level VARCHAR2(30);
776: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
777: l_payer_attribs PayerAttributes_rec_type;
778: l_prev_msg_count NUMBER;
779:
780: CURSOR c_chnnl_assign

Line 891: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

887: IS
888: l_api_version CONSTANT NUMBER := 1.0;
889: l_module CONSTANT VARCHAR2(30) := 'Get_Trxn_Appl_Pmt_Channels';
890: l_payer_level VARCHAR2(30);
891: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
892: l_payer_attribs PayerAttributes_rec_type;
893: l_prev_msg_count NUMBER;
894:
895: l_channel_count NUMBER;

Line 915: FROM iby_external_payers_all

911: AND (pm.payment_flow = G_PMT_FLOW_FNDCPT)
912: AND pm.ext_pmt_party_id IN
913: (
914: SELECT ext_payer_id
915: FROM iby_external_payers_all
916: WHERE (payment_function = ci_payer.Payment_Function)
917: AND (party_id = ci_payer.Party_Id)
918: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
919: (ci_payer.org_type, ci_payer.org_id,

Line 1027: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1023: IS
1024: l_api_version CONSTANT NUMBER := 1.0;
1025: l_module CONSTANT VARCHAR2(30) := 'Set_Payer_Instr_Assignment';
1026: l_payer_level VARCHAR2(30);
1027: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1028: l_payer_attribs PayerAttributes_rec_type;
1029: l_prev_msg_count NUMBER;
1030:
1031: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 1327: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1323: IS
1324: l_api_version CONSTANT NUMBER := 1.0;
1325: l_module CONSTANT VARCHAR2(30) := 'Get_Payer_Instr_Assignments';
1326: l_payer_level VARCHAR2(30);
1327: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1328: l_payer_attribs PayerAttributes_rec_type;
1329: l_assign_count NUMBER := 0;
1330: l_prev_msg_count NUMBER;
1331:

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

1447:
1448: l_instr_count NUMBER := 0;
1449:
1450: CURSOR c_instr_assignments
1451: (ci_party_id IN iby_external_payers_all.party_id%TYPE)
1452: IS
1453: SELECT DISTINCT u.instrument_type, u.instrument_id
1454: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p
1455: WHERE (u.payment_flow = G_PMT_FLOW_FNDCPT)

Line 1454: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p

1450: CURSOR c_instr_assignments
1451: (ci_party_id IN iby_external_payers_all.party_id%TYPE)
1452: IS
1453: SELECT DISTINCT u.instrument_type, u.instrument_id
1454: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p
1455: WHERE (u.payment_flow = G_PMT_FLOW_FNDCPT)
1456: AND (u.ext_pmt_party_id = p.ext_payer_id)
1457: AND (p.party_id = ci_party_id);
1458:

Line 1565: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

1561: l_module CONSTANT VARCHAR2(30) := 'Get_Trxn_Appl_Instr_Assign';
1562: l_prev_msg_count NUMBER;
1563:
1564: l_payer_level VARCHAR2(30);
1565: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1566: l_payer_attribs PayerAttributes_rec_type;
1567:
1568: l_assign_count NUMBER;
1569:

Line 1589: FROM iby_external_payers_all

1585: AND sysdate >= start_date
1586: AND sysdate < NVL(end_date, sysdate+1)
1587: AND ext_pmt_party_id IN
1588: (SELECT ext_payer_id
1589: FROM iby_external_payers_all
1590: WHERE (payment_function = ci_payer.Payment_Function)
1591: AND (party_id = ci_payer.Party_Id)
1592: AND (IBY_FNDCPT_COMMON_PUB.Compare_Payer
1593: (ci_payer.org_type, ci_payer.org_id,

Line 2835: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;

2831: )
2832: IS
2833:
2834: l_payer_level VARCHAR2(30);
2835: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2836: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2837:
2838: CURSOR l_payer_attr_cur (
2839: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2845: FROM iby_external_payers_all p

2841: ci_payer_equiv IN VARCHAR2
2842: )
2843: IS
2844: SELECT bank_charge_bearer_code, dirdeb_instruction_code
2845: FROM iby_external_payers_all p
2846: WHERE p.party_id = ci_payer.Party_Id
2847: AND IBY_FNDCPT_COMMON_PUB.Compare_Payer
2848: (ci_payer.org_type, ci_payer.org_id,
2849: ci_payer.Cust_Account_Id, ci_payer.Account_Site_Id,