55: --
56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
70: --
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
70: --
71: -- Code Ends Here
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
70: --
71: -- Code Ends Here
72: --