eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TASKFLOW_WORKFLOW dependencies on HR_NAVIGATION_NODES

Line 1468: from hr_navigation_nodes hnn

1464: --
1465: cursor l_csr_nav_node_id(c_nav_unit_id number, c_customized_restriction_id number) is
1466: select hnn.nav_node_id
1467: ,hnn.name
1468: from hr_navigation_nodes hnn
1469: where hnn.nav_unit_id = c_nav_unit_id
1470: and nvl(hnn.customized_restriction_id, hr_api.g_number) =
1471: nvl(c_customized_restriction_id, hr_api.g_number);
1472: --

Line 1478: l_navigation_node_name hr_navigation_nodes.name%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;
1481: l_root_nav_node_id hr_navigation_nodes.nav_node_id%type;
1482: l_proc varchar2(72) := g_package||'insert_navigation_nodes';

Line 1480: l_nav_node_id hr_navigation_nodes.nav_node_id%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;
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;

Line 1481: l_root_nav_node_id hr_navigation_nodes.nav_node_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;
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;

Line 1641: select hr_navigation_nodes_s.nextval

1637: if not l_found_nav_node then
1638: hr_utility.set_location(l_proc, 55);
1639: -- derive a new name
1640: begin
1641: select hr_navigation_nodes_s.nextval
1642: into l_nextval
1643: from sys.dual;
1644: exception
1645: when others then

Line 1654: insert into hr_navigation_nodes

1650: end;
1651: hr_utility.set_location(l_proc, 60);
1652: l_navigation_node_name := l_taskflow_actvity_name||l_nextval;
1653: -- the navigation node does not exist so we need to insert it
1654: insert into hr_navigation_nodes
1655: (nav_node_id,
1656: nav_unit_id,
1657: name,
1658: customized_restriction_id)