APPS.HR_WORKFLOW_INSTALL_PKG SQL Statements

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

Line: 52

  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;

Line: 304

  select workflow_name
  from   hr_workflows
  where  workflow_id = p_workflow_id ;

Line: 319

  select workflow_id
  from   hr_workflows
  where  workflow_name = p_workflow_name ;

Line: 333

		select	workflow_id
		from	hr_workflows
		where	workflow_name = p_workflow_name;

Line: 351

		select	nav_unit_id
		from	hr_navigation_units
		where	form_name = p_form_name
			and nvl(block_name,'-9999')=nvl(p_block_name,'-9999');

Line: 362

		select	nav_node_id
		from	hr_navigation_nodes
		where	name = p_name;

Line: 372

		select	nav_node_usage_id
		from	hr_navigation_node_usages
		where	nav_node_id = current_nav_node_id
		and	workflow_id = current_workflow_id;

Line: 385

	   insert into hr_workflows (workflow_id, workflow_name)
	   values (hr_workflows_s.nextval,	 p_name);

Line: 400

       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);

Line: 417

 		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');

Line: 423

     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);

Line: 433

   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);

Line: 454

	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);

Line: 469

	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);

Line: 503

	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);

Line: 518

  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;

Line: 524

    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);

Line: 534

    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);

Line: 555

		select	global_usage_id
		from hr_nav_unit_global_usages
		where	global_name = p_global_name
		and	nav_unit_id = current_nav_unit_id;

Line: 569

	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);

Line: 587

	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);