[Home] [Help]
166: ,t.FORM_LEFT_PROMPT
167: ,t.FORM_ABOVE_PROMPT
168: ,t.DESCRIPTION
169: ,t.language
170: FROM fnd_descr_flex_col_usage_tl t
171: ,fnd_descr_flex_column_usages b
172: WHERE b.application_id = t.application_id
173: AND b.descriptive_flexfield_name = t.descriptive_flexfield_name
174: AND b.descriptive_flex_context_code = t.descriptive_flex_context_code
341: RANGE => NULL);
342:
343: END IF;
344: END LOOP; --c_get_segments
345: pay_ip_startup_util.write_log('LOG','PAY_34015_IP_UPD_TABLE','FND_DESCR_FLEX_COL_USAGE_TL for the Context '||lv_new_context_name,NULL);
346: update_flex_col_usages_tl(lv_desc_flex_context_code,lv_new_context_name,p_dff_name);
347:
348: END LOOP;--get_context_rec
349: CLOSE cv_get_context;
366: ,t.FORM_LEFT_PROMPT
367: ,t.FORM_ABOVE_PROMPT
368: ,t.DESCRIPTION
369: ,t.language
370: FROM fnd_descr_flex_col_usage_tl t
371: ,fnd_descr_flex_column_usages b
372: WHERE b.application_id = t.application_id
373: AND b.descriptive_flexfield_name = t.descriptive_flexfield_name
374: AND b.descriptive_flex_context_code = t.descriptive_flex_context_code
384: FOR rec in c_get_segments_ol(P_SOURCE_CONTEXT_CODE)
385: LOOP
386:
387: hr_utility.trace('Entered pay_ip_utility.update_flex_col_usages_tl --For Loop');
388: UPDATE fnd_descr_flex_col_usage_tl SET
389: FORM_LEFT_PROMPT = rec.FORM_LEFT_PROMPT
390: ,FORM_ABOVE_PROMPT = rec.FORM_ABOVE_PROMPT
391: ,DESCRIPTION = rec.DESCRIPTION
392: WHERE APPLICATION_ID = rec.APPLICATION_ID
394: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = P_DEST_CONTEXT_CODE
395: AND APPLICATION_COLUMN_NAME = rec.APPLICATION_COLUMN_NAME
396: AND LANGUAGE = rec.LANGUAGE;
397:
398: hr_utility.trace('Updated fnd_descr_flex_col_usage_tl = '||SQL%ROWCOUNT);
399: END LOOP;
400: END update_flex_col_usages_tl;
401:
402: -- ---------------------------------------------------------------------