DBA Data[Home] [Help]

APPS.OKC_AAV_PVT dependencies on OKC_UTIL

Line 378: --l_unq_tbl OKC_UTIL.unq_tbl_type;

374: ,p_aavv_rec IN aavv_rec_type)
375: IS
376:
377: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
378: --l_unq_tbl OKC_UTIL.unq_tbl_type;
379: l_dummy VARCHAR2(1);
380: l_row_found Boolean := False;
381: CURSOR c1(p_aae_id okc_action_att_vals_v.aae_id%TYPE,
382: p_coe_id okc_action_att_vals_v.coe_id%TYPE) is

Line 407: OKC_UTIL.check_comp_unique('OKC_ACTION_ATT_VALS_V'

403: -- initialize return status
404: x_return_status := OKC_API.G_RET_STS_SUCCESS;
405:
406: -- call check_comp_unique utility
407: OKC_UTIL.check_comp_unique('OKC_ACTION_ATT_VALS_V'
408: ,l_unq_tbl
409: ,l_return_status);
410: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
411: x_return_status := OKC_API.G_RET_STS_ERROR;

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

2144: -- Procedure for mass insert in OKC_ACTION_ATTRIBUTES_VALS _B and TL tables
2145: ---------------------------------------------------------------
2146: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_aavv_tbl aavv_tbl_type) IS
2147: l_tabsize NUMBER := p_aavv_tbl.COUNT;
2148: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
2149:
2150: in_aae_id OKC_DATATYPES.NumberTabTyp;
2151: in_coe_id OKC_DATATYPES.NumberTabTyp;
2152: in_object_version_number OKC_DATATYPES.NumberTabTyp;