APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on PO_VENDORS

Line 1482: l_supplier_id po_vendors.vendor_id%TYPE;

1478: , x_supplier_site_id OUT NOCOPY NUMBER
1479: )
1480: IS
1481: l_api_name VARCHAR2(30) := 'get_supplier_name';
1482: l_supplier_id po_vendors.vendor_id%TYPE;
1483: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;
1484: l_supplier_name po_vendors.vendor_name%TYPE;
1485:
1486: BEGIN

Line 1484: l_supplier_name po_vendors.vendor_name%TYPE;

1480: IS
1481: l_api_name VARCHAR2(30) := 'get_supplier_name';
1482: l_supplier_id po_vendors.vendor_id%TYPE;
1483: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;
1484: l_supplier_name po_vendors.vendor_name%TYPE;
1485:
1486: BEGIN
1487:
1488: JMF_SHIKYU_UTIL.debug_output

Line 1529: SELECT po_vendors.vendor_name

1525: x_supplier_id := l_supplier_id;
1526: x_supplier_site_id := l_supplier_site_id;
1527:
1528: BEGIN
1529: SELECT po_vendors.vendor_name
1530: INTO l_supplier_name
1531: FROM po_vendors
1532: WHERE po_vendors.vendor_id = l_supplier_id;
1533: EXCEPTION

Line 1531: FROM po_vendors

1527:
1528: BEGIN
1529: SELECT po_vendors.vendor_name
1530: INTO l_supplier_name
1531: FROM po_vendors
1532: WHERE po_vendors.vendor_id = l_supplier_id;
1533: EXCEPTION
1534: WHEN no_data_found THEN
1535: JMF_SHIKYU_UTIL.debug_output

Line 1532: WHERE po_vendors.vendor_id = l_supplier_id;

1528: BEGIN
1529: SELECT po_vendors.vendor_name
1530: INTO l_supplier_name
1531: FROM po_vendors
1532: WHERE po_vendors.vendor_id = l_supplier_id;
1533: EXCEPTION
1534: WHEN no_data_found THEN
1535: JMF_SHIKYU_UTIL.debug_output
1536: (