APPS.OKC_CPS_PVT dependencies on OKC_UTIL

Line 794: -- l_unq_tbl OKC_UTIL.unq_tbl_type;

790: FUNCTION Validate_Record (
791: p_cpsv_rec IN cpsv_rec_type
792: ) RETURN VARCHAR2 IS
793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
794: -- l_unq_tbl OKC_UTIL.unq_tbl_type;
795:
796: Cursor l_cps_csr Is
797: select count(1)
798: from okc_k_processes cps, okc_process_defs_b pdfb

Line 836: -- OKC_UTIL.check_comp_unique call earlier was not using

832: l_dummy VARCHAR2(1);
833: BEGIN
834: -- ------------------------------------------------------
835: -- Bug# 1636056 related changes - Shyam
836: -- OKC_UTIL.check_comp_unique call earlier was not using
837: -- the bind variables and parses everytime, replaced with
838: -- the explicit cursors above, for identical function.
839: -- ------------------------------------------------------
840: IF ( p_cpsv_rec.CHR_ID IS NOT NULL

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

2603: -- Procedure for mass insert in OKC_K_PROCESSES table
2604: ---------------------------------------------------------------
2605: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_cpsv_tbl cpsv_tbl_type) IS
2606: l_tabsize NUMBER := p_cpsv_tbl.COUNT;
2607: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
2608:
2609: in_id OKC_DATATYPES.NumberTabTyp;
2610: in_object_version_number OKC_DATATYPES.NumberTabTyp;
2611: in_pdf_id OKC_DATATYPES.NumberTabTyp;