DBA Data[Home] [Help]

APPS.OKC_SAI_PVT dependencies on OKC_UTIL

Line 203: -- OKC_UTIL.check_comp_unique call is replaced with

199: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
200:
201: -- ---------------------------------------------------------------------
202: -- Bug 1636056 related changes - Shyam
203: -- OKC_UTIL.check_comp_unique call is replaced with
204: -- the explicit cursors above, for identical function to
205: -- check uniqueness for SAE_ID + SAE_ID_FOR in OKC_STD_ART_INCMPTS_V
206: -- ---------------------------------------------------------------------
207: IF ( (p_saiv_rec.sae_id IS NOT NULL)

Line 500: l_unq OKC_UTIL.unq_tbl_type;

496: p_saiv_rec IN saiv_rec_type
497: ) RETURN VARCHAR2 IS
498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
499: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: l_unq OKC_UTIL.unq_tbl_type;
501: BEGIN
502: l_return_status:=OKC_API.G_RET_STS_SUCCESS;
503: --check that sae_id and sae_id_for are not same
504: IF (p_saiv_rec.sae_id=p_saiv_rec.sae_id_for)