The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
SELECT LANGUAGE_CODE
INTO V_BASE_LANGUAGE
FROM FND_LANGUAGES
WHERE NVL(INSTALLED_FLAG, 'X') = 'B';
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;
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;
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;
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;
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;
v_delete_field_element JDR_DOCBUILDER.ELEMENT;
v_delete_parameter JDR_DOCBUILDER.ELEMENT;
v_delete_parameters JDR_DOCBUILDER.ELEMENT;
JDR_DOCBUILDER.DELETEDOCUMENT (v_section_entry_path);
JDR_DOCBUILDER.DELETEDOCUMENT (v_section_read_path);
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;
JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
JDR_DOCBUILDER.setAttribute (v_temp_element, 'id', 'columnDelete' || v_section_code);
JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
-- add a delete image
v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', 'deleteImage' || v_section_code);
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
JDR_DOCBUILDER.addChild (v_temp_element, JDR_DOCBUILDER.UI_NS, 'contents', v_delete_field_element);
v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', '${oa.encrypt.' || v_view_name ||'.FormFieldValueId}');
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS, 'parameters', v_delete_parameter);
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_view_name);
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS, 'parameters', v_delete_parameter);
JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS, 'primaryClientAction', v_delete_parameters);
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;
JDR_DOCBUILDER.DELETEDOCUMENT (g_jrad_ext_page_path);
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;
v_delete_field_element JDR_DOCBUILDER.ELEMENT;
v_delete_parameter JDR_DOCBUILDER.ELEMENT;
v_delete_parameters JDR_DOCBUILDER.ELEMENT;
JDR_DOCBUILDER.DELETEDOCUMENT(v_data_entry_rgn_name);
JDR_DOCBUILDER.DELETEDOCUMENT(v_read_only_rgn_name);
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;
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;
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;
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;
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;
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;
JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
/** Adding the delete column **/
v_temp_element := JDR_DOCBUILDER.CREATEELEMENT (JDR_DOCBUILDER.OA_NS, 'column');
JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', v_jrad_element_id || '_DELIMG');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
v_delete_field_element);
v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value',
'${oa.encrypt.' || v_curr_formfieldvaluesvo_name || '.FormFieldValueId}');
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
'parameters', v_delete_parameter);
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_curr_formfieldvaluesvo_name);
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
'parameters', v_delete_parameter);
JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS,
'primaryClientAction', v_delete_parameters);
/** 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);
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;
JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
/** Adding the delete column **/
v_temp_element := JDR_DOCBUILDER.CREATEELEMENT (JDR_DOCBUILDER.OA_NS, 'column');
JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', v_jrad_element_id || '_DELIMG');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
v_delete_field_element);
v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value',
'${oa.encrypt.' || v_curr_formfieldvaluesvo_name || '.FormFieldValueId}');
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
'parameters', v_delete_parameter);
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_curr_formfieldvaluesvo_name);
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
'parameters', v_delete_parameter);
JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS,
'primaryClientAction', v_delete_parameters);
/** 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);
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;
JDR_DOCBUILDER.setAttribute (v_add_table_row_element, 'autoInsertion', 'false');
/** Adding the delete column **/
v_temp_element := JDR_DOCBUILDER.CREATEELEMENT (JDR_DOCBUILDER.OA_NS, 'column');
JDR_DOCBUILDER.setAttribute (v_column_header_element, 'prompt', 'Delete');
v_delete_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,'image');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'id', v_jrad_element_id || '_DELIMG');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'source', 'deleteicon_enabled.gif');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'warnAboutChanges', 'false');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'serverUnvalidated', 'true');
JDR_DOCBUILDER.setAttribute (v_delete_field_element, 'unvalidated', 'true');
JDR_DOCBUILDER.addChild (v_temp_element, JDR_DOCBUILDER.UI_NS, 'contents', v_delete_field_element);
v_delete_parameters := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'fireAction');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'event', 'Delete');
JDR_DOCBUILDER.setAttribute (v_delete_parameters, 'unvalidated', 'true');
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'Id');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value',
'${oa.encrypt.' || v_curr_formfieldvaluesvo_name || '.FormFieldValueId}');
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
'parameters', v_delete_parameter);
v_delete_parameter := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.UI_NS, 'parameter');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'key', 'ViewName');
JDR_DOCBUILDER.setAttribute (v_delete_parameter, 'value', v_curr_formfieldvaluesvo_name);
JDR_DOCBUILDER.addChild (v_delete_parameters, JDR_DOCBUILDER.UI_NS,
'parameters', v_delete_parameter);
JDR_DOCBUILDER.addChild (v_delete_field_element, JDR_DOCBUILDER.UI_NS,
'primaryClientAction', v_delete_parameters);
/** 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);
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;