DBA Data[Home] [Help]

APPS.PON_FORMS_JRAD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 69

		select  decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
		into    v_ret_value
		from 	pon_fields,
			fnd_flex_value_sets
		where	pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
		and	pon_fields.value_set_name is not null
		and	pon_fields.field_code	  = p_field_code;
Line: 433

	SELECT 	LANGUAGE_CODE
	INTO 	V_BASE_LANGUAGE
	FROM	FND_LANGUAGES
	WHERE	NVL(INSTALLED_FLAG, 'X') = 'B';
Line: 570

		SELECT  fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
		INTO 	v_display_type, v_validation_type
		FROM	fnd_flex_value_sets
		WHERE 	fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
Line: 699

		SELECT  fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
		INTO 	v_display_type, v_validation_type
		FROM	fnd_flex_value_sets
		WHERE 	fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
Line: 817

SELECT	pon_form_section_compiled.FORM_ID,
	pon_form_section_compiled.TYPE,
	pon_form_section_compiled.FIELD_CODE,
	pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
	pon_form_section_compiled.REQUIRED,
	NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
	pon_forms_sections.FORM_CODE SECTION_CODE,
	pon_fields.DATATYPE ,
	pon_fields.VALUE_SET_NAME,
	pon_fields.SYSTEM_FLAG,
	pon_fields_tl.FIELD_NAME,
	pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
	pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
	NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
	NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
FROM	PON_FORM_SECTION_COMPILED,
	PON_FIELDS,
	PON_FIELDS_TL,
	PON_FORMS_SECTIONS
WHERE   pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
AND     pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
AND	pon_forms_sections.FORM_ID	     = P_FORM_ID
AND     pon_form_section_compiled.FORM_ID    = P_FORM_ID
AND	pon_form_section_compiled.TYPE	     IN ('FORM_FIELD', 'REPEAT_SECTION')
AND	pon_fields_tl.LANGUAGE(+)	     = g_base_language
ORDER BY
	INTERNAL_SEQUENCE_NUMBER;
Line: 882

		select  LEVEL1_SECTION_ID , LEVEL2_SECTION_ID, type
		into	v_LEVEL1_SECTION_ID, v_incl_section_id, v_parent_row_type
		from	pon_form_section_compiled
		where	form_id = p_form_id
		and	repeating_section_id = section_id
		and 	internal_sequence_number = p_row_seq_num;
Line: 949

			  SELECT
			  	  forms_tl.form_name , forms.form_code
			  INTO
				  v_section_title, v_section_code
			  FROM
				  pon_forms_sections 	forms,
				  pon_forms_sections_tl forms_tl
			  WHERE
				  forms.form_id 	= forms_tl.form_id AND
				  forms.form_id		= v_form_fields_row.section_id AND
				  forms_tl.LANGUAGE	= g_base_language;
Line: 1262

v_delete_field_element 		JDR_DOCBUILDER.ELEMENT;
Line: 1263

v_delete_parameter 		JDR_DOCBUILDER.ELEMENT;
Line: 1264

v_delete_parameters 		JDR_DOCBUILDER.ELEMENT;
Line: 1296

		  JDR_DOCBUILDER.DELETEDOCUMENT (v_section_entry_path);
Line: 1301

		  JDR_DOCBUILDER.DELETEDOCUMENT (v_section_read_path);
Line: 1320

	SELECT
		forms_tl.form_name, forms.form_code, forms_tl.tip_text
	INTO 	v_section_title, v_section_code, v_section_desc
	FROM
		pon_forms_sections forms,
		pon_forms_sections_tl forms_tl
	WHERE
		forms.form_id		= forms_tl.form_id AND
		forms.form_id		= p_section_id AND
		forms_tl.LANGUAGE	= g_base_language;
Line: 1354

	JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
Line: 1361

	JDR_DOCBUILDER.setAttribute (v_temp_element, 'id', 'columnDelete' || v_section_code);
Line: 1367

	JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
Line: 1370

	-- add a delete image
	v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
Line: 1372

	JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', 'deleteImage' || v_section_code);
Line: 1373

	JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
Line: 1374

	JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
Line: 1375

	JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
Line: 1376

	JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
Line: 1378

	JDR_DOCBUILDER.addChild (v_temp_element, JDR_DOCBUILDER.UI_NS, 'contents', v_delete_field_element);
Line: 1380

	v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
Line: 1381

	JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
Line: 1382

	JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
Line: 1383

	v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 1384

	JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
Line: 1385

	JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', '${oa.encrypt.' || v_view_name ||'.FormFieldValueId}');
Line: 1386

	JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS, 'parameters', v_delete_parameter);
Line: 1387

	v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 1388

	JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
Line: 1389

	JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_view_name);
Line: 1390

	JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS, 'parameters', v_delete_parameter);
Line: 1391

	JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS, 'primaryClientAction', v_delete_parameters);
Line: 1462

select 	pon_fields.field_code,
	pon_form_section_compiled.mapping_field_value_column,
	pon_fields.datatype,
	pon_fields.value_set_name,
	pon_fields.system_flag,
	pon_fields.system_field_lov_flag,
	pon_fields_tl.field_name,
	pon_fields_tl.description field_description,
	pon_forms_sections.form_id,
	pon_forms_sections.form_code,
	pon_forms_sections_tl.form_name,
	pon_forms_sections_tl.form_description,
	pon_form_section_compiled.display_on_main_page,
	pon_form_section_compiled.internal_sequence_number
from 	pon_fields,
	pon_fields_tl,
	pon_forms_sections,
	pon_forms_sections_tl,
	pon_form_section_compiled
where
	pon_forms_sections.FORM_CODE = 'ABSTRACT'
and	pon_forms_sections.STATUS   = 'ACTIVE'
and	pon_forms_sections.FORM_ID  = pon_form_section_compiled.FORM_ID
and	pon_forms_sections.FORM_ID  = pon_forms_sections_tl.FORM_ID
and	pon_form_section_compiled.TYPE 	= 'FORM_FIELD'
and	pon_form_section_compiled.FIELD_CODE is not null
and	pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
and	pon_fields.FIELD_CODE 		= pon_fields_tl.FIELD_CODE
and 	pon_fields_tl.LANGUAGE 		= g_base_language
and	pon_forms_sections_tl.LANGUAGE	= g_base_language
and	nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'
order by
	internal_sequence_number;
Line: 1517

		  JDR_DOCBUILDER.DELETEDOCUMENT (g_jrad_ext_page_path);
Line: 1669

SELECT	pon_form_section_compiled.FORM_ID,
	pon_form_section_compiled.TYPE,
	pon_form_section_compiled.FIELD_CODE,
	pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
	pon_form_section_compiled.REQUIRED,
	NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
	pon_forms_sections.FORM_CODE SECTION_CODE,
	pon_fields.DATATYPE,
	pon_fields.SYSTEM_FLAG,
	pon_fields.VALUE_SET_NAME,
	pon_fields_tl.FIELD_NAME,
	pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
	pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
	NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
	NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID,
  pon_form_section_compiled.EDITABLE
FROM	PON_FORM_SECTION_COMPILED,
	PON_FIELDS,
	PON_FIELDS_TL,
	PON_FORMS_SECTIONS
WHERE   pon_form_section_compiled.FIELD_CODE 		= pon_fields.FIELD_CODE(+)
AND     pon_form_section_compiled.FIELD_CODE 		= pon_fields_tl.FIELD_CODE(+)
AND	pon_forms_sections.FORM_ID	     		= pon_form_section_compiled.FORM_ID
AND     pon_form_section_compiled.FORM_ID    		= P_FORM_ID
AND	NVL(pon_form_section_compiled.ENABLED, 'Y') 	= 'Y'
AND	pon_fields_tl.LANGUAGE(+)	     		= g_base_language
ORDER BY
	INTERNAL_SEQUENCE_NUMBER;
Line: 1725

v_delete_field_element 		JDR_DOCBUILDER.ELEMENT;
Line: 1726

v_delete_parameter 		JDR_DOCBUILDER.ELEMENT;
Line: 1727

v_delete_parameters 		JDR_DOCBUILDER.ELEMENT;
Line: 1780

		JDR_DOCBUILDER.DELETEDOCUMENT(v_data_entry_rgn_name);
Line: 1784

		JDR_DOCBUILDER.DELETEDOCUMENT(v_read_only_rgn_name);
Line: 1837

			SELECT
				forms_tl.form_name, forms.form_code
			INTO
				v_section_title, v_section_code
			FROM
				pon_forms_sections forms,
				pon_forms_sections_tl forms_tl
			WHERE
				forms.form_id		= forms_tl.form_id AND
				forms.form_id		= v_current_section_id AND
				forms_tl.LANGUAGE	= g_base_language;
Line: 1960

			SELECT
				forms_tl.form_name, forms.form_code, forms_tl.tip_text
			INTO
				v_section_title, v_section_code, v_section_desc
			FROM
				pon_forms_sections forms,
				pon_forms_sections_tl forms_tl
			WHERE
				forms.form_id		= forms_tl.form_id AND
				forms.form_id		= v_current_section_id AND
				forms_tl.LANGUAGE	= g_base_language;
Line: 2067

                                SELECT
                                        forms_tl.form_name, forms.form_code, forms_tl.tip_text
                                INTO
                                        v_section_title, v_section_code, v_section_desc
                                FROM
                                        pon_forms_sections forms,
                                        pon_forms_sections_tl forms_tl
                                WHERE
                                        forms.form_id           = forms_tl.form_id AND
                                        forms.form_id           = v_current_section_id AND
                                        forms_tl.LANGUAGE       = g_base_language;
Line: 2136

			SELECT
				forms_tl.form_name, forms.form_code, forms_tl.tip_text
			INTO
				v_section_title, v_section_code, v_section_desc
			FROM
				pon_forms_sections forms,
				pon_forms_sections_tl forms_tl
			WHERE
					forms.form_id		= forms_tl.form_id AND
					forms.form_id		= v_current_section_id AND
					forms_tl.LANGUAGE	= g_base_language;
Line: 2235

                                SELECT
                                        forms_tl.form_name, forms.form_code, forms_tl.tip_text
                                INTO
                                        v_section_title, v_section_code, v_section_desc
                                FROM
                                        pon_forms_sections forms,
                                        pon_forms_sections_tl forms_tl
                                WHERE
                                        forms.form_id           = forms_tl.form_id AND
                                        forms.form_id           = v_current_section_id AND
                                        forms_tl.LANGUAGE       = g_base_language;
Line: 2303

			SELECT
				forms_tl.form_name, forms.form_code
			INTO
				v_section_title, v_section_code
			FROM
				pon_forms_sections forms,
				pon_forms_sections_tl forms_tl
			WHERE
				forms.form_id		= forms_tl.form_id AND
				forms.form_id		= v_current_section_id AND
				forms_tl.LANGUAGE	= g_base_language;
Line: 2352

			JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
Line: 2374

			/** Adding the delete column **/
			v_temp_element := JDR_DOCBUILDER.CREATEELEMENT (JDR_DOCBUILDER.OA_NS, 'column');
Line: 2384

			JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
Line: 2388

			v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
Line: 2389

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', v_jrad_element_id ||   '_DELIMG');
Line: 2390

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
Line: 2391

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
Line: 2392

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
Line: 2393

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
Line: 2395

						 v_delete_field_element);
Line: 2397

			v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
Line: 2398

			JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
Line: 2399

			JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
Line: 2400

			v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 2401

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
Line: 2403

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value',
					'${oa.encrypt.' || v_curr_formfieldvaluesvo_name ||  '.FormFieldValueId}');
Line: 2406

			JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
							'parameters', v_delete_parameter);
Line: 2409

			v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 2411

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
Line: 2413

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_curr_formfieldvaluesvo_name);
Line: 2414

			JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
							'parameters', v_delete_parameter);
Line: 2417

			JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS,
							'primaryClientAction', v_delete_parameters);
Line: 2420

				/** Done: Adding delete colmn */

			-- add the table into the header region
			JDR_DOCBUILDER.addChild (v_section_element, jdr_docbuilder.UI_NS,'contents',
						v_section_layout_element);
Line: 2490

				SELECT
					forms_tl.form_name, forms.form_code
				INTO
					v_section_title, v_section_code
				FROM
					pon_forms_sections forms,
					pon_forms_sections_tl forms_tl
				WHERE
					forms.form_id		= forms_tl.form_id AND
					forms.form_id		= v_current_section_id AND
					forms_tl.LANGUAGE	= g_base_language;
Line: 2545

				JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
Line: 2566

				/** Adding the delete column **/
				v_temp_element := JDR_DOCBUILDER.CREATEELEMENT (JDR_DOCBUILDER.OA_NS, 'column');
Line: 2575

				JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
Line: 2579

				v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
Line: 2580

				JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', v_jrad_element_id || '_DELIMG');
Line: 2581

				JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
Line: 2582

				JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
Line: 2583

				JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
Line: 2584

				JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
Line: 2589

						   	 v_delete_field_element);
Line: 2591

				v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
Line: 2592

				JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
Line: 2593

				JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
Line: 2594

				v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 2595

				JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
Line: 2597

				JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value',
					'${oa.encrypt.' || v_curr_formfieldvaluesvo_name ||  '.FormFieldValueId}');
Line: 2600

				JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
							'parameters', v_delete_parameter);
Line: 2603

				v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 2605

				JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
Line: 2607

				JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_curr_formfieldvaluesvo_name);
Line: 2608

				JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
							'parameters', v_delete_parameter);
Line: 2611

				JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS,
							'primaryClientAction', v_delete_parameters);
Line: 2614

				/** Done: Adding delete colmn */

				-- add the table into the header region
				JDR_DOCBUILDER.addChild (v_section_element, jdr_docbuilder.UI_NS,'contents',
							v_section_layout_element);
Line: 2680

			SELECT
				forms_tl.form_name, forms.form_code
			INTO
				v_section_title, v_section_code
			FROM
				pon_forms_sections forms,
				pon_forms_sections_tl forms_tl
			WHERE
				forms.form_id		= forms_tl.form_id AND
				forms.form_id		= v_current_section_id AND
				forms_tl.LANGUAGE	= g_base_language;
Line: 2731

			JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
Line: 2750

			/** Adding the delete column **/
			v_temp_element := JDR_DOCBUILDER.CREATEELEMENT (JDR_DOCBUILDER.OA_NS, 'column');
Line: 2760

			JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
Line: 2764

			v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
Line: 2765

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', v_jrad_element_id ||  '_DELIMG');
Line: 2766

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
Line: 2767

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
Line: 2768

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
Line: 2769

			JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
Line: 2770

			JDR_DOCBUILDER.addChild (v_temp_element, JDR_DOCBUILDER.UI_NS, 'contents', v_delete_field_element);
Line: 2772

			v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
Line: 2773

			JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
Line: 2774

			JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
Line: 2775

			v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 2776

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
Line: 2778

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value',
					'${oa.encrypt.' || v_curr_formfieldvaluesvo_name ||  '.FormFieldValueId}');
Line: 2781

			JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
							'parameters', v_delete_parameter);
Line: 2784

			v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
Line: 2786

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
Line: 2788

			JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_curr_formfieldvaluesvo_name);
Line: 2789

			JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
						'parameters', v_delete_parameter);
Line: 2792

			JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS,
						'primaryClientAction', v_delete_parameters);
Line: 2795

			/** Done: Adding delete colmn */

			-- add the table into the header region
			JDR_DOCBUILDER.addChild (v_section_element, jdr_docbuilder.UI_NS,'contents',
						v_section_layout_element);
Line: 3167

	select
    type,
    nvl(is_repeating_section_flag,'N')
  into
    v_form_type,
    v_is_repeating_section_flag
  from pon_forms_sections where form_id = p_form_id;