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 1029: pon_fields fld

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

Line 1311: pon_fields f,

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

Line 1462: pon_fields f,

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

Line 2733: pon_fields f

2729: f.datatype,
2730: f.system_flag,
2731: ff.EDITABLE
2732: from pon_form_section_fields ff,
2733: pon_fields f
2734: where form_id = p_form_id
2735: and f.field_code(+) = ff.field_code
2736: order by sequence_number;
2737:

Line 2899: pon_fields f

2895: f.datatype,
2896: f.system_flag,
2897: ff.EDITABLE
2898: from pon_form_section_fields ff,
2899: pon_fields f
2900: where form_id = p_level1_section_id
2901: and f.field_code(+) = ff.field_code
2902: order by sequence_number;
2903:

Line 3034: pon_fields f

3030: f.datatype,
3031: f.system_flag,
3032: ff.EDITABLE
3033: from pon_form_section_fields ff,
3034: pon_fields f
3035: where form_id = p_level2_section_id
3036: and f.field_code(+) = ff.field_code
3037: order by sequence_number;
3038:

Line 4461: SELECT field_length INTO l_max_field_length FROM pon_fields WHERE field_code = p_field_code;

4457: AS
4458: l_max_field_length NUMBER;
4459:
4460: BEGIN
4461: SELECT field_length INTO l_max_field_length FROM pon_fields WHERE field_code = p_field_code;
4462:
4463: IF( l_max_field_length IS NULL OR p_field_length <= l_max_field_length) THEN
4464: x_result:='S';
4465: ELSE