APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1270: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;

1266: l_new_vset_rec vset_rec_type;
1267: l_report_name_like VARCHAR2(200) :='$SRS$.'||Nvl(p_report_name_like,'%');
1268: l_ret_code NUMBER := g_ret_no_error;
1269: l_segs_count NUMBER := 0;
1270: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;
1271:
1272: CURSOR srs_cur(p_application_id IN NUMBER,
1273: p_flex_value_set_id IN NUMBER,
1274: p_report_name_like IN VARCHAR2)

Line 1281: FROM fnd_descr_flex_column_usages

1277: application_id, descriptive_flexfield_name,
1278: descriptive_flex_context_code,
1279: application_column_name, end_user_column_name,
1280: default_type, default_value
1281: FROM fnd_descr_flex_column_usages
1282: WHERE application_id = p_application_id
1283: AND flex_value_set_id = p_flex_value_set_id
1284: AND descriptive_flexfield_name LIKE p_report_name_like
1285: AND enabled_flag = 'Y'

Line 1385: UPDATE fnd_descr_flex_column_usages

1381: END IF;
1382: END IF;
1383:
1384: BEGIN
1385: UPDATE fnd_descr_flex_column_usages
1386: SET flex_value_set_id = l_new_vset_rec.flex_value_set_id,
1387: default_value = l_default_value,
1388: last_update_date = l_who_rec.last_update_date,
1389: last_updated_by = l_who_rec.last_updated_by

Line 1397: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',

1393: AND application_column_name = srs_rec.application_column_name;
1394: EXCEPTION
1395: WHEN OTHERS THEN
1396: report_error(l_func_name,
1397: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',
1398: Sqlerrm);
1399: l_ret_code := g_ret_ignored_errors;
1400: END;
1401: COMMIT;

Line 1430: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;

1426: 'upgrade_date_dff_segments');
1427: l_application_id NUMBER;
1428: l_ret_code NUMBER := g_ret_no_error;
1429: l_segs_count NUMBER := 0;
1430: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;
1431: l_old_vset_rec vset_rec_type;
1432: l_new_vset_rec vset_rec_type;
1433: l_dff_name_like VARCHAR2(500) := Nvl(p_dff_name_like, '%');
1434: l_context_code_like VARCHAR2(500) := Nvl(p_context_code_like, '%');

Line 1453: fnd_descr_flex_column_usages dfcu, fnd_columns fc

1449: dfcu.application_column_name, dfcu.end_user_column_name,
1450: dfcu.default_type, dfcu.default_value,
1451: fc.column_type, fc.width
1452: FROM fnd_descriptive_flexs df, fnd_descr_flex_contexts dfc,
1453: fnd_descr_flex_column_usages dfcu, fnd_columns fc
1454: WHERE df.application_id = dfc.application_id
1455: AND df.descriptive_flexfield_name = dfc.descriptive_flexfield_name
1456: AND dfc.application_id = dfcu.application_id
1457: AND dfc.descriptive_flexfield_name = dfcu.descriptive_flexfield_name

Line 1570: UPDATE fnd_descr_flex_column_usages

1566: END IF;
1567: END IF;
1568:
1569: BEGIN
1570: UPDATE fnd_descr_flex_column_usages
1571: SET flex_value_set_id = l_new_vset_rec.flex_value_set_id,
1572: default_value = l_default_value,
1573: last_update_date = l_who_rec.last_update_date,
1574: last_updated_by = l_who_rec.last_updated_by

Line 1582: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',

1578: AND application_column_name = dff_rec.application_column_name;
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: report_error(l_func_name,
1582: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',
1583: Sqlerrm);
1584: l_ret_code := g_ret_ignored_errors;
1585: END;
1586: COMMIT;

Line 2253: fnd_descr_flex_column_usages dfcu, fnd_columns fc

2249: dfcu.application_column_name, dfcu.end_user_column_name,
2250: dfcu.default_type, dfcu.default_value, dfcu.ROWID,
2251: fc.column_type, fc.width
2252: FROM fnd_descriptive_flexs df, fnd_descr_flex_contexts dfc,
2253: fnd_descr_flex_column_usages dfcu, fnd_columns fc
2254: WHERE df.application_id = dfc.application_id
2255: AND df.descriptive_flexfield_name = dfc.descriptive_flexfield_name
2256: AND dfc.application_id = dfcu.application_id
2257: AND dfc.descriptive_flexfield_name = dfcu.descriptive_flexfield_name

Line 2725: UPDATE fnd_descr_flex_column_usages

2721: dff_rec.default_value || ': ' || l_error);
2722: END IF;
2723: IF (dff_rec.default_value <> l_vc2_tmp1) THEN
2724: BEGIN
2725: UPDATE fnd_descr_flex_column_usages
2726: SET
2727: default_value = l_vc2_tmp1,
2728: last_update_date = p_who_rec.last_update_date,
2729: last_updated_by = p_who_rec.last_updated_by

Line 2739: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',

2735: EXCEPTION
2736: WHEN OTHERS THEN
2737: cp_report_error
2738: (l_func_name,
2739: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',
2740: Sqlerrm);
2741: END;
2742: END IF;
2743: END IF;