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 1199: l_party_id ap_suppliers.party_id%TYPE;

1195: l_dup_acct_id number;
1196: l_dup_start_date date;
1197: l_dup_end_date date;
1198: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1199: l_party_id ap_suppliers.party_id%TYPE;
1200: l_supplier_name ap_suppliers.vendor_name%TYPE;
1201: l_supplier_number ap_suppliers.segment1%TYPE;
1202:
1203: -- picks up branch number

Line 1200: l_supplier_name ap_suppliers.vendor_name%TYPE;

1196: l_dup_start_date date;
1197: l_dup_end_date date;
1198: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1199: l_party_id ap_suppliers.party_id%TYPE;
1200: l_supplier_name ap_suppliers.vendor_name%TYPE;
1201: l_supplier_number ap_suppliers.segment1%TYPE;
1202:
1203: -- picks up branch number
1204: CURSOR c_branch (p_branch_id NUMBER) IS

Line 1201: l_supplier_number ap_suppliers.segment1%TYPE;

1197: l_dup_end_date date;
1198: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1199: l_party_id ap_suppliers.party_id%TYPE;
1200: l_supplier_name ap_suppliers.vendor_name%TYPE;
1201: l_supplier_number ap_suppliers.segment1%TYPE;
1202:
1203: -- picks up branch number
1204: CURSOR c_branch (p_branch_id NUMBER) IS
1205: SELECT bank_or_branch_number

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

1324: fnd_msg_pub.add;
1325: OPEN c_supplier(l_dup_acct_id);
1326: FETCH c_supplier INTO l_party_id;
1327: IF l_party_id IS NOT NULL THEN
1328: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1329: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1330: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1331: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1332: fnd_msg_pub.add;

Line 1936: l_party_id ap_suppliers.party_id%TYPE;

1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1933: l_dup_acct_id number;
1934: l_dup_start_date date;
1935: l_dup_end_date date;
1936: l_party_id ap_suppliers.party_id%TYPE;
1937: l_supplier_name ap_suppliers.vendor_name%TYPE;
1938: l_supplier_number ap_suppliers.segment1%TYPE;
1939:
1940:

Line 1937: l_supplier_name ap_suppliers.vendor_name%TYPE;

1933: l_dup_acct_id number;
1934: l_dup_start_date date;
1935: l_dup_end_date date;
1936: l_party_id ap_suppliers.party_id%TYPE;
1937: l_supplier_name ap_suppliers.vendor_name%TYPE;
1938: l_supplier_number ap_suppliers.segment1%TYPE;
1939:
1940:
1941: -- Get Object Version Number

Line 1938: l_supplier_number ap_suppliers.segment1%TYPE;

1934: l_dup_start_date date;
1935: l_dup_end_date date;
1936: l_party_id ap_suppliers.party_id%TYPE;
1937: l_supplier_name ap_suppliers.vendor_name%TYPE;
1938: l_supplier_number ap_suppliers.segment1%TYPE;
1939:
1940:
1941: -- Get Object Version Number
1942: CURSOR c_ovn (p_acct_id NUMBER) IS

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

2272: fnd_msg_pub.add;
2273: OPEN c_supplier(l_dup_acct_id);
2274: FETCH c_supplier INTO l_party_id;
2275: IF l_party_id IS NOT NULL THEN
2276: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2277: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2278: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2279: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2280: fnd_msg_pub.add;

Line 4708: FROM ap_suppliers

4704: x_vendor_id OUT NOCOPY NUMBER) IS
4705: BEGIN
4706: SELECT vendor_id
4707: INTO x_vendor_id
4708: FROM ap_suppliers
4709: WHERE party_id = p_party_id
4710: AND rownum = 1;
4711:
4712: EXCEPTION