92: --
93: -- Added the following code as a part of Zero Downtime Patching Project.
94: -- Code Starts Here.
95: --
96: PER_RIC_PKG.chk_integrity (
97: p_entity_name=>'PER_SOLUTION_CMPT_NAMES',
98: p_ref_entity_info=>
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
95: --
96: PER_RIC_PKG.chk_integrity (
97: p_entity_name=>'PER_SOLUTION_CMPT_NAMES',
98: p_ref_entity_info=>
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
96: PER_RIC_PKG.chk_integrity (
97: p_entity_name=>'PER_SOLUTION_CMPT_NAMES',
98: p_ref_entity_info=>
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
97: p_entity_name=>'PER_SOLUTION_CMPT_NAMES',
98: p_ref_entity_info=>
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
105: PER_RIC_PKG.col_info_rec('COMPONENT_NAME', p_rec.component_name, NULL,NULL),
98: p_ref_entity_info=>
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
105: PER_RIC_PKG.col_info_rec('COMPONENT_NAME', p_rec.component_name, NULL,NULL),
106: PER_RIC_PKG.col_info_rec('SOLUTION_TYPE_NAME', p_rec.solution_type_name,NULL,NULL)))),
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
105: PER_RIC_PKG.col_info_rec('COMPONENT_NAME', p_rec.component_name, NULL,NULL),
106: PER_RIC_PKG.col_info_rec('SOLUTION_TYPE_NAME', p_rec.solution_type_name,NULL,NULL)))),
107: p_ref_type=>'INS');
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
105: PER_RIC_PKG.col_info_rec('COMPONENT_NAME', p_rec.component_name, NULL,NULL),
106: PER_RIC_PKG.col_info_rec('SOLUTION_TYPE_NAME', p_rec.solution_type_name,NULL,NULL)))),
107: p_ref_type=>'INS');
108: --
101: PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
105: PER_RIC_PKG.col_info_rec('COMPONENT_NAME', p_rec.component_name, NULL,NULL),
106: PER_RIC_PKG.col_info_rec('SOLUTION_TYPE_NAME', p_rec.solution_type_name,NULL,NULL)))),
107: p_ref_type=>'INS');
108: --
109: -- Code Ends Here
102: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_TYPE_CMPTS',
104: PER_RIC_PKG.column_info_tbl(
105: PER_RIC_PKG.col_info_rec('COMPONENT_NAME', p_rec.component_name, NULL,NULL),
106: PER_RIC_PKG.col_info_rec('SOLUTION_TYPE_NAME', p_rec.solution_type_name,NULL,NULL)))),
107: p_ref_type=>'INS');
108: --
109: -- Code Ends Here
110: --