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