APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALUE_SETS

Line 68: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;

64: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
65: SUBTYPE col_type IS fnd_columns%ROWTYPE;
66: SUBTYPE resp_type IS fnd_responsibility%ROWTYPE;
67:
68: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
69: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
70: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;
71: SUBTYPE vst_scr_type IS fnd_flex_value_rules%ROWTYPE;
72: SUBTYPE vst_scr_tl_type IS fnd_flex_value_rules_tl%ROWTYPE;

Line 1263: FROM fnd_flex_value_sets

1259: BEGIN
1260: l_func_name := g_api_name || 'get_vst_set(F)';
1261: SELECT *
1262: INTO x_vst_set
1263: FROM fnd_flex_value_sets
1264: WHERE flex_value_set_name = p_flex_value_set_name;
1265: RETURN TRUE;
1266: EXCEPTION
1267: WHEN no_data_found THEN

Line 4021: UPDATE fnd_flex_value_sets SET

4017: --
4018: IF (g_debug_on) THEN
4019: debug(l_func_name, 'Translating VALUE_SET.(non-MLS)');
4020: END IF;
4021: UPDATE fnd_flex_value_sets SET
4022: last_updated_by = l_file_who.last_updated_by,
4023: last_update_date = l_file_who.last_update_date,
4024: last_update_login = l_file_who.last_update_login,
4025: description = Nvl(p_description, description)

Line 4051: UPDATE fnd_flex_value_sets SET

4047:
4048: IF (g_debug_on) THEN
4049: debug(l_func_name, 'Updating VALUE_SET.(non-MLS)');
4050: END IF;
4051: UPDATE fnd_flex_value_sets SET
4052: last_updated_by = l_file_who.last_updated_by,
4053: last_update_date = l_file_who.last_update_date,
4054: last_update_login = l_file_who.last_update_login,
4055: description = p_description,

Line 4077: INSERT INTO fnd_flex_value_sets

4073: IF (SQL%notfound) THEN
4074: IF (g_debug_on) THEN
4075: debug(l_func_name, 'Inserting VALUE_SET.(non-MLS)');
4076: END IF;
4077: INSERT INTO fnd_flex_value_sets
4078: (
4079: flex_value_set_id,
4080: flex_value_set_name,
4081:

Line 4107: fnd_flex_value_sets_s.NEXTVAL,

4103: dependant_default_meaning
4104: )
4105: VALUES
4106: (
4107: fnd_flex_value_sets_s.NEXTVAL,
4108: p_flex_value_set_name,
4109:
4110: l_file_who.created_by,
4111: l_file_who.creation_date,

Line 4156: FROM fnd_flex_value_sets

4152: INTO l_count
4153: FROM fnd_flex_value_norm_hierarchy
4154: WHERE flex_value_set_id =
4155: (SELECT flex_value_set_id
4156: FROM fnd_flex_value_sets
4157: WHERE flex_value_set_name = p_flex_value_set_name);
4158: IF (l_count > 0) THEN
4159: call_cp(p_mode => 'VST',
4160: p_upload_mode => p_upload_mode,