APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1268: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;

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

Line 1279: FROM fnd_descr_flex_column_usages

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

Line 1383: UPDATE fnd_descr_flex_column_usages

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

Line 1395: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',

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

Line 1428: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;

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

Line 1451: fnd_descr_flex_column_usages dfcu, fnd_columns fc

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

Line 1568: UPDATE fnd_descr_flex_column_usages

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

Line 1580: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',

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

Line 2251: fnd_descr_flex_column_usages dfcu, fnd_columns fc

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

Line 2723: UPDATE fnd_descr_flex_column_usages

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

Line 2737: 'Failure in UPDATE FND_DESCR_FLEX_COLUMN_USAGES.',

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