APPS.FND_FLEX_LOADER_APIS dependencies on FND_SHORTHAND_FLEX_ALIASES

Line 96: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%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;
95: SUBTYPE kff_wfp_type IS fnd_flex_workflow_processes%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;

Line 2611: FROM fnd_shorthand_flex_aliases

2607: BEGIN
2608: l_func_name := g_api_name || 'get_kff_sha(F)';
2609: SELECT *
2610: INTO x_kff_sha
2611: FROM fnd_shorthand_flex_aliases
2612: WHERE application_id = p_kff_str.application_id
2613: AND id_flex_code = p_kff_str.id_flex_code
2614: AND id_flex_num = p_kff_str.id_flex_num
2615: AND alias_name = p_alias_name;

Line 7635: UPDATE fnd_shorthand_flex_aliases

7631:
7632: --
7633: -- Update shorthand aliases
7634: --
7635: UPDATE fnd_shorthand_flex_aliases
7636: SET id_flex_num = p_id_flex_num_new
7637: WHERE application_id = p_application_id
7638: AND id_flex_code = p_id_flex_code
7639: AND id_flex_num = p_id_flex_num_old;

Line 9145: UPDATE fnd_shorthand_flex_aliases SET

9141: --
9142: IF (g_debug_on) THEN
9143: debug(l_func_name, 'Translating KFF_SH_ALIAS.(non-MLS)');
9144: END IF;
9145: UPDATE fnd_shorthand_flex_aliases SET
9146: last_updated_by = l_file_who.last_updated_by,
9147: last_update_date = l_file_who.last_update_date,
9148: last_update_login = l_file_who.last_update_login,
9149: description = Nvl(p_description, description)

Line 9187: UPDATE fnd_shorthand_flex_aliases SET

9183:
9184: IF (g_debug_on) THEN
9185: debug(l_func_name, 'Updating KFF_SH_ALIAS.(non-MLS)');
9186: END IF;
9187: UPDATE fnd_shorthand_flex_aliases SET
9188: last_updated_by = l_file_who.last_updated_by,
9189: last_update_date = l_file_who.last_update_date,
9190: last_update_login = l_file_who.last_update_login,
9191: concatenated_segments = p_concatenated_segments,

Line 9221: INSERT INTO fnd_shorthand_flex_aliases

9217: IF (SQL%notfound) THEN
9218: IF (g_debug_on) THEN
9219: debug(l_func_name, 'Inserting KFF_SH_ALIAS.(non-MLS)');
9220: END IF;
9221: INSERT INTO fnd_shorthand_flex_aliases
9222: (
9223: application_id,
9224: id_flex_code,
9225: id_flex_num,