[Home] [Help]
3139: --bug 14000059
3140: IF(l_eam_mat_req_rec.suggested_vendor_name is not null and l_eam_mat_req_rec.vendor_id is null) THEN
3141: BEGIN
3142: SELECT vendor_id INTO l_eam_mat_req_rec.vendor_id
3143: FROM po_suppliers_val_v
3144: WHERE upper(vendor_name) = upper(l_eam_mat_req_rec.suggested_vendor_name );
3145: EXCEPTION
3146: WHEN OTHERS THEN
3147: NULL;
4158:
4159: IF(l_eam_direct_items_rec.suggested_vendor_name is not null and l_eam_direct_items_rec.suggested_vendor_id is null) THEN
4160: BEGIN
4161: SELECT vendor_id INTO l_eam_direct_items_rec.suggested_vendor_id
4162: FROM po_suppliers_val_v
4163: WHERE upper(vendor_name) = upper(l_eam_direct_items_rec.suggested_vendor_name );
4164: EXCEPTION
4165: WHEN OTHERS THEN
4166: NULL;