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_DISBURSEMENT_SETUP_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 36: insert into IBY_EXTERNAL_PAYEES_ALL (

32: print_debuginfo(l_module_name, 'ENTER');
33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: insert into IBY_EXTERNAL_PAYEES_ALL (
37: EXT_PAYEE_ID,
38: PAYEE_PARTY_ID,
39: PAYMENT_FUNCTION,
40: EXCLUSIVE_PAYMENT_FLAG,

Line 105: print_debuginfo(l_module_name, 'Exception while insertion into iby_external_payees_all. ');

101: print_debuginfo(l_module_name, 'RETURN');
102:
103: exception
104: when others then
105: print_debuginfo(l_module_name, 'Exception while insertion into iby_external_payees_all. ');
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107:
108: end insert_payee_row;
109:

Line 240: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE

236: PROCEDURE Get_Payee_Id (
237: p_payee_context IN PayeeContext_rec_type,
238: p_validation_level IN VARCHAR2,
239: x_payee_level OUT NOCOPY VARCHAR2,
240: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE
241: )
242: IS
243:
244: CURSOR c_payee

Line 253: FROM iby_external_payees_all payee

249: ci_org_id IN p_payee_context.Org_Id%TYPE,
250: ci_pmt_function IN p_payee_context.Payment_Function%TYPE)
251: IS
252: SELECT ext_payee_id
253: FROM iby_external_payees_all payee
254: WHERE payee.PAYEE_PARTY_ID = ci_party_id
255: AND payee.PAYMENT_FUNCTION = ci_pmt_function
256: AND ((ci_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
257: (payee.PARTY_SITE_ID = ci_party_site_id))

Line 372: FROM iby_external_payees_all payee

368: p_payer_org_type VARCHAR2,
369: p_payment_function VARCHAR2)
370: IS
371: SELECT count(payee.EXT_PAYEE_ID), max(payee.EXT_PAYEE_ID)
372: FROM iby_external_payees_all payee
373: WHERE payee.PAYEE_PARTY_ID = p_payee_party_id
374: AND payee.PAYMENT_FUNCTION = p_payment_function
375: AND ((p_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
376: (payee.PARTY_SITE_ID = p_party_site_id))

Line 501: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_ext_payee_id from dual;

497: print_debuginfo(l_module_name, 'Payee count is ' || l_payee_cnt);
498: print_debuginfo(l_module_name, 'Payee Id is ' || l_payee_id);
499:
500: IF l_payee_cnt = 0 THEN
501: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_ext_payee_id from dual;
502: insert_payee_row(l_ext_payee_id,
503: p_ext_payee_tab(counter),
504: l_payee_crt_status);
505:

Line 654: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;

650: l_module CONSTANT VARCHAR2(30) := 'Set_Payee_Instr_Assignment';
651: l_prev_msg_count NUMBER;
652:
653: l_payee_level VARCHAR2(30);
654: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;
655:
656: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
657:
658: l_assign_id NUMBER;

Line 725: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_payee_id from dual;

721: -- create the payee entity if it does not exist
722: IF (l_payee_id IS NULL) THEN
723: -- Create a default external payee
724: print_debuginfo(l_module,'Inside if l_payee_id is null, trying to insert in external_payees_all ');
725: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_payee_id from dual;
726:
727: l_ext_payee_rec.Payee_Party_Id := p_payee.Party_Id;
728: l_ext_payee_rec.Payee_Party_Site_Id := p_payee.Party_Site_id;
729: l_ext_payee_rec.Supplier_Site_Id := p_payee.Supplier_Site_id;

Line 937: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;

933: l_module CONSTANT VARCHAR2(30) := 'Get_Payer_Instr_Assignments';
934: l_prev_msg_count NUMBER;
935:
936: l_payee_level VARCHAR2(30);
937: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;
938:
939: l_assign_count NUMBER := 0;
940:
941: CURSOR c_instr_assignments

Line 1079: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)

1075:
1076: l_instr_count NUMBER := 0;
1077:
1078: CURSOR c_instr_assignments
1079: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
1080: IS
1081: SELECT DISTINCT u.instrument_type, u.instrument_id
1082: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p
1083: WHERE (u.payment_flow = G_PMT_FLOW_DISBURSE)

Line 1082: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p

1078: CURSOR c_instr_assignments
1079: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
1080: IS
1081: SELECT DISTINCT u.instrument_type, u.instrument_id
1082: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p
1083: WHERE (u.payment_flow = G_PMT_FLOW_DISBURSE)
1084: AND (u.ext_pmt_party_id = p.ext_payee_id)
1085: AND (p.payee_party_id = ci_party_id);
1086:

Line 2238: FROM iby_external_payees_all payee

2234: p_payer_org_type VARCHAR2,
2235: p_payment_function VARCHAR2)
2236: IS
2237: SELECT count(payee.EXT_PAYEE_ID), max(payee.EXT_PAYEE_ID)
2238: FROM iby_external_payees_all payee
2239: WHERE payee.PAYEE_PARTY_ID = p_payee_party_id
2240: AND payee.PAYMENT_FUNCTION = p_payment_function
2241: AND ((p_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
2242: (payee.PARTY_SITE_ID = p_party_site_id))

Line 2373: UPDATE iby_external_payees_all

2369: x_return_status := FND_API.G_RET_STS_ERROR;
2370:
2371: ELSE
2372: -- update external payee
2373: UPDATE iby_external_payees_all
2374: SET exclusive_payment_flag = p_ext_payee_tab(counter).exclusive_pay_flag,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_date = trunc(sysdate),
2377: last_update_login = fnd_global.user_id,