274: /*
275: Begin
276: SELECT LOCATION_ID
277: INTO l_supplier_org_location_id
278: FROM HR_ORGANIZATION_UNITS
279: WHERE ORGANIZATION_ID = L_repair_supplier_org_id;
280: Exception
281: When no_data_found then
282: l_supplier_org_location_id := Null;
361:
362: Begin
363: SELECT LOCATION_ID
364: INTO l_supplier_org_location_id
365: FROM HR_ORGANIZATION_UNITS
366: WHERE ORGANIZATION_ID = nvl(P_repair_supplier_org_id,L_repair_supplier_org_id);
367: Exception
368: When no_data_found then
369: --l_supplier_org_location_id := Null;
405:
406: Begin
407: SELECT LOCATION_ID
408: INTO l_ship_to_location_id
409: FROM HR_ORGANIZATION_UNITS
410: WHERE ORGANIZATION_ID = P_dest_organization_id;
411: Exception
412: When no_data_found then
413: --l_ship_to_location_id := Null;