APPS.ICX_POR_SCHEMA_UPGRADE dependencies on ICX_POR_DESCRIPTORS_TL

Line 9: ** tables are icx_por_categories_tl, icx_Por_descriptors_tl and

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: **/
12: PROCEDURE create_new_categ_descs_tables IS
13: BEGIN

Line 80: -- make a replica of icx_por_descriptors_tl

76: );
77:
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,

Line 151: icx_por_descriptors_tl des1

147: des1.ITEM_DETAIL_VISIBLE,
148: des1.REBUILD_FLAG,
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)