APPS.ICX_POR_MAP_CATEGORIES dependencies on ICX_CAT_CATEGORIES_TL

Line 24: FROM icx_cat_categories_tl

20: p_message OUT VARCHAR2)
21: IS
22: cursor c_populate_new_cat_info(p_destCatKey VARCHAR2) is
23: SELECT rt_category_id, category_name, language
24: FROM icx_cat_categories_tl
25: WHERE upper_key = UPPER(p_destCatKey) ;
26:
27: cursor c_installed_languages is
28: SELECT language_code

Line 35: v_newCatName icx_cat_categories_tl.category_name%TYPE;

31:
32: xErrLoc INTEGER := 0;
33: v_oldCatId NUMBER := -1;
34: v_jobNum NUMBER := -1;
35: v_newCatName icx_cat_categories_tl.category_name%TYPE;
36:
37: BEGIN
38: p_status := 'Y'; --SUCCESS
39: xErrLoc := 100;

Line 65: FROM icx_cat_categories_tl

61:
62: xErrLoc := 600;
63: --Get the category_id of sourceCategory
64: SELECT rt_category_id INTO v_oldCatId
65: FROM icx_cat_categories_tl
66: WHERE upper_key = UPPER(p_oldCatKey)
67: and rownum = 1;
68: p_message := p_message ||'; newCatdId:' ||gNewCatIdTab(1) ||', oldCatId:' ||v_oldCatId;
69: