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_LOADER_APIS dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 102: SUBTYPE kff_fqa_type IS fnd_segment_attribute_values%ROWTYPE;

98: SUBTYPE kff_cvr_tl_type IS fnd_flex_vdation_rules_tl%ROWTYPE;
99: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
100: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
101: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;
102: SUBTYPE kff_fqa_type IS fnd_segment_attribute_values%ROWTYPE;
103:
104: TYPE vtv_rec_type IS RECORD
105: (
106: id_flex_application_id NUMBER,

Line 2918: FROM fnd_segment_attribute_values

2914: BEGIN
2915: l_func_name := g_api_name || 'get_kff_fqa(F)';
2916: SELECT *
2917: INTO x_kff_fqa
2918: FROM fnd_segment_attribute_values
2919: WHERE application_id = p_kff_flq.application_id
2920: AND id_flex_code = p_kff_flq.id_flex_code
2921: AND segment_attribute_type = p_kff_flq.segment_attribute_type
2922: AND id_flex_num = p_kff_seg.id_flex_num

Line 3004: FROM fnd_segment_attribute_values sav

3000: WHERE sat.application_id = ifsg.application_id
3001: AND sat.id_flex_code = ifsg.id_flex_code
3002: AND NOT exists
3003: (SELECT NULL
3004: FROM fnd_segment_attribute_values sav
3005: WHERE sav.application_id = ifsg.application_id
3006: AND sav.id_flex_code = ifsg.id_flex_code
3007: AND sav.id_flex_num = ifsg.id_flex_num
3008: AND sav.application_column_name = ifsg.application_column_name

Line 3052: INSERT INTO fnd_segment_attribute_values

3048:
3049: --
3050: -- Insert the missing row
3051: --
3052: INSERT INTO fnd_segment_attribute_values
3053: (
3054: application_id,
3055: id_flex_code,
3056: id_flex_num,

Line 3092: FROM fnd_segment_attribute_values sav

3088: AND ifsg.application_column_name = missing_sav_rec.application_column_name
3089: AND sat.segment_attribute_type = missing_sav_rec.segment_attribute_type
3090: AND NOT exists
3091: (SELECT NULL
3092: FROM fnd_segment_attribute_values sav
3093: WHERE sav.application_id = ifsg.application_id
3094: AND sav.id_flex_code = ifsg.id_flex_code
3095: AND sav.id_flex_num = ifsg.id_flex_num
3096: AND sav.application_column_name = ifsg.application_column_name

Line 3141: fnd_segment_attribute_values sav,

3137: vat.value_attribute_type,
3138: l_sysdate
3139: FROM
3140: fnd_val_attribute_types_vl vat,
3141: fnd_segment_attribute_values sav,
3142: fnd_id_flex_segments_vl ifsg
3143: WHERE sav.application_id = ifsg.application_id
3144: AND sav.id_flex_code = ifsg.id_flex_code
3145: AND sav.id_flex_num = ifsg.id_flex_num

Line 7617: UPDATE fnd_segment_attribute_values

7613: BEGIN
7614: --
7615: -- Update qualifier assignments
7616: --
7617: UPDATE fnd_segment_attribute_values
7618: SET id_flex_num = p_id_flex_num_new
7619: WHERE application_id = p_application_id
7620: AND id_flex_code = p_id_flex_code
7621: AND id_flex_num = p_id_flex_num_old;

Line 10124: UPDATE fnd_segment_attribute_values SET

10120: --
10121: IF (g_debug_on) THEN
10122: debug(l_func_name, 'Updating KFF_FLEXQ_ASSIGN.(no-TL)');
10123: END IF;
10124: UPDATE fnd_segment_attribute_values SET
10125: last_updated_by = l_file_who.last_updated_by,
10126: last_update_date = l_file_who.last_update_date,
10127: last_update_login = l_file_who.last_update_login,
10128: attribute_value = p_attribute_value

Line 10139: INSERT INTO fnd_segment_attribute_values

10135: IF (SQL%notfound) THEN
10136: IF (g_debug_on) THEN
10137: debug(l_func_name, 'Inserting KFF_FLEXQ_ASSIGN.(no-TL)');
10138: END IF;
10139: INSERT INTO fnd_segment_attribute_values
10140: (
10141: application_id,
10142: id_flex_code,
10143: id_flex_num,