DBA Data[Home] [Help]

APPS.OKL_PYD_PVT dependencies on OKC_API

Line 2915: IF (x_ppydv_rec.object_version_number = OKC_API.G_MISS_NUM)

2911: IF (x_ppydv_rec.id = OKL_API.G_MISS_NUM)
2912: THEN
2913: x_ppydv_rec.id := l_db_ppydv_rec.id;
2914: END IF;
2915: IF (x_ppydv_rec.object_version_number = OKC_API.G_MISS_NUM)
2916: THEN
2917: x_ppydv_rec.object_version_number := l_db_ppydv_rec.object_version_number;
2918: END IF;
2919: IF (x_ppydv_rec.cpl_id = OKL_API.G_MISS_NUM)

Line 3738: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

3734: FUNCTION create_version(
3735: p_chr_id IN NUMBER,
3736: p_major_version IN NUMBER) RETURN VARCHAR2 IS
3737:
3738: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3739:
3740: BEGIN
3741: INSERT INTO OKL_PARTY_PYMT_DTLS_H
3742: (

Line 3841: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

3837: EXCEPTION
3838: -- other appropriate handlers
3839: WHEN OTHERS THEN
3840: -- store SQL error message on message stack
3841: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3842: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3843: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3844: p_token1_value => sqlcode,
3845: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3849: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3845: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3846: p_token2_value => sqlerrm);
3847:
3848: -- notify UNEXPECTED error
3849: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3850: return l_return_status;
3851: END create_version;
3852:
3853: --------------------------------------------------------------------

Line 3860: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

3856: FUNCTION restore_version(
3857: p_chr_id IN NUMBER,
3858: p_major_version IN NUMBER) RETURN VARCHAR2 IS
3859:
3860: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3861:
3862: BEGIN
3863: INSERT INTO OKL_PARTY_PAYMENT_DTLS
3864: (

Line 3963: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

3959: EXCEPTION
3960: -- other appropriate handlers
3961: WHEN OTHERS THEN
3962: -- store SQL error message on message stack
3963: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3964: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3965: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3966: p_token1_value => sqlcode,
3967: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3971: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3967: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3968: p_token2_value => sqlerrm);
3969:
3970: -- notify UNEXPECTED error
3971: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3972: return l_return_status;
3973: END restore_version;
3974:
3975: END OKL_PYD_PVT;