[Home] [Help]
47: p_message := 'No: of rows updated in icx_por_category_data_sources:' ||SQL%ROWCOUNT;
48:
49: xErrLoc := 200;
50: --Mapping already existed only then requires the
51: --updation of icx_cat_category_items, icx_cat_ext_items_tlp and icx_cat_items_tlp
52: if ( SQL%ROWCOUNT > 0 ) then
53: --populate the destCategory informations
54: xErrLoc := 300;
55: OPEN c_populate_new_cat_info (p_destCatKey);
68: p_message := p_message ||'; newCatdId:' ||gNewCatIdTab(1) ||', oldCatId:' ||v_oldCatId;
69:
70: xErrLoc := 700;
71: --update category_items
72: UPDATE icx_cat_category_items ci1
73: SET ci1.rt_category_id = gNewCatIdTab(1)
74: WHERE (ci1.rt_item_id, ci1.rt_category_id) in
75: (SELECT ci2.rt_item_id, ci2.rt_category_id
76: FROM icx_cat_category_items ci2,
72: UPDATE icx_cat_category_items ci1
73: SET ci1.rt_category_id = gNewCatIdTab(1)
74: WHERE (ci1.rt_item_id, ci1.rt_category_id) in
75: (SELECT ci2.rt_item_id, ci2.rt_category_id
76: FROM icx_cat_category_items ci2,
77: icx_cat_items_b i
78: WHERE ci2.rt_category_id = v_oldCatId
79: AND ci2.rt_item_id = i.rt_item_id
80: -- only update extracted items
78: WHERE ci2.rt_category_id = v_oldCatId
79: AND ci2.rt_item_id = i.rt_item_id
80: -- only update extracted items
81: AND i.extractor_updated_flag = 'Y' );
82: p_message := p_message ||'; No: of rows updated in icx_cat_category_items:' ||SQL%ROWCOUNT;
83:
84: /* DLD No need to check since there will be always a row in icx_cat_items_tlp
85: SELECT 1 into hasLocals
86: FROM icx_cat_descriptors_tl
185: primary_category_name = v_newCatName
186: WHERE language = lang.language_code
187: AND rt_item_id in
188: (SELECT i.rt_item_id
189: FROM icx_cat_category_items ci,
190: icx_cat_items_b i
191: WHERE ci.rt_category_id = gNewCatIdTab(1)
192: AND ci.rt_item_id = i.rt_item_id
193: AND i.extractor_updated_flag = 'Y');