APPS.HR_WORKFLOW_INSTALL_PKG dependencies on HR_NAVIGATION_NODES

Line 63: hr_navigation_nodes NN,

59: FROM hr_navigation_node_usages NNU,
60: hr_navigation_node_usages NNU2,
61: hr_workflows W,
62: hr_navigation_units NU,
63: hr_navigation_nodes NN,
64: hr_navigation_units NU2,
65: hr_navigation_nodes NN2,
66: hr_navigation_paths P,
67: hr_navigation_paths_tl PTL

Line 65: hr_navigation_nodes NN2,

61: hr_workflows W,
62: hr_navigation_units NU,
63: hr_navigation_nodes NN,
64: hr_navigation_units NU2,
65: hr_navigation_nodes NN2,
66: hr_navigation_paths P,
67: hr_navigation_paths_tl PTL
68: WHERE nn2.nav_node_id = nnu2.nav_node_id
69: AND nnu2.workflow_id = w.workflow_id

Line 363: from hr_navigation_nodes

359: end get_nav_unit_id;
360: procedure get_nav_node_id (p_name varchar2) is
361: cursor id is
362: select nav_node_id
363: from hr_navigation_nodes
364: where name = p_name;
365: begin
366: open id;
367: fetch id into current_nav_node_id;

Line 454: insert into hr_navigation_nodes (

450:
451: procedure new_nav_node (p_name varchar2,
452: p_customized_restriction_id number default null) is
453: begin
454: insert into hr_navigation_nodes (
455: nav_node_id,
456: nav_unit_id,
457: name,
458: customized_restriction_id)

Line 460: hr_navigation_nodes_s.nextval,

456: nav_unit_id,
457: name,
458: customized_restriction_id)
459: values (
460: hr_navigation_nodes_s.nextval,
461: current_nav_unit_id,
462: p_name,
463: p_customized_restriction_id);
464: get_nav_node_id (p_name);