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

Line 368: l_primary_pay_flag AP_SUPPLIER_SITES.primary_pay_site_flag%TYPE;

364: x_msg_data OUT NOCOPY VARCHAR2
365: )
366: IS
367:
368: l_primary_pay_flag AP_SUPPLIER_SITES.primary_pay_site_flag%TYPE;
369: l_org_id AP_SUPPLIER_SITES.ORG_ID%TYPE;
370: l_count number;
371: l_vendor_site_code AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
372: l_vendor_site_id number;

Line 369: l_org_id AP_SUPPLIER_SITES.ORG_ID%TYPE;

365: )
366: IS
367:
368: l_primary_pay_flag AP_SUPPLIER_SITES.primary_pay_site_flag%TYPE;
369: l_org_id AP_SUPPLIER_SITES.ORG_ID%TYPE;
370: l_count number;
371: l_vendor_site_code AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
372: l_vendor_site_id number;
373: BEGIN

Line 371: l_vendor_site_code AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;

367:
368: l_primary_pay_flag AP_SUPPLIER_SITES.primary_pay_site_flag%TYPE;
369: l_org_id AP_SUPPLIER_SITES.ORG_ID%TYPE;
370: l_count number;
371: l_vendor_site_code AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
372: l_vendor_site_id number;
373: BEGIN
374:
375: l_primary_pay_flag := p_vendor_site_rec.primary_pay_site_flag;

Line 395: from ap_supplier_sites_all

391:
392:
393: select count(*)
394: into l_count
395: from ap_supplier_sites_all
396: where org_id = l_org_id
397: and primary_pay_site_flag = l_primary_pay_flag
398: and vendor_id = p_vendor_site_rec.vendor_id
399: and vendor_site_id <> l_vendor_site_id

Line 411: from ap_supplier_sites_all

407: end if;
408:
409: select vendor_site_code
410: into l_vendor_site_code
411: from ap_supplier_sites_all
412: where org_id = l_org_id
413: and primary_pay_site_flag = l_primary_pay_flag
414: and vendor_id = p_vendor_site_rec.vendor_id
415: and vendor_site_id <> l_vendor_site_id

Line 2461: FROM ap_supplier_sites_all

2457:
2458: -- Start Bug 6620664 - Handling Concurrent updates on Suppliers>>Accounting page
2459: IF p_last_update_date IS NOT NULL then
2460: SELECT last_update_date INTO l_last_update_date
2461: FROM ap_supplier_sites_all
2462: WHERE vendor_site_id = p_vendor_site_id
2463: AND vendor_id = p_vendor_id;
2464: IF l_last_update_date > p_last_update_date then
2465: x_error_msg := fnd_message.get_string('POS','POS_LOCK_SITE_ROW');