APPS.HR_WORKFLOWS_PKG dependencies on HR_NAVIGATION_PATHS

Line 14: FROM hr_navigation_paths

10: FROM hr_navigation_node_usages
11: WHERE workflow_id = x_workflow_id;
12: CURSOR csr_nav_paths IS
13: SELECT nav_path_id
14: FROM hr_navigation_paths
15: WHERE from_nav_node_usage_id = l_nav_node_usage_id
16: OR to_nav_node_usage_id = l_nav_node_usage_id;
17: BEGIN
18: --

Line 29: DELETE FROM hr_navigation_paths_tl

25: --
26: FOR nav_path_record IN csr_nav_paths LOOP
27: l_nav_path_id := nav_path_record.nav_path_id;
28:
29: DELETE FROM hr_navigation_paths_tl
30: WHERE nav_path_id = l_nav_path_id;
31:
32: --
33: -- Added the following code as a part of Zero Downtime Patching Project.

Line 38: p_entity_name => 'HR_NAVIGATION_PATHS',

34: -- Code Starts Here.
35: --
36: BEGIN
37: per_ric_pkg.Chk_integrity (
38: p_entity_name => 'HR_NAVIGATION_PATHS',
39: p_ref_entity => 'HR_NAVIGATION_PATHS_TL',
40: p_ref_column_name => 'NAV_PATH_ID',
41: p_ref_col_value_number => l_nav_path_id,
42: p_ref_col_value_varchar => NULL,

Line 39: p_ref_entity => 'HR_NAVIGATION_PATHS_TL',

35: --
36: BEGIN
37: per_ric_pkg.Chk_integrity (
38: p_entity_name => 'HR_NAVIGATION_PATHS',
39: p_ref_entity => 'HR_NAVIGATION_PATHS_TL',
40: p_ref_column_name => 'NAV_PATH_ID',
41: p_ref_col_value_number => l_nav_path_id,
42: p_ref_col_value_varchar => NULL,
43: p_ref_col_value_date => NULL,

Line 50: DELETE FROM hr_navigation_paths

46:
47: --
48: -- Code Ends Here.
49: --
50: DELETE FROM hr_navigation_paths
51: WHERE from_nav_node_usage_id = l_nav_node_usage_id
52: OR to_nav_node_usage_id = l_nav_node_usage_id;
53: --
54: END LOOP;

Line 64: p_ref_entity => 'HR_NAVIGATION_PATHS',

60: --
61: BEGIN
62: per_ric_pkg.Chk_integrity (
63: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
64: p_ref_entity => 'HR_NAVIGATION_PATHS',
65: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID', NULL,l_nav_node_usage_id,NULL),
67: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID', NULL, l_nav_node_usage_id, NULL)
68: ),