APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_CAT_DESCRIPTORS_TL

Line 381: from icx_cat_descriptors_tl d

377: d.section_tag,
378: d.stored_in_column,
379: d.stored_in_table,
380: d.searchable
381: from icx_cat_descriptors_tl d
382: where d.rt_category_id = v_category_id
383: and d.language = gJobLanguage
384: order by d.rt_descriptor_id;
385: vColName VARCHAR2(30);

Line 608: from icx_cat_descriptors_tl

604: section_tag,
605: stored_in_column,
606: stored_in_table,
607: searchable
608: from icx_cat_descriptors_tl
609: where rt_category_id = p_category_id
610: and language = gJobLanguage
611: and stored_in_table = 'ICX_CAT_ITEMS_TLP'
612: order by rt_descriptor_id;

Line 2321: from icx_cat_descriptors_tl d

2317: PROCEDURE fetch_local_descriptors(pCategoryId IN NUMBER) IS
2318: i pls_integer := 0;
2319: CURSOR local_descriptors_cr(v_category_id NUMBER) IS
2320: select d.key
2321: from icx_cat_descriptors_tl d
2322: where d.rt_category_id = v_category_id
2323: -- and d.class in ('POM_CAT_ATTR')
2324: and d.language = gJobLanguage
2325: order by d.rt_descriptor_id;

Line 2362: from icx_cat_descriptors_tl

2358: CURSOR custom_non_price_desc_cr(p_category_id NUMBER) IS
2359: select rt_descriptor_id, type, key,
2360: section_tag, stored_in_column, stored_in_table,
2361: searchable
2362: from icx_cat_descriptors_tl
2363: where rt_category_id = p_category_id
2364: and language = gJobLanguage
2365: and stored_in_table = 'ICX_CAT_ITEMS_TLP'
2366: and rt_descriptor_id >= 100000

Line 3253: vDescName ICX_CAT_DESCRIPTORS_TL.KEY%TYPE;

3249: PROCEDURE save_required_desc_errors(p_request_id IN NUMBER,
3250: p_line_number IN NUMBER, p_desc_names IN VARCHAR2) IS
3251: vBreakPos PLS_INTEGER := 1;
3252: vStartPos PLS_INTEGER := 1;
3253: vDescName ICX_CAT_DESCRIPTORS_TL.KEY%TYPE;
3254: BEGIN
3255: IF (p_desc_names IS NULL) THEN
3256: RETURN;
3257: END IF;