APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on PO_VENDORS

Line 1502: l_supplier_id po_vendors.vendor_id%TYPE;

1498: , x_supplier_site_id OUT NOCOPY NUMBER
1499: )
1500: IS
1501: l_api_name VARCHAR2(30) := 'get_supplier_name';
1502: l_supplier_id po_vendors.vendor_id%TYPE;
1503: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;
1504: l_supplier_name po_vendors.vendor_name%TYPE;
1505:
1506: BEGIN

Line 1504: l_supplier_name po_vendors.vendor_name%TYPE;

1500: IS
1501: l_api_name VARCHAR2(30) := 'get_supplier_name';
1502: l_supplier_id po_vendors.vendor_id%TYPE;
1503: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;
1504: l_supplier_name po_vendors.vendor_name%TYPE;
1505:
1506: BEGIN
1507:
1508: JMF_SHIKYU_UTIL.debug_output

Line 1549: SELECT po_vendors.vendor_name

1545: x_supplier_id := l_supplier_id;
1546: x_supplier_site_id := l_supplier_site_id;
1547:
1548: BEGIN
1549: SELECT po_vendors.vendor_name
1550: INTO l_supplier_name
1551: FROM po_vendors
1552: WHERE po_vendors.vendor_id = l_supplier_id;
1553: EXCEPTION

Line 1551: FROM po_vendors

1547:
1548: BEGIN
1549: SELECT po_vendors.vendor_name
1550: INTO l_supplier_name
1551: FROM po_vendors
1552: WHERE po_vendors.vendor_id = l_supplier_id;
1553: EXCEPTION
1554: WHEN no_data_found THEN
1555: JMF_SHIKYU_UTIL.debug_output

Line 1552: WHERE po_vendors.vendor_id = l_supplier_id;

1548: BEGIN
1549: SELECT po_vendors.vendor_name
1550: INTO l_supplier_name
1551: FROM po_vendors
1552: WHERE po_vendors.vendor_id = l_supplier_id;
1553: EXCEPTION
1554: WHEN no_data_found THEN
1555: JMF_SHIKYU_UTIL.debug_output
1556: (