APPS.PON_FORMS_JRAD_PVT dependencies on PON_FIELDS

Line 70: from pon_fields,

66:
67: BEGIN
68: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
69: into v_ret_value
70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
73: and pon_fields.value_set_name is not null
74: and pon_fields.field_code = p_field_code;

Line 72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name

68: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
69: into v_ret_value
70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
73: and pon_fields.value_set_name is not null
74: and pon_fields.field_code = p_field_code;
75:
76: EXCEPTION

Line 73: and pon_fields.value_set_name is not null

69: into v_ret_value
70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
73: and pon_fields.value_set_name is not null
74: and pon_fields.field_code = p_field_code;
75:
76: EXCEPTION
77: WHEN OTHERS THEN

Line 74: and pon_fields.field_code = p_field_code;

70: from pon_fields,
71: fnd_flex_value_sets
72: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
73: and pon_fields.value_set_name is not null
74: and pon_fields.field_code = p_field_code;
75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: v_ret_value := 'N';

Line 694: pon_fields.DATATYPE ,

690: pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
691: pon_form_section_compiled.REQUIRED,
692: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
693: pon_forms_sections.FORM_CODE SECTION_CODE,
694: pon_fields.DATATYPE ,
695: pon_fields.VALUE_SET_NAME,
696: pon_fields.SYSTEM_FLAG,
697: pon_fields_tl.FIELD_NAME,
698: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

Line 695: pon_fields.VALUE_SET_NAME,

691: pon_form_section_compiled.REQUIRED,
692: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
693: pon_forms_sections.FORM_CODE SECTION_CODE,
694: pon_fields.DATATYPE ,
695: pon_fields.VALUE_SET_NAME,
696: pon_fields.SYSTEM_FLAG,
697: pon_fields_tl.FIELD_NAME,
698: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
699: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,

Line 696: pon_fields.SYSTEM_FLAG,

692: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
693: pon_forms_sections.FORM_CODE SECTION_CODE,
694: pon_fields.DATATYPE ,
695: pon_fields.VALUE_SET_NAME,
696: pon_fields.SYSTEM_FLAG,
697: pon_fields_tl.FIELD_NAME,
698: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
699: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
700: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,

Line 697: pon_fields_tl.FIELD_NAME,

693: pon_forms_sections.FORM_CODE SECTION_CODE,
694: pon_fields.DATATYPE ,
695: pon_fields.VALUE_SET_NAME,
696: pon_fields.SYSTEM_FLAG,
697: pon_fields_tl.FIELD_NAME,
698: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
699: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
700: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
701: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID

Line 698: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

694: pon_fields.DATATYPE ,
695: pon_fields.VALUE_SET_NAME,
696: pon_fields.SYSTEM_FLAG,
697: pon_fields_tl.FIELD_NAME,
698: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
699: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
700: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
701: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
702: FROM PON_FORM_SECTION_COMPILED,

Line 703: PON_FIELDS,

699: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
700: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
701: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
702: FROM PON_FORM_SECTION_COMPILED,
703: PON_FIELDS,
704: PON_FIELDS_TL,
705: PON_FORMS_SECTIONS
706: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
707: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

Line 704: PON_FIELDS_TL,

700: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
701: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
702: FROM PON_FORM_SECTION_COMPILED,
703: PON_FIELDS,
704: PON_FIELDS_TL,
705: PON_FORMS_SECTIONS
706: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
707: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
708: AND pon_forms_sections.FORM_ID = P_FORM_ID

Line 706: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)

702: FROM PON_FORM_SECTION_COMPILED,
703: PON_FIELDS,
704: PON_FIELDS_TL,
705: PON_FORMS_SECTIONS
706: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
707: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
708: AND pon_forms_sections.FORM_ID = P_FORM_ID
709: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
710: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')

Line 707: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

703: PON_FIELDS,
704: PON_FIELDS_TL,
705: PON_FORMS_SECTIONS
706: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
707: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
708: AND pon_forms_sections.FORM_ID = P_FORM_ID
709: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
710: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')
711: AND pon_fields_tl.LANGUAGE(+) = g_base_language

Line 711: AND pon_fields_tl.LANGUAGE(+) = g_base_language

707: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
708: AND pon_forms_sections.FORM_ID = P_FORM_ID
709: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
710: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')
711: AND pon_fields_tl.LANGUAGE(+) = g_base_language
712: ORDER BY
713: INTERNAL_SEQUENCE_NUMBER;
714:
715: v_section_field_element JDR_DOCBUILDER.ELEMENT;

Line 1332: select pon_fields.field_code,

1328: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ABSTRACT_TABLE';
1329:
1330: CURSOR V_ABSTRACT_FIELDS_CURSOR IS
1331:
1332: select pon_fields.field_code,
1333: pon_form_section_compiled.mapping_field_value_column,
1334: pon_fields.datatype,
1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,

Line 1334: pon_fields.datatype,

1330: CURSOR V_ABSTRACT_FIELDS_CURSOR IS
1331:
1332: select pon_fields.field_code,
1333: pon_form_section_compiled.mapping_field_value_column,
1334: pon_fields.datatype,
1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,
1337: pon_fields.system_field_lov_flag,
1338: pon_fields_tl.field_name,

Line 1335: pon_fields.value_set_name,

1331:
1332: select pon_fields.field_code,
1333: pon_form_section_compiled.mapping_field_value_column,
1334: pon_fields.datatype,
1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,
1337: pon_fields.system_field_lov_flag,
1338: pon_fields_tl.field_name,
1339: pon_fields_tl.description field_description,

Line 1336: pon_fields.system_flag,

1332: select pon_fields.field_code,
1333: pon_form_section_compiled.mapping_field_value_column,
1334: pon_fields.datatype,
1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,
1337: pon_fields.system_field_lov_flag,
1338: pon_fields_tl.field_name,
1339: pon_fields_tl.description field_description,
1340: pon_forms_sections.form_id,

Line 1337: pon_fields.system_field_lov_flag,

1333: pon_form_section_compiled.mapping_field_value_column,
1334: pon_fields.datatype,
1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,
1337: pon_fields.system_field_lov_flag,
1338: pon_fields_tl.field_name,
1339: pon_fields_tl.description field_description,
1340: pon_forms_sections.form_id,
1341: pon_forms_sections.form_code,

Line 1338: pon_fields_tl.field_name,

1334: pon_fields.datatype,
1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,
1337: pon_fields.system_field_lov_flag,
1338: pon_fields_tl.field_name,
1339: pon_fields_tl.description field_description,
1340: pon_forms_sections.form_id,
1341: pon_forms_sections.form_code,
1342: pon_forms_sections_tl.form_name,

Line 1339: pon_fields_tl.description field_description,

1335: pon_fields.value_set_name,
1336: pon_fields.system_flag,
1337: pon_fields.system_field_lov_flag,
1338: pon_fields_tl.field_name,
1339: pon_fields_tl.description field_description,
1340: pon_forms_sections.form_id,
1341: pon_forms_sections.form_code,
1342: pon_forms_sections_tl.form_name,
1343: pon_forms_sections_tl.form_description,

Line 1346: from pon_fields,

1342: pon_forms_sections_tl.form_name,
1343: pon_forms_sections_tl.form_description,
1344: pon_form_section_compiled.display_on_main_page,
1345: pon_form_section_compiled.internal_sequence_number
1346: from pon_fields,
1347: pon_fields_tl,
1348: pon_forms_sections,
1349: pon_forms_sections_tl,
1350: pon_form_section_compiled

Line 1347: pon_fields_tl,

1343: pon_forms_sections_tl.form_description,
1344: pon_form_section_compiled.display_on_main_page,
1345: pon_form_section_compiled.internal_sequence_number
1346: from pon_fields,
1347: pon_fields_tl,
1348: pon_forms_sections,
1349: pon_forms_sections_tl,
1350: pon_form_section_compiled
1351: where

Line 1358: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE

1354: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1355: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1356: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1357: and pon_form_section_compiled.FIELD_CODE is not null
1358: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1359: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1360: and pon_fields_tl.LANGUAGE = g_base_language
1361: and pon_forms_sections_tl.LANGUAGE = g_base_language
1362: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'

Line 1359: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE

1355: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1356: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1357: and pon_form_section_compiled.FIELD_CODE is not null
1358: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1359: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1360: and pon_fields_tl.LANGUAGE = g_base_language
1361: and pon_forms_sections_tl.LANGUAGE = g_base_language
1362: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'
1363: order by

Line 1360: and pon_fields_tl.LANGUAGE = g_base_language

1356: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1357: and pon_form_section_compiled.FIELD_CODE is not null
1358: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1359: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1360: and pon_fields_tl.LANGUAGE = g_base_language
1361: and pon_forms_sections_tl.LANGUAGE = g_base_language
1362: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'
1363: order by
1364: internal_sequence_number;

Line 1546: pon_fields.DATATYPE,

1542: pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
1543: pon_form_section_compiled.REQUIRED,
1544: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1545: pon_forms_sections.FORM_CODE SECTION_CODE,
1546: pon_fields.DATATYPE,
1547: pon_fields.SYSTEM_FLAG,
1548: pon_fields.VALUE_SET_NAME,
1549: pon_fields_tl.FIELD_NAME,
1550: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

Line 1547: pon_fields.SYSTEM_FLAG,

1543: pon_form_section_compiled.REQUIRED,
1544: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1545: pon_forms_sections.FORM_CODE SECTION_CODE,
1546: pon_fields.DATATYPE,
1547: pon_fields.SYSTEM_FLAG,
1548: pon_fields.VALUE_SET_NAME,
1549: pon_fields_tl.FIELD_NAME,
1550: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1551: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,

Line 1548: pon_fields.VALUE_SET_NAME,

1544: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1545: pon_forms_sections.FORM_CODE SECTION_CODE,
1546: pon_fields.DATATYPE,
1547: pon_fields.SYSTEM_FLAG,
1548: pon_fields.VALUE_SET_NAME,
1549: pon_fields_tl.FIELD_NAME,
1550: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1551: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1552: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,

Line 1549: pon_fields_tl.FIELD_NAME,

1545: pon_forms_sections.FORM_CODE SECTION_CODE,
1546: pon_fields.DATATYPE,
1547: pon_fields.SYSTEM_FLAG,
1548: pon_fields.VALUE_SET_NAME,
1549: pon_fields_tl.FIELD_NAME,
1550: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1551: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1552: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1553: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID

Line 1550: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

1546: pon_fields.DATATYPE,
1547: pon_fields.SYSTEM_FLAG,
1548: pon_fields.VALUE_SET_NAME,
1549: pon_fields_tl.FIELD_NAME,
1550: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1551: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1552: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1553: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID
1554: FROM PON_FORM_SECTION_COMPILED,

Line 1555: PON_FIELDS,

1551: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1552: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1553: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID
1554: FROM PON_FORM_SECTION_COMPILED,
1555: PON_FIELDS,
1556: PON_FIELDS_TL,
1557: PON_FORMS_SECTIONS
1558: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1559: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

Line 1556: PON_FIELDS_TL,

1552: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1553: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID
1554: FROM PON_FORM_SECTION_COMPILED,
1555: PON_FIELDS,
1556: PON_FIELDS_TL,
1557: PON_FORMS_SECTIONS
1558: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1559: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1560: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID

Line 1558: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)

1554: FROM PON_FORM_SECTION_COMPILED,
1555: PON_FIELDS,
1556: PON_FIELDS_TL,
1557: PON_FORMS_SECTIONS
1558: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1559: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1560: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1561: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1562: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'

Line 1559: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

1555: PON_FIELDS,
1556: PON_FIELDS_TL,
1557: PON_FORMS_SECTIONS
1558: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1559: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1560: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1561: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1562: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'
1563: AND pon_fields_tl.LANGUAGE(+) = g_base_language

Line 1563: AND pon_fields_tl.LANGUAGE(+) = g_base_language

1559: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1560: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1561: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1562: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'
1563: AND pon_fields_tl.LANGUAGE(+) = g_base_language
1564: ORDER BY
1565: INTERNAL_SEQUENCE_NUMBER;
1566:
1567: