APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_CAT_CATEGORIES_TL

Line 92: category_name icx_cat_categories_tl.category_name%TYPE,

88: and creating the correct number of rows in the languages the item already
89: exists in
90: */
91: TYPE CategoryInfo IS RECORD (
92: category_name icx_cat_categories_tl.category_name%TYPE,
93: descriptor_count PLS_INTEGER := 0,
94: searchable_desc_count PLS_INTEGER := 0,
95: updateTLSQL VARCHAR2(32767),
96: updateNonTLSQL VARCHAR2(32767),

Line 542: SELECT category_name FROM icx_cat_categories_tl

538: v_distinct_catids dbms_sql.number_table;
539: v_category_info CategoryInfo;
540: i PLS_INTEGER;
541: CURSOR get_category_name(p_category_id NUMBER) IS
542: SELECT category_name FROM icx_cat_categories_tl
543: WHERE rt_category_id = p_category_id
544: AND language = gJobLanguage;
545: v_current_catid NUMBER;
546: xErrLoc PLS_INTEGER := 100;

Line 5071: set primary_category_name = (select category_name from icx_cat_categories_tl

5067: -- build_root_sql() as primary_category_name is a translated attribute.
5068: FOR i in 1..xLangArray.COUNT LOOP
5069: FORALL j in 1..gChangedCatItemIds.COUNT
5070: update icx_cat_items_tlp
5071: set primary_category_name = (select category_name from icx_cat_categories_tl
5072: where rt_category_id = gChangedNewCatIds(j)
5073: and language = xLangArray(i))
5074: where rt_item_id = gChangedCatItemIds(j) and language = xLangArray(i);
5075: END LOOP;