2093: '_PVT'
2094: );
2095: END delete_row;
2096:
2097: --This function is called from versioning API OKC_VERSION_PVT
2098: --Old Location: OKCRVERB.pls
2099: --New Location: Base Table API
2100:
2101: FUNCTION create_version(
2141: EXCEPTION
2142: -- other appropriate handlers
2143: WHEN OTHERS THEN
2144: -- store SQL error message on message stack
2145: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2146: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2147: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2148: p_token1_value => sqlcode,
2149: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2142: -- other appropriate handlers
2143: WHEN OTHERS THEN
2144: -- store SQL error message on message stack
2145: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2146: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2147: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2148: p_token1_value => sqlcode,
2149: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2150: p_token2_value => sqlerrm);
2143: WHEN OTHERS THEN
2144: -- store SQL error message on message stack
2145: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2146: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2147: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2148: p_token1_value => sqlcode,
2149: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2150: p_token2_value => sqlerrm);
2151:
2145: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2146: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2147: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2148: p_token1_value => sqlcode,
2149: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2150: p_token2_value => sqlerrm);
2151:
2152: -- notify UNEXPECTED error
2153: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2153: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2154: return l_return_status;
2155: END create_version;
2156:
2157: --This Function is called from Versioning API OKC_VERSION_PVT
2158: --Old Location:OKCRVERB.pls
2159: --New Location:Base Table API
2160:
2161: FUNCTION restore_version(
2200: EXCEPTION
2201: -- other appropriate handlers
2202: WHEN OTHERS THEN
2203: -- store SQL error message on message stack
2204: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2205: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2206: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2207: p_token1_value => sqlcode,
2208: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2201: -- other appropriate handlers
2202: WHEN OTHERS THEN
2203: -- store SQL error message on message stack
2204: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2205: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2206: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2207: p_token1_value => sqlcode,
2208: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2209: p_token2_value => sqlerrm);
2202: WHEN OTHERS THEN
2203: -- store SQL error message on message stack
2204: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2205: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2206: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2207: p_token1_value => sqlcode,
2208: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2209: p_token2_value => sqlerrm);
2210:
2204: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2205: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2206: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2207: p_token1_value => sqlcode,
2208: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2209: p_token2_value => sqlerrm);
2210:
2211: -- notify UNEXPECTED error
2212: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;