APPS.PON_FORMS_UTIL_PVT dependencies on PON_FIELDS

Line 134: l_vset_name PON_FIELDS.VALUE_SET_NAME%TYPE;

130: FUNCTION getFlexValuePVT(p_field_code IN VARCHAR2, p_field_value IN VARCHAR2) RETURN VARCHAR2 IS
131:
132: l_validation_type VARCHAR2(1);
133: l_ret_val VARCHAR2(2000);
134: l_vset_name PON_FIELDS.VALUE_SET_NAME%TYPE;
135: l_err_num NUMBER;
136: l_err_msg VARCHAR2(200);
137: l_api_name CONSTANT VARCHAR2(30) := 'getFlexValuePVT';
138: BEGIN

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 149: AND pon_fields.FIELD_CODE = P_FIELD_CODE;

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);
153: ELSIF ((l_validation_type = 'X') or (l_validation_type = 'I')) THEN

Line 972: pon_fields fld

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;
976:

Line 1254: pon_fields f,

1250: valset.flex_value_set_id value_set_id,
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'

Line 1404: pon_fields f,

1400: from pon_form_section_compiled ff,
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

Line 2668: pon_fields f

2664: ff.ENABLED,
2665: f.datatype,
2666: f.system_flag
2667: from pon_form_section_fields ff,
2668: pon_fields f
2669: where form_id = p_form_id
2670: and f.field_code(+) = ff.field_code
2671: order by sequence_number;
2672:

Line 2829: pon_fields f

2825: ff.ENABLED,
2826: f.datatype,
2827: f.system_flag
2828: from pon_form_section_fields ff,
2829: pon_fields f
2830: where form_id = p_level1_section_id
2831: and f.field_code(+) = ff.field_code
2832: order by sequence_number;
2833:

Line 2960: pon_fields f

2956: ff.ENABLED,
2957: f.datatype,
2958: f.system_flag
2959: from pon_form_section_fields ff,
2960: pon_fields f
2961: where form_id = p_level2_section_id
2962: and f.field_code(+) = ff.field_code
2963: order by sequence_number;
2964: