eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEX_SEGMENTS

Line 64: FROM fnd_id_flex_segments_vl

60: structure IN structure_type,
61: enabled IN VARCHAR2 DEFAULT NULL) IS
62: SELECT segment_name,
63: application_column_name
64: FROM fnd_id_flex_segments_vl
65: WHERE application_id = flexfield.application_id
66: AND id_flex_code = flexfield.flex_code
67: AND id_flex_num = structure.structure_number
68: AND (enabled IS NULL or enabled_flag = 'Y')

Line 445: AND NOT EXISTS (SELECT NULL FROM fnd_id_flex_segments

441: AND c.flexfield_usage_code = 'K'
442: -- AND ct.lookup_type = 'COLUMN_TYPE'
443: -- AND ct.lookup_code = column_type
444: -- check that it is not already in use
445: AND NOT EXISTS (SELECT NULL FROM fnd_id_flex_segments
446: WHERE application_id = flexfield.application_id
447: AND id_flex_code = flexfield.flex_code
448: AND id_flex_num = structure.structure_number
449: AND application_column_name = c.column_name)

Line 506: (SELECT NULL FROM fnd_id_flex_segments s

502: v.format_type))))
503: AND (application_column_type_i = 'D'
504: OR application_column_size_i >= Nvl(id_column_size, maximum_size))
505: AND (validation_type <> 'D' OR EXISTS
506: (SELECT NULL FROM fnd_id_flex_segments s
507: WHERE application_id = flexfield.application_id
508: AND id_flex_code = flexfield.flex_code
509: AND id_flex_num = structure.structure_number
510: AND s.flex_value_set_id = v.parent_flex_value_set_id

Line 720: segment_name IN fnd_id_flex_segments_vl.segment_name%TYPE)

716: /* ------------------------------------------------------------ */
717: FUNCTION check_duplicate_segment(
718: flexfield IN flexfield_type,
719: structure IN structure_type,
720: segment_name IN fnd_id_flex_segments_vl.segment_name%TYPE)
721: RETURN NUMBER
722: IS
723: row_count NUMBER;
724: BEGIN

Line 730: FROM fnd_id_flex_segments_vl v

726: -- Check for duplicate segment name.
727: --
728: SELECT count(*)
729: INTO row_count
730: FROM fnd_id_flex_segments_vl v
731: WHERE application_id = flexfield.application_id
732: AND id_flex_code = flexfield.flex_code
733: AND id_flex_num = structure.structure_number
734: AND v.segment_name = check_duplicate_segment.segment_name

Line 1584: FROM fnd_id_flex_segments ifsg

1580: created_by_i,
1581: last_update_date_i,
1582: last_updated_by_i,
1583: last_update_login_i
1584: FROM fnd_id_flex_segments ifsg
1585: WHERE application_id = flexfield.application_id
1586: AND id_flex_code = flexfield.flex_code
1587: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
1588:

Line 1651: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav

1647: s.id_flex_num || '/' ||
1648: s.application_column_name || '/' ||
1649: s.segment_name
1650: INTO l_vc2
1651: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav
1652: WHERE s.application_id = sav.application_id
1653: AND s.id_flex_code = sav.id_flex_code
1654: AND s.id_flex_num = sav.id_flex_num
1655: AND s.application_column_name = sav.application_column_name

Line 1755: FROM fnd_id_flex_segments ifsg,

1751: created_by_i,
1752: last_update_date_i,
1753: last_updated_by_i,
1754: last_update_login_i
1755: FROM fnd_id_flex_segments ifsg,
1756: fnd_segment_attribute_types sat
1757: WHERE sat.application_id = ifsg.application_id
1758: AND sat.id_flex_code = ifsg.id_flex_code
1759: AND NOT exists

Line 1909: fnd_id_flex_segments ifsg

1905: flex_qualifier,
1906: qualifier_name,
1907: SYSDATE
1908: FROM fnd_segment_attribute_values sav,
1909: fnd_id_flex_segments ifsg
1910: WHERE sav.application_id = flexfield.application_id
1911: AND sav.id_flex_code = flexfield.flex_code
1912: AND sav.segment_attribute_type = flex_qualifier
1913: AND sav.attribute_value = 'Y'

Line 2706: FROM fnd_id_flex_segments_vl seg

2702: seg.concatenation_description_len,
2703: seg.form_above_prompt,
2704: seg.form_left_prompt
2705: INTO segment
2706: FROM fnd_id_flex_segments_vl seg
2707: WHERE seg.application_id = flexfield.application_id
2708: AND seg.id_flex_code = flexfield.flex_code
2709: AND seg.id_flex_num = structure.structure_number
2710: AND seg.segment_name = find_segment.segment_name

Line 2748: INTO fnd_id_flex_segments (application_id,

2744:
2745: validate_segment(flexfield, structure, segment);
2746:
2747: INSERT
2748: INTO fnd_id_flex_segments (application_id,
2749: id_flex_code,
2750: id_flex_num,
2751:
2752: application_column_name,

Line 2840: FROM fnd_id_flex_segments s, fnd_segment_attribute_types t

2836: last_update_login_i,
2837:
2838: t.global_flag,
2839: s.application_id
2840: FROM fnd_id_flex_segments s, fnd_segment_attribute_types t
2841: WHERE s.application_id = flexfield.application_id
2842: AND s.application_column_name = segment.column_name
2843: AND s.id_flex_code = flexfield.flex_code
2844: AND s.id_flex_num = structure.structure_number

Line 2885: INSERT INTO fnd_id_flex_segments_tl(application_id,

2881: AND q.value_attribute_type = vat.value_attribute_type)
2882: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2883: END;
2884:
2885: INSERT INTO fnd_id_flex_segments_tl(application_id,
2886: id_flex_code,
2887: id_flex_num,
2888: application_column_name,
2889: language,

Line 2921: FROM fnd_id_flex_segments_tl t

2917: FROM fnd_languages l
2918: WHERE l.installed_flag IN ('I', 'B')
2919: AND NOT EXISTS
2920: (SELECT NULL
2921: FROM fnd_id_flex_segments_tl t
2922: WHERE t.application_id = flexfield.application_id
2923: AND t.id_flex_code = flexfield.flex_code
2924: AND t.id_flex_num = structure.structure_number
2925: AND t.application_column_name = segment.column_name

Line 3046: UPDATE fnd_id_flex_segments SET

3042: do_validation := FALSE;
3043: validate_segment(flexfield, structure, segment);
3044: do_validation := TRUE;
3045:
3046: UPDATE fnd_id_flex_segments SET
3047: -- application_column_name = segment.column_name,
3048: segment_name = segment.segment_name,
3049: segment_num = segment.segment_number,
3050: application_column_index_flag = segment.indexed_flag,

Line 3126: UPDATE fnd_id_flex_segments_tl SET

3122: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3123: END;
3124:
3125:
3126: UPDATE fnd_id_flex_segments_tl SET
3127: application_column_name = segment.column_name,
3128: form_left_prompt = segment.window_prompt,
3129: form_above_prompt = segment.lov_prompt,
3130: description = segment.description,

Line 3174: DELETE FROM fnd_id_flex_segments_tl

3170:
3171: --
3172: -- Delete from translation table.
3173: --
3174: DELETE FROM fnd_id_flex_segments_tl
3175: WHERE application_id = flexfield.application_id
3176: AND id_flex_code = flexfield.flex_code
3177: AND id_flex_num = structure.structure_number
3178: AND application_column_name = segment.column_name

Line 3184: DELETE FROM fnd_id_flex_segments

3180:
3181: --
3182: -- Delete from base key flexfield segment table.
3183: --
3184: DELETE FROM fnd_id_flex_segments
3185: WHERE application_id = flexfield.application_id
3186: AND id_flex_code = flexfield.flex_code
3187: AND id_flex_num = structure.structure_number
3188: AND segment_name = segment.segment_name

Line 3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3708: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
3709: l_a_id fnd_id_flexs.application_id%TYPE;
3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;
3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;

Line 3713: l_segment fnd_id_flex_segments.segment_name%TYPE;

3709: l_a_id fnd_id_flexs.application_id%TYPE;
3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;
3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;
3717: l_set_col fnd_id_flexs.set_defining_column_name%TYPE;

Line 3778: FROM fnd_id_flexs idf, fnd_id_flex_segments ifst

3774: BEGIN
3775: SELECT idf.application_id, idf.id_flex_code,
3776: idf.id_flex_name, ifst.id_flex_num, ifst.segment_name
3777: INTO l_a_id, l_flex_code, l_flex_name, l_flex_num, l_segment
3778: FROM fnd_id_flexs idf, fnd_id_flex_segments ifst
3779: WHERE idf.application_id = ifst.application_id
3780: AND idf.id_flex_code = ifst.id_flex_code
3781: AND idf.table_application_id = p_application_id
3782: AND Upper(idf.application_table_name) = up_table_name

Line 3799: 'SELECT FROM FND_ID_FLEX_SEGMENTS is failed. ' || chr_newline ||

3795: WHEN no_data_found THEN
3796: NULL;
3797: WHEN OTHERS THEN
3798: x_message :=
3799: 'SELECT FROM FND_ID_FLEX_SEGMENTS is failed. ' || chr_newline ||
3800: 'SQLERRM : ' || Sqlerrm;
3801: RETURN(TRUE);
3802: END;
3803:

Line 3868: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

3864: l_segment_order := g_cache_value.number_1;
3865: ELSE
3866: SELECT s.segment_num
3867: INTO l_segment_num
3868: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
3869: fnd_segment_attribute_types sat
3870: WHERE s.application_id = p_application_id
3871: AND s.id_flex_code = p_id_flex_code
3872: AND s.id_flex_num = p_id_flex_num

Line 3888: FROM fnd_id_flex_segments

3884: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3885:
3886: SELECT count(segment_num)
3887: INTO l_segment_order
3888: FROM fnd_id_flex_segments
3889: WHERE application_id = p_application_id
3890: AND id_flex_code = p_id_flex_code
3891: AND id_flex_num = p_id_flex_num
3892: AND enabled_flag = 'Y'

Line 4117: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;

4113: l_first_occur NUMBER := 1;
4114: l_last_occur NUMBER := 1;
4115: l_numof_awc_elements NUMBER := 0;
4116: l_awc_elements awc_elements_type;
4117: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;
4118: l_app app_type;
4119:
4120:
4121: BEGIN

Line 4127: FROM fnd_id_flex_segments

4123: get_app(p_flexfield.appl_short_name, l_app);
4124:
4125: SELECT additional_where_clause
4126: INTO l_additional_where_clause
4127: FROM fnd_id_flex_segments
4128: WHERE application_id = l_app.application_id
4129: AND id_flex_code = p_flexfield.flex_code
4130: AND id_flex_num = p_structure.structure_number
4131: AND application_column_name = p_segment.column_name;

Line 4249: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;

4245: p_clause IN varchar2)
4246: IS
4247: l_numof_awc_elements NUMBER := 0;
4248: l_awc_elements awc_elements_type;
4249: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;
4250: l_application_id fnd_id_flex_segments.application_id%TYPE;
4251: l_app app_type;
4252:
4253: BEGIN

Line 4250: l_application_id fnd_id_flex_segments.application_id%TYPE;

4246: IS
4247: l_numof_awc_elements NUMBER := 0;
4248: l_awc_elements awc_elements_type;
4249: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;
4250: l_application_id fnd_id_flex_segments.application_id%TYPE;
4251: l_app app_type;
4252:
4253: BEGIN
4254:

Line 4322: UPDATE fnd_id_flex_segments

4318: l_additional_where_clause := l_additional_where_clause||chr_newline;
4319:
4320: -- Update the segments' additional_where_clause column.
4321:
4322: UPDATE fnd_id_flex_segments
4323: SET additional_where_clause = l_additional_where_clause
4324: WHERE application_id = l_app.application_id
4325: AND id_flex_code = p_flexfield.flex_code
4326: AND id_flex_num = p_structure.structure_number

Line 4343: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;

4339: p_tag IN varchar2)
4340: IS
4341: l_numof_awc_elements NUMBER := 0;
4342: l_awc_elements awc_elements_type;
4343: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;
4344: l_application_id fnd_id_flex_segments.application_id%TYPE;
4345: l_found boolean;
4346: l_app app_type;
4347:

Line 4344: l_application_id fnd_id_flex_segments.application_id%TYPE;

4340: IS
4341: l_numof_awc_elements NUMBER := 0;
4342: l_awc_elements awc_elements_type;
4343: l_additional_where_clause fnd_id_flex_segments.additional_where_clause%TYPE;
4344: l_application_id fnd_id_flex_segments.application_id%TYPE;
4345: l_found boolean;
4346: l_app app_type;
4347:
4348: BEGIN

Line 4390: UPDATE fnd_id_flex_segments

4386: l_additional_where_clause := l_additional_where_clause||chr_newline;
4387:
4388: -- Update the segments' additional_where_clause column.
4389:
4390: UPDATE fnd_id_flex_segments
4391: SET additional_where_clause = l_additional_where_clause
4392: WHERE application_id = l_app.application_id
4393: AND id_flex_code = p_flexfield.flex_code
4394: AND id_flex_num = p_structure.structure_number