APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SOLN_CATEGORIES_TL

Line 3725: from cs_kb_soln_categories_tl

3721: fetch c1 INTO category_id_tbl(j);
3722: exit when c1%NOTFOUND;
3723:
3724: select name into l_cat_name
3725: from cs_kb_soln_categories_tl
3726: where language = userenv('LANG') and category_id = category_id_tbl(j);
3727:
3728: if(p_verify and 0 < instr(l_cat_name, '>')) then
3729: contains_gt := true;

Line 3765: cs_kb_soln_categories_tl

3761: ) RETURN NUMBER IS
3762:
3763: Cursor c1 is
3764: select category_id from
3765: cs_kb_soln_categories_tl
3766: where upper(name) = upper(p_last_name)
3767: and language = userenv('LANG');
3768:
3769: cursor c2(c_id IN NUMBER) is

Line 3775: ) b, cs_kb_soln_categories_tl tl

3771: from ( SELECT category_id, level lev
3772: FROM cs_kb_soln_categories_b
3773: START WITH category_id = c_id
3774: CONNECT BY prior parent_category_id = category_id
3775: ) b, cs_kb_soln_categories_tl tl
3776: where
3777: b.category_id = tl.category_id
3778: and tl.language = userenv( 'LANG' )
3779: order by b.lev;

Line 3880: l_temp CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

3876: p_category_name IN varchar2,
3877: p_delim IN VARCHAR2
3878: ) RETURN VARCHAR2 IS
3879:
3880: l_temp CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;
3881: l_start_loc number := 1;
3882: l_temp_loc number := 1;
3883: l_temp_loc_buf number := 1;
3884: l_length number;

Line 3885: l_out CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

3881: l_start_loc number := 1;
3882: l_temp_loc number := 1;
3883: l_temp_loc_buf number := 1;
3884: l_length number;
3885: l_out CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;
3886:
3887: begin
3888: --remove spaces
3889:

Line 4009: l_category_name CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

4005: from cs_kb_set_categories a
4006: where a.set_id = c_set_id;
4007:
4008: -- Declare some local temporary variables
4009: l_category_name CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;
4010: l_category_id NUMBER(15);
4011: l_ret_val NUMBER(15);
4012: l_gt VARCHAR2(15);
4013: l_elmt_content_type VARCHAR2(30);