APPS.HR_WORKFLOW_INSTALL_PKG dependencies on HR_NAVIGATION_PATHS

Line 66: hr_navigation_paths P,

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
70: AND nn2.nav_unit_id = nu2.nav_unit_id

Line 67: hr_navigation_paths_tl PTL

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
70: AND nn2.nav_unit_id = nu2.nav_unit_id
71: AND p.FROM_NAV_NODE_USAGE_ID = nnu2.nav_node_usage_id

Line 503: insert into hr_navigation_paths (

499: get_node_usage_id;
500: l_to := current_nav_node_usage_id;
501: current_nav_node_usage_id := l_current_nav_node_usage_id;
502:
503: insert into hr_navigation_paths (
504: nav_path_id,
505: from_nav_node_usage_id,
506: to_nav_node_usage_id,
507: nav_button_required,

Line 511: hr_navigation_paths_s.nextval,

507: nav_button_required,
508: sequence,
509: override_label)
510: values (
511: hr_navigation_paths_s.nextval,
512: l_from,
513: l_to,
514: p_nav_button_required,
515: p_sequence,

Line 520: from hr_navigation_paths

516: p_override_label);
517:
518: select nav_path_id
519: into l_nav_path_id
520: from hr_navigation_paths
521: where from_nav_node_usage_id = l_from
522: and to_nav_node_usage_id = l_to;
523:
524: select L.language_code

Line 530: from HR_NAVIGATION_PATHS_TL T

526: from FND_LANGUAGES L
527: where L.INSTALLED_FLAG in ('I', 'B')
528: and not exists
529: (select NULL
530: from HR_NAVIGATION_PATHS_TL T
531: where T.NAV_PATH_ID = L_NAV_PATH_ID
532: and T.LANGUAGE = L.LANGUAGE_CODE);
533:
534: insert into hr_navigation_paths_tl (

Line 534: insert into hr_navigation_paths_tl (

530: from HR_NAVIGATION_PATHS_TL T
531: where T.NAV_PATH_ID = L_NAV_PATH_ID
532: and T.LANGUAGE = L.LANGUAGE_CODE);
533:
534: insert into hr_navigation_paths_tl (
535: nav_path_id
536: ,language
537: ,source_lang
538: ,override_label

Line 544: from hr_navigation_paths b

540: select b.nav_path_id
541: ,l_current_language
542: ,userenv('LANG')
543: ,b.override_label
544: from hr_navigation_paths b
545: where not exists
546: (select '1'
547: from hr_navigation_paths_tl t
548: where t.nav_path_id = b.nav_path_id

Line 547: from hr_navigation_paths_tl t

543: ,b.override_label
544: from hr_navigation_paths b
545: where not exists
546: (select '1'
547: from hr_navigation_paths_tl t
548: where t.nav_path_id = b.nav_path_id
549: and t.language = l_current_language);
550:
551: end new_path;