The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name || ' - ' from ben_cwb_pl_dsgn
where pl_id = p_group_pl_id and pl_id = group_pl_id
and oipl_id = -1 and group_oipl_id = -1;
select a.application_short_name,
v.integrator_code,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
v.enabled_flag,
substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upl_param_list_asn,
v.upload_param_list_code upl_param_list_code,
substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_serv_param_list_app_id),1,30) upl_serv_param_list_asn,
v.upload_serv_param_list_code upl_serv_param_list_code,
substr(bne_lct_tools_pkg.app_id_to_asn(v.import_param_list_app_id),1,30) import_param_list_asn,
v.import_param_list_code,
v.date_format,
v.import_type,
v.uploader_class,
v.user_name,
v.upload_header,
v.upload_title_bar,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_param_list_asn,
v.create_doc_list_code create_doc_param_list_code,
v.new_session_flag,
v.layout_resolver_class,
v.layout_verifier_class,
v.session_config_class,
substr(bne_lct_tools_pkg.app_id_to_asn(v.session_param_list_app_id),1,30) session_param_list_asn,
v.session_param_list_code,
substr(bne_lct_tools_pkg.app_id_to_asn(s.application_id),1,30),
s.object_code,
s.object_type,
v.display_flag
from bne_integrators_vl v, bne_secured_objects s, fnd_application a
where v.application_id = a.application_id
and v.application_id = s.application_id (+)
and v.integrator_code = s.object_code (+)
and s.object_type (+) = 'INTEGRATOR'
and v.integrator_code = p_integrator_code
and a.application_short_name = 'PER'
and not exists (select null from bne_integrators_b b where b.integrator_code = l_new_integrator_code)
order by a.application_short_name, v.integrator_code;
select a.application_short_name,
v.interface_code,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
v.interface_name,
v.upload_type,
v.upload_obj_name,
substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upload_param_list_asn,
v.upload_param_list_code,
v.upload_order,
v.user_name,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
from bne_interfaces_vl v, fnd_application a
where v.application_id = a.application_id
and v.integrator_code = p_integrator_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.interface_code;
select v.sequence_num,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
v.interface_col_type,
v.interface_col_name,
v.enabled_flag,
v.required_flag,
v.display_flag,
v.read_only_flag,
v.not_null_flag,
v.summary_flag,
v.mapping_enabled_flag,
v.data_type,
v.field_size,
v.default_type,
v.default_value,
v.segment_number,
v.group_name,
v.oa_flex_code,
v.oa_concat_flex,
v.val_type,
v.val_id_col,
v.val_mean_col,
v.val_desc_col,
v.val_obj_name,
v.val_addl_w_c,
substr(bne_lct_tools_pkg.app_id_to_asn(v.val_component_app_id),1,30) val_component_asn,
v.val_component_code,
v.oa_flex_num,
v.oa_flex_application_id,
v.display_order,
v.upload_param_list_item_num,
v.expanded_sql_query,
v.user_hint,
v.prompt_left,
v.prompt_above,
v.user_help_text,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
v.lov_type,
v.offline_lov_enabled_flag,
v.variable_data_type_class,
v.viewer_group,
v.edit_type,
v.display_width,
substr(bne_lct_tools_pkg.app_id_to_asn(v.val_query_app_id),1,30) val_query_asn,
v.val_query_code,
substr(bne_lct_tools_pkg.app_id_to_asn(v.expanded_sql_query_app_id),1,30) expanded_sql_query_asn,
v.expanded_sql_query_code
from bne_interface_cols_vl v, fnd_application a
where v.application_id = a.application_id
and v.interface_code = v_interface_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.interface_code, v.sequence_num;
select a.application_short_name,
v.content_code,
v.object_version_number,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
substr(bne_lct_tools_pkg.app_id_to_asn(v.param_list_app_id),1,30) param_list_asn,
v.param_list_code,
v.content_class,
v.user_name,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
v.once_only_download_flag
from bne_contents_vl v, fnd_application a
where v.integrator_app_id = a.application_id
and v.integrator_code = p_integrator_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.content_code;
select v.sequence_num,
v.object_version_number,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.col_name,
v.user_name,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
v.read_only_flag
from bne_content_cols_vl v, fnd_application a
where v.application_id = a.application_id
and v.content_code = v_content_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.content_code, v.sequence_num;
select v.object_version_number,
v.query,
substr(bne_lct_tools_pkg.app_id_to_asn(v.query_app_id),1,30) bne_query_query_asn,
v.query_code,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
from bne_stored_sql v, fnd_application a
where v.application_id = a.application_id
and v.content_code = v_content_code
and a.application_short_name = 'PER';
select a.application_short_name,
v.mapping_code,
v.reporting_flag,
substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,
v.reporting_interface_code,
v.user_name,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
from bne_mappings_vl v, fnd_application a
where v.application_id = a.application_id
and v.integrator_code = p_integrator_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.mapping_code;
select v.sequence_num,
substr(bne_lct_tools_pkg.app_id_to_asn(v.interface_app_id),1,30) interface_asn,
v.interface_code,
v.interface_seq_num,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.decode_flag,
v.object_version_number,
substr(bne_lct_tools_pkg.app_id_to_asn(v.content_app_id),1,30) content_asn,
v.content_code,
v.content_seq_num,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
from bne_mapping_lines v, fnd_application a
where v.application_id = a.application_id
and v.mapping_code = v_mapping_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.mapping_code, v.sequence_num;
select a.application_short_name,
v.layout_code,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
substr(bne_lct_tools_pkg.app_id_to_asn(v.stylesheet_app_id),1,30) stylesheet_asn,
v.stylesheet_code,
v.style,
v.style_class,
v.reporting_flag,
substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,
v.reporting_interface_code,
v.user_name,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_list_asn,
v.create_doc_list_code
from bne_layouts_vl v, fnd_application a
where v.integrator_app_id = a.application_id
and v.integrator_code like p_integrator_code
and a.application_short_name like 'PER'
order by a.application_short_name, v.layout_code desc;
select v.block_id,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
v.parent_id,
v.layout_element,
v.style_class,
v.style,
v.row_style_class,
v.row_style,
v.col_style_class,
v.col_style,
v.prompt_displayed_flag,
v.prompt_style_class,
v.prompt_style,
v.hint_displayed_flag,
v.hint_style_class,
v.hint_style,
v.orientation,
v.layout_control,
v.display_flag,
v.blocksize,
v.minsize,
v.maxsize,
v.sequence_num,
v.prompt_colspan,
v.hint_colspan,
v.row_colspan,
v.summary_style_class,
v.summary_style,
v.user_name,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
v.title_style_class,
v.title_style,
v.prompt_above
from bne_layout_blocks_vl v, fnd_application a
where v.application_id = a.application_id
and v.layout_code = v_layout_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.layout_code, v.block_id;
select v.sequence_num,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
v.object_version_number,
substr(bne_lct_tools_pkg.app_id_to_asn(v.interface_app_id),1,30) interface_asn,
v.interface_code,
v.interface_seq_num,
v.style_class,
v.style,
v.prompt_style_class,
v.prompt_style,
v.hint_style_class,
v.hint_style,
v.default_value,
v.default_type,
v.display_width,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
v.read_only_flag
from bne_layout_cols v, fnd_application a
where v.application_id = a.application_id
and v.layout_code = v_layout_code
and a.application_short_name = 'PER'
and v.block_id = v_block_id
order by a.application_short_name, v.layout_code, v.block_id, v.sequence_num;
select a.application_short_name,
v.object_code,
v.object_type,
v.object_version_number,
substr(bne_lct_tools_pkg.app_id_to_asn(v.security_rule_app_id),1,30) rule_security_rule_asn,
v.security_rule_code rule_security_rule_code,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
v.security_rule_app_id
from bne_secured_objects v, fnd_application a
where v.application_id = a.application_id
and v.object_code = p_integrator_code
and v.object_type = 'INTEGRATOR'
and a.application_short_name = 'PER'
order by a.application_short_name, v.object_code, v.object_type;
select a.application_short_name,
v.security_code,
v.object_version_number,
v.security_type,
v.security_value,
substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
from bne_security_rules v, fnd_application a
where v.application_id = a.application_id
and v.security_code = v_security_rule_code
and a.application_short_name = 'PER'
order by a.application_short_name, v.security_code;
x_last_update_date => l_bne_integrator.last_update_date,
x_custom_mode => null ,
x_create_doc_list_asn => l_bne_integrator.create_doc_param_list_asn ,
x_create_doc_list_code => l_bne_integrator.create_doc_param_list_code ,
x_new_session_flag => l_bne_integrator.new_session_flag ,
x_layout_resolver_class => l_bne_integrator.layout_resolver_class ,
x_layout_verifier_class => l_bne_integrator.layout_verifier_class ,
x_session_config_class => l_bne_integrator.session_config_class ,
x_session_param_list_asn => l_bne_integrator.session_param_list_asn ,
x_session_param_list_code => l_bne_integrator.session_param_list_code ,
x_display_flag => l_bne_integrator.display_flag
);
x_last_update_date => l_bne_interface.last_update_date ,
x_custom_mode => null
);
x_last_update_date => l_bne_interface_col.last_update_date ,
x_lov_type => l_bne_interface_col.lov_type ,
x_offline_lov_enabled_flag => l_bne_interface_col.offline_lov_enabled_flag ,
x_custom_mode => null ,
x_variable_data_type_class => l_bne_interface_col.variable_data_type_class ,
x_viewer_group => l_bne_interface_col.viewer_group ,
x_edit_type => l_bne_interface_col.edit_type ,
x_display_width => l_bne_interface_col.display_width ,
x_val_query_asn => l_bne_interface_col.val_query_asn ,
x_val_query_code => l_bne_interface_col.val_query_code ,
x_expanded_sql_query_asn => l_bne_interface_col.expanded_sql_query_asn ,
x_expanded_sql_query_code => l_bne_interface_col.expanded_sql_query_code
);
x_last_update_date => l_bne_content.last_update_date ,
x_custom_mode => null ,
x_once_only_download_flag => l_bne_content.once_only_download_flag
);
x_last_update_date => l_bne_content_col.last_update_date ,
x_custom_mode => null ,
x_read_only_flag => l_bne_content_col.read_only_flag
);
x_last_update_date => l_bne_stored_sql.last_update_date ,
x_custom_mode => null ,
x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,
x_query_code => l_bne_stored_sql.query_code
);
x_last_update_date => l_bne_mapping.last_update_date ,
x_custom_mode => null
);
x_last_update_date => l_bne_mapping_line.last_update_date ,
x_custom_mode => null
);
x_last_update_date => l_bne_layout.last_update_date ,
x_custom_mode => null ,
x_create_doc_list_asn => l_bne_layout.create_doc_list_asn ,
x_create_doc_list_code => l_bne_layout.create_doc_list_code
);
x_last_update_date => l_bne_layout_block.last_update_date ,
x_custom_mode => null
);
x_last_update_date => l_bne_layout_col.last_update_date ,
x_custom_mode => null
);
x_last_update_date => l_bne_secured_object.last_update_date ,
x_custom_mode => null
);
x_last_update_date => l_bne_security_rule.last_update_date ,
x_custom_mode => null
);
update ben_cwb_pl_dsgn set custom_integrator = l_new_integrator_code
where pl_id = p_group_pl_id and pl_id = group_pl_id
and oipl_id = -1 and group_oipl_id = -1;