54: --
55: -- Added the following code as a part of Zero Downtime Patching Project.
56: -- Code Starts Here.
57: --
58: per_ric_pkg.Chk_integrity(
59: p_entity_name=>'HR_NAVIGATION_UNITS',
60: p_ref_entity=>'HR_WORKFLOWS',
61: p_ref_column_name=>'DEFAULT_WORKFLOW_ID',
62: p_ref_col_value_number=>X_Default_Workflow_Id,
87: --
88: -- Added the following code as a part of Zero Downtime Patching Project.
89: -- Code Starts Here.
90: --
91: per_ric_pkg.Chk_integrity (
92: p_entity_name=>'HR_NAVIGATION_UNITS_TL',
93: p_ref_entity=>'HR_NAVIGATION_UNITS',
94: p_ref_column_name=>'NAV_UNIT_ID',
95: p_ref_col_value_number=>X_Nav_Unit_Id,
333: --
334: -- Added the following code as a part of Zero Downtime Patching Project.
335: -- Code Starts Here.
336: --
337: PER_RIC_PKG.chk_integrity(
338: p_entity_name=> 'HR_NAVIGATION_UNITS',
339: p_ref_entity_info =>
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
336: --
337: PER_RIC_PKG.chk_integrity(
338: p_entity_name=> 'HR_NAVIGATION_UNITS',
339: p_ref_entity_info =>
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
337: PER_RIC_PKG.chk_integrity(
338: p_entity_name=> 'HR_NAVIGATION_UNITS',
339: p_ref_entity_info =>
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
338: p_entity_name=> 'HR_NAVIGATION_UNITS',
339: p_ref_entity_info =>
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
339: p_ref_entity_info =>
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID', NULL,x_nav_unit_id, NULL)))),
343: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID', NULL,x_nav_unit_id, NULL)))),
351: p_ref_type=>'DEL');
344: PER_RIC_PKG.col_info_rec('TO_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID', NULL,x_nav_unit_id, NULL)))),
351: p_ref_type=>'DEL');
352: --
345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID', NULL,x_nav_unit_id, NULL)))),
351: p_ref_type=>'DEL');
352: --
353: -- Code Ends Here
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID', NULL,x_nav_unit_id, NULL)))),
351: p_ref_type=>'DEL');
352: --
353: -- Code Ends Here
354: --