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_EXT_BANKACCT_PUB dependencies on AP_SUPPLIERS

Line 1329: l_party_id ap_suppliers.party_id%TYPE;

1325: l_dup_acct_id number;
1326: l_dup_start_date date;
1327: l_dup_end_date date;
1328: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1329: l_party_id ap_suppliers.party_id%TYPE;
1330: l_supplier_name ap_suppliers.vendor_name%TYPE;
1331: l_supplier_number ap_suppliers.segment1%TYPE;
1332:
1333: l_error_msg VARCHAR2(500);

Line 1330: l_supplier_name ap_suppliers.vendor_name%TYPE;

1326: l_dup_start_date date;
1327: l_dup_end_date date;
1328: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1329: l_party_id ap_suppliers.party_id%TYPE;
1330: l_supplier_name ap_suppliers.vendor_name%TYPE;
1331: l_supplier_number ap_suppliers.segment1%TYPE;
1332:
1333: l_error_msg VARCHAR2(500);
1334: l_ret_stat VARCHAR2(1);

Line 1331: l_supplier_number ap_suppliers.segment1%TYPE;

1327: l_dup_end_date date;
1328: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1329: l_party_id ap_suppliers.party_id%TYPE;
1330: l_supplier_name ap_suppliers.vendor_name%TYPE;
1331: l_supplier_number ap_suppliers.segment1%TYPE;
1332:
1333: l_error_msg VARCHAR2(500);
1334: l_ret_stat VARCHAR2(1);
1335: l_org_id iby_external_payees_all.org_id%TYPE;

Line 1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;

1482: fnd_msg_pub.add;
1483: /*OPEN c_supplier(l_dup_acct_id);
1484: FETCH c_supplier INTO l_party_id;
1485: IF l_party_id IS NOT NULL THEN
1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1487: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1488: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1489: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1490: fnd_msg_pub.add;

Line 2277: l_party_id ap_suppliers.party_id%TYPE;

2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2274: l_dup_acct_id number;
2275: l_dup_start_date date;
2276: l_dup_end_date date;
2277: l_party_id ap_suppliers.party_id%TYPE;
2278: l_supplier_name ap_suppliers.vendor_name%TYPE;
2279: l_supplier_number ap_suppliers.segment1%TYPE;
2280:
2281: l_error_msg VARCHAR2(500);

Line 2278: l_supplier_name ap_suppliers.vendor_name%TYPE;

2274: l_dup_acct_id number;
2275: l_dup_start_date date;
2276: l_dup_end_date date;
2277: l_party_id ap_suppliers.party_id%TYPE;
2278: l_supplier_name ap_suppliers.vendor_name%TYPE;
2279: l_supplier_number ap_suppliers.segment1%TYPE;
2280:
2281: l_error_msg VARCHAR2(500);
2282: l_ret_stat VARCHAR2(1);

Line 2279: l_supplier_number ap_suppliers.segment1%TYPE;

2275: l_dup_start_date date;
2276: l_dup_end_date date;
2277: l_party_id ap_suppliers.party_id%TYPE;
2278: l_supplier_name ap_suppliers.vendor_name%TYPE;
2279: l_supplier_number ap_suppliers.segment1%TYPE;
2280:
2281: l_error_msg VARCHAR2(500);
2282: l_ret_stat VARCHAR2(1);
2283: l_org_id iby_external_payees_all.org_id%TYPE;

Line 2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;

2680: fnd_msg_pub.add;
2681: /*OPEN c_supplier(l_dup_acct_id);
2682: FETCH c_supplier INTO l_party_id;
2683: IF l_party_id IS NOT NULL THEN
2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2685: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2686: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2687: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2688: fnd_msg_pub.add;

Line 5546: FROM ap_suppliers

5542: x_vendor_id OUT NOCOPY NUMBER) IS
5543: BEGIN
5544: SELECT vendor_id
5545: INTO x_vendor_id
5546: FROM ap_suppliers
5547: WHERE party_id = p_party_id
5548: AND rownum = 1;
5549:
5550: EXCEPTION