eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_FORMS_JRAD_PVT dependencies on PON_FORMS_SECTIONS

Line 823: pon_forms_sections.FORM_CODE SECTION_CODE,

819: pon_form_section_compiled.FIELD_CODE,
820: pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
821: pon_form_section_compiled.REQUIRED,
822: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
823: pon_forms_sections.FORM_CODE SECTION_CODE,
824: pon_fields.DATATYPE ,
825: pon_fields.VALUE_SET_NAME,
826: pon_fields.SYSTEM_FLAG,
827: pon_fields_tl.FIELD_NAME,

Line 835: PON_FORMS_SECTIONS

831: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
832: FROM PON_FORM_SECTION_COMPILED,
833: PON_FIELDS,
834: PON_FIELDS_TL,
835: PON_FORMS_SECTIONS
836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
838: AND pon_forms_sections.FORM_ID = P_FORM_ID
839: AND pon_form_section_compiled.FORM_ID = P_FORM_ID

Line 838: AND pon_forms_sections.FORM_ID = P_FORM_ID

834: PON_FIELDS_TL,
835: PON_FORMS_SECTIONS
836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
838: AND pon_forms_sections.FORM_ID = P_FORM_ID
839: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
840: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')
841: AND pon_fields_tl.LANGUAGE(+) = g_base_language
842: ORDER BY

Line 850: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;

846: v_message_layout_element JDR_DOCBUILDER.ELEMENT;
847: v_temp_element JDR_DOCBUILDER.ELEMENT;
848: v_column_header_element JDR_DOCBUILDER.ELEMENT;
849: v_form_fields_row V_FORM_FIELDS_CURSOR%ROWTYPE;
850: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
851: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
852: v_action_parameters JDR_DOCBUILDER.ELEMENT;
853: v_action_parameter JDR_DOCBUILDER.ELEMENT;
854: v_curr_formfieldvaluesvo_name VARCHAR2(20);

Line 851: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

847: v_temp_element JDR_DOCBUILDER.ELEMENT;
848: v_column_header_element JDR_DOCBUILDER.ELEMENT;
849: v_form_fields_row V_FORM_FIELDS_CURSOR%ROWTYPE;
850: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
851: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
852: v_action_parameters JDR_DOCBUILDER.ELEMENT;
853: v_action_parameter JDR_DOCBUILDER.ELEMENT;
854: v_curr_formfieldvaluesvo_name VARCHAR2(20);
855: v_display_type VARCHAR2(1);

Line 954: pon_forms_sections forms,

950: forms_tl.form_name , forms.form_code
951: INTO
952: v_section_title, v_section_code
953: FROM
954: pon_forms_sections forms,
955: pon_forms_sections_tl forms_tl
956: WHERE
957: forms.form_id = forms_tl.form_id AND
958: forms.form_id = v_form_fields_row.section_id AND

Line 955: pon_forms_sections_tl forms_tl

951: INTO
952: v_section_title, v_section_code
953: FROM
954: pon_forms_sections forms,
955: pon_forms_sections_tl forms_tl
956: WHERE
957: forms.form_id = forms_tl.form_id AND
958: forms.form_id = v_form_fields_row.section_id AND
959: forms_tl.LANGUAGE = g_base_language;

Line 1253: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;

1249: x_error_code OUT NOCOPY VARCHAR2,
1250: x_error_message OUT NOCOPY VARCHAR2) IS
1251: rval INTEGER;
1252:
1253: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1254:
1255: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1256: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1257: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;

Line 1255: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1251: rval INTEGER;
1252:
1253: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1254:
1255: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1256: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1257: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;
1258:
1259:

Line 1256: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;

1252:
1253: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1254:
1255: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1256: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1257: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;
1258:
1259:
1260: v_section_element JDR_DOCBUILDER.ELEMENT;

Line 1257: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;

1253: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1254:
1255: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1256: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1257: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;
1258:
1259:
1260: v_section_element JDR_DOCBUILDER.ELEMENT;
1261: v_section_layout_element JDR_DOCBUILDER.ELEMENT;

Line 1273: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;

1269: v_table_footer_element_rd JDR_DOCBUILDER.ELEMENT;
1270: v_temp_element JDR_DOCBUILDER.ELEMENT;
1271: v_column_header_element JDR_DOCBUILDER.ELEMENT;
1272: v_section_tip_element JDR_DOCBUILDER.ELEMENT;
1273: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1274:
1275: v_view_name VARCHAR2(30);
1276:
1277: mainDocBuyerEntry JDR_DOCBUILDER.DOCUMENT;

Line 1324: pon_forms_sections forms,

1320: SELECT
1321: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1322: INTO v_section_title, v_section_code, v_section_desc
1323: FROM
1324: pon_forms_sections forms,
1325: pon_forms_sections_tl forms_tl
1326: WHERE
1327: forms.form_id = forms_tl.form_id AND
1328: forms.form_id = p_section_id AND

Line 1325: pon_forms_sections_tl forms_tl

1321: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1322: INTO v_section_title, v_section_code, v_section_desc
1323: FROM
1324: pon_forms_sections forms,
1325: pon_forms_sections_tl forms_tl
1326: WHERE
1327: forms.form_id = forms_tl.form_id AND
1328: forms.form_id = p_section_id AND
1329: forms_tl.LANGUAGE = g_base_language;

Line 1470: pon_forms_sections.form_id,

1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,
1472: pon_forms_sections_tl.form_name,
1473: pon_forms_sections_tl.form_description,
1474: pon_form_section_compiled.display_on_main_page,

Line 1471: pon_forms_sections.form_code,

1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,
1472: pon_forms_sections_tl.form_name,
1473: pon_forms_sections_tl.form_description,
1474: pon_form_section_compiled.display_on_main_page,
1475: pon_form_section_compiled.internal_sequence_number

Line 1472: pon_forms_sections_tl.form_name,

1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,
1472: pon_forms_sections_tl.form_name,
1473: pon_forms_sections_tl.form_description,
1474: pon_form_section_compiled.display_on_main_page,
1475: pon_form_section_compiled.internal_sequence_number
1476: from pon_fields,

Line 1473: pon_forms_sections_tl.form_description,

1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,
1472: pon_forms_sections_tl.form_name,
1473: pon_forms_sections_tl.form_description,
1474: pon_form_section_compiled.display_on_main_page,
1475: pon_form_section_compiled.internal_sequence_number
1476: from pon_fields,
1477: pon_fields_tl,

Line 1478: pon_forms_sections,

1474: pon_form_section_compiled.display_on_main_page,
1475: pon_form_section_compiled.internal_sequence_number
1476: from pon_fields,
1477: pon_fields_tl,
1478: pon_forms_sections,
1479: pon_forms_sections_tl,
1480: pon_form_section_compiled
1481: where
1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'

Line 1479: pon_forms_sections_tl,

1475: pon_form_section_compiled.internal_sequence_number
1476: from pon_fields,
1477: pon_fields_tl,
1478: pon_forms_sections,
1479: pon_forms_sections_tl,
1480: pon_form_section_compiled
1481: where
1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1483: and pon_forms_sections.STATUS = 'ACTIVE'

Line 1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'

1478: pon_forms_sections,
1479: pon_forms_sections_tl,
1480: pon_form_section_compiled
1481: where
1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1483: and pon_forms_sections.STATUS = 'ACTIVE'
1484: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'

Line 1483: and pon_forms_sections.STATUS = 'ACTIVE'

1479: pon_forms_sections_tl,
1480: pon_form_section_compiled
1481: where
1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1483: and pon_forms_sections.STATUS = 'ACTIVE'
1484: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1487: and pon_form_section_compiled.FIELD_CODE is not null

Line 1484: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID

1480: pon_form_section_compiled
1481: where
1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1483: and pon_forms_sections.STATUS = 'ACTIVE'
1484: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1487: and pon_form_section_compiled.FIELD_CODE is not null
1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE

Line 1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID

1481: where
1482: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1483: and pon_forms_sections.STATUS = 'ACTIVE'
1484: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1487: and pon_form_section_compiled.FIELD_CODE is not null
1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1489: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE

Line 1491: and pon_forms_sections_tl.LANGUAGE = g_base_language

1487: and pon_form_section_compiled.FIELD_CODE is not null
1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1489: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1490: and pon_fields_tl.LANGUAGE = g_base_language
1491: and pon_forms_sections_tl.LANGUAGE = g_base_language
1492: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'
1493: order by
1494: internal_sequence_number;
1495:

Line 1508: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1504: v_section_link_element JDR_DOCBUILDER.ELEMENT;
1505: v_section_img_element JDR_DOCBUILDER.ELEMENT;
1506:
1507: v_abstract_fields_row V_ABSTRACT_FIELDS_CURSOR%ROWTYPE;
1508: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1509: v_curr_vo_name VARCHAR2(100);
1510: rval INTEGER;
1511:
1512: BEGIN

Line 1675: pon_forms_sections.FORM_CODE SECTION_CODE,

1671: pon_form_section_compiled.FIELD_CODE,
1672: pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
1673: pon_form_section_compiled.REQUIRED,
1674: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1675: pon_forms_sections.FORM_CODE SECTION_CODE,
1676: pon_fields.DATATYPE,
1677: pon_fields.SYSTEM_FLAG,
1678: pon_fields.VALUE_SET_NAME,
1679: pon_fields_tl.FIELD_NAME,

Line 1688: PON_FORMS_SECTIONS

1684: pon_form_section_compiled.EDITABLE
1685: FROM PON_FORM_SECTION_COMPILED,
1686: PON_FIELDS,
1687: PON_FIELDS_TL,
1688: PON_FORMS_SECTIONS
1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1692: AND pon_form_section_compiled.FORM_ID = P_FORM_ID

Line 1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID

1687: PON_FIELDS_TL,
1688: PON_FORMS_SECTIONS
1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1692: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1693: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'
1694: AND pon_fields_tl.LANGUAGE(+) = g_base_language
1695: ORDER BY

Line 1739: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;

1735: v_section_layout_element_rd JDR_DOCBUILDER.ELEMENT;
1736: v_section_field_element_rd JDR_DOCBUILDER.ELEMENT;
1737: v_lov_mapping_element JDR_DOCBUILDER.ELEMENT;
1738:
1739: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1740: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1741: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1742: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1743: v_field_jrad_id VARCHAR2(200);

Line 1740: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1736: v_section_field_element_rd JDR_DOCBUILDER.ELEMENT;
1737: v_lov_mapping_element JDR_DOCBUILDER.ELEMENT;
1738:
1739: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1740: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1741: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1742: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1743: v_field_jrad_id VARCHAR2(200);
1744: v_jrad_element_id VARCHAR2(200);

Line 1741: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1737: v_lov_mapping_element JDR_DOCBUILDER.ELEMENT;
1738:
1739: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1740: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1741: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1742: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1743: v_field_jrad_id VARCHAR2(200);
1744: v_jrad_element_id VARCHAR2(200);
1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

Line 1742: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;

1738:
1739: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1740: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1741: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1742: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1743: v_field_jrad_id VARCHAR2(200);
1744: v_jrad_element_id VARCHAR2(200);
1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1746:

Line 1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

1741: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1742: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1743: v_field_jrad_id VARCHAR2(200);
1744: v_jrad_element_id VARCHAR2(200);
1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1746:
1747: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1748: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1749: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

Line 1747: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;

1743: v_field_jrad_id VARCHAR2(200);
1744: v_jrad_element_id VARCHAR2(200);
1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1746:
1747: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1748: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1749: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1750:
1751: v_formfieldvaluesvo_list_count INTEGER;

Line 1748: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

1744: v_jrad_element_id VARCHAR2(200);
1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1746:
1747: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1748: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1749: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1750:
1751: v_formfieldvaluesvo_list_count INTEGER;
1752: v_form_mcl_count INTEGER;

Line 1749: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

1745: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1746:
1747: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1748: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1749: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1750:
1751: v_formfieldvaluesvo_list_count INTEGER;
1752: v_form_mcl_count INTEGER;
1753: v_section_mcl_count INTEGER;

Line 1842: pon_forms_sections forms,

1838: forms_tl.form_name, forms.form_code
1839: INTO
1840: v_section_title, v_section_code
1841: FROM
1842: pon_forms_sections forms,
1843: pon_forms_sections_tl forms_tl
1844: WHERE
1845: forms.form_id = forms_tl.form_id AND
1846: forms.form_id = v_current_section_id AND

Line 1843: pon_forms_sections_tl forms_tl

1839: INTO
1840: v_section_title, v_section_code
1841: FROM
1842: pon_forms_sections forms,
1843: pon_forms_sections_tl forms_tl
1844: WHERE
1845: forms.form_id = forms_tl.form_id AND
1846: forms.form_id = v_current_section_id AND
1847: forms_tl.LANGUAGE = g_base_language;

Line 1965: pon_forms_sections forms,

1961: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1962: INTO
1963: v_section_title, v_section_code, v_section_desc
1964: FROM
1965: pon_forms_sections forms,
1966: pon_forms_sections_tl forms_tl
1967: WHERE
1968: forms.form_id = forms_tl.form_id AND
1969: forms.form_id = v_current_section_id AND

Line 1966: pon_forms_sections_tl forms_tl

1962: INTO
1963: v_section_title, v_section_code, v_section_desc
1964: FROM
1965: pon_forms_sections forms,
1966: pon_forms_sections_tl forms_tl
1967: WHERE
1968: forms.form_id = forms_tl.form_id AND
1969: forms.form_id = v_current_section_id AND
1970: forms_tl.LANGUAGE = g_base_language;

Line 2072: pon_forms_sections forms,

2068: forms_tl.form_name, forms.form_code, forms_tl.tip_text
2069: INTO
2070: v_section_title, v_section_code, v_section_desc
2071: FROM
2072: pon_forms_sections forms,
2073: pon_forms_sections_tl forms_tl
2074: WHERE
2075: forms.form_id = forms_tl.form_id AND
2076: forms.form_id = v_current_section_id AND

Line 2073: pon_forms_sections_tl forms_tl

2069: INTO
2070: v_section_title, v_section_code, v_section_desc
2071: FROM
2072: pon_forms_sections forms,
2073: pon_forms_sections_tl forms_tl
2074: WHERE
2075: forms.form_id = forms_tl.form_id AND
2076: forms.form_id = v_current_section_id AND
2077: forms_tl.LANGUAGE = g_base_language;

Line 2141: pon_forms_sections forms,

2137: forms_tl.form_name, forms.form_code, forms_tl.tip_text
2138: INTO
2139: v_section_title, v_section_code, v_section_desc
2140: FROM
2141: pon_forms_sections forms,
2142: pon_forms_sections_tl forms_tl
2143: WHERE
2144: forms.form_id = forms_tl.form_id AND
2145: forms.form_id = v_current_section_id AND

Line 2142: pon_forms_sections_tl forms_tl

2138: INTO
2139: v_section_title, v_section_code, v_section_desc
2140: FROM
2141: pon_forms_sections forms,
2142: pon_forms_sections_tl forms_tl
2143: WHERE
2144: forms.form_id = forms_tl.form_id AND
2145: forms.form_id = v_current_section_id AND
2146: forms_tl.LANGUAGE = g_base_language;

Line 2240: pon_forms_sections forms,

2236: forms_tl.form_name, forms.form_code, forms_tl.tip_text
2237: INTO
2238: v_section_title, v_section_code, v_section_desc
2239: FROM
2240: pon_forms_sections forms,
2241: pon_forms_sections_tl forms_tl
2242: WHERE
2243: forms.form_id = forms_tl.form_id AND
2244: forms.form_id = v_current_section_id AND

Line 2241: pon_forms_sections_tl forms_tl

2237: INTO
2238: v_section_title, v_section_code, v_section_desc
2239: FROM
2240: pon_forms_sections forms,
2241: pon_forms_sections_tl forms_tl
2242: WHERE
2243: forms.form_id = forms_tl.form_id AND
2244: forms.form_id = v_current_section_id AND
2245: forms_tl.LANGUAGE = g_base_language;

Line 2308: pon_forms_sections forms,

2304: forms_tl.form_name, forms.form_code
2305: INTO
2306: v_section_title, v_section_code
2307: FROM
2308: pon_forms_sections forms,
2309: pon_forms_sections_tl forms_tl
2310: WHERE
2311: forms.form_id = forms_tl.form_id AND
2312: forms.form_id = v_current_section_id AND

Line 2309: pon_forms_sections_tl forms_tl

2305: INTO
2306: v_section_title, v_section_code
2307: FROM
2308: pon_forms_sections forms,
2309: pon_forms_sections_tl forms_tl
2310: WHERE
2311: forms.form_id = forms_tl.form_id AND
2312: forms.form_id = v_current_section_id AND
2313: forms_tl.LANGUAGE = g_base_language;

Line 2495: pon_forms_sections forms,

2491: forms_tl.form_name, forms.form_code
2492: INTO
2493: v_section_title, v_section_code
2494: FROM
2495: pon_forms_sections forms,
2496: pon_forms_sections_tl forms_tl
2497: WHERE
2498: forms.form_id = forms_tl.form_id AND
2499: forms.form_id = v_current_section_id AND

Line 2496: pon_forms_sections_tl forms_tl

2492: INTO
2493: v_section_title, v_section_code
2494: FROM
2495: pon_forms_sections forms,
2496: pon_forms_sections_tl forms_tl
2497: WHERE
2498: forms.form_id = forms_tl.form_id AND
2499: forms.form_id = v_current_section_id AND
2500: forms_tl.LANGUAGE = g_base_language;

Line 2685: pon_forms_sections forms,

2681: forms_tl.form_name, forms.form_code
2682: INTO
2683: v_section_title, v_section_code
2684: FROM
2685: pon_forms_sections forms,
2686: pon_forms_sections_tl forms_tl
2687: WHERE
2688: forms.form_id = forms_tl.form_id AND
2689: forms.form_id = v_current_section_id AND

Line 2686: pon_forms_sections_tl forms_tl

2682: INTO
2683: v_section_title, v_section_code
2684: FROM
2685: pon_forms_sections forms,
2686: pon_forms_sections_tl forms_tl
2687: WHERE
2688: forms.form_id = forms_tl.form_id AND
2689: forms.form_id = v_current_section_id AND
2690: forms_tl.LANGUAGE = g_base_language;

Line 3154: v_form_type PON_FORMS_SECTIONS.TYPE%TYPE;

3150: x_error_code OUT NOCOPY VARCHAR2,
3151: x_error_message OUT NOCOPY VARCHAR2
3152: ) IS
3153:
3154: v_form_type PON_FORMS_SECTIONS.TYPE%TYPE;
3155: v_is_repeating_section_flag PON_FORMS_SECTIONS.IS_REPEATING_SECTION_FLAG%TYPE;
3156: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JRAD';
3157:
3158: BEGIN

Line 3155: v_is_repeating_section_flag PON_FORMS_SECTIONS.IS_REPEATING_SECTION_FLAG%TYPE;

3151: x_error_message OUT NOCOPY VARCHAR2
3152: ) IS
3153:
3154: v_form_type PON_FORMS_SECTIONS.TYPE%TYPE;
3155: v_is_repeating_section_flag PON_FORMS_SECTIONS.IS_REPEATING_SECTION_FLAG%TYPE;
3156: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JRAD';
3157:
3158: BEGIN
3159: -- initialize to error

Line 3173: from pon_forms_sections where form_id = p_form_id;

3169: nvl(is_repeating_section_flag,'N')
3170: into
3171: v_form_type,
3172: v_is_repeating_section_flag
3173: from pon_forms_sections where form_id = p_form_id;
3174:
3175: -- generate the buyer data-entry page
3176: -- generate the buyer view-only page
3177: