APPS.PON_FORMS_UTIL_PVT dependencies on PON_FORM_SECTION_COMPILED

Line 294: insert into pon_form_section_compiled

290: p_REPEATING_SECTION_ID = '||p_REPEATING_SECTION_ID||'
291: p_DISPLAY_ON_MAIN_PAGE = '||p_DISPLAY_ON_MAIN_PAGE||'
292: p_ENABLED = '||p_ENABLED);
293:
294: insert into pon_form_section_compiled
295: (FORM_SECTION_FIELD_ID,
296: FORM_ID,
297: TYPE,
298: FIELD_CODE,

Line 1309: from pon_form_section_compiled ff,

1305: f.datatype,
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

Line 1458: from pon_form_section_compiled ff,

1454: f.SYSTEM_FIELD_LOV_FLAG,
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,

Line 2716: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;

2712: x_is_repeating_section_flag VARCHAR2(1);
2713:
2714: x_form_section_field_id NUMBER;
2715:
2716: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;
2717:
2718: CURSOR c1_form_section_fields IS
2719: select
2720: ff.FORM_SECTION_FIELD_ID,

Line 2753: Delete pon_form_section_compiled

2749: g_text_sequence_number := 0;
2750:
2751: g_internal_sequence_number := 10;
2752:
2753: Delete pon_form_section_compiled
2754: where form_id = p_form_id;
2755: -- Inser a row for the form
2756: InsertCompiledRow( p_FORM_SECTION_FIELD_ID => null,
2757: p_form_id => p_form_id,

Line 2846: update pon_form_section_compiled

2842: INSERT_LEVEL1_SECTION_IN_FORM(p_form_id,form_section_compiled.SECTION_ID);
2843:
2844: if form_section_compiled.ENABLED = 'N' then
2845:
2846: update pon_form_section_compiled
2847: set enabled = 'N'
2848: where form_id = p_form_id
2849: and level1_section_id = form_section_compiled.SECTION_ID;
2850:

Line 2880: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;

2876:
2877: x_form_section_field_id NUMBER;
2878:
2879:
2880: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;
2881:
2882: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LEVEL1_SECTION_IN_FORM';
2883:
2884: CURSOR LEVEL1_SECTION_fields IS

Line 3015: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;

3011:
3012: x_form_section_field_id NUMBER;
3013:
3014:
3015: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;
3016:
3017: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LEVEL2_SECTION_IN_FORM';
3018:
3019: CURSOR inner_section_fields IS