788: p_isev_rec IN isev_rec_type) IS
789: item_not_found_error EXCEPTION;
790: l_row_notfound BOOLEAN := TRUE;
791: l_row_found BOOLEAN := FALSE;
792: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
793: SELECT '1'
794: FROM Okx_TimeZones_V
795: WHERE okx_timezones_v.timezone_id = p_tze_id;
796: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
790: l_row_notfound BOOLEAN := TRUE;
791: l_row_found BOOLEAN := FALSE;
792: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
793: SELECT '1'
794: FROM Okx_TimeZones_V
795: WHERE okx_timezones_v.timezone_id = p_tze_id;
796: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
797: BEGIN
798: x_return_status := OKC_API.G_RET_STS_SUCCESS;
791: l_row_found BOOLEAN := FALSE;
792: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
793: SELECT '1'
794: FROM Okx_TimeZones_V
795: WHERE okx_timezones_v.timezone_id = p_tze_id;
796: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
797: BEGIN
798: x_return_status := OKC_API.G_RET_STS_SUCCESS;
799: IF (p_isev_rec.TZE_ID IS NOT NULL AND
792: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
793: SELECT '1'
794: FROM Okx_TimeZones_V
795: WHERE okx_timezones_v.timezone_id = p_tze_id;
796: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
797: BEGIN
798: x_return_status := OKC_API.G_RET_STS_SUCCESS;
799: IF (p_isev_rec.TZE_ID IS NOT NULL AND
800: p_isev_rec.TZE_ID <> OKC_API.G_MISS_NUM)
798: x_return_status := OKC_API.G_RET_STS_SUCCESS;
799: IF (p_isev_rec.TZE_ID IS NOT NULL AND
800: p_isev_rec.TZE_ID <> OKC_API.G_MISS_NUM)
801: THEN
802: OPEN okx_timezones_v_pk_csr(p_isev_rec.TZE_ID);
803: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
804: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
805: CLOSE okx_timezones_v_pk_csr;
806: IF (l_row_notfound) THEN
799: IF (p_isev_rec.TZE_ID IS NOT NULL AND
800: p_isev_rec.TZE_ID <> OKC_API.G_MISS_NUM)
801: THEN
802: OPEN okx_timezones_v_pk_csr(p_isev_rec.TZE_ID);
803: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
804: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
805: CLOSE okx_timezones_v_pk_csr;
806: IF (l_row_notfound) THEN
807: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
800: p_isev_rec.TZE_ID <> OKC_API.G_MISS_NUM)
801: THEN
802: OPEN okx_timezones_v_pk_csr(p_isev_rec.TZE_ID);
803: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
804: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
805: CLOSE okx_timezones_v_pk_csr;
806: IF (l_row_notfound) THEN
807: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
808: RAISE item_not_found_error;
801: THEN
802: OPEN okx_timezones_v_pk_csr(p_isev_rec.TZE_ID);
803: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
804: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
805: CLOSE okx_timezones_v_pk_csr;
806: IF (l_row_notfound) THEN
807: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
808: RAISE item_not_found_error;
809: END IF;