APPS.ICX_POR_MAP_CATEGORIES dependencies on ICX_CAT_EXT_ITEMS_TLP

Line 51: --updation of icx_cat_category_items, icx_cat_ext_items_tlp and icx_cat_items_tlp

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);

Line 95: update icx_cat_ext_items_tlp ext

91: */
92:
93: xErrLoc := 800;
94: --update cat_ext_items_tlp with the new category_id and make all the attributes to null
95: update icx_cat_ext_items_tlp ext
96: set rt_category_id = gNewCatIdTab(1), --newCatID
97: text_cat_attribute1 = null, text_cat_attribute2 = null, text_cat_attribute3 = null,
98: text_cat_attribute4 = null, text_cat_attribute5 = null, text_cat_attribute6 = null,
99: text_cat_attribute7 = null, text_cat_attribute8 = null, text_cat_attribute9 = null,

Line 154: p_message := p_message ||'; No: of rows updated in icx_cat_ext_items_tlp:' ||SQL%ROWCOUNT;

150: where ext.rt_item_id = b.rt_item_id
151: and b.extractor_updated_flag = 'Y' );
152: --end if;
153: xErrLoc := 810;
154: p_message := p_message ||'; No: of rows updated in icx_cat_ext_items_tlp:' ||SQL%ROWCOUNT;
155:
156: xErrLoc := 900;
157: --Get the jobNum to update in icx_cat_items_tlp for the rebuild of intermedia index
158: SELECT icx_por_batch_jobs_s.nextval