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 247: from po_vendor_sites_all

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

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

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

Line 253: Select PO_VENDOR_SITES_S.NEXTVAL

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

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

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

Line 574: Select PO_VENDOR_SITES_S.NEXTVAL

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

Line 1659: vendor_site_old po_vendor_sites.vendor_site_code%TYPE;

1655: ) IS
1656:
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

Line 1676: from po_vendor_sites

1672: -- Get old site name.
1673:
1674: /* select vendor_site_code
1675: into vendor_site_old
1676: from po_vendor_sites
1677: where rowid = X_rowid;
1678:
1679: select count(*)
1680: into total_sites

Line 1681: from po_vendor_sites_all

1677: where rowid = X_rowid;
1678:
1679: select count(*)
1680: into total_sites
1681: from po_vendor_sites_all
1682: where vendor_site_id = X_vendor_site_id;
1683:
1684: if ( total_sites > 1 and ( vendor_site_old <> X_vendor_site_code)) then
1685: fnd_message.set_name('SQLAP','AP_SHARED_SITE');