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 806: from fnd_flex_value_sets

802: print_debug_log(l_api_name, 'BEGIN- p_value_set_name = '||p_value_set_name);
803:
804: select validation_type
805: into l_value_set_type
806: from fnd_flex_value_sets
807: where FLEX_VALUE_SET_NAME = p_value_set_name;
808:
809: if (l_value_set_type = 'F') then
810: GetValSetTBLQuery (p_value_set_name =>p_value_set_name,

Line 873: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

869: p_orderby = '||p_orderby);
870:
871: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
872: into l_value_column_name,l_id_column_name
873: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
874: where tbl.flex_value_set_id =val.flex_value_set_id
875: and val.flex_value_set_name = p_value_set_name;
876:
877: print_debug_log(l_api_name, ' l_value_column_name = '||l_value_column_name||'

Line 959: fnd_flex_value_sets valset

955: cursor get_value is
956: select tl.FLEX_VALUE_MEANING
957: from fnd_flex_values_tl tl,
958: fnd_flex_values val,
959: fnd_flex_value_sets valset
960: where tl.flex_value_id = val.flex_value_id
961: and tl.language = USERENV('LANG')
962: and val.flex_value_set_id = valset.flex_value_set_id
963: and valset.flex_value_set_name = p_value_set_name

Line 1028: fnd_flex_value_sets val,

1024: else
1025: select tbl.ID_COLUMN_NAME, tbl.VALUE_COLUMN_NAME, fld.VALUE_SET_QUERY, fld.VALUE_SET_ID_EXISTS
1026: into l_id_column_name, l_value_column_name, l_query_stmt, l_id_column_exists
1027: from fnd_flex_validation_tables tbl,
1028: fnd_flex_value_sets val,
1029: pon_fields fld
1030: where tbl.flex_value_set_id = val.flex_value_set_id
1031: and val.flex_value_set_name = fld.value_set_name
1032: and fld.field_code = p_field_code;

Line 1103: from fnd_flex_value_sets

1099: p_query_stmt = '||p_query_stmt);
1100:
1101: select validation_type
1102: into l_value_set_type
1103: from fnd_flex_value_sets
1104: where FLEX_VALUE_SET_NAME = p_value_set_name;
1105:
1106: print_debug_log(l_api_name, 'l_value_set_type = '||l_value_set_type);
1107:

Line 1124: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

1120: elsif l_value_set_type = 'F' then
1121:
1122: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
1123: into l_value_column_name,l_id_column_name
1124: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
1125: where tbl.flex_value_set_id =val.flex_value_set_id
1126: and val.flex_value_set_name = p_value_set_name;
1127:
1128: print_debug_log(l_api_name, 'l_value_column_name = '||l_value_column_name ||' l_id_column_name = '||l_id_column_name);

Line 1312: fnd_flex_value_sets valset

1308: valset.VALIDATION_TYPE
1309: from pon_form_section_compiled ff,
1310: pon_forms_sections rs,
1311: pon_fields f,
1312: fnd_flex_value_sets valset
1313: where ff.form_id = p_section_id
1314: and rs.form_id(+) = ff.repeating_section_id
1315: and ff.enabled ='Y'
1316: and f.field_code(+) = ff.field_code

Line 1463: fnd_flex_value_sets valset

1459: PON_FORMS_SECTIONS ts,
1460: PON_FORMS_SECTIONS isec,
1461: PON_FORMS_SECTIONS rs,
1462: pon_fields f,
1463: fnd_flex_value_sets valset
1464: where ts.form_id(+) = ff.LEVEL1_SECTION_ID
1465: and isec.form_id(+) = ff.LEVEL2_SECTION_ID
1466: and rs.form_id(+) = ff.repeating_section_id
1467: and ff.form_id = p_form_id