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 367: l_primary_pay_flag AP_SUPPLIER_SITES.primary_pay_site_flag%TYPE;

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

Line 368: l_org_id AP_SUPPLIER_SITES.ORG_ID%TYPE;

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

Line 370: l_vendor_site_code AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;

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

Line 394: from ap_supplier_sites_all

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

Line 410: from ap_supplier_sites_all

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

Line 2420: FROM ap_supplier_sites_all

2416:
2417: -- Start Bug 6620664 - Handling Concurrent updates on Suppliers>>Accounting page
2418: IF p_last_update_date IS NOT NULL then
2419: SELECT last_update_date INTO l_last_update_date
2420: FROM ap_supplier_sites_all
2421: WHERE vendor_site_id = p_vendor_site_id
2422: AND vendor_id = p_vendor_id;
2423: IF l_last_update_date > p_last_update_date then
2424: x_error_msg := fnd_message.get_string('POS','POS_LOCK_SITE_ROW');