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_TL

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