APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SOLN_CATEGORIES_TL

Line 3715: from cs_kb_soln_categories_tl

3711: fetch c1 INTO category_id_tbl(j);
3712: exit when c1%NOTFOUND;
3713:
3714: select name into l_cat_name
3715: from cs_kb_soln_categories_tl
3716: where language = userenv('LANG') and category_id = category_id_tbl(j);
3717:
3718: if(p_verify and 0 < instr(l_cat_name, '>')) then
3719: contains_gt := true;

Line 3755: cs_kb_soln_categories_tl

3751: ) RETURN NUMBER IS
3752:
3753: Cursor c1 is
3754: select category_id from
3755: cs_kb_soln_categories_tl
3756: where upper(name) = upper(p_last_name)
3757: and language = userenv('LANG');
3758:
3759: cursor c2(c_id IN NUMBER) is

Line 3765: ) b, cs_kb_soln_categories_tl tl

3761: from ( SELECT category_id, level lev
3762: FROM cs_kb_soln_categories_b
3763: START WITH category_id = c_id
3764: CONNECT BY prior parent_category_id = category_id
3765: ) b, cs_kb_soln_categories_tl tl
3766: where
3767: b.category_id = tl.category_id
3768: and tl.language = userenv( 'LANG' )
3769: order by b.lev;

Line 3870: l_temp CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

3866: p_category_name IN varchar2,
3867: p_delim IN VARCHAR2
3868: ) RETURN VARCHAR2 IS
3869:
3870: l_temp CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;
3871: l_start_loc number := 1;
3872: l_temp_loc number := 1;
3873: l_temp_loc_buf number := 1;
3874: l_length number;

Line 3875: l_out CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

3871: l_start_loc number := 1;
3872: l_temp_loc number := 1;
3873: l_temp_loc_buf number := 1;
3874: l_length number;
3875: l_out CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;
3876:
3877: begin
3878: --remove spaces
3879:

Line 3999: l_category_name CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;

3995: from cs_kb_set_categories a
3996: where a.set_id = c_set_id;
3997:
3998: -- Declare some local temporary variables
3999: l_category_name CS_KB_SOLN_CATEGORIES_TL.NAME%TYPE;
4000: l_category_id NUMBER(15);
4001: l_ret_val NUMBER(15);
4002: l_gt VARCHAR2(15);
4003: l_elmt_content_type VARCHAR2(30);