APPS.ICX_POR_SCHEMA_UPGRADE dependencies on ICX_CAT_BROWSE_TREES

Line 8: ** and icx_cat_browse_trees table. The source for the above

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

Line 159: -- Populate the icx_cat_browse_trees with rows

155: and des1.language = des2.language)
156: );
157: l_loc := 400;
158:
159: -- Populate the icx_cat_browse_trees with rows
160: -- from icx_por_table_of_contents_tl
161: insert into icx_cat_browse_trees (PARENT_CATEGORY_ID,
162: CHILD_CATEGORY_ID, LAST_UPDATE_LOGIN ,
163: LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE)

Line 161: insert into icx_cat_browse_trees (PARENT_CATEGORY_ID,

157: l_loc := 400;
158:
159: -- Populate the icx_cat_browse_trees with rows
160: -- from icx_por_table_of_contents_tl
161: insert into icx_cat_browse_trees (PARENT_CATEGORY_ID,
162: CHILD_CATEGORY_ID, LAST_UPDATE_LOGIN ,
163: LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE)
164: select toc1.RT_CATEGORY_ID, toc1.CHILD, 1, toc1.LAST_UPDATED_BY,
165: toc1.LAST_UPDATE_DATE, toc1.CREATED_BY, toc1.CREATION_DATE

Line 167: where not exists (select null from icx_cat_browse_trees toc2

163: LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE)
164: select toc1.RT_CATEGORY_ID, toc1.CHILD, 1, toc1.LAST_UPDATED_BY,
165: toc1.LAST_UPDATE_DATE, toc1.CREATED_BY, toc1.CREATION_DATE
166: from icx_por_table_of_contents_tl toc1
167: where not exists (select null from icx_cat_browse_trees toc2
168: where toc2.PARENT_CATEGORY_ID = toc1.RT_CATEGORY_ID
169: and toc2.CHILD_CATEGORY_ID = toc1.CHILD);
170:
171: l_loc := 500;