546: p_talv_rec IN talv_rec_type) IS
547: item_not_found_error EXCEPTION;
548: l_row_notfound BOOLEAN := TRUE;
549: l_row_found BOOLEAN := FALSE;
550: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
551: SELECT '1'
552: FROM Okx_TimeZones_V
553: WHERE okx_timezones_v.timezone_id = p_tze_id;
554: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
548: l_row_notfound BOOLEAN := TRUE;
549: l_row_found BOOLEAN := FALSE;
550: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
551: SELECT '1'
552: FROM Okx_TimeZones_V
553: WHERE okx_timezones_v.timezone_id = p_tze_id;
554: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
555: BEGIN
556: x_return_status := OKC_API.G_RET_STS_SUCCESS;
549: l_row_found BOOLEAN := FALSE;
550: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
551: SELECT '1'
552: FROM Okx_TimeZones_V
553: WHERE okx_timezones_v.timezone_id = p_tze_id;
554: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
555: BEGIN
556: x_return_status := OKC_API.G_RET_STS_SUCCESS;
557: IF (p_talv_rec.TZE_ID IS NOT NULL AND
550: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
551: SELECT '1'
552: FROM Okx_TimeZones_V
553: WHERE okx_timezones_v.timezone_id = p_tze_id;
554: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
555: BEGIN
556: x_return_status := OKC_API.G_RET_STS_SUCCESS;
557: IF (p_talv_rec.TZE_ID IS NOT NULL AND
558: p_talv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
556: x_return_status := OKC_API.G_RET_STS_SUCCESS;
557: IF (p_talv_rec.TZE_ID IS NOT NULL AND
558: p_talv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
559: THEN
560: OPEN okx_timezones_v_pk_csr(p_talv_rec.TZE_ID);
561: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
562: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
563: CLOSE okx_timezones_v_pk_csr;
564: IF (l_row_notfound) THEN
557: IF (p_talv_rec.TZE_ID IS NOT NULL AND
558: p_talv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
559: THEN
560: OPEN okx_timezones_v_pk_csr(p_talv_rec.TZE_ID);
561: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
562: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
563: CLOSE okx_timezones_v_pk_csr;
564: IF (l_row_notfound) THEN
565: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
558: p_talv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
559: THEN
560: OPEN okx_timezones_v_pk_csr(p_talv_rec.TZE_ID);
561: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
562: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
563: CLOSE okx_timezones_v_pk_csr;
564: IF (l_row_notfound) THEN
565: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
566: RAISE item_not_found_error;
559: THEN
560: OPEN okx_timezones_v_pk_csr(p_talv_rec.TZE_ID);
561: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
562: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
563: CLOSE okx_timezones_v_pk_csr;
564: IF (l_row_notfound) THEN
565: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
566: RAISE item_not_found_error;
567: END IF;