DBA Data[Home] [Help]

APPS.AP_VENDOR_SITES_PKG dependencies on AP_SUPPLIERS

Line 1661: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE; --Bug15966842

1657: current_calling_sequence varchar2(2000);
1658: debug_info varchar2(100);
1659: vendor_site_old po_vendor_sites.vendor_site_code%TYPE;
1660: total_sites number;
1661: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE; --Bug15966842
1662:
1663: BEGIN
1664: -- Update the calling sequence
1665: --

Line 1703: FROM ap_suppliers

1699:
1700: --Bug15966842
1701: SELECT vendor_type_lookup_code
1702: INTO l_vendor_type_lookup_code
1703: FROM ap_suppliers
1704: WHERE vendor_id = X_Vendor_Id;
1705: --Bug15966842
1706:
1707: debug_info := 'Update ap_supplier_sites';

Line 1882: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE; --Bug15966842

1878: ) IS
1879:
1880: current_calling_sequence varchar2(2000);
1881: debug_info varchar2(100);
1882: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE; --Bug15966842
1883: BEGIN
1884:
1885: debug_info := 'Update ap_supplier_sites';
1886:

Line 1903: FROM ap_suppliers

1899:
1900: --Bug15966842
1901: SELECT vendor_type_lookup_code
1902: INTO l_vendor_type_lookup_code
1903: FROM ap_suppliers
1904: WHERE vendor_id = p_vendor_site_rec.Vendor_Id;
1905: --Bug15966842
1906:
1907: UPDATE ap_supplier_sites_all