APPS.FND_FLEX_VAL_API dependencies on FND_ID_FLEX_SEGMENTS

Line 1337: FROM fnd_id_flex_segments

1333: -- Is this value set used by a key flexfield segment.
1334: --
1335: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1336: count(*) INTO l_row_count
1337: FROM fnd_id_flex_segments
1338: WHERE flex_value_set_id = l_value_set_id;
1339:
1340: -- IF (l_row_count <> 0) THEN
1341: -- message('This value set is used in at least one of the key flexfield ');

Line 1352: FROM fnd_id_flex_segments g, fnd_id_flex_structures_tl c

1348: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1349: g.application_id || ':' || g.id_flex_code || ':' ||
1350: c.id_flex_structure_name || ':' || g.application_column_name
1351: INTO l_dummy_vc2
1352: FROM fnd_id_flex_segments g, fnd_id_flex_structures_tl c
1353: WHERE g.flex_value_set_id = l_value_set_id
1354: AND c.id_flex_code = g.id_flex_code
1355: AND c.id_flex_num = g.id_flex_num
1356: AND c.application_id = g.application_id

Line 4083: fnd_flex_value_sets v, fnd_id_flex_segments s

4079: s.segment_num, v.parent_flex_value_set_id
4080: INTO
4081: l_segment_num, l_parent_value_set_id
4082: FROM
4083: fnd_flex_value_sets v, fnd_id_flex_segments s
4084: WHERE
4085: v.flex_value_set_id = p_value_set_id
4086: AND s.id_flex_num = p_id_flex_num
4087: AND v.parent_flex_value_set_id = s.flex_value_set_id;

Line 4202: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)

4198: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4199: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4200: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4201: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4202: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4203: IS
4204:
4205: l_format_type_name VARCHAR2(80);
4206: l_appl_column_type_name VARCHAR2(80);

Line 4302: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)

4298:
4299: PROCEDURE is_vset_obsolete(
4300: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4301: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4302: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4303: IS
4304: BEGIN
4305:
4306: /*

Line 4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,

4518: -- certain segment. Now we have a separate procedure for KFF.
4519:
4520: PROCEDURE is_value_set_allowed_kff
4521: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,

Line 4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,

4519:
4520: PROCEDURE is_value_set_allowed_kff
4521: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4527: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)

Line 4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,

4520: PROCEDURE is_value_set_allowed_kff
4521: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4527: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4528: IS

Line 4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,

4521: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4527: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4528: IS
4529:

Line 4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,

4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4527: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4528: IS
4529:
4530: l_validation_type VARCHAR2(1);

Line 4527: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)

4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4526: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4527: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4528: IS
4529:
4530: l_validation_type VARCHAR2(1);
4531: l_format_type VARCHAR2(1);

Line 4693: fnd_flex_value_sets v, fnd_id_flex_segments s

4689: min(s.segment_num), v.parent_flex_value_set_id
4690: INTO
4691: l_segment_num, l_parent_value_set_id
4692: FROM
4693: fnd_flex_value_sets v, fnd_id_flex_segments s
4694: WHERE
4695: v.flex_value_set_id = p_flex_value_set_id
4696: -- Bug#4564981
4697: AND s.application_id = p_application_id