APPS.FND_FLEX_DIAGNOSE dependencies on FND_SHORTHAND_FLEX_ALIASES

Line 39: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;

35: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
36: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%ROWTYPE;
38: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
39: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
40: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;
41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
42: SUBTYPE kff_cvi_type IS fnd_flex_include_rule_lines%ROWTYPE;
43: SUBTYPE kff_cve_type IS fnd_flex_exclude_rule_lines%ROWTYPE;

Line 632: FROM fnd_shorthand_flex_aliases

628: IS
629: BEGIN
630: SELECT *
631: INTO x_kff_sha
632: FROM fnd_shorthand_flex_aliases
633: WHERE application_id = p_kff_str.application_id
634: AND id_flex_code = p_kff_str.id_flex_code
635: AND id_flex_num = p_kff_str.id_flex_num
636: AND alias_name = p_alias_name;

Line 640: x_message := msg_uts('FND_SHORTHAND_FLEX_ALIASES',

636: AND alias_name = p_alias_name;
637: RETURN(TRUE);
638: EXCEPTION
639: WHEN OTHERS THEN
640: x_message := msg_uts('FND_SHORTHAND_FLEX_ALIASES',
641: 'application_id', p_kff_str.application_id,
642: 'id_flex_code', p_kff_str.id_flex_code,
643: 'id_flex_num', p_kff_str.id_flex_num,
644: 'alias_name', p_alias_name);

Line 3571: FROM fnd_shorthand_flex_aliases

3567: BEGIN
3568: SELECT alias_name || '/' || enabled_flag || '/' ||
3569: concatenated_segments || '/' || Nvl(description, '')
3570: INTO l_return
3571: FROM fnd_shorthand_flex_aliases
3572: WHERE application_id = p_application_id
3573: AND id_flex_code = p_id_flex_code
3574: AND id_flex_num = p_id_flex_num
3575: AND alias_name = p_alias_name;

Line 4794: FROM fnd_shorthand_flex_aliases sfa

4790: -- SHAs without Structure.
4791: --
4792: BEGIN
4793: DELETE
4794: FROM fnd_shorthand_flex_aliases sfa
4795: WHERE application_id = p_application_id
4796: AND id_flex_code = p_id_flex_code
4797: AND id_flex_num = p_id_flex_num
4798: AND alias_name = p_alias_name

Line 4810: 'Unable to delete from FND_SHORTHAND_FLEX_ALIASES. ' || Sqlerrm;

4806: GOTO return_success;
4807: EXCEPTION
4808: WHEN OTHERS THEN
4809: x_message :=
4810: 'Unable to delete from FND_SHORTHAND_FLEX_ALIASES. ' || Sqlerrm;
4811: GOTO return_error;
4812: END;
4813: END IF;
4814:

Line 4852: UPDATE fnd_shorthand_flex_aliases SET

4848: l_kff_sha.end_date_active := l_kff_sha.start_date_active;
4849: END IF;
4850:
4851: BEGIN
4852: UPDATE fnd_shorthand_flex_aliases SET
4853: enabled_flag = l_kff_sha.enabled_flag,
4854: start_date_active = l_kff_sha.start_date_active,
4855: end_date_active = l_kff_sha.end_date_active,
4856: last_update_date = Sysdate,

Line 4867: 'Unable to update FND_SHORTHAND_FLEX_ALIASES. ' || Sqlerrm;

4863: GOTO return_success;
4864: EXCEPTION
4865: WHEN OTHERS THEN
4866: x_message :=
4867: 'Unable to update FND_SHORTHAND_FLEX_ALIASES. ' || Sqlerrm;
4868: GOTO return_error;
4869: END;
4870: END IF;
4871: