APPS.FND_FLEX_VAL_API dependencies on FND_ID_FLEX_SEGMENTS

Line 1326: FROM fnd_id_flex_segments

1322: -- Is this value set used by a key flexfield segment.
1323: --
1324: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1325: count(*) INTO l_row_count
1326: FROM fnd_id_flex_segments
1327: WHERE flex_value_set_id = l_value_set_id;
1328:
1329: -- IF (l_row_count <> 0) THEN
1330: -- message('This value set is used in at least one of the key flexfield ');

Line 1341: FROM fnd_id_flex_segments g, fnd_id_flex_structures_tl c

1337: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1338: g.application_id || ':' || g.id_flex_code || ':' ||
1339: c.id_flex_structure_name || ':' || g.application_column_name
1340: INTO l_dummy_vc2
1341: FROM fnd_id_flex_segments g, fnd_id_flex_structures_tl c
1342: WHERE g.flex_value_set_id = l_value_set_id
1343: AND c.id_flex_code = g.id_flex_code
1344: AND c.id_flex_num = g.id_flex_num
1345: AND c.application_id = g.application_id

Line 3955: fnd_flex_value_sets v, fnd_id_flex_segments s

3951: s.segment_num, v.parent_flex_value_set_id
3952: INTO
3953: l_segment_num, l_parent_value_set_id
3954: FROM
3955: fnd_flex_value_sets v, fnd_id_flex_segments s
3956: WHERE
3957: v.flex_value_set_id = p_value_set_id
3958: AND s.id_flex_num = p_id_flex_num
3959: AND v.parent_flex_value_set_id = s.flex_value_set_id;

Line 4074: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)

4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4074: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4075: IS
4076:
4077: l_format_type_name VARCHAR2(80);
4078: l_appl_column_type_name VARCHAR2(80);

Line 4174: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)

4170:
4171: PROCEDURE is_vset_obsolete(
4172: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4173: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4174: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4175: IS
4176: BEGIN
4177:
4178: /*

Line 4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,

4390: -- certain segment. Now we have a separate procedure for KFF.
4391:
4392: PROCEDURE is_value_set_allowed_kff
4393: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,

Line 4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,

4391:
4392: PROCEDURE is_value_set_allowed_kff
4393: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4399: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)

Line 4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,

4392: PROCEDURE is_value_set_allowed_kff
4393: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4399: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4400: IS

Line 4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,

4393: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4399: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4400: IS
4401:

Line 4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,

4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4399: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4400: IS
4401:
4402: l_validation_type VARCHAR2(1);

Line 4399: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)

4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
4398: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
4399: p_segment_num IN fnd_id_flex_segments.segment_num%TYPE)
4400: IS
4401:
4402: l_validation_type VARCHAR2(1);
4403: l_format_type VARCHAR2(1);

Line 4565: fnd_flex_value_sets v, fnd_id_flex_segments s

4561: min(s.segment_num), v.parent_flex_value_set_id
4562: INTO
4563: l_segment_num, l_parent_value_set_id
4564: FROM
4565: fnd_flex_value_sets v, fnd_id_flex_segments s
4566: WHERE
4567: v.flex_value_set_id = p_flex_value_set_id
4568: -- Bug#4564981
4569: AND s.application_id = p_application_id