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_ID_FLEX_SEGMENTS

Line 100: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;

96: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
97: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%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

Line 101: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;

97: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%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: (

Line 2830: FROM fnd_id_flex_segments

2826: BEGIN
2827: l_func_name := g_api_name || 'get_kff_seg(F)';
2828: SELECT *
2829: INTO x_kff_seg
2830: FROM fnd_id_flex_segments
2831: WHERE application_id = p_kff_str.application_id
2832: AND id_flex_code = p_kff_str.id_flex_code
2833: AND id_flex_num = p_kff_str.id_flex_num
2834: AND application_column_name = p_application_column_name;

Line 2887: FROM fnd_id_flex_segments_tl

2883: BEGIN
2884: l_func_name := g_api_name || 'get_kff_seg_tl(F)';
2885: SELECT *
2886: INTO x_kff_seg_tl
2887: FROM fnd_id_flex_segments_tl
2888: WHERE application_id = p_kff_seg.application_id
2889: AND id_flex_code = p_kff_seg.id_flex_code
2890: AND id_flex_num = p_kff_seg.id_flex_num
2891: AND application_column_name = p_kff_seg.application_column_name

Line 2999: FROM fnd_id_flex_segments ifsg, fnd_segment_attribute_types sat

2995: sat.last_update_date sat_last_update_date,
2996: sat.last_update_login sat_last_update_login,
2997:
2998: sat.global_flag
2999: FROM fnd_id_flex_segments ifsg, fnd_segment_attribute_types sat
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

Line 3082: FROM fnd_id_flex_segments ifsg, fnd_segment_attribute_types sat

3078: l_who.last_update_date,
3079: l_who.last_update_login,
3080:
3081: sat.global_flag
3082: FROM fnd_id_flex_segments ifsg, fnd_segment_attribute_types sat
3083: WHERE sat.application_id = ifsg.application_id
3084: AND sat.id_flex_code = ifsg.id_flex_code
3085: AND ifsg.application_id = missing_sav_rec.application_id
3086: AND ifsg.id_flex_code = missing_sav_rec.id_flex_code

Line 3142: fnd_id_flex_segments_vl ifsg

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
3146: AND sav.application_column_name = ifsg.application_column_name

Line 7620: UPDATE fnd_id_flex_segments

7616:
7617: --
7618: -- Update segments
7619: --
7620: UPDATE fnd_id_flex_segments
7621: SET id_flex_num = p_id_flex_num_new
7622: WHERE application_id = p_application_id
7623: AND id_flex_code = p_id_flex_code
7624: AND id_flex_num = p_id_flex_num_old;

Line 7626: UPDATE fnd_id_flex_segments_tl

7622: WHERE application_id = p_application_id
7623: AND id_flex_code = p_id_flex_code
7624: AND id_flex_num = p_id_flex_num_old;
7625:
7626: UPDATE fnd_id_flex_segments_tl
7627: SET id_flex_num = p_id_flex_num_new
7628: WHERE application_id = p_application_id
7629: AND id_flex_code = p_id_flex_code
7630: AND id_flex_num = p_id_flex_num_old;

Line 9887: fnd_id_flex_segments_pkg.translate_row

9883:
9884: IF (g_debug_on) THEN
9885: debug(l_func_name, 'Translating KFF_SEGMENT.(MLS)');
9886: END IF;
9887: fnd_id_flex_segments_pkg.translate_row
9888: (x_application_short_name => p_application_short_name,
9889: x_id_flex_code => p_id_flex_code,
9890: x_id_flex_structure_code => p_id_flex_structure_code,
9891: x_application_column_name => p_application_column_name,

Line 9961: fnd_id_flex_segments_pkg.load_row

9957:
9958: IF (g_debug_on) THEN
9959: debug(l_func_name, 'Uploading KFF_SEGMENT.(MLS)');
9960: END IF;
9961: fnd_id_flex_segments_pkg.load_row
9962: (x_application_short_name => p_application_short_name,
9963: x_id_flex_code => p_id_flex_code,
9964: x_id_flex_structure_code => p_id_flex_structure_code,
9965: x_application_column_name => p_application_column_name,