APPS.OKC_CTC_PVT dependencies on OKC_UTIL

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

576: raise G_EXCEPTION_HALT_VALIDATION;
577: end if;
578:
579: --
580: x_return_status := OKC_UTIL.check_lookup_code('OKC_CONTACT_ROLE',p_ctcv_rec.cro_code);
581: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
582: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CRO_CODE');
583: x_return_status := OKC_API.G_RET_STS_ERROR;
584: end if;

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

829:
830: BEGIN
831:
832:
833: l_sql_stmt := OKC_UTIL.GET_SQL_FROM_JTFV(P_jtot_object_code);
834:
835: IF l_sql_stmt is null THEN
836: return '-1';
837: END IF;

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

1249: IF (p_ctcv_rec.resource_class IS NOT NULL AND
1250: p_ctcv_rec.resource_class <> OKC_API.G_MISS_CHAR) THEN
1251:
1252: -- Check If the value is a valid code from lookup table
1253: x_return_status := OKC_UTIL.check_lookup_code('OKS_RESOURCE_CLASS',
1254: p_ctcv_rec.resource_class);
1255:
1256: If (x_return_status = OKC_API.G_RET_STS_ERROR) Then
1257: --set error message in message stack

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

1514: END IF;
1515: End If; -- if user defined
1516: -- ---------------------------------------------------------------------
1517: -- Bug 1636056 related changes - Shyam
1518: -- OKC_UTIL.check_comp_unique call is replaced with
1519: -- the explicit cursors above, for identical function to check
1520: -- uniqueness in OKC_CONTACTS table.
1521: -- ---------------------------------------------------------------------
1522: IF ( (p_ctcv_rec.CPL_ID IS NOT NULL)

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

3841: -- Procedure for mass insert in OKC_CONTACTS _B and TL tables
3842: ---------------------------------------------------------------
3843: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_ctcv_tbl ctcv_tbl_type) IS
3844: l_tabsize NUMBER := p_ctcv_tbl.COUNT;
3845: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3846: l_ste_code VARCHAR2(30);/*added for bug 6882512*/
3847: in_id OKC_DATATYPES.NumberTabTyp;
3848: in_object_version_number OKC_DATATYPES.NumberTabTyp;
3849: in_cpl_id OKC_DATATYPES.NumberTabTyp;