3785: x_status := 0;
3786: l_regions_processed := 0;
3787:
3788: -- populate previous values to some impossible data ... like G_MISS..something.
3789: l_prev_country := FND_API.G_MISS_CHAR;
3790: l_prev_state := FND_API.G_MISS_CHAR;
3791: l_prev_city := FND_API.G_MISS_CHAR;
3792: l_prev_country_code := FND_API.G_MISS_CHAR;
3793: l_prev_state_code := FND_API.G_MISS_CHAR;
3786: l_regions_processed := 0;
3787:
3788: -- populate previous values to some impossible data ... like G_MISS..something.
3789: l_prev_country := FND_API.G_MISS_CHAR;
3790: l_prev_state := FND_API.G_MISS_CHAR;
3791: l_prev_city := FND_API.G_MISS_CHAR;
3792: l_prev_country_code := FND_API.G_MISS_CHAR;
3793: l_prev_state_code := FND_API.G_MISS_CHAR;
3794: l_prev_city_code := FND_API.G_MISS_CHAR;
3787:
3788: -- populate previous values to some impossible data ... like G_MISS..something.
3789: l_prev_country := FND_API.G_MISS_CHAR;
3790: l_prev_state := FND_API.G_MISS_CHAR;
3791: l_prev_city := FND_API.G_MISS_CHAR;
3792: l_prev_country_code := FND_API.G_MISS_CHAR;
3793: l_prev_state_code := FND_API.G_MISS_CHAR;
3794: l_prev_city_code := FND_API.G_MISS_CHAR;
3795:
3788: -- populate previous values to some impossible data ... like G_MISS..something.
3789: l_prev_country := FND_API.G_MISS_CHAR;
3790: l_prev_state := FND_API.G_MISS_CHAR;
3791: l_prev_city := FND_API.G_MISS_CHAR;
3792: l_prev_country_code := FND_API.G_MISS_CHAR;
3793: l_prev_state_code := FND_API.G_MISS_CHAR;
3794: l_prev_city_code := FND_API.G_MISS_CHAR;
3795:
3796: OPEN get_all_regions;
3789: l_prev_country := FND_API.G_MISS_CHAR;
3790: l_prev_state := FND_API.G_MISS_CHAR;
3791: l_prev_city := FND_API.G_MISS_CHAR;
3792: l_prev_country_code := FND_API.G_MISS_CHAR;
3793: l_prev_state_code := FND_API.G_MISS_CHAR;
3794: l_prev_city_code := FND_API.G_MISS_CHAR;
3795:
3796: OPEN get_all_regions;
3797: LOOP
3790: l_prev_state := FND_API.G_MISS_CHAR;
3791: l_prev_city := FND_API.G_MISS_CHAR;
3792: l_prev_country_code := FND_API.G_MISS_CHAR;
3793: l_prev_state_code := FND_API.G_MISS_CHAR;
3794: l_prev_city_code := FND_API.G_MISS_CHAR;
3795:
3796: OPEN get_all_regions;
3797: LOOP
3798: -- Fetching regions in bulk from Interface table (limit is 1000).