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 35: l_remit_advice_delivery_method IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;

31: l_module_name VARCHAR2(100) := G_PKG_NAME || 'insert_payee_row';
32:
33: --bug 10374184
34:
35: l_remit_advice_delivery_method IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
36: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
37: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.REMIT_ADVICE_FAX%TYPE;
38:
39: CURSOR ar_refund_payee_csr(p_payee_party_id NUMBER,

Line 36: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;

32:
33: --bug 10374184
34:
35: l_remit_advice_delivery_method IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
36: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
37: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.REMIT_ADVICE_FAX%TYPE;
38:
39: CURSOR ar_refund_payee_csr(p_payee_party_id NUMBER,
40: p_party_site_id NUMBER,

Line 37: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.REMIT_ADVICE_FAX%TYPE;

33: --bug 10374184
34:
35: l_remit_advice_delivery_method IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE;
36: l_remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE;
37: l_remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.REMIT_ADVICE_FAX%TYPE;
38:
39: CURSOR ar_refund_payee_csr(p_payee_party_id NUMBER,
40: p_party_site_id NUMBER,
41: p_payer_org_id NUMBER,

Line 98: insert into IBY_EXTERNAL_PAYEES_ALL (

94: END IF;
95:
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: insert into IBY_EXTERNAL_PAYEES_ALL (
99: EXT_PAYEE_ID,
100: PAYEE_PARTY_ID,
101: PAYMENT_FUNCTION,
102: EXCLUSIVE_PAYMENT_FLAG,

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

169: END IF;
170: exception
171: when others then
172: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
173: print_debuginfo(l_module_name, 'Exception while insertion into iby_external_payees_all. ');
174: END IF;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: end insert_payee_row;

Line 330: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE

326: PROCEDURE Get_Payee_Id (
327: p_payee_context IN PayeeContext_rec_type,
328: p_validation_level IN VARCHAR2,
329: x_payee_level OUT NOCOPY VARCHAR2,
330: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE
331: )
332: IS
333:
334: CURSOR c_payee

Line 343: FROM iby_external_payees_all payee

339: ci_org_id IN p_payee_context.Org_Id%TYPE,
340: ci_pmt_function IN p_payee_context.Payment_Function%TYPE)
341: IS
342: SELECT ext_payee_id
343: FROM iby_external_payees_all payee
344: WHERE payee.PAYEE_PARTY_ID = ci_party_id
345: AND payee.PAYMENT_FUNCTION = ci_pmt_function
346: AND ((ci_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
347: (payee.PARTY_SITE_ID = ci_party_site_id))

Line 467: FROM iby_external_payees_all payee

463: p_payer_org_type VARCHAR2,
464: p_payment_function VARCHAR2)
465: IS
466: SELECT count(payee.EXT_PAYEE_ID), max(payee.EXT_PAYEE_ID)
467: FROM iby_external_payees_all payee
468: WHERE payee.PAYEE_PARTY_ID = p_payee_party_id
469: AND payee.PAYMENT_FUNCTION = p_payment_function
470: AND ((p_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
471: (payee.PARTY_SITE_ID = p_party_site_id))

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

664:
665: END IF;
666:
667: IF l_payee_cnt = 0 THEN
668: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_ext_payee_id from dual;
669: insert_payee_row(l_ext_payee_id,
670: l_ext_payee_tab(counter),
671: l_payee_crt_status);
672:

Line 837: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;

833: l_module CONSTANT VARCHAR2(30) := 'Set_Payee_Instr_Assignment';
834: l_prev_msg_count NUMBER;
835:
836: l_payee_level VARCHAR2(30);
837: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;
838:
839: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
840:
841: l_assign_id NUMBER;

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

940: -- create the payee entity if it does not exist
941: IF (l_payee_id IS NULL) THEN
942: -- Create a default external payee
943: print_debuginfo(l_module,'Inside if l_payee_id is null, trying to insert in external_payees_all ');
944: select IBY_EXTERNAL_PAYEES_ALL_S.nextval into l_payee_id from dual;
945:
946: l_ext_payee_rec.Payee_Party_Id := p_payee.Party_Id;
947: l_ext_payee_rec.Payee_Party_Site_Id := p_payee.Party_Site_id;
948: l_ext_payee_rec.Supplier_Site_Id := p_payee.Supplier_Site_id;

Line 1200: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;

1196: l_module CONSTANT VARCHAR2(30) := 'Get_Payer_Instr_Assignments';
1197: l_prev_msg_count NUMBER;
1198:
1199: l_payee_level VARCHAR2(30);
1200: l_payee_id iby_external_payees_all.ext_payee_id%TYPE;
1201:
1202: l_assign_count NUMBER := 0;
1203:
1204: CURSOR c_instr_assignments

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

1338:
1339: l_instr_count NUMBER := 0;
1340:
1341: CURSOR c_instr_assignments
1342: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
1343: IS
1344: SELECT DISTINCT u.instrument_type, u.instrument_id
1345: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p
1346: WHERE (u.payment_flow = G_PMT_FLOW_DISBURSE)

Line 1345: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p

1341: CURSOR c_instr_assignments
1342: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
1343: IS
1344: SELECT DISTINCT u.instrument_type, u.instrument_id
1345: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p
1346: WHERE (u.payment_flow = G_PMT_FLOW_DISBURSE)
1347: AND (u.ext_pmt_party_id = p.ext_payee_id)
1348: AND (p.payee_party_id = ci_party_id);
1349:

Line 2748: FROM iby_external_payees_all payee

2744: p_payer_org_type VARCHAR2,
2745: p_payment_function VARCHAR2)
2746: IS
2747: SELECT count(payee.EXT_PAYEE_ID), max(payee.EXT_PAYEE_ID)
2748: FROM iby_external_payees_all payee
2749: WHERE payee.PAYEE_PARTY_ID = p_payee_party_id
2750: AND payee.PAYMENT_FUNCTION = p_payment_function
2751: AND ((p_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
2752: (payee.PARTY_SITE_ID = p_party_site_id))

Line 2903: UPDATE iby_external_payees_all

2899: x_return_status := FND_API.G_RET_STS_ERROR;
2900:
2901: ELSE
2902: -- update external payee
2903: UPDATE iby_external_payees_all
2904: SET exclusive_payment_flag = p_ext_payee_tab(counter).exclusive_pay_flag,
2905: last_updated_by = fnd_global.user_id,
2906: last_update_date = SYSDATE, -- bug 13881024
2907: last_update_login = fnd_global.user_id,