APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALUES

Line 77: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;

73: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;
74: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%ROWTYPE;
75: SUBTYPE vst_rgr_type IS fnd_flex_hierarchies%ROWTYPE;
76: SUBTYPE vst_rgr_tl_type IS fnd_flex_hierarchies_tl%ROWTYPE;
77: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;
78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
80:
81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;

Line 78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;

74: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%ROWTYPE;
75: SUBTYPE vst_rgr_type IS fnd_flex_hierarchies%ROWTYPE;
76: SUBTYPE vst_rgr_tl_type IS fnd_flex_hierarchies_tl%ROWTYPE;
77: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;
78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
80:
81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
82: SUBTYPE dff_flx_tl_type IS fnd_descriptive_flexs_tl%ROWTYPE;

Line 1728: FROM fnd_flex_values

1724: l_func_name := g_api_name || 'get_vst_val(F)';
1725: IF (p_vst_set.validation_type IN ('D', 'Y')) THEN
1726: SELECT *
1727: INTO x_vst_val
1728: FROM fnd_flex_values
1729: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
1730: AND (parent_flex_value_low = p_parent_flex_value_low OR
1731: (parent_flex_value_low IS NULL AND
1732: p_parent_flex_value_low IS NULL))

Line 1737: FROM fnd_flex_values

1733: AND flex_value = p_flex_value;
1734: ELSE
1735: SELECT *
1736: INTO x_vst_val
1737: FROM fnd_flex_values
1738: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
1739: AND flex_value = p_flex_value;
1740: END IF;
1741: RETURN TRUE;

Line 1791: FROM fnd_flex_values_tl

1787: BEGIN
1788: l_func_name := g_api_name || 'get_vst_val_tl(F)';
1789: SELECT *
1790: INTO x_vst_val_tl
1791: FROM fnd_flex_values_tl
1792: WHERE flex_value_id = p_vst_val.flex_value_id
1793: AND language = p_language;
1794: RETURN TRUE;
1795: EXCEPTION

Line 3914: UPDATE fnd_flex_values SET

3910:
3911: IF (g_debug_on) THEN
3912: debug(l_func_name, 'Updating VALUE_QUALIFIER_VALUE.(no-TL)');
3913: END IF;
3914: UPDATE fnd_flex_values SET
3915: last_updated_by = l_file_who.last_updated_by,
3916: last_update_date = l_file_who.last_update_date,
3917: last_update_login = l_file_who.last_update_login,
3918: compiled_value_attributes = l_cva

Line 5398: l_flex_value_meaning fnd_flex_values_tl.flex_value_meaning%TYPE;

5394: l_vst_rgr vst_rgr_type;
5395: l_vst_val vst_val_type;
5396: l_vst_val_tl vst_val_tl_type;
5397: l_file_who who_type;
5398: l_flex_value_meaning fnd_flex_values_tl.flex_value_meaning%TYPE;
5399: BEGIN
5400: l_func_name := g_api_name || 'up_vset_value()';
5401: init('VSET_VALUE', p_upload_phase);
5402: IF (g_debug_on) THEN

Line 5469: fnd_flex_values_pkg.translate_row

5465:
5466: IF (g_debug_on) THEN
5467: debug(l_func_name, 'Translating VSET_VALUE.(MLS)');
5468: END IF;
5469: fnd_flex_values_pkg.translate_row
5470: (x_flex_value_set_name => p_flex_value_set_name,
5471: x_parent_flex_value_low => p_parent_flex_value_low,
5472: x_flex_value => p_flex_value,
5473: x_who => l_file_who,

Line 5509: fnd_flex_values_pkg.load_row

5505:
5506: IF (g_debug_on) THEN
5507: debug(l_func_name, 'Uploading VSET_VALUE.(MLS)');
5508: END IF;
5509: fnd_flex_values_pkg.load_row
5510: (x_flex_value_set_name => p_flex_value_set_name,
5511: x_parent_flex_value_low => p_parent_flex_value_low,
5512: x_flex_value => p_flex_value,
5513: x_who => l_file_who,