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_UTIL_PVT dependencies on PON_FORMS_SECTIONS

Line 74: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

70: ======================================================================*/
71:
72: FUNCTION getDataEntryRegionName(p_form_id IN NUMBER) RETURN VARCHAR2 IS
73:
74: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
75: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;
76: v_type PON_FORMS_SECTIONS.TYPE%TYPE;
77:
78: l_api_name CONSTANT VARCHAR2(30) := 'getDataEntryRegionName';

Line 75: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;

71:
72: FUNCTION getDataEntryRegionName(p_form_id IN NUMBER) RETURN VARCHAR2 IS
73:
74: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
75: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;
76: v_type PON_FORMS_SECTIONS.TYPE%TYPE;
77:
78: l_api_name CONSTANT VARCHAR2(30) := 'getDataEntryRegionName';
79:

Line 76: v_type PON_FORMS_SECTIONS.TYPE%TYPE;

72: FUNCTION getDataEntryRegionName(p_form_id IN NUMBER) RETURN VARCHAR2 IS
73:
74: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
75: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;
76: v_type PON_FORMS_SECTIONS.TYPE%TYPE;
77:
78: l_api_name CONSTANT VARCHAR2(30) := 'getDataEntryRegionName';
79:
80: BEGIN

Line 86: from pon_forms_sections where form_id = p_form_id;

82: print_debug_log(l_api_name, 'BEGIN- p_form_id = '||p_form_id);
83:
84: select form_code , form_version , type
85: into v_form_code, v_form_version, v_type
86: from pon_forms_sections where form_id = p_form_id;
87:
88: print_debug_log(l_api_name, 'END- DataEntryRegionName = '|| g_jrad_rgn_pkg_name || 'pon_'|| v_form_code || '_V' || to_char(v_form_version) || '_RG');
89:
90: return g_jrad_rgn_pkg_name || 'pon_'|| v_form_code || '_V' || to_char(v_form_version) || '_RG';

Line 102: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;

98: ======================================================================*/
99:
100: FUNCTION getReadOnlyRegionName(p_form_id IN NUMBER) RETURN VARCHAR2 IS
101:
102: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
103: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;
104: v_type PON_FORMS_SECTIONS.TYPE%TYPE;
105:
106: l_api_name CONSTANT VARCHAR2(30) := 'getReadOnlyRegionName';

Line 103: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;

99:
100: FUNCTION getReadOnlyRegionName(p_form_id IN NUMBER) RETURN VARCHAR2 IS
101:
102: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
103: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;
104: v_type PON_FORMS_SECTIONS.TYPE%TYPE;
105:
106: l_api_name CONSTANT VARCHAR2(30) := 'getReadOnlyRegionName';
107:

Line 104: v_type PON_FORMS_SECTIONS.TYPE%TYPE;

100: FUNCTION getReadOnlyRegionName(p_form_id IN NUMBER) RETURN VARCHAR2 IS
101:
102: v_form_code PON_FORMS_SECTIONS.FORM_CODE%TYPE;
103: v_form_version PON_FORMS_SECTIONS.FORM_VERSION%TYPE;
104: v_type PON_FORMS_SECTIONS.TYPE%TYPE;
105:
106: l_api_name CONSTANT VARCHAR2(30) := 'getReadOnlyRegionName';
107:
108: BEGIN

Line 114: from pon_forms_sections where form_id = p_form_id;

110: print_debug_log(l_api_name, 'BEGIN- p_form_id = '||p_form_id);
111:
112: select form_code , form_version , type
113: into v_form_code, v_form_version, v_type
114: from pon_forms_sections where form_id = p_form_id;
115:
116: print_debug_log(l_api_name, 'END- ReadOnlyRegionName = '||g_jrad_rgn_pkg_name || 'pon_'|| v_form_code || '_V' || to_char(v_form_version) || '_DSP_RG');
117:
118: return g_jrad_rgn_pkg_name || 'pon_'|| v_form_code || '_V' || to_char(v_form_version) || '_DSP_RG';

Line 1310: pon_forms_sections rs,

1306: f.value_set_name,
1307: valset.flex_value_set_id value_set_id,
1308: valset.VALIDATION_TYPE
1309: from pon_form_section_compiled ff,
1310: pon_forms_sections rs,
1311: pon_fields f,
1312: fnd_flex_value_sets valset
1313: where ff.form_id = p_section_id
1314: and rs.form_id(+) = ff.repeating_section_id

Line 1459: PON_FORMS_SECTIONS ts,

1455: valset.flex_value_set_id value_set_id,
1456: valset.VALIDATION_TYPE,
1457: ff.EDITABLE --Add for FOB project
1458: from pon_form_section_compiled ff,
1459: PON_FORMS_SECTIONS ts,
1460: PON_FORMS_SECTIONS isec,
1461: PON_FORMS_SECTIONS rs,
1462: pon_fields f,
1463: fnd_flex_value_sets valset

Line 1460: PON_FORMS_SECTIONS isec,

1456: valset.VALIDATION_TYPE,
1457: ff.EDITABLE --Add for FOB project
1458: from pon_form_section_compiled ff,
1459: PON_FORMS_SECTIONS ts,
1460: PON_FORMS_SECTIONS isec,
1461: PON_FORMS_SECTIONS rs,
1462: pon_fields f,
1463: fnd_flex_value_sets valset
1464: where ts.form_id(+) = ff.LEVEL1_SECTION_ID

Line 1461: PON_FORMS_SECTIONS rs,

1457: ff.EDITABLE --Add for FOB project
1458: from pon_form_section_compiled ff,
1459: PON_FORMS_SECTIONS ts,
1460: PON_FORMS_SECTIONS isec,
1461: PON_FORMS_SECTIONS rs,
1462: pon_fields f,
1463: fnd_flex_value_sets valset
1464: where ts.form_id(+) = ff.LEVEL1_SECTION_ID
1465: and isec.form_id(+) = ff.LEVEL2_SECTION_ID

Line 1517: from PON_FORMS_SECTIONS

1513: g_alias_counter := g_alias_counter + 1;
1514:
1515: select form_code
1516: into l_form_code
1517: from PON_FORMS_SECTIONS
1518: where form_id = p_form_id;
1519:
1520: print_debug_log(l_api_name, 'l_form_code = '||l_form_code||' g_alias_counter = '||g_alias_counter);
1521:

Line 1771: from pon_forms_sections

1767: SAVEPOINT PON_XMLSCHEMA;
1768: g_mode := 'SCHEMA';
1769: select form_code
1770: into l_form_code
1771: from pon_forms_sections
1772: where form_id = p_form_id;
1773:
1774: print_debug_log(l_api_name, 'g_mode = '||g_mode||' l_form_code = '||l_form_code);
1775:

Line 1887: from pon_forms_sections

1883: form_code
1884: into
1885: p_xdo_stylesheet_code,
1886: l_form_code
1887: from pon_forms_sections
1888: where form_id = p_form_id;
1889:
1890:
1891: GENERATE_XMLQUERY(p_form_id,

Line 2804: pon_forms_sections

2800: nvl(is_repeating_section_flag,'N')
2801: into
2802: x_is_repeating_section_flag
2803: from
2804: pon_forms_sections
2805: where
2806: FORM_ID = x_section_id;
2807:
2808: if x_is_repeating_section_flag = 'Y' then

Line 2944: pon_forms_sections

2940: nvl(is_repeating_section_flag,'N')
2941: into
2942: x_is_repeating_section_flag
2943: from
2944: pon_forms_sections
2945: where
2946: FORM_ID = x_section_id;
2947:
2948: if x_is_repeating_section_flag = 'Y' then

Line 3119: PON_FORMS_SECTIONS FS

3115: SELECT
3116: DISTINCT FS.FORM_ID SECTION_ID
3117: FROM
3118: PON_FORM_SECTION_FIELDS FSF,
3119: PON_FORMS_SECTIONS FS
3120: WHERE
3121: FSF.SECTION_ID = FS.FORM_ID
3122: AND
3123: FS.IS_REPEATING_SECTION_FLAG = 'Y'

Line 3134: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

3130: CONNECT
3131: BY PRIOR FSF.SECTION_ID = FSF.FORM_ID;
3132:
3133: v_repeating_section_id v_repeating_section_id_cursor%ROWTYPE;
3134: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
3135: x_error_message VARCHAR2(100);
3136: x_error_code VARCHAR2(100);
3137: x_result VARCHAR2(100);
3138: v_read_only_region_name VARCHAR2(100);

Line 3177: UPDATE PON_FORMS_SECTIONS

3173: -- if the form/abstract/section is active
3174: v_read_only_region_name := getReadOnlyRegionName (v_section_id);
3175: v_edit_region_name := getDataEntryRegionName (v_section_id);
3176:
3177: UPDATE PON_FORMS_SECTIONS
3178: SET
3179: JRAD_XML_REGION_NAME_DISP = v_read_only_region_name,
3180: JRAD_XML_REGION_NAME = v_edit_region_name
3181: WHERE

Line 3220: x_query_stmt PON_FORMS_SECTIONS.XML_QUERY%TYPE;

3216: x_form_version NUMBER;
3217: x_type VARCHAR2(30);
3218: x_data_entry_region_name VARCHAR2(100);
3219: x_read_only_region_name_disp VARCHAR2(100);
3220: x_query_stmt PON_FORMS_SECTIONS.XML_QUERY%TYPE;
3221: x_error_message VARCHAR2(100);
3222: x_error_code VARCHAR2(100);
3223: x_result VARCHAR2(100);
3224: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_FORM_DETAILS';

Line 3249: pon_forms_sections

3245: x_type,
3246: x_data_entry_region_name,
3247: x_read_only_region_name_disp
3248: from
3249: pon_forms_sections
3250: where
3251: FORM_ID = p_form_id;
3252:
3253: -- generate inner repeating sections

Line 3286: pon_forms_sections

3282: return;
3283: end if;
3284:
3285: update
3286: pon_forms_sections
3287: set
3288: xml_query = x_query_stmt
3289: where
3290: form_id = p_form_id;

Line 3320: UPDATE pon_forms_sections

3316: -- if the form/abstract/section is active
3317: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
3318: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
3319:
3320: UPDATE pon_forms_sections
3321: SET
3322: jrad_xml_region_name = x_data_entry_region_name,
3323: jrad_xml_region_name_disp = x_read_only_region_name_disp
3324: WHERE form_id = p_form_id

Line 3394: from pon_forms_sections

3390: where auction_header_id = p_auction_header_id;
3391:
3392: select form_id
3393: into l_form_id
3394: from pon_forms_sections
3395: where form_code = 'ABSTRACT'
3396: and type = 'ABSTRACT';
3397:
3398: update pon_forms_instances

Line 3438: l_form_type PON_FORMS_SECTIONS.FORM_CODE%TYPE;

3434: x_error_code OUT NOCOPY VARCHAR2,
3435: x_error_message OUT NOCOPY VARCHAR2) IS
3436:
3437: l_api_name CONSTANT VARCHAR2(30) := 'PERFORMPOSTSAVECHANGES';
3438: l_form_type PON_FORMS_SECTIONS.FORM_CODE%TYPE;
3439: l_old_status PON_FORMS_INSTANCES.STATUS%TYPE;
3440:
3441: BEGIN
3442:

Line 3449: from pon_forms_sections

3445: p_entity_code = '||p_entity_code);
3446:
3447: select type
3448: into l_form_type
3449: from pon_forms_sections
3450: where form_id = p_form_id;
3451:
3452: if(l_form_type = 'FORM') then
3453: /*Add for FBO project.

Line 4319: select FORM_NAME into l_form_name from PON_FORMS_SECTIONS_TL where form_id = p_form_id

4315:
4316: l_curr_lang := fnd_global.current_language;
4317:
4318: --get form name
4319: select FORM_NAME into l_form_name from PON_FORMS_SECTIONS_TL where form_id = p_form_id
4320: AND LANGUAGE = l_curr_lang; -- bug 9855606
4321:
4322: --get item key
4323: select to_char(l_form_name) || '-' ||to_char(l_solnbr) ||'-' ||to_char(l_sequence)