690: p_cylv_rec IN cylv_rec_type) IS
691: item_not_found_error EXCEPTION;
692: l_row_notfound BOOLEAN := TRUE;
693: l_row_found BOOLEAN := FALSE;
694: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
695: SELECT '1'
696: FROM Okx_TimeZones_V
697: WHERE okx_timezones_v.timezone_id = p_tze_id;
698: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
692: l_row_notfound BOOLEAN := TRUE;
693: l_row_found BOOLEAN := FALSE;
694: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
695: SELECT '1'
696: FROM Okx_TimeZones_V
697: WHERE okx_timezones_v.timezone_id = p_tze_id;
698: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
699: BEGIN
700: x_return_status := OKC_API.G_RET_STS_SUCCESS;
693: l_row_found BOOLEAN := FALSE;
694: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
695: SELECT '1'
696: FROM Okx_TimeZones_V
697: WHERE okx_timezones_v.timezone_id = p_tze_id;
698: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
699: BEGIN
700: x_return_status := OKC_API.G_RET_STS_SUCCESS;
701: IF (p_cylv_rec.TZE_ID IS NOT NULL AND
694: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
695: SELECT '1'
696: FROM Okx_TimeZones_V
697: WHERE okx_timezones_v.timezone_id = p_tze_id;
698: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
699: BEGIN
700: x_return_status := OKC_API.G_RET_STS_SUCCESS;
701: IF (p_cylv_rec.TZE_ID IS NOT NULL AND
702: p_cylv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
700: x_return_status := OKC_API.G_RET_STS_SUCCESS;
701: IF (p_cylv_rec.TZE_ID IS NOT NULL AND
702: p_cylv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
703: THEN
704: OPEN okx_timezones_v_pk_csr(p_cylv_rec.TZE_ID);
705: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
706: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
707: CLOSE okx_timezones_v_pk_csr;
708: IF (l_row_notfound) THEN
701: IF (p_cylv_rec.TZE_ID IS NOT NULL AND
702: p_cylv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
703: THEN
704: OPEN okx_timezones_v_pk_csr(p_cylv_rec.TZE_ID);
705: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
706: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
707: CLOSE okx_timezones_v_pk_csr;
708: IF (l_row_notfound) THEN
709: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
702: p_cylv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
703: THEN
704: OPEN okx_timezones_v_pk_csr(p_cylv_rec.TZE_ID);
705: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
706: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
707: CLOSE okx_timezones_v_pk_csr;
708: IF (l_row_notfound) THEN
709: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
710: RAISE item_not_found_error;
703: THEN
704: OPEN okx_timezones_v_pk_csr(p_cylv_rec.TZE_ID);
705: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
706: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
707: CLOSE okx_timezones_v_pk_csr;
708: IF (l_row_notfound) THEN
709: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
710: RAISE item_not_found_error;
711: END IF;