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 1253: pon_forms_sections rs,

1249: f.value_set_name,
1250: valset.flex_value_set_id value_set_id,
1251: valset.VALIDATION_TYPE
1252: from pon_form_section_compiled ff,
1253: pon_forms_sections rs,
1254: pon_fields f,
1255: fnd_flex_value_sets valset
1256: where ff.form_id = p_section_id
1257: and rs.form_id(+) = ff.repeating_section_id

Line 1401: PON_FORMS_SECTIONS ts,

1397: f.SYSTEM_FIELD_LOV_FLAG,
1398: valset.flex_value_set_id value_set_id,
1399: valset.VALIDATION_TYPE
1400: from pon_form_section_compiled ff,
1401: PON_FORMS_SECTIONS ts,
1402: PON_FORMS_SECTIONS isec,
1403: PON_FORMS_SECTIONS rs,
1404: pon_fields f,
1405: fnd_flex_value_sets valset

Line 1402: PON_FORMS_SECTIONS isec,

1398: valset.flex_value_set_id value_set_id,
1399: valset.VALIDATION_TYPE
1400: from pon_form_section_compiled ff,
1401: PON_FORMS_SECTIONS ts,
1402: PON_FORMS_SECTIONS isec,
1403: PON_FORMS_SECTIONS rs,
1404: pon_fields f,
1405: fnd_flex_value_sets valset
1406: where ts.form_id(+) = ff.LEVEL1_SECTION_ID

Line 1403: PON_FORMS_SECTIONS rs,

1399: valset.VALIDATION_TYPE
1400: from pon_form_section_compiled ff,
1401: PON_FORMS_SECTIONS ts,
1402: PON_FORMS_SECTIONS isec,
1403: PON_FORMS_SECTIONS rs,
1404: pon_fields f,
1405: fnd_flex_value_sets valset
1406: where ts.form_id(+) = ff.LEVEL1_SECTION_ID
1407: and isec.form_id(+) = ff.LEVEL2_SECTION_ID

Line 1459: from PON_FORMS_SECTIONS

1455: g_alias_counter := g_alias_counter + 1;
1456:
1457: select form_code
1458: into l_form_code
1459: from PON_FORMS_SECTIONS
1460: where form_id = p_form_id;
1461:
1462: print_debug_log(l_api_name, 'l_form_code = '||l_form_code||' g_alias_counter = '||g_alias_counter);
1463:

Line 1707: from pon_forms_sections

1703: SAVEPOINT PON_XMLSCHEMA;
1704: g_mode := 'SCHEMA';
1705: select form_code
1706: into l_form_code
1707: from pon_forms_sections
1708: where form_id = p_form_id;
1709:
1710: print_debug_log(l_api_name, 'g_mode = '||g_mode||' l_form_code = '||l_form_code);
1711:

Line 1823: from pon_forms_sections

1819: form_code
1820: into
1821: p_xdo_stylesheet_code,
1822: l_form_code
1823: from pon_forms_sections
1824: where form_id = p_form_id;
1825:
1826:
1827: GENERATE_XMLQUERY(p_form_id,

Line 2737: pon_forms_sections

2733: nvl(is_repeating_section_flag,'N')
2734: into
2735: x_is_repeating_section_flag
2736: from
2737: pon_forms_sections
2738: where
2739: FORM_ID = x_section_id;
2740:
2741: if x_is_repeating_section_flag = 'Y' then

Line 2873: pon_forms_sections

2869: nvl(is_repeating_section_flag,'N')
2870: into
2871: x_is_repeating_section_flag
2872: from
2873: pon_forms_sections
2874: where
2875: FORM_ID = x_section_id;
2876:
2877: if x_is_repeating_section_flag = 'Y' then

Line 3043: PON_FORMS_SECTIONS FS

3039: SELECT
3040: DISTINCT FS.FORM_ID SECTION_ID
3041: FROM
3042: PON_FORM_SECTION_FIELDS FSF,
3043: PON_FORMS_SECTIONS FS
3044: WHERE
3045: FSF.SECTION_ID = FS.FORM_ID
3046: AND
3047: FS.IS_REPEATING_SECTION_FLAG = 'Y'

Line 3058: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;

3054: CONNECT
3055: BY PRIOR FSF.SECTION_ID = FSF.FORM_ID;
3056:
3057: v_repeating_section_id v_repeating_section_id_cursor%ROWTYPE;
3058: v_section_id PON_FORMS_SECTIONS.FORM_ID%TYPE;
3059: x_error_message VARCHAR2(100);
3060: x_error_code VARCHAR2(100);
3061: x_result VARCHAR2(100);
3062: v_read_only_region_name VARCHAR2(100);

Line 3101: UPDATE PON_FORMS_SECTIONS

3097: -- if the form/abstract/section is active
3098: v_read_only_region_name := getReadOnlyRegionName (v_section_id);
3099: v_edit_region_name := getDataEntryRegionName (v_section_id);
3100:
3101: UPDATE PON_FORMS_SECTIONS
3102: SET
3103: JRAD_XML_REGION_NAME_DISP = v_read_only_region_name,
3104: JRAD_XML_REGION_NAME = v_edit_region_name
3105: WHERE

Line 3144: x_query_stmt PON_FORMS_SECTIONS.XML_QUERY%TYPE;

3140: x_form_version NUMBER;
3141: x_type VARCHAR2(30);
3142: x_data_entry_region_name VARCHAR2(100);
3143: x_read_only_region_name_disp VARCHAR2(100);
3144: x_query_stmt PON_FORMS_SECTIONS.XML_QUERY%TYPE;
3145: x_error_message VARCHAR2(100);
3146: x_error_code VARCHAR2(100);
3147: x_result VARCHAR2(100);
3148: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_FORM_DETAILS';

Line 3173: pon_forms_sections

3169: x_type,
3170: x_data_entry_region_name,
3171: x_read_only_region_name_disp
3172: from
3173: pon_forms_sections
3174: where
3175: FORM_ID = p_form_id;
3176:
3177: -- generate inner repeating sections

Line 3210: pon_forms_sections

3206: return;
3207: end if;
3208:
3209: update
3210: pon_forms_sections
3211: set
3212: xml_query = x_query_stmt
3213: where
3214: form_id = p_form_id;

Line 3244: UPDATE pon_forms_sections

3240: -- if the form/abstract/section is active
3241: x_data_entry_region_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
3242: x_read_only_region_name_disp := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
3243:
3244: UPDATE pon_forms_sections
3245: SET
3246: jrad_xml_region_name = x_data_entry_region_name,
3247: jrad_xml_region_name_disp = x_read_only_region_name_disp
3248: WHERE form_id = p_form_id

Line 3318: from pon_forms_sections

3314: where auction_header_id = p_auction_header_id;
3315:
3316: select form_id
3317: into l_form_id
3318: from pon_forms_sections
3319: where form_code = 'ABSTRACT'
3320: and type = 'ABSTRACT';
3321:
3322: update pon_forms_instances

Line 3362: l_form_type PON_FORMS_SECTIONS.FORM_CODE%TYPE;

3358: x_error_code OUT NOCOPY VARCHAR2,
3359: x_error_message OUT NOCOPY VARCHAR2) IS
3360:
3361: l_api_name CONSTANT VARCHAR2(30) := 'PERFORMPOSTSAVECHANGES';
3362: l_form_type PON_FORMS_SECTIONS.FORM_CODE%TYPE;
3363: l_old_status PON_FORMS_INSTANCES.STATUS%TYPE;
3364:
3365: BEGIN
3366:

Line 3373: from pon_forms_sections

3369: p_entity_code = '||p_entity_code);
3370:
3371: select type
3372: into l_form_type
3373: from pon_forms_sections
3374: where form_id = p_form_id;
3375:
3376: if(l_form_type = 'FORM') then
3377: