APPS.OKC_TCU_PVT dependencies on OKC_UTIL

Line 545: x_return_status := OKC_UTIL.CHECK_LOOKUP_CODE('OKC_TIME',p_tcuv_rec.TCE_CODE);

541: x_return_status := OKC_API.G_RET_STS_SUCCESS;
542: IF (p_tcuv_rec.TCE_CODE IS NOT NULL AND
543: p_tcuv_rec.TCE_CODE <> OKC_API.G_MISS_CHAR)
544: THEN
545: x_return_status := OKC_UTIL.CHECK_LOOKUP_CODE('OKC_TIME',p_tcuv_rec.TCE_CODE);
546: if x_return_status = OKC_API.G_RET_STS_ERROR
547: Then
548: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TCE_CODE');
549: end if;

Line 689: --l_col_tbl okc_util.unq_tbl_type;

685: -----------------------------------------------
686: FUNCTION Validate_Record (
687: p_tcuv_rec IN tcuv_rec_type
688: ) RETURN VARCHAR2 IS
689: --l_col_tbl okc_util.unq_tbl_type;
690: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
692: l_dummy VARCHAR2(1);
693: l_row_found Boolean := False;

Line 718: OKC_UTIL.check_comp_unique('OKC_TIME_CODE_UNITS_V',

714: l_col_tbl(1).p_col_name := 'TCE_CODE';
715: l_col_tbl(1).p_col_val := p_tcuv_rec.tce_code;
716: l_col_tbl(2).p_col_name := 'UOM_CODE';
717: l_col_tbl(2).p_col_val := p_tcuv_rec.uom_code;
718: OKC_UTIL.check_comp_unique('OKC_TIME_CODE_UNITS_V',
719: l_col_tbl,
720: l_return_status);
721: if l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
722: return (l_return_status);

Line 745: OKC_UTIL.check_comp_unique('OKC_TIME_CODE_UNITS_V',

741: l_col_tbl(1).p_col_name := 'UOM_CODE';
742: l_col_tbl(1).p_col_val := p_tcuv_rec.uom_code;
743: l_col_tbl(2).p_col_name := 'QUANTITY';
744: l_col_tbl(2).p_col_val := p_tcuv_rec.quantity;
745: OKC_UTIL.check_comp_unique('OKC_TIME_CODE_UNITS_V',
746: l_col_tbl,
747: l_return_status); */
748: OPEN c2(p_tcuv_rec.uom_code,
749: p_tcuv_rec.quantity);

Line 1184: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1180: ) RETURN VARCHAR2 IS
1181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1182: BEGIN
1183: x_okc_time_code_units_tl_rec := p_okc_time_code_units_tl_rec;
1184: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1185: x_okc_time_code_units_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1186: RETURN(l_return_status);
1187: END Set_Attributes;
1188: BEGIN

Line 1185: x_okc_time_code_units_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1182: BEGIN
1183: x_okc_time_code_units_tl_rec := p_okc_time_code_units_tl_rec;
1184: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1185: x_okc_time_code_units_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1186: RETURN(l_return_status);
1187: END Set_Attributes;
1188: BEGIN
1189: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2201: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2197: ) RETURN VARCHAR2 IS
2198: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2199: BEGIN
2200: x_okc_time_code_units_tl_rec := p_okc_time_code_units_tl_rec;
2201: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2202: x_okc_time_code_units_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2203: RETURN(l_return_status);
2204: END Set_Attributes;
2205: BEGIN

Line 2202: x_okc_time_code_units_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2198: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2199: BEGIN
2200: x_okc_time_code_units_tl_rec := p_okc_time_code_units_tl_rec;
2201: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2202: x_okc_time_code_units_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2203: RETURN(l_return_status);
2204: END Set_Attributes;
2205: BEGIN
2206: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2744: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2740: ) RETURN VARCHAR2 IS
2741: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2742: BEGIN
2743: x_okc_time_code_units_tl_rec := p_okc_time_code_units_tl_rec;
2744: x_okc_time_code_units_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2745: RETURN(l_return_status);
2746: END Set_Attributes;
2747: BEGIN
2748: l_return_status := OKC_API.START_ACTIVITY(l_api_name,