50: --
51:
52: /* Commented and Added as a part of fix for bug#12554709 Starts
53: BEGIN
54: PER_RIC_PKG.chk_integrity (
55: p_entity_name => 'HR_NAVIGATION_PATHS',
56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,
53: BEGIN
54: PER_RIC_PKG.chk_integrity (
55: p_entity_name => 'HR_NAVIGATION_PATHS',
56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,
59: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)
60: ),
61: p_ref_type => 'INS');
54: PER_RIC_PKG.chk_integrity (
55: p_entity_name => 'HR_NAVIGATION_PATHS',
56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,
59: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)
60: ),
61: p_ref_type => 'INS');
62:
55: p_entity_name => 'HR_NAVIGATION_PATHS',
56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,
59: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)
60: ),
61: p_ref_type => 'INS');
62:
63: END;*/
62:
63: END;*/
64:
65: BEGIN
66: PER_RIC_PKG.chk_integrity (
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
64:
65: BEGIN
66: PER_RIC_PKG.chk_integrity (
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
65: BEGIN
66: PER_RIC_PKG.chk_integrity (
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
73: ),
66: PER_RIC_PKG.chk_integrity (
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
73: ),
74: p_ref_type => 'INS');
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
73: ),
74: p_ref_type => 'INS');
75:
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)))
73: ),
74: p_ref_type => 'INS');
75:
76: END;
103: -- Code Starts Here.
104: --
105:
106: BEGIN
107: PER_RIC_PKG.chk_integrity (
108: p_entity_name => 'HR_NAVIGATION_PATHS_TL',
109: p_ref_entity => 'HR_NAVIGATION_PATHS',
110: p_ref_column_name => 'NAV_PATH_ID',
111: p_ref_col_value_number => X_NAV_PATH_ID,