APPS.POS_SBD_PKG dependencies on AP_SUPPLIERS

Line 2634: l_party_id ap_suppliers.party_id%TYPE;

2630: IS
2631: l_end_date DATE;
2632: l_start_date DATE;
2633: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
2634: l_party_id ap_suppliers.party_id%TYPE;
2635: l_supplier_name ap_suppliers.vendor_name%TYPE;
2636: l_supplier_number ap_suppliers.segment1%TYPE;
2637: l_msg_count NUMBER;
2638: l_msg_data varchar(2000);

Line 2635: l_supplier_name ap_suppliers.vendor_name%TYPE;

2631: l_end_date DATE;
2632: l_start_date DATE;
2633: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
2634: l_party_id ap_suppliers.party_id%TYPE;
2635: l_supplier_name ap_suppliers.vendor_name%TYPE;
2636: l_supplier_number ap_suppliers.segment1%TYPE;
2637: l_msg_count NUMBER;
2638: l_msg_data varchar(2000);
2639: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 2636: l_supplier_number ap_suppliers.segment1%TYPE;

2632: l_start_date DATE;
2633: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
2634: l_party_id ap_suppliers.party_id%TYPE;
2635: l_supplier_name ap_suppliers.vendor_name%TYPE;
2636: l_supplier_number ap_suppliers.segment1%TYPE;
2637: l_msg_count NUMBER;
2638: l_msg_data varchar(2000);
2639: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2640:

Line 2686: FROM ap_suppliers

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