17: -- Code Starts Here.
18: --
19:
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
19:
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
29: p_ref_type => 'INS');
22: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
29: p_ref_type => 'INS');
30:
23: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
24: PER_RIC_PKG.ref_info_rec('HR_WORKFLOWS', PER_RIC_PKG.column_info_tbl(
25: PER_RIC_PKG.col_info_rec('WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
26: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES', PER_RIC_PKG.column_info_tbl(
27: PER_RIC_PKG.col_info_rec('NAV_NODE_ID',NULL,X_NAV_NODE_ID,NULL)))
28: ),
29: p_ref_type => 'INS');
30:
31: END;
109: -- Code Starts Here.
110: --
111:
112: BEGIN
113: PER_RIC_PKG.chk_integrity (
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
112: BEGIN
113: PER_RIC_PKG.chk_integrity (
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
119: ),
120: p_ref_type => 'DEL');
113: PER_RIC_PKG.chk_integrity (
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
119: ),
120: p_ref_type => 'DEL');
121:
114: p_entity_name => 'HR_NAVIGATION_NODE_USAGES',
115: p_ref_entity => 'HR_NAVIGATION_PATHS',
116: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
117: PER_RIC_PKG.col_info_rec('FROM_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL) ,
118: PER_RIC_PKG.col_info_rec('TO_NAV_NODE_USAGE_ID',NULL,X_NAV_NODE_USAGE_ID,NULL)
119: ),
120: p_ref_type => 'DEL');
121:
122: END;