APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_ID_FLEX_SEGMENTS

Line 1616: l_default_value fnd_id_flex_segments.default_value%TYPE;

1612: 'upgrade_date_kff_segments');
1613: l_application_id NUMBER;
1614: l_ret_code NUMBER := g_ret_no_error;
1615: l_segs_count NUMBER := 0;
1616: l_default_value fnd_id_flex_segments.default_value%TYPE;
1617: l_old_vset_rec vset_rec_type;
1618: l_new_vset_rec vset_rec_type;
1619: l_struct_num_like VARCHAR2(500) := Nvl(p_struct_num_like, '%');
1620: l_struct_name_like VARCHAR2(500) := Nvl(p_struct_name_like, '%');

Line 1640: fnd_id_flex_segments ifsg, fnd_columns fc

1636: ifsg.segment_name, ifsg.application_column_name,
1637: ifsg.default_type, ifsg.default_value,
1638: fc.column_type, fc.width
1639: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,
1640: fnd_id_flex_segments ifsg, fnd_columns fc
1641: WHERE idf.application_id = ifst.application_id
1642: AND idf.id_flex_code = ifst.id_flex_code
1643: AND ifst.application_id = ifsg.application_id
1644: AND ifst.id_flex_code = ifsg.id_flex_code

Line 1761: UPDATE fnd_id_flex_segments

1757: END IF;
1758: END IF;
1759:
1760: BEGIN
1761: UPDATE fnd_id_flex_segments
1762: SET flex_value_set_id = l_new_vset_rec.flex_value_set_id,
1763: default_value = l_default_value,
1764: last_update_date = l_who_rec.last_update_date,
1765: last_updated_by = l_who_rec.last_updated_by

Line 1773: 'Failure in UPDATE fnd_id_flex_segments.', Sqlerrm);

1769: AND application_column_name = kff_rec.application_column_name;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: report_error(l_func_name,
1773: 'Failure in UPDATE fnd_id_flex_segments.', Sqlerrm);
1774: l_ret_code := g_ret_ignored_errors;
1775: END;
1776:
1777: COMMIT;

Line 1909: fnd_id_flex_segments s

1905: INTO
1906: l_num_segs
1907: FROM
1908: fnd_id_flexs f,
1909: fnd_id_flex_segments s
1910: WHERE
1911: s.flex_value_set_id=l_ind_vset_rec.flex_value_set_id AND
1912: f.application_id=s.application_id AND
1913: f.id_flex_code=s.id_flex_code AND

Line 1927: fnd_id_flex_segments fifsg

1923: INTO
1924: l_trans_msg
1925: FROM
1926: fnd_id_flexs fif, fnd_id_flex_structures fifst,
1927: fnd_id_flex_segments fifsg
1928: WHERE
1929: fifst.application_id = fif.application_id
1930: and fifst.id_flex_code = fif.id_flex_code
1931: and fifsg.application_id = fifst.application_id

Line 2286: fnd_id_flex_segments ifsg, fnd_columns fc

2282: ifsg.segment_name, ifsg.application_column_name,
2283: ifsg.default_type, ifsg.default_value, ifsg.ROWID,
2284: fc.column_type, fc.width
2285: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,
2286: fnd_id_flex_segments ifsg, fnd_columns fc
2287: WHERE idf.application_id = ifst.application_id
2288: AND idf.id_flex_code = ifst.id_flex_code
2289: AND ifst.application_id = ifsg.application_id
2290: AND ifst.id_flex_code = ifsg.id_flex_code

Line 2885: UPDATE fnd_id_flex_segments

2881: kff_rec.default_value || ': ' || l_error);
2882: END IF;
2883: IF (dff_rec.default_value <> l_vc2_tmp1) THEN
2884: BEGIN
2885: UPDATE fnd_id_flex_segments
2886: SET
2887: default_value = l_vc2_tmp1,
2888: last_update_date = p_who_rec.last_update_date,
2889: last_updated_by = p_who_rec.last_updated_by

Line 2898: 'Failure in UPDATE FND_ID_FLEX_SEGMENTS.',

2894: COMMIT;
2895: EXCEPTION
2896: WHEN OTHERS THEN
2897: cp_report_error(l_func_name,
2898: 'Failure in UPDATE FND_ID_FLEX_SEGMENTS.',
2899: Sqlerrm);
2900: END;
2901: END IF;
2902: END IF;

Line 3502: FROM fnd_id_flex_segments_vl ifsg, fnd_id_flex_structures_vl ifst,

3498: fvs.flex_value_set_name,
3499: fvs.maximum_size,
3500: fl3.meaning format_type_lookup
3501:
3502: FROM fnd_id_flex_segments_vl ifsg, fnd_id_flex_structures_vl ifst,
3503: fnd_id_flexs idf, fnd_application_vl fa,
3504: fnd_lookups fl1, fnd_lookups fl2, fnd_lookups fl3,
3505: fnd_flex_value_sets fvs
3506: WHERE idf.application_id = fa.application_id