DBA Data[Home] [Help]

APPS.OKC_LSE_PVT dependencies on OKC_UTIL

Line 523: l_col_tbl okc_util.unq_tbl_type;

519: FUNCTION Check_Unique_Name (
520: p_lsev_rec IN lsev_rec_type
521: ) RETURN VARCHAR2 IS
522: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
523: l_col_tbl okc_util.unq_tbl_type;
524: l_id NUMBER:=OKC_API.G_MISS_NUM;
525: CURSOR loc_top_csr (p_id IN NUMBER) is
526: select id, lse_type from okc_line_styles_b
527: connect by prior lse_parent_id = id

Line 689: x_return_status := OKC_UTIL.CHECK_LOOKUP_CODE('OKC_LINE_TYPE',p_lsev_rec.lty_code);

685: x_return_status := OKC_API.G_RET_STS_SUCCESS;
686: IF (p_lsev_rec.lty_code IS NOT NULL AND
687: p_lsev_rec.lty_code <> OKC_API.G_MISS_CHAR)
688: THEN
689: x_return_status := OKC_UTIL.CHECK_LOOKUP_CODE('OKC_LINE_TYPE',p_lsev_rec.lty_code);
690: if x_return_status = OKC_API.G_RET_STS_ERROR
691: Then
692: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LTY_CODE');
693: end if;