APPS.HR_WORKFLOWS_PKG dependencies on HR_NAVIGATION_NODE_USAGES

Line 10: FROM hr_navigation_node_usages

6: l_nav_node_usage_id NUMBER;
7: l_nav_path_id NUMBER;
8: CURSOR csr_node_usages IS
9: SELECT nav_node_usage_id
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

Line 63: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',

59: -- Code Starts Here.
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)

Line 75: DELETE FROM hr_navigation_node_usages

71:
72: --
73: -- Code Ends Here.
74: --
75: DELETE FROM hr_navigation_node_usages
76: WHERE nav_node_usage_id = l_nav_node_usage_id;
77: --
78: END LOOP;
79: END cleanup_taskflow_update;

Line 168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(

164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL)))),
170: p_ref_type => 'DEL');
171:
172: END;