APPS.PON_FORMS_UTIL_PVT dependencies on PON_FORM_SECTION_COMPILED

Line 289: insert into pon_form_section_compiled

285: p_REPEATING_SECTION_ID = '||p_REPEATING_SECTION_ID||'
286: p_DISPLAY_ON_MAIN_PAGE = '||p_DISPLAY_ON_MAIN_PAGE||'
287: p_ENABLED = '||p_ENABLED);
288:
289: insert into pon_form_section_compiled
290: (FORM_SECTION_FIELD_ID,
291: FORM_ID,
292: TYPE,
293: FIELD_CODE,

Line 1252: from pon_form_section_compiled ff,

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

Line 1400: from pon_form_section_compiled ff,

1396: f.system_flag,
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,

Line 2652: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;

2648: x_is_repeating_section_flag VARCHAR2(1);
2649:
2650: x_form_section_field_id NUMBER;
2651:
2652: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;
2653:
2654: CURSOR c1_form_section_fields IS
2655: select
2656: ff.FORM_SECTION_FIELD_ID,

Line 2688: Delete pon_form_section_compiled

2684: g_text_sequence_number := 0;
2685:
2686: g_internal_sequence_number := 10;
2687:
2688: Delete pon_form_section_compiled
2689: where form_id = p_form_id;
2690: -- Inser a row for the form
2691: InsertCompiledRow( p_FORM_SECTION_FIELD_ID => null,
2692: p_form_id => p_form_id,

Line 2777: update pon_form_section_compiled

2773: INSERT_LEVEL1_SECTION_IN_FORM(p_form_id,form_section_compiled.SECTION_ID);
2774:
2775: if form_section_compiled.ENABLED = 'N' then
2776:
2777: update pon_form_section_compiled
2778: set enabled = 'N'
2779: where form_id = p_form_id
2780: and level1_section_id = form_section_compiled.SECTION_ID;
2781:

Line 2811: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;

2807:
2808: x_form_section_field_id NUMBER;
2809:
2810:
2811: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;
2812:
2813: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LEVEL1_SECTION_IN_FORM';
2814:
2815: CURSOR LEVEL1_SECTION_fields IS

Line 2942: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;

2938:
2939: x_form_section_field_id NUMBER;
2940:
2941:
2942: x_mapping_column PON_FORM_SECTION_COMPILED.MAPPING_FIELD_VALUE_COLUMN%TYPE;
2943:
2944: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LEVEL2_SECTION_IN_FORM';
2945:
2946: CURSOR inner_section_fields IS