APPS.ICX_POR_SCHEMA_UPGRADE dependencies on ICX_CAT_DESCRIPTORS_TL

Line 7: ** Synopsis : Populate the icx_cat_categories_tl, icx_cat_descriptors_tl,

3:
4: /**
5: **
6: ** Procedure: create_new_categ_descs_tables
7: ** Synopsis : Populate the icx_cat_categories_tl, icx_cat_descriptors_tl,
8: ** and icx_cat_browse_trees table. The source for the above
9: ** tables are icx_por_categories_tl, icx_Por_descriptors_tl and
10: ** icx_por_table_of_contents_tl respectively.
11: **/

Line 82: insert into icx_cat_descriptors_tl

78: l_loc := 300;
79:
80: -- make a replica of icx_por_descriptors_tl
81: -- ignore the validated, class, customization_level,multivalue, section_tag
82: insert into icx_cat_descriptors_tl
83: (
84: RT_DESCRIPTOR_ID,
85: LANGUAGE,
86: SOURCE_LANG,

Line 153: and not exists (select null from icx_cat_descriptors_tl des2

149: decode(des1.rt_category_id, 0 , 'ICX_BASE_ATTR', 'ICX_CAT_ATTR')
150: from
151: icx_por_descriptors_tl des1
152: where des1.rt_descriptor_id > 100
153: and not exists (select null from icx_cat_descriptors_tl des2
154: where des1.rt_descriptor_id = des2.rt_descriptor_id
155: and des1.language = des2.language)
156: );
157: l_loc := 400;

Line 200: from icx_cat_descriptors_tl;

196: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Open the get_categories cursor to get distinct categories');
197:
198: open get_categories for
199: select distinct RT_CATEGORY_ID
200: from icx_cat_descriptors_tl;
201:
202: l_loc := 200;
203:
204: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Loop through every category to assign section tag and section map');