APPS.FV_CGAC_CRT_TAS dependencies on FND_FLEX_VALUE_SETS

Line 178: l_max_fund_value_size fnd_flex_value_sets.maximum_size%TYPE;

174: l_message VARCHAR2(80);
175: l_call_status BOOLEAN;
176: l_tas_type VARCHAR2(20);
177: l_fund_prefix_indicator VARCHAR2(10);
178: l_max_fund_value_size fnd_flex_value_sets.maximum_size%TYPE;
179: l_flex_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%type;
180:
181: BEGIN
182: l_module_name := g_module_name || 'Main ';

Line 697: FROM fnd_flex_value_sets

693: --Get the maximum length of the value set being used for the fund value
694: BEGIN
695: SELECT maximum_size
696: INTO l_max_fund_value_size
697: FROM fnd_flex_value_sets
698: WHERE flex_value_set_name = x_value_set_name;
699:
700: EXCEPTION WHEN OTHERS THEN
701: errbuf := g_error_message|| SQLERRM;

Line 727: select count(*)into fund_duplicate_cnt from fnd_flex_values val, fnd_flex_value_sets vset

723: -- Insert new values for new fund into the interface record
724: cgac_crttas_record.fund_value := fund_values_record.fund_value;
725: cgac_crttas_record.original_fund_parameter_id := fund_values_record.fund_parameter_id;
726:
727: select count(*)into fund_duplicate_cnt from fnd_flex_values val, fnd_flex_value_sets vset
728: where val.flex_value = fund_values_record.fund_value and val.flex_value_set_id = vset.flex_value_set_id
729: and vset.flex_value_set_name= x_value_set_name;
730:
731: select count(*) into fund_duplicate_cnt1 from fv_cgac_crt_tas_temp where