69: -- get ship to of repair organization
70: begin
71: select location_id
72: into l_order_hdr_Rec.ship_to_location_id
73: from hr_organization_units
74: where organization_id = p_repair_supplier_id;
75: exception
76: when no_data_found then
77: null;
113: -- get ship to of FS organization
114: begin
115: select location_id
116: into l_order_hdr_Rec.ship_to_location_id
117: from hr_organization_units
118: where organization_id = px_header_rec.dest_organization_id;
119: exception
120: when no_data_found then
121: null;