APPS.OKC_CTC_PVT dependencies on OKC_UTIL

Line 523: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTACT_ROLE',p_ctcv_rec.cro_code);

519: raise G_EXCEPTION_HALT_VALIDATION;
520: end if;
521:
522: --
523: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTACT_ROLE',p_ctcv_rec.cro_code);
524: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
525: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CRO_CODE');
526: x_return_status := OKC_API.G_RET_STS_ERROR;
527: end if;

Line 776: l_sql_stmt := OKC_UTIL.GET_SQL_FROM_JTFV(P_jtot_object_code);

772:
773: BEGIN
774:
775:
776: l_sql_stmt := OKC_UTIL.GET_SQL_FROM_JTFV(P_jtot_object_code);
777:
778: IF l_sql_stmt is null THEN
779: return '-1';
780: END IF;

Line 1196: x_return_status := OKC_UTIL.check_lookup_code('OKS_RESOURCE_CLASS',

1192: IF (p_ctcv_rec.resource_class IS NOT NULL AND
1193: p_ctcv_rec.resource_class <> OKC_API.G_MISS_CHAR) THEN
1194:
1195: -- Check If the value is a valid code from lookup table
1196: x_return_status := OKC_UTIL.check_lookup_code('OKS_RESOURCE_CLASS',
1197: p_ctcv_rec.resource_class);
1198:
1199: If (x_return_status = OKC_API.G_RET_STS_ERROR) Then
1200: --set error message in message stack

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

1457: END IF;
1458: End If; -- if user defined
1459: -- ---------------------------------------------------------------------
1460: -- Bug 1636056 related changes - Shyam
1461: -- OKC_UTIL.check_comp_unique call is replaced with
1462: -- the explicit cursors above, for identical function to check
1463: -- uniqueness in OKC_CONTACTS table.
1464: -- ---------------------------------------------------------------------
1465: IF ( (p_ctcv_rec.CPL_ID IS NOT NULL)

Line 3762: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

3758: -- Procedure for mass insert in OKC_CONTACTS _B and TL tables
3759: ---------------------------------------------------------------
3760: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_ctcv_tbl ctcv_tbl_type) IS
3761: l_tabsize NUMBER := p_ctcv_tbl.COUNT;
3762: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3763:
3764: in_id OKC_DATATYPES.NumberTabTyp;
3765: in_object_version_number OKC_DATATYPES.NumberTabTyp;
3766: in_cpl_id OKC_DATATYPES.NumberTabTyp;