DBA Data[Home] [Help]

APPS.OKL_PYD_PVT dependencies on OKC_API

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

2889: IF (x_ppydv_rec.id = OKL_API.G_MISS_NUM)
2890: THEN
2891: x_ppydv_rec.id := l_db_ppydv_rec.id;
2892: END IF;
2893: IF (x_ppydv_rec.object_version_number = OKC_API.G_MISS_NUM)
2894: THEN
2895: x_ppydv_rec.object_version_number := l_db_ppydv_rec.object_version_number;
2896: END IF;
2897: IF (x_ppydv_rec.cpl_id = OKL_API.G_MISS_NUM)

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

3705: FUNCTION create_version(
3706: p_chr_id IN NUMBER,
3707: p_major_version IN NUMBER) RETURN VARCHAR2 IS
3708:
3709: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3710:
3711: BEGIN
3712: INSERT INTO OKL_PARTY_PYMT_DTLS_H
3713: (

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

3806: EXCEPTION
3807: -- other appropriate handlers
3808: WHEN OTHERS THEN
3809: -- store SQL error message on message stack
3810: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3811: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3812: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3813: p_token1_value => sqlcode,
3814: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3818: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3814: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3815: p_token2_value => sqlerrm);
3816:
3817: -- notify UNEXPECTED error
3818: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3819: return l_return_status;
3820: END create_version;
3821:
3822: --------------------------------------------------------------------

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

3825: FUNCTION restore_version(
3826: p_chr_id IN NUMBER,
3827: p_major_version IN NUMBER) RETURN VARCHAR2 IS
3828:
3829: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3830:
3831: BEGIN
3832: INSERT INTO OKL_PARTY_PAYMENT_DTLS
3833: (

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

3926: EXCEPTION
3927: -- other appropriate handlers
3928: WHEN OTHERS THEN
3929: -- store SQL error message on message stack
3930: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3931: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3932: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3933: p_token1_value => sqlcode,
3934: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3938: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3934: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3935: p_token2_value => sqlerrm);
3936:
3937: -- notify UNEXPECTED error
3938: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3939: return l_return_status;
3940: END restore_version;
3941:
3942: END OKL_PYD_PVT;