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.AP_VENDOR_SITES_PKG dependencies on AP_SUPPLIER_SITES

Line 210: FROM ap_supplier_sites

206: X_Org_ID NUMBER DEFAULT mo_global.get_current_org_id
207: ) IS
208:
209: CURSOR C IS SELECT rowid
210: FROM ap_supplier_sites
211: WHERE vendor_site_id = X_vendor_site_id;
212: current_calling_sequence varchar2(2000);
213: debug_info varchar2(100);
214:

Line 258: debug_info := 'Insert values into ap_supplier_sites';

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

Line 259: INSERT INTO ap_supplier_sites_all(

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

Line 565: FROM ap_supplier_sites

561: x_vendor_site_id OUT NOCOPY NUMBER
562: ) IS
563:
564: CURSOR C IS SELECT rowid
565: FROM ap_supplier_sites
566: WHERE vendor_site_id = X_vendor_site_id;
567:
568: current_calling_sequence varchar2(2000);
569: debug_info varchar2(2000);

Line 579: debug_info := 'Insert values into ap_supplier_sites';

575: into x_vendor_site_id
576: from sys.dual;
577: -- end if;
578:
579: debug_info := 'Insert values into ap_supplier_sites';
580: INSERT INTO ap_supplier_sites_all(
581: vendor_site_id,
582: last_update_date,
583: last_updated_by,

Line 580: INSERT INTO ap_supplier_sites_all(

576: from sys.dual;
577: -- end if;
578:
579: debug_info := 'Insert values into ap_supplier_sites';
580: INSERT INTO ap_supplier_sites_all(
581: vendor_site_id,
582: last_update_date,
583: last_updated_by,
584: vendor_id,

Line 1061: FROM ap_supplier_sites

1057: X_org_id NUMBER DEFAULT mo_global.get_current_org_id
1058: ) IS
1059: CURSOR C IS
1060: SELECT *
1061: FROM ap_supplier_sites
1062: WHERE rowid = X_Rowid
1063: FOR UPDATE of vendor_site_id NOWAIT;
1064: Recinfo C%ROWTYPE;
1065:

Line 1707: debug_info := 'Update ap_supplier_sites';

1703: FROM ap_suppliers
1704: WHERE vendor_id = X_Vendor_Id;
1705: --Bug15966842
1706:
1707: debug_info := 'Update ap_supplier_sites';
1708: UPDATE ap_supplier_sites
1709: SET
1710: vendor_site_id = X_Vendor_Site_Id,
1711: last_update_date = X_Last_Update_Date,

Line 1708: UPDATE ap_supplier_sites

1704: WHERE vendor_id = X_Vendor_Id;
1705: --Bug15966842
1706:
1707: debug_info := 'Update ap_supplier_sites';
1708: UPDATE ap_supplier_sites
1709: SET
1710: vendor_site_id = X_Vendor_Site_Id,
1711: last_update_date = X_Last_Update_Date,
1712: last_updated_by = X_Last_Updated_By,

Line 1885: debug_info := 'Update ap_supplier_sites';

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:
1887: --Bug 6216082 Begins. Added the following call to IGI package
1888: --Bug 7577497 Added another parameter to the function call p_pay_tax_grp_id
1889: IF (p_vendor_site_rec.Awt_Group_Id IS NOT NULL OR

Line 1907: UPDATE ap_supplier_sites_all

1903: FROM ap_suppliers
1904: WHERE vendor_id = p_vendor_site_rec.Vendor_Id;
1905: --Bug15966842
1906:
1907: UPDATE ap_supplier_sites_all
1908: SET
1909: last_update_date = p_Last_Update_Date,
1910: last_updated_by = p_Last_Updated_By,
1911: vendor_id = p_vendor_site_rec.Vendor_Id,

Line 2106: FROM ap_supplier_sites

2102:
2103: debug_info := 'Count sites with offset';
2104: SELECT count(1)
2105: INTO l_offset_count
2106: FROM ap_supplier_sites
2107: WHERE vendor_id = x_vendor_id
2108: AND nvl(offset_tax_flag, 'N') <> 'N';
2109: --
2110: if (l_offset_count > 0 ) then

Line 2150: FROM ap_supplier_sites

2146:
2147: debug_info := 'Count duplicates for vendor_id and site_code';
2148: SELECT count(1)
2149: INTO L_Duplicate_count
2150: FROM ap_supplier_sites
2151: WHERE (rowid <> x_rowid or x_rowid IS NULL)
2152: AND vendor_id = x_vendor_id
2153: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)
2154: AND nvl(org_id,-99) = nvl(x_org_id,-99); --MO Access Control

Line 2193: FROM ap_supplier_sites

2189: X_calling_sequence;
2190: debug_info := 'Count tax reporting sites (vendor_id = ' || x_vendor_id || ')';
2191: SELECT count(1)
2192: INTO L_Multiple_count
2193: FROM ap_supplier_sites
2194: WHERE vendor_id = x_vendor_id
2195: AND tax_reporting_site_flag = 'Y'
2196: AND vendor_site_id <> nvl(x_vendor_site_id,-999)
2197: AND nvl(org_id,-99) = nvl(x_org_id,-99); --MO Access Control

Line 2234: FROM ap_supplier_sites

2230:
2231: debug_info := 'Count sites not in base currency for vendor_id';
2232: SELECT count(1)
2233: INTO L_overlap_count
2234: FROM ap_supplier_sites
2235: WHERE vendor_id = x_vendor_id
2236: AND (invoice_currency_code <> x_Base_Currency_Code
2237: OR invoice_currency_code IS NULL);
2238:

Line 2281: FROM ap_supplier_sites_all

2277: -- select the tax site
2278:
2279: SELECT vendor_site_code
2280: INTO x_vendor_site_code
2281: FROM ap_supplier_sites_all
2282: WHERE vendor_id = x_vendor_id
2283: AND nvl(org_id,-99) = nvl(x_org_id,-99)
2284: AND Tax_Reporting_Site_Flag = 'Y';
2285:

Line 2318: FROM ap_supplier_sites

2314: debug_info := 'Check that all Site State Codes are valid for US sites';
2315:
2316: SELECT count(1)
2317: INTO L_Return_Count
2318: FROM ap_supplier_sites
2319: WHERE vendor_id = x_vendor_id
2320: AND country = 'US'
2321: AND nvl(state,'99') not in (SELECT region_short_name
2322: FROM AP_income_tax_regions);

Line 2361: FROM ap_supplier_sites

2357:
2358: debug_info := 'Count duplicates for vendor_id and site_code';
2359: SELECT count(1)
2360: INTO L_Duplicate_count
2361: FROM ap_supplier_sites
2362: WHERE (rowid <> x_rowid or x_rowid IS NULL)
2363: AND vendor_id = x_vendor_id
2364: AND UPPER(ece_tp_location_code) = UPPER(x_ece_tp_location_code)
2365: --MO Access Control