The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT w.workflow_name AS workflow_name,
nu2.form_name AS from_form_name,
nn2.name AS from_node_name,
nu.form_name AS to_form_name,
nn.name AS to_node_name,
to_char(p.sequence) AS sequence,
ptl.override_label AS Button_label
FROM hr_navigation_node_usages NNU,
hr_navigation_node_usages NNU2,
hr_workflows W,
hr_navigation_units NU,
hr_navigation_nodes NN,
hr_navigation_units NU2,
hr_navigation_nodes NN2,
hr_navigation_paths P,
hr_navigation_paths_tl PTL
WHERE nn2.nav_node_id = nnu2.nav_node_id
AND nnu2.workflow_id = w.workflow_id
AND nn2.nav_unit_id = nu2.nav_unit_id
AND p.FROM_NAV_NODE_USAGE_ID = nnu2.nav_node_usage_id
AND p.TO_NAV_NODE_USAGE_ID = nnu.nav_node_usage_id
AND nn.nav_node_id = nnu.nav_node_id
AND nnu.workflow_id = w.workflow_id
AND nn.nav_unit_id = nu.nav_unit_id
AND p.nav_path_id = ptl.nav_path_id
AND ptl.language=userenv('LANG')
ORDER BY w.workflow_name, from_form_name, from_node_name, p.sequence;
select workflow_name
from hr_workflows
where workflow_id = p_workflow_id ;
select workflow_id
from hr_workflows
where workflow_name = p_workflow_name ;
select workflow_id
from hr_workflows
where workflow_name = p_workflow_name;
select nav_unit_id
from hr_navigation_units
where form_name = p_form_name
and nvl(block_name,'-9999')=nvl(p_block_name,'-9999');
select nav_node_id
from hr_navigation_nodes
where name = p_name;
select nav_node_usage_id
from hr_navigation_node_usages
where nav_node_id = current_nav_node_id
and workflow_id = current_workflow_id;
insert into hr_workflows (workflow_id, workflow_name)
values (hr_workflows_s.nextval, p_name);
insert into hr_navigation_units (
nav_unit_id,
application_abbrev,
default_label,
form_name,
max_number_of_nav_buttons,
block_name)
values (
hr_navigation_units_s.nextval,
p_application_abbrev,
p_default_label,
p_form_name,
p_max_no_of_buttons,
p_block_name);
select nav_unit_id
into l_nav_unit_id
from hr_navigation_units
where form_name = p_form_name
and nvl(block_name,'-9999')=nvl(p_block_name,'-9999');
select L.language_code
into l_current_language
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from HR_NAVIGATION_UNITS_TL T
where T.NAV_UNIT_ID = L_NAV_UNIT_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
insert into hr_navigation_units_tl (
nav_unit_id
,language
,source_lang
,default_label
)
select b.nav_unit_id
,l_current_language
,userenv('LANG')
,b.default_label
from hr_navigation_units b
where not exists
(select '1'
from hr_navigation_units_tl t
where t.nav_unit_id = b.nav_unit_id
and t.language = l_current_language);
insert into hr_navigation_nodes (
nav_node_id,
nav_unit_id,
name,
customized_restriction_id)
values (
hr_navigation_nodes_s.nextval,
current_nav_unit_id,
p_name,
p_customized_restriction_id);
insert into hr_navigation_node_usages (
nav_node_usage_id,
workflow_id,
nav_node_id,
top_node)
values (
hr_navigation_node_usages_s.nextval,
current_workflow_id,
current_nav_node_id,
p_top_node);
insert into hr_navigation_paths (
nav_path_id,
from_nav_node_usage_id,
to_nav_node_usage_id,
nav_button_required,
sequence,
override_label)
values (
hr_navigation_paths_s.nextval,
l_from,
l_to,
p_nav_button_required,
p_sequence,
p_override_label);
select nav_path_id
into l_nav_path_id
from hr_navigation_paths
where from_nav_node_usage_id = l_from
and to_nav_node_usage_id = l_to;
select L.language_code
into l_current_language
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from HR_NAVIGATION_PATHS_TL T
where T.NAV_PATH_ID = L_NAV_PATH_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
insert into hr_navigation_paths_tl (
nav_path_id
,language
,source_lang
,override_label
)
select b.nav_path_id
,l_current_language
,userenv('LANG')
,b.override_label
from hr_navigation_paths b
where not exists
(select '1'
from hr_navigation_paths_tl t
where t.nav_path_id = b.nav_path_id
and t.language = l_current_language);
select global_usage_id
from hr_nav_unit_global_usages
where global_name = p_global_name
and nav_unit_id = current_nav_unit_id;
insert into hr_nav_unit_global_usages (
global_usage_id,
nav_unit_id,
global_name,
in_or_out,
mandatory_flag)
values (
hr_nav_unit_global_usages_s.nextval,
current_nav_unit_id,
p_global_name,
p_in_or_out,
p_mandatory_flag);
insert into hr_navigation_context_rules (
nav_context_rule_id,
global_usage_id,
evaluation_type_code,
value)
values (
hr_navigation_context_rules_s.nextval,
current_global_usage_id,
p_evaluation_type_code,
p_value);