APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_ID_FLEX_SEGMENTS

Line 1614: l_default_value fnd_id_flex_segments.default_value%TYPE;

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

Line 1638: fnd_id_flex_segments ifsg, fnd_columns fc

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

Line 1759: UPDATE fnd_id_flex_segments

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

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

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

Line 1907: fnd_id_flex_segments s

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

Line 1925: fnd_id_flex_segments fifsg

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

Line 2284: fnd_id_flex_segments ifsg, fnd_columns fc

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

Line 2883: UPDATE fnd_id_flex_segments

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

Line 2896: 'Failure in UPDATE FND_ID_FLEX_SEGMENTS.',

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

Line 3500: FROM fnd_id_flex_segments_vl ifsg, fnd_id_flex_structures_vl ifst,

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