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 PO_VENDOR_SITES

Line 209: FROM po_vendor_sites

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

Line 246: from po_vendor_sites_all

242: made earlier (Bug 702458)
243: debug_info := 'Select vendor site id for any other site with same site_code';
244: Select max(vendor_site_id)
245: into x_vendor_site_id
246: from po_vendor_sites_all
247: where vendor_id = x_vendor_id
248: and vendor_site_code = x_vendor_site_code; */
249:
250: --(Bug 702458) if (x_vendor_site_id IS NULL) then

Line 251: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';

247: where vendor_id = x_vendor_id
248: and vendor_site_code = x_vendor_site_code; */
249:
250: --(Bug 702458) if (x_vendor_site_id IS NULL) then
251: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
252: Select PO_VENDOR_SITES_S.NEXTVAL
253: into x_vendor_site_id
254: from sys.dual;
255: -- end if;

Line 252: Select PO_VENDOR_SITES_S.NEXTVAL

248: and vendor_site_code = x_vendor_site_code; */
249:
250: --(Bug 702458) if (x_vendor_site_id IS NULL) then
251: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
252: Select PO_VENDOR_SITES_S.NEXTVAL
253: into x_vendor_site_id
254: from sys.dual;
255: -- end if;
256:

Line 257: debug_info := 'Insert values into PO_VENDOR_SITES';

253: into x_vendor_site_id
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,

Line 562: FROM po_vendor_sites

558: x_vendor_site_id OUT NOCOPY NUMBER
559: ) IS
560:
561: CURSOR C IS SELECT rowid
562: FROM po_vendor_sites
563: WHERE vendor_site_id = X_vendor_site_id;
564:
565: current_calling_sequence varchar2(2000);
566: debug_info varchar2(2000);

Line 570: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';

566: debug_info varchar2(2000);
567:
568: BEGIN
569:
570: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
571: Select PO_VENDOR_SITES_S.NEXTVAL
572: into x_vendor_site_id
573: from sys.dual;
574: -- end if;

Line 571: Select PO_VENDOR_SITES_S.NEXTVAL

567:
568: BEGIN
569:
570: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
571: Select PO_VENDOR_SITES_S.NEXTVAL
572: into x_vendor_site_id
573: from sys.dual;
574: -- end if;
575:

Line 576: debug_info := 'Insert values into PO_VENDOR_SITES';

572: into x_vendor_site_id
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,

Line 1618: vendor_site_old po_vendor_sites.vendor_site_code%TYPE;

1614: ) IS
1615:
1616: current_calling_sequence varchar2(2000);
1617: debug_info varchar2(100);
1618: vendor_site_old po_vendor_sites.vendor_site_code%TYPE;
1619: total_sites number;
1620:
1621: BEGIN
1622: -- Update the calling sequence

Line 1634: from po_vendor_sites

1630: -- Get old site name.
1631:
1632: /* select vendor_site_code
1633: into vendor_site_old
1634: from po_vendor_sites
1635: where rowid = X_rowid;
1636:
1637: select count(*)
1638: into total_sites

Line 1639: from po_vendor_sites_all

1635: where rowid = X_rowid;
1636:
1637: select count(*)
1638: into total_sites
1639: from po_vendor_sites_all
1640: where vendor_site_id = X_vendor_site_id;
1641:
1642: if ( total_sites > 1 and ( vendor_site_old <> X_vendor_site_code)) then
1643: fnd_message.set_name('SQLAP','AP_SHARED_SITE');

Line 1658: debug_info := 'Update PO_VENDOR_SITES';

1654: x_org_id, --MO Access Control
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,

Line 1832: debug_info := 'Update PO_VENDOR_SITES';

1828: debug_info varchar2(100);
1829:
1830: BEGIN
1831:
1832: debug_info := 'Update PO_VENDOR_SITES';
1833:
1834: --Bug 6216082 Begins. Added the following call to IGI package
1835: --Bug 7577497 Added another parameter to the function call p_pay_tax_grp_id
1836: IF (p_vendor_site_rec.Awt_Group_Id IS NOT NULL OR

Line 2066: FROM po_vendor_sites

2062:
2063: debug_info := 'Count duplicates for vendor_id and site_code';
2064: SELECT count(1)
2065: INTO L_Duplicate_count
2066: FROM po_vendor_sites
2067: WHERE (rowid <> x_rowid or x_rowid IS NULL)
2068: AND vendor_id = x_vendor_id
2069: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)
2070: AND nvl(org_id,-99) = nvl(x_org_id,-99); --MO Access Control

Line 2150: FROM po_vendor_sites

2146:
2147: debug_info := 'Count sites not in base currency for vendor_id';
2148: SELECT count(1)
2149: INTO L_overlap_count
2150: FROM po_vendor_sites
2151: WHERE vendor_id = x_vendor_id
2152: AND (invoice_currency_code <> x_Base_Currency_Code
2153: OR invoice_currency_code IS NULL);
2154:

Line 2197: FROM po_vendor_sites_all

2193: -- select the tax site
2194:
2195: SELECT vendor_site_code
2196: INTO x_vendor_site_code
2197: FROM po_vendor_sites_all
2198: WHERE vendor_id = x_vendor_id
2199: AND nvl(org_id,-99) = nvl(x_org_id,-99)
2200: AND Tax_Reporting_Site_Flag = 'Y';
2201:

Line 2234: FROM po_vendor_sites

2230: debug_info := 'Check that all Site State Codes are valid for US sites';
2231:
2232: SELECT count(1)
2233: INTO L_Return_Count
2234: FROM po_vendor_sites
2235: WHERE vendor_id = x_vendor_id
2236: AND country = 'US'
2237: AND nvl(state,'99') not in (SELECT region_short_name
2238: FROM AP_income_tax_regions);

Line 2277: FROM po_vendor_sites

2273:
2274: debug_info := 'Count duplicates for vendor_id and site_code';
2275: SELECT count(1)
2276: INTO L_Duplicate_count
2277: FROM po_vendor_sites
2278: WHERE (rowid <> x_rowid or x_rowid IS NULL)
2279: AND vendor_id = x_vendor_id
2280: AND UPPER(ece_tp_location_code) = UPPER(x_ece_tp_location_code)
2281: --MO Access Control