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 693: pon_forms_sections.FORM_CODE SECTION_CODE,

689: pon_form_section_compiled.FIELD_CODE,
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,

Line 705: PON_FORMS_SECTIONS

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
709: AND pon_form_section_compiled.FORM_ID = P_FORM_ID

Line 708: AND pon_forms_sections.FORM_ID = P_FORM_ID

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
712: ORDER BY

Line 720: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;

716: v_message_layout_element JDR_DOCBUILDER.ELEMENT;
717: v_temp_element JDR_DOCBUILDER.ELEMENT;
718: v_column_header_element JDR_DOCBUILDER.ELEMENT;
719: v_form_fields_row V_FORM_FIELDS_CURSOR%ROWTYPE;
720: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
721: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
722: v_action_parameters JDR_DOCBUILDER.ELEMENT;
723: v_action_parameter JDR_DOCBUILDER.ELEMENT;
724: v_curr_formfieldvaluesvo_name VARCHAR2(20);

Line 721: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

717: v_temp_element JDR_DOCBUILDER.ELEMENT;
718: v_column_header_element JDR_DOCBUILDER.ELEMENT;
719: v_form_fields_row V_FORM_FIELDS_CURSOR%ROWTYPE;
720: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
721: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
722: v_action_parameters JDR_DOCBUILDER.ELEMENT;
723: v_action_parameter JDR_DOCBUILDER.ELEMENT;
724: v_curr_formfieldvaluesvo_name VARCHAR2(20);
725: v_display_type VARCHAR2(1);

Line 824: pon_forms_sections forms,

820: forms_tl.form_name , forms.form_code
821: INTO
822: v_section_title, v_section_code
823: FROM
824: pon_forms_sections forms,
825: pon_forms_sections_tl forms_tl
826: WHERE
827: forms.form_id = forms_tl.form_id AND
828: forms.form_id = v_form_fields_row.section_id AND

Line 825: pon_forms_sections_tl forms_tl

821: INTO
822: v_section_title, v_section_code
823: FROM
824: pon_forms_sections forms,
825: pon_forms_sections_tl forms_tl
826: WHERE
827: forms.form_id = forms_tl.form_id AND
828: forms.form_id = v_form_fields_row.section_id AND
829: forms_tl.LANGUAGE = g_base_language;

Line 1123: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;

1119: x_error_code OUT NOCOPY VARCHAR2,
1120: x_error_message OUT NOCOPY VARCHAR2) IS
1121: rval INTEGER;
1122:
1123: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1124:
1125: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1126: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1127: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;

Line 1125: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1121: rval INTEGER;
1122:
1123: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1124:
1125: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1126: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1127: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;
1128:
1129:

Line 1126: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;

1122:
1123: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1124:
1125: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1126: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1127: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;
1128:
1129:
1130: v_section_element JDR_DOCBUILDER.ELEMENT;

Line 1127: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;

1123: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1124:
1125: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1126: v_section_entry_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME%TYPE;
1127: v_section_read_path PON_FORMS_SECTIONS.JRAD_XML_REGION_NAME_DISP%TYPE;
1128:
1129:
1130: v_section_element JDR_DOCBUILDER.ELEMENT;
1131: v_section_layout_element JDR_DOCBUILDER.ELEMENT;

Line 1143: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;

1139: v_table_footer_element_rd JDR_DOCBUILDER.ELEMENT;
1140: v_temp_element JDR_DOCBUILDER.ELEMENT;
1141: v_column_header_element JDR_DOCBUILDER.ELEMENT;
1142: v_section_tip_element JDR_DOCBUILDER.ELEMENT;
1143: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1144:
1145: v_view_name VARCHAR2(30);
1146:
1147: mainDocBuyerEntry JDR_DOCBUILDER.DOCUMENT;

Line 1194: pon_forms_sections forms,

1190: SELECT
1191: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1192: INTO v_section_title, v_section_code, v_section_desc
1193: FROM
1194: pon_forms_sections forms,
1195: pon_forms_sections_tl forms_tl
1196: WHERE
1197: forms.form_id = forms_tl.form_id AND
1198: forms.form_id = p_section_id AND

Line 1195: pon_forms_sections_tl forms_tl

1191: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1192: INTO v_section_title, v_section_code, v_section_desc
1193: FROM
1194: pon_forms_sections forms,
1195: pon_forms_sections_tl forms_tl
1196: WHERE
1197: forms.form_id = forms_tl.form_id AND
1198: forms.form_id = p_section_id AND
1199: forms_tl.LANGUAGE = g_base_language;

Line 1340: pon_forms_sections.form_id,

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,
1344: pon_form_section_compiled.display_on_main_page,

Line 1341: pon_forms_sections.form_code,

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,
1344: pon_form_section_compiled.display_on_main_page,
1345: pon_form_section_compiled.internal_sequence_number

Line 1342: pon_forms_sections_tl.form_name,

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,
1344: pon_form_section_compiled.display_on_main_page,
1345: pon_form_section_compiled.internal_sequence_number
1346: from pon_fields,

Line 1343: pon_forms_sections_tl.form_description,

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,
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,

Line 1348: pon_forms_sections,

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
1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'

Line 1349: pon_forms_sections_tl,

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
1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1353: and pon_forms_sections.STATUS = 'ACTIVE'

Line 1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'

1348: pon_forms_sections,
1349: pon_forms_sections_tl,
1350: pon_form_section_compiled
1351: where
1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1353: and pon_forms_sections.STATUS = 'ACTIVE'
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'

Line 1353: and pon_forms_sections.STATUS = 'ACTIVE'

1349: pon_forms_sections_tl,
1350: pon_form_section_compiled
1351: where
1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1353: and pon_forms_sections.STATUS = 'ACTIVE'
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

Line 1354: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID

1350: pon_form_section_compiled
1351: where
1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1353: and pon_forms_sections.STATUS = 'ACTIVE'
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

Line 1355: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID

1351: where
1352: pon_forms_sections.FORM_CODE = 'ABSTRACT'
1353: and pon_forms_sections.STATUS = 'ACTIVE'
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

Line 1361: and pon_forms_sections_tl.LANGUAGE = g_base_language

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

Line 1378: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1374: v_section_link_element JDR_DOCBUILDER.ELEMENT;
1375: v_section_img_element JDR_DOCBUILDER.ELEMENT;
1376:
1377: v_abstract_fields_row V_ABSTRACT_FIELDS_CURSOR%ROWTYPE;
1378: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1379: v_curr_vo_name VARCHAR2(100);
1380: rval INTEGER;
1381:
1382: BEGIN

Line 1545: pon_forms_sections.FORM_CODE SECTION_CODE,

1541: pon_form_section_compiled.FIELD_CODE,
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,

Line 1557: PON_FORMS_SECTIONS

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
1561: AND pon_form_section_compiled.FORM_ID = P_FORM_ID

Line 1560: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID

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
1564: ORDER BY

Line 1608: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;

1604: v_section_layout_element_rd JDR_DOCBUILDER.ELEMENT;
1605: v_section_field_element_rd JDR_DOCBUILDER.ELEMENT;
1606:
1607:
1608: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1609: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1610: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1611: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1612: v_field_jrad_id VARCHAR2(200);

Line 1609: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1605: v_section_field_element_rd JDR_DOCBUILDER.ELEMENT;
1606:
1607:
1608: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1609: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1610: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1611: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1612: v_field_jrad_id VARCHAR2(200);
1613: v_jrad_element_id VARCHAR2(200);

Line 1610: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

1606:
1607:
1608: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1609: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1610: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1611: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1612: v_field_jrad_id VARCHAR2(200);
1613: v_jrad_element_id VARCHAR2(200);
1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

Line 1611: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;

1607:
1608: v_section_title PON_FORMS_SECTIONS_TL.FORM_NAME%TYPE;
1609: v_parent_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1610: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1611: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1612: v_field_jrad_id VARCHAR2(200);
1613: v_jrad_element_id VARCHAR2(200);
1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1615:

Line 1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

1610: v_section_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
1611: v_section_desc PON_FORMS_SECTIONS_TL.FORM_DESCRIPTION%TYPE;
1612: v_field_jrad_id VARCHAR2(200);
1613: v_jrad_element_id VARCHAR2(200);
1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1615:
1616: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1617: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1618: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

Line 1616: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;

1612: v_field_jrad_id VARCHAR2(200);
1613: v_jrad_element_id VARCHAR2(200);
1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1615:
1616: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1617: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1618: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1619:
1620: v_formfieldvaluesvo_list_count INTEGER;

Line 1617: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

1613: v_jrad_element_id VARCHAR2(200);
1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1615:
1616: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1617: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1618: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1619:
1620: v_formfieldvaluesvo_list_count INTEGER;
1621: v_form_mcl_count INTEGER;

Line 1618: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

1614: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1615:
1616: v_LEVEL1_SECTION_ID PON_FORMS_SECTIONS.FORM_ID%TYPE;
1617: v_parent_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1618: v_current_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
1619:
1620: v_formfieldvaluesvo_list_count INTEGER;
1621: v_form_mcl_count INTEGER;
1622: v_section_mcl_count INTEGER;

Line 1711: pon_forms_sections forms,

1707: forms_tl.form_name, forms.form_code
1708: INTO
1709: v_section_title, v_section_code
1710: FROM
1711: pon_forms_sections forms,
1712: pon_forms_sections_tl forms_tl
1713: WHERE
1714: forms.form_id = forms_tl.form_id AND
1715: forms.form_id = v_current_section_id AND

Line 1712: pon_forms_sections_tl forms_tl

1708: INTO
1709: v_section_title, v_section_code
1710: FROM
1711: pon_forms_sections forms,
1712: pon_forms_sections_tl forms_tl
1713: WHERE
1714: forms.form_id = forms_tl.form_id AND
1715: forms.form_id = v_current_section_id AND
1716: forms_tl.LANGUAGE = g_base_language;

Line 1834: pon_forms_sections forms,

1830: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1831: INTO
1832: v_section_title, v_section_code, v_section_desc
1833: FROM
1834: pon_forms_sections forms,
1835: pon_forms_sections_tl forms_tl
1836: WHERE
1837: forms.form_id = forms_tl.form_id AND
1838: forms.form_id = v_current_section_id AND

Line 1835: pon_forms_sections_tl forms_tl

1831: INTO
1832: v_section_title, v_section_code, v_section_desc
1833: FROM
1834: pon_forms_sections forms,
1835: pon_forms_sections_tl forms_tl
1836: WHERE
1837: forms.form_id = forms_tl.form_id AND
1838: forms.form_id = v_current_section_id AND
1839: forms_tl.LANGUAGE = g_base_language;

Line 1941: pon_forms_sections forms,

1937: forms_tl.form_name, forms.form_code, forms_tl.tip_text
1938: INTO
1939: v_section_title, v_section_code, v_section_desc
1940: FROM
1941: pon_forms_sections forms,
1942: pon_forms_sections_tl forms_tl
1943: WHERE
1944: forms.form_id = forms_tl.form_id AND
1945: forms.form_id = v_current_section_id AND

Line 1942: pon_forms_sections_tl forms_tl

1938: INTO
1939: v_section_title, v_section_code, v_section_desc
1940: FROM
1941: pon_forms_sections forms,
1942: pon_forms_sections_tl forms_tl
1943: WHERE
1944: forms.form_id = forms_tl.form_id AND
1945: forms.form_id = v_current_section_id AND
1946: forms_tl.LANGUAGE = g_base_language;

Line 2010: pon_forms_sections forms,

2006: forms_tl.form_name, forms.form_code, forms_tl.tip_text
2007: INTO
2008: v_section_title, v_section_code, v_section_desc
2009: FROM
2010: pon_forms_sections forms,
2011: pon_forms_sections_tl forms_tl
2012: WHERE
2013: forms.form_id = forms_tl.form_id AND
2014: forms.form_id = v_current_section_id AND

Line 2011: pon_forms_sections_tl forms_tl

2007: INTO
2008: v_section_title, v_section_code, v_section_desc
2009: FROM
2010: pon_forms_sections forms,
2011: pon_forms_sections_tl forms_tl
2012: WHERE
2013: forms.form_id = forms_tl.form_id AND
2014: forms.form_id = v_current_section_id AND
2015: forms_tl.LANGUAGE = g_base_language;

Line 2109: pon_forms_sections forms,

2105: forms_tl.form_name, forms.form_code, forms_tl.tip_text
2106: INTO
2107: v_section_title, v_section_code, v_section_desc
2108: FROM
2109: pon_forms_sections forms,
2110: pon_forms_sections_tl forms_tl
2111: WHERE
2112: forms.form_id = forms_tl.form_id AND
2113: forms.form_id = v_current_section_id AND

Line 2110: pon_forms_sections_tl forms_tl

2106: INTO
2107: v_section_title, v_section_code, v_section_desc
2108: FROM
2109: pon_forms_sections forms,
2110: pon_forms_sections_tl forms_tl
2111: WHERE
2112: forms.form_id = forms_tl.form_id AND
2113: forms.form_id = v_current_section_id AND
2114: forms_tl.LANGUAGE = g_base_language;

Line 2177: pon_forms_sections forms,

2173: forms_tl.form_name, forms.form_code
2174: INTO
2175: v_section_title, v_section_code
2176: FROM
2177: pon_forms_sections forms,
2178: pon_forms_sections_tl forms_tl
2179: WHERE
2180: forms.form_id = forms_tl.form_id AND
2181: forms.form_id = v_current_section_id AND

Line 2178: pon_forms_sections_tl forms_tl

2174: INTO
2175: v_section_title, v_section_code
2176: FROM
2177: pon_forms_sections forms,
2178: pon_forms_sections_tl forms_tl
2179: WHERE
2180: forms.form_id = forms_tl.form_id AND
2181: forms.form_id = v_current_section_id AND
2182: forms_tl.LANGUAGE = g_base_language;

Line 2364: pon_forms_sections forms,

2360: forms_tl.form_name, forms.form_code
2361: INTO
2362: v_section_title, v_section_code
2363: FROM
2364: pon_forms_sections forms,
2365: pon_forms_sections_tl forms_tl
2366: WHERE
2367: forms.form_id = forms_tl.form_id AND
2368: forms.form_id = v_current_section_id AND

Line 2365: pon_forms_sections_tl forms_tl

2361: INTO
2362: v_section_title, v_section_code
2363: FROM
2364: pon_forms_sections forms,
2365: pon_forms_sections_tl forms_tl
2366: WHERE
2367: forms.form_id = forms_tl.form_id AND
2368: forms.form_id = v_current_section_id AND
2369: forms_tl.LANGUAGE = g_base_language;

Line 2554: pon_forms_sections forms,

2550: forms_tl.form_name, forms.form_code
2551: INTO
2552: v_section_title, v_section_code
2553: FROM
2554: pon_forms_sections forms,
2555: pon_forms_sections_tl forms_tl
2556: WHERE
2557: forms.form_id = forms_tl.form_id AND
2558: forms.form_id = v_current_section_id AND

Line 2555: pon_forms_sections_tl forms_tl

2551: INTO
2552: v_section_title, v_section_code
2553: FROM
2554: pon_forms_sections forms,
2555: pon_forms_sections_tl forms_tl
2556: WHERE
2557: forms.form_id = forms_tl.form_id AND
2558: forms.form_id = v_current_section_id AND
2559: forms_tl.LANGUAGE = g_base_language;

Line 2993: v_form_type PON_FORMS_SECTIONS.TYPE%TYPE;

2989: x_error_code OUT NOCOPY VARCHAR2,
2990: x_error_message OUT NOCOPY VARCHAR2
2991: ) IS
2992:
2993: v_form_type PON_FORMS_SECTIONS.TYPE%TYPE;
2994: v_is_repeating_section_flag PON_FORMS_SECTIONS.IS_REPEATING_SECTION_FLAG%TYPE;
2995: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JRAD';
2996:
2997: BEGIN

Line 2994: v_is_repeating_section_flag PON_FORMS_SECTIONS.IS_REPEATING_SECTION_FLAG%TYPE;

2990: x_error_message OUT NOCOPY VARCHAR2
2991: ) IS
2992:
2993: v_form_type PON_FORMS_SECTIONS.TYPE%TYPE;
2994: v_is_repeating_section_flag PON_FORMS_SECTIONS.IS_REPEATING_SECTION_FLAG%TYPE;
2995: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JRAD';
2996:
2997: BEGIN
2998: -- initialize to error

Line 3012: from pon_forms_sections where form_id = p_form_id;

3008: nvl(is_repeating_section_flag,'N')
3009: into
3010: v_form_type,
3011: v_is_repeating_section_flag
3012: from pon_forms_sections where form_id = p_form_id;
3013:
3014: -- generate the buyer data-entry page
3015: -- generate the buyer view-only page
3016: