[Home] [Help]
1836: p_services_total_amt_tolerance OUT NOCOPY NUMBER,
1837: p_calling_sequence IN VARCHAR2)
1838: RETURN BOOLEAN IS
1839: debug_info VARCHAR2(500);
1840: l_price_tolerance ap_tolerance_templates.price_tolerance%TYPE;
1841: BEGIN
1842:
1843: debug_info := '(Get_tolerance_info 1) Get tolerance info...';
1844: If AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' then
1872: p_max_qty_rec_tolerance,
1873: p_goods_ship_amt_tolerance,
1874: p_goods_rate_amt_tolerance,
1875: p_goods_total_amt_tolerance
1876: from ap_tolerance_templates att,
1877: po_vendor_sites_all pvs
1878: where pvs.vendor_site_id = p_vendor_site_id
1879: and pvs.tolerance_id = att.tolerance_id;
1880:
1902: p_max_amt_rec_tolerance,
1903: p_services_ship_amt_tolerance,
1904: p_services_rate_amt_tolerance,
1905: p_services_total_amt_tolerance
1906: from ap_tolerance_templates att,
1907: po_vendor_sites_all pvs
1908: where pvs.vendor_site_id = p_vendor_site_id
1909: and pvs.services_tolerance_id = att.tolerance_id;
1910: