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 7641: UPDATE fnd_shorthand_flex_aliases

7637:
7638: --
7639: -- Update shorthand aliases
7640: --
7641: UPDATE fnd_shorthand_flex_aliases
7642: SET id_flex_num = p_id_flex_num_new
7643: WHERE application_id = p_application_id
7644: AND id_flex_code = p_id_flex_code
7645: AND id_flex_num = p_id_flex_num_old;

Line 9151: UPDATE fnd_shorthand_flex_aliases SET

9147: --
9148: IF (g_debug_on) THEN
9149: debug(l_func_name, 'Translating KFF_SH_ALIAS.(non-MLS)');
9150: END IF;
9151: UPDATE fnd_shorthand_flex_aliases SET
9152: last_updated_by = l_file_who.last_updated_by,
9153: last_update_date = l_file_who.last_update_date,
9154: last_update_login = l_file_who.last_update_login,
9155: description = Nvl(p_description, description)

Line 9193: UPDATE fnd_shorthand_flex_aliases SET

9189:
9190: IF (g_debug_on) THEN
9191: debug(l_func_name, 'Updating KFF_SH_ALIAS.(non-MLS)');
9192: END IF;
9193: UPDATE fnd_shorthand_flex_aliases SET
9194: last_updated_by = l_file_who.last_updated_by,
9195: last_update_date = l_file_who.last_update_date,
9196: last_update_login = l_file_who.last_update_login,
9197: concatenated_segments = p_concatenated_segments,

Line 9227: INSERT INTO fnd_shorthand_flex_aliases

9223: IF (SQL%notfound) THEN
9224: IF (g_debug_on) THEN
9225: debug(l_func_name, 'Inserting KFF_SH_ALIAS.(non-MLS)');
9226: END IF;
9227: INSERT INTO fnd_shorthand_flex_aliases
9228: (
9229: application_id,
9230: id_flex_code,
9231: id_flex_num,