APPS.ICX_POR_SCHEMA_UPGRADE dependencies on ICX_CAT_CATEGORIES_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 20: insert into icx_cat_categories_tl

16: -- Make a replica(new table) of the categories and descriptors table
17: -- dont do a blind replica, may be section map did not exist in
18: -- the current version of the customer's odf
19: -- Bug#2830088: modified the "not exists" for category check.
20: insert into icx_cat_categories_tl
21: (
22: RT_CATEGORY_ID,
23: LANGUAGE,
24: SOURCE_LANG,

Line 72: and not exists (select null from icx_cat_categories_tl ct2

68: UPPER_KEY
69: from
70: icx_por_categories_tl ct1
71: where ct1.rt_category_id > 0
72: and not exists (select null from icx_cat_categories_tl ct2
73: where ct1.key = ct2.key
74: and ct1.type = ct2.type
75: and ct1.language = ct2.language)
76: );