[Home] [Help]
227: pvendor_no OUT NOCOPY VARCHAR2) IS
228:
229: CURSOR get_vend_no IS
230: SELECT vendor_no
231: FROM po_vend_mst
232: WHERE vendor_id = pvendor_id;
233:
234: BEGIN
235:
247: pvendor_desc OUT NOCOPY VARCHAR2) IS
248:
249: CURSOR get_vend_name IS
250: SELECT vendor_name
251: FROM po_vend_mst
252: WHERE vendor_id = pvendor_id;
253:
254: BEGIN
255: