APPS.FND_FLEX_LOADER_APIS dependencies on FND_SEGMENT_ATTRIBUTE_TYPES

Line 90: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;

86: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;
87: SUBTYPE dff_seg_tl_type IS fnd_descr_flex_col_usage_tl%ROWTYPE;
88:
89: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
90: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
91: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
92: SUBTYPE kff_sgq_tl_type IS fnd_val_attribute_types_tl%ROWTYPE;
93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
94: SUBTYPE kff_str_tl_type IS fnd_id_flex_structures_tl%ROWTYPE;

Line 2285: FROM fnd_segment_attribute_types

2281: BEGIN
2282: l_func_name := g_api_name || 'get_kff_flq(F)';
2283: SELECT *
2284: INTO x_kff_flq
2285: FROM fnd_segment_attribute_types
2286: WHERE application_id = p_kff_flx.application_id
2287: AND id_flex_code = p_kff_flx.id_flex_code
2288: AND segment_attribute_type = p_segment_attribute_type;
2289: RETURN TRUE;

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 8294: UPDATE fnd_segment_attribute_types SET

8290: --
8291: IF (g_debug_on) THEN
8292: debug(l_func_name, 'Translating KFF_FLEX_QUAL.(non-MLS)');
8293: END IF;
8294: UPDATE fnd_segment_attribute_types SET
8295: last_updated_by = l_file_who.last_updated_by,
8296: last_update_date = l_file_who.last_update_date,
8297: last_update_login = l_file_who.last_update_login,
8298: segment_prompt = Nvl(p_segment_prompt, segment_prompt),

Line 8329: UPDATE fnd_segment_attribute_types SET

8325:
8326: IF (g_debug_on) THEN
8327: debug(l_func_name, 'Updating KFF_FLEX_QUAL.(non-MLS)');
8328: END IF;
8329: UPDATE fnd_segment_attribute_types SET
8330: last_updated_by = l_file_who.last_updated_by,
8331: last_update_date = l_file_who.last_update_date,
8332: last_update_login = l_file_who.last_update_login,
8333: global_flag = p_global_flag,

Line 8346: INSERT INTO fnd_segment_attribute_types

8342: IF (SQL%notfound) THEN
8343: IF (g_debug_on) THEN
8344: debug(l_func_name, 'Inserting KFF_FLEX_QUAL.(non-MLS)');
8345: END IF;
8346: INSERT INTO fnd_segment_attribute_types
8347: (
8348: application_id,
8349: id_flex_code,
8350: segment_attribute_type,