APPS.ICX_POR_MAP_CATEGORIES dependencies on ICX_CAT_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 84: /* DLD No need to check since there will be always a row in icx_cat_items_tlp

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
87: WHERE rt_category_id = :oldCatID
88: AND rownum = 1

Line 157: --Get the jobNum to update in icx_cat_items_tlp for the rebuild of intermedia index

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
159: INTO v_jobNum
160: FROM dual;
161: xErrLoc := 810;

Line 167: --to be updated in the primary_category_name in icx_cat_items_tlp

163:
164: xErrLoc := 1000;
165: FOR lang in c_installed_languages LOOP
166: --Get the category_name for the installed language
167: --to be updated in the primary_category_name in icx_cat_items_tlp
168: v_newCatName := 'NULL CATG NAME';
169: FOR i in 1..gNewCatLangTab.COUNT LOOP
170: if ( lang.language_code = gNewCatLangTab(i) ) then
171: v_newCatName := gNewCatNameTab(i);

Line 180: -- update icx_cat_items_tlp with jobNum and primary_category_name and primary_category_id.

176: END LOOP;
177: xErrLoc := 1100;
178: if ( v_newCatName <> 'NULL CATG NAME' ) then
179: xErrLoc := 1200;
180: -- update icx_cat_items_tlp with jobNum and primary_category_name and primary_category_id.
181: UPDATE icx_cat_items_tlp
182: SET --job_number = v_jobNum,
183: request_id = v_jobNum,
184: primary_category_id = gNewCatIdTab(1),

Line 181: UPDATE icx_cat_items_tlp

177: xErrLoc := 1100;
178: if ( v_newCatName <> 'NULL CATG NAME' ) then
179: xErrLoc := 1200;
180: -- update icx_cat_items_tlp with jobNum and primary_category_name and primary_category_id.
181: UPDATE icx_cat_items_tlp
182: SET --job_number = v_jobNum,
183: request_id = v_jobNum,
184: primary_category_id = gNewCatIdTab(1),
185: primary_category_name = v_newCatName

Line 194: p_message := p_message ||'; No: of rows updated in icx_cat_items_tlp for '||lang.language_code ||' :' ||SQL%ROWCOUNT;

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');
194: p_message := p_message ||'; No: of rows updated in icx_cat_items_tlp for '||lang.language_code ||' :' ||SQL%ROWCOUNT;
195: end if;
196: END LOOP;
197:
198: xErrLoc := 1300;