APPS.AP_VENDOR_SITES_PKG dependencies on AP_SUPPLIER_SITES

Line 258: INSERT INTO ap_supplier_sites_all(

254: from sys.dual;
255: -- end if;
256:
257: debug_info := 'Insert values into PO_VENDOR_SITES';
258: INSERT INTO ap_supplier_sites_all(
259: vendor_site_id,
260: last_update_date,
261: last_updated_by,
262: vendor_id,

Line 577: INSERT INTO ap_supplier_sites_all(

573: from sys.dual;
574: -- end if;
575:
576: debug_info := 'Insert values into PO_VENDOR_SITES';
577: INSERT INTO ap_supplier_sites_all(
578: vendor_site_id,
579: last_update_date,
580: last_updated_by,
581: vendor_id,

Line 1020: FROM ap_supplier_sites

1016: X_org_id NUMBER DEFAULT mo_global.get_current_org_id
1017: ) IS
1018: CURSOR C IS
1019: SELECT *
1020: FROM ap_supplier_sites
1021: WHERE rowid = X_Rowid
1022: FOR UPDATE of vendor_site_id NOWAIT;
1023: Recinfo C%ROWTYPE;
1024:

Line 1659: UPDATE ap_supplier_sites

1655: X_calling_sequence => current_calling_sequence);
1656: end if;
1657:
1658: debug_info := 'Update PO_VENDOR_SITES';
1659: UPDATE ap_supplier_sites
1660: SET
1661: vendor_site_id = X_Vendor_Site_Id,
1662: last_update_date = X_Last_Update_Date,
1663: last_updated_by = X_Last_Updated_By,

Line 1847: UPDATE ap_supplier_sites_all

1843: );
1844: END IF;
1845: --Bug 6216082 Ends.
1846:
1847: UPDATE ap_supplier_sites_all
1848: SET
1849: last_update_date = p_Last_Update_Date,
1850: last_updated_by = p_Last_Updated_By,
1851: vendor_id = p_vendor_site_rec.Vendor_Id,

Line 2022: FROM ap_supplier_sites

2018:
2019: debug_info := 'Count sites with offset';
2020: SELECT count(1)
2021: INTO l_offset_count
2022: FROM ap_supplier_sites
2023: WHERE vendor_id = x_vendor_id
2024: AND nvl(offset_tax_flag, 'N') <> 'N';
2025: --
2026: if (l_offset_count > 0 ) then

Line 2109: FROM ap_supplier_sites

2105: X_calling_sequence;
2106: debug_info := 'Count tax reporting sites (vendor_id = ' || x_vendor_id || ')';
2107: SELECT count(1)
2108: INTO L_Multiple_count
2109: FROM ap_supplier_sites
2110: WHERE vendor_id = x_vendor_id
2111: AND tax_reporting_site_flag = 'Y'
2112: AND vendor_site_id <> nvl(x_vendor_site_id,-999)
2113: AND nvl(org_id,-99) = nvl(x_org_id,-99); --MO Access Control