APPS.HR_TASKFLOW_WORKFLOW dependencies on HR_NAVIGATION_UNITS

Line 10: ,sqlform hr_navigation_units.form_name%type

6: g_process_activity_rec wf_process_activities%rowtype;
7: type g_usage_rec is record
8: (nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type
9: ,instance_id wf_process_activities.instance_id%type
10: ,sqlform hr_navigation_units.form_name%type
11: ,override_label hr_navigation_paths.override_label%type);
12: type g_wf_transition_rec is record
13: (to_process_activity wf_activity_transitions.to_process_activity%type
14: ,result_code wf_activity_transitions.result_code%type);

Line 170: l_sqlform hr_navigation_units.form_name%type := null;

166: -- --------------------------------------------------------------------------
167: -- |-------------------------------< get_sqlform >-------------------------|
168: -- --------------------------------------------------------------------------
169: function get_sqlform(p_instance_id in number) return varchar2 is
170: l_sqlform hr_navigation_units.form_name%type := null;
171: l_proc varchar2(72) := g_package||'get_sqlform';
172: begin
173: hr_utility.set_location('Entering:'||l_proc, 10);
174: for i in g_node_usage_tab.first..g_node_usage_tab.last loop

Line 769: l_sqlform hr_navigation_units.form_name%type;

765: or waav.text_value = g_parent_transition);
766: --
767: l_nav_button_required hr_navigation_paths.nav_button_required%type := 'N';
768: l_name wf_activity_attr_values.name%type;
769: l_sqlform hr_navigation_units.form_name%type;
770: l_parent boolean := false;
771: l_index binary_integer;
772: --
773: begin

Line 1444: from hr_navigation_units hnu,

1440: --
1441: cursor l_csr_nav_unit_id(c_form_name varchar2, c_block_name varchar2) is
1442: select hnu.nav_unit_id
1443: ,hnul.default_label
1444: from hr_navigation_units hnu,
1445: hr_navigation_units_tl hnul
1446: where hnu.form_name = c_form_name
1447: and nvl(hnu.block_name, hr_api.g_varchar2) = nvl(c_block_name, hr_api.g_varchar2)
1448: and hnu.nav_unit_id = hnul.nav_unit_id

Line 1445: hr_navigation_units_tl hnul

1441: cursor l_csr_nav_unit_id(c_form_name varchar2, c_block_name varchar2) is
1442: select hnu.nav_unit_id
1443: ,hnul.default_label
1444: from hr_navigation_units hnu,
1445: hr_navigation_units_tl hnul
1446: where hnu.form_name = c_form_name
1447: and nvl(hnu.block_name, hr_api.g_varchar2) = nvl(c_block_name, hr_api.g_varchar2)
1448: and hnu.nav_unit_id = hnul.nav_unit_id
1449: and hnul.language=userenv('LANG');

Line 1476: l_nav_unit_id hr_navigation_units.nav_unit_id%type;

1472: --
1473: l_taskflow_actvity_name wf_activity_attr_values.text_value%type;
1474: l_customization_name wf_activity_attr_values.text_value%type;
1475: l_taskflow_block_name wf_activity_attr_values.text_value%type;
1476: l_nav_unit_id hr_navigation_units.nav_unit_id%type;
1477: l_customized_restriction_id pay_customized_restrictions.customized_restriction_id%type;
1478: l_navigation_node_name hr_navigation_nodes.name%type;
1479: l_nextval number;
1480: l_nav_node_id hr_navigation_nodes.nav_node_id%type;

Line 1484: l_default_label hr_navigation_units.default_label%type;

1480: l_nav_node_id hr_navigation_nodes.nav_node_id%type;
1481: l_root_nav_node_id hr_navigation_nodes.nav_node_id%type;
1482: l_proc varchar2(72) := g_package||'insert_navigation_nodes';
1483: l_override_label hr_navigation_paths.override_label%type;
1484: l_default_label hr_navigation_units.default_label%type;
1485: l_found_nav_node boolean;
1486: --
1487: type l_process_stack_tab is table of
1488: wf_process_activities.instance_id%type

Line 1574: -- ensure that a corresponding row exists within the HR_NAVIGATION_UNITS

1570: l_customization_name := l_csr_attrs.text_value;
1571: end if;
1572: end loop;
1573: hr_utility.set_location(l_proc, 40);
1574: -- ensure that a corresponding row exists within the HR_NAVIGATION_UNITS
1575: -- table.
1576: open l_csr_nav_unit_id(l_taskflow_actvity_name, l_taskflow_block_name);
1577: fetch l_csr_nav_unit_id into l_nav_unit_id, l_default_label;
1578: if l_csr_nav_unit_id%notfound then