DBA Data[Home] [Help]

APPS.OKL_PFC_PVT dependencies on OKC_API

Line 783: IF (p_pfcv_rec.id IS NOT NULL AND p_pfcv_rec.id <> OKC_API.G_MISS_NUM) THEN

779: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
780: BEGIN
781:
782: -- Check if value passed for id
783: IF (p_pfcv_rec.id IS NOT NULL AND p_pfcv_rec.id <> OKC_API.G_MISS_NUM) THEN
784:
785: OPEN okl_cre_upd_csr(p_pfcv_rec.id);
786: FETCH okl_cre_upd_csr INTO l_id, l_khr_id;
787:

Line 813: l_return_status := OKC_API.G_RET_STS_ERROR;

809: ,p_token1 => 'CONTRACT_NUMBER'
810: ,p_token1_value => l_contract_number);
811:
812: -- notify caller of an error
813: l_return_status := OKC_API.G_RET_STS_ERROR;
814: END IF;
815:
816: CLOSE okl_pfc_upd_csr;
817: END IF;

Line 840: l_return_status := OKC_API.G_RET_STS_ERROR;

836: ,p_msg_name => 'OKL_AM_PFC_K_EXISTS_ERR'
837: ,p_token1 => 'CONTRACT_NUMBER'
838: ,p_token1_value => l_contract_number);
839: -- notify caller of an error
840: l_return_status := OKC_API.G_RET_STS_ERROR;
841:
842: END IF;
843:
844: CLOSE okl_pfc_cre_csr;