713: p_tavv_rec IN tavv_rec_type) IS
714: item_not_found_error EXCEPTION;
715: l_row_notfound BOOLEAN := TRUE;
716: l_row_found BOOLEAN := FALSE;
717: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
718: SELECT '1'
719: FROM Okx_TimeZones_V
720: WHERE okx_timezones_v.timezone_id = p_tze_id;
721: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
715: l_row_notfound BOOLEAN := TRUE;
716: l_row_found BOOLEAN := FALSE;
717: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
718: SELECT '1'
719: FROM Okx_TimeZones_V
720: WHERE okx_timezones_v.timezone_id = p_tze_id;
721: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
722: BEGIN
723: x_return_status := OKC_API.G_RET_STS_SUCCESS;
716: l_row_found BOOLEAN := FALSE;
717: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
718: SELECT '1'
719: FROM Okx_TimeZones_V
720: WHERE okx_timezones_v.timezone_id = p_tze_id;
721: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
722: BEGIN
723: x_return_status := OKC_API.G_RET_STS_SUCCESS;
724: IF (p_tavv_rec.TZE_ID IS NOT NULL AND
717: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
718: SELECT '1'
719: FROM Okx_TimeZones_V
720: WHERE okx_timezones_v.timezone_id = p_tze_id;
721: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
722: BEGIN
723: x_return_status := OKC_API.G_RET_STS_SUCCESS;
724: IF (p_tavv_rec.TZE_ID IS NOT NULL AND
725: p_tavv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
723: x_return_status := OKC_API.G_RET_STS_SUCCESS;
724: IF (p_tavv_rec.TZE_ID IS NOT NULL AND
725: p_tavv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
726: THEN
727: OPEN okx_timezones_v_pk_csr(p_tavv_rec.TZE_ID);
728: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
729: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
730: CLOSE okx_timezones_v_pk_csr;
731: IF (l_row_notfound) THEN
724: IF (p_tavv_rec.TZE_ID IS NOT NULL AND
725: p_tavv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
726: THEN
727: OPEN okx_timezones_v_pk_csr(p_tavv_rec.TZE_ID);
728: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
729: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
730: CLOSE okx_timezones_v_pk_csr;
731: IF (l_row_notfound) THEN
732: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
725: p_tavv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
726: THEN
727: OPEN okx_timezones_v_pk_csr(p_tavv_rec.TZE_ID);
728: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
729: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
730: CLOSE okx_timezones_v_pk_csr;
731: IF (l_row_notfound) THEN
732: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
733: RAISE item_not_found_error;
726: THEN
727: OPEN okx_timezones_v_pk_csr(p_tavv_rec.TZE_ID);
728: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
729: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
730: CLOSE okx_timezones_v_pk_csr;
731: IF (l_row_notfound) THEN
732: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
733: RAISE item_not_found_error;
734: END IF;