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