33: if x_country_of_origin is null then
34: begin
35: select country_of_origin_code
36: into x_country_of_origin
37: from po_vendor_sites_all
38: where vendor_id = x_vendor_id
39: and vendor_site_id = x_vendor_site_id
40: and rownum = 1;
41:
50: elsif x_item_id is null then
51: begin
52: select country_of_origin_code
53: into x_country_of_origin
54: from po_vendor_sites_all
55: where vendor_id = x_vendor_id
56: and vendor_site_id = x_vendor_site_id
57: and rownum = 1;
58: