APPS.PON_FORMS_UTIL_PVT dependencies on FND_FLEX_VALUE_SETS

Line 145: SELECT fnd_flex_value_sets.VALIDATION_TYPE, fnd_flex_value_sets.flex_value_set_name

141:
142: -- just in case something bad happens
143: l_ret_val := p_field_value;
144:
145: SELECT fnd_flex_value_sets.VALIDATION_TYPE, fnd_flex_value_sets.flex_value_set_name
146: INTO l_validation_type, l_vset_name
147: FROM fnd_flex_value_sets, pon_fields
148: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = pon_fields.VALUE_SET_NAME
149: AND pon_fields.FIELD_CODE = P_FIELD_CODE;

Line 147: FROM fnd_flex_value_sets, pon_fields

143: l_ret_val := p_field_value;
144:
145: SELECT fnd_flex_value_sets.VALIDATION_TYPE, fnd_flex_value_sets.flex_value_set_name
146: INTO l_validation_type, l_vset_name
147: FROM fnd_flex_value_sets, pon_fields
148: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = pon_fields.VALUE_SET_NAME
149: AND pon_fields.FIELD_CODE = P_FIELD_CODE;
150:
151: IF(l_validation_type = 'F') THEN

Line 148: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = pon_fields.VALUE_SET_NAME

144:
145: SELECT fnd_flex_value_sets.VALIDATION_TYPE, fnd_flex_value_sets.flex_value_set_name
146: INTO l_validation_type, l_vset_name
147: FROM fnd_flex_value_sets, pon_fields
148: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = pon_fields.VALUE_SET_NAME
149: AND pon_fields.FIELD_CODE = P_FIELD_CODE;
150:
151: IF(l_validation_type = 'F') THEN
152: l_ret_val := PON_FORMS_UTIL_PVT.getFlexTblValue(p_field_code, p_field_value);

Line 749: from fnd_flex_value_sets

745: print_debug_log(l_api_name, 'BEGIN- p_value_set_name = '||p_value_set_name);
746:
747: select validation_type
748: into l_value_set_type
749: from fnd_flex_value_sets
750: where FLEX_VALUE_SET_NAME = p_value_set_name;
751:
752: if (l_value_set_type = 'F') then
753: GetValSetTBLQuery (p_value_set_name =>p_value_set_name,

Line 816: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

812: p_orderby = '||p_orderby);
813:
814: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
815: into l_value_column_name,l_id_column_name
816: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
817: where tbl.flex_value_set_id =val.flex_value_set_id
818: and val.flex_value_set_name = p_value_set_name;
819:
820: print_debug_log(l_api_name, ' l_value_column_name = '||l_value_column_name||'

Line 902: fnd_flex_value_sets valset

898: cursor get_value is
899: select tl.FLEX_VALUE_MEANING
900: from fnd_flex_values_tl tl,
901: fnd_flex_values val,
902: fnd_flex_value_sets valset
903: where tl.flex_value_id = val.flex_value_id
904: and tl.language = USERENV('LANG')
905: and val.flex_value_set_id = valset.flex_value_set_id
906: and valset.flex_value_set_name = p_value_set_name

Line 971: fnd_flex_value_sets val,

967: else
968: select tbl.ID_COLUMN_NAME, tbl.VALUE_COLUMN_NAME, fld.VALUE_SET_QUERY, fld.VALUE_SET_ID_EXISTS
969: into l_id_column_name, l_value_column_name, l_query_stmt, l_id_column_exists
970: from fnd_flex_validation_tables tbl,
971: fnd_flex_value_sets val,
972: pon_fields fld
973: where tbl.flex_value_set_id = val.flex_value_set_id
974: and val.flex_value_set_name = fld.value_set_name
975: and fld.field_code = p_field_code;

Line 1046: from fnd_flex_value_sets

1042: p_query_stmt = '||p_query_stmt);
1043:
1044: select validation_type
1045: into l_value_set_type
1046: from fnd_flex_value_sets
1047: where FLEX_VALUE_SET_NAME = p_value_set_name;
1048:
1049: print_debug_log(l_api_name, 'l_value_set_type = '||l_value_set_type);
1050:

Line 1067: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

1063: elsif l_value_set_type = 'F' then
1064:
1065: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
1066: into l_value_column_name,l_id_column_name
1067: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
1068: where tbl.flex_value_set_id =val.flex_value_set_id
1069: and val.flex_value_set_name = p_value_set_name;
1070:
1071: print_debug_log(l_api_name, 'l_value_column_name = '||l_value_column_name ||' l_id_column_name = '||l_id_column_name);

Line 1255: fnd_flex_value_sets valset

1251: valset.VALIDATION_TYPE
1252: from pon_form_section_compiled ff,
1253: pon_forms_sections rs,
1254: pon_fields f,
1255: fnd_flex_value_sets valset
1256: where ff.form_id = p_section_id
1257: and rs.form_id(+) = ff.repeating_section_id
1258: and ff.enabled ='Y'
1259: and f.field_code(+) = ff.field_code

Line 1405: fnd_flex_value_sets valset

1401: PON_FORMS_SECTIONS ts,
1402: PON_FORMS_SECTIONS isec,
1403: PON_FORMS_SECTIONS rs,
1404: pon_fields f,
1405: fnd_flex_value_sets valset
1406: where ts.form_id(+) = ff.LEVEL1_SECTION_ID
1407: and isec.form_id(+) = ff.LEVEL2_SECTION_ID
1408: and rs.form_id(+) = ff.repeating_section_id
1409: and ff.form_id = p_form_id