61: --
62: -- Added the following code as a part of Zero Downtime Patching Project.
63: -- Code Starts Here.
64: --
65: PER_RIC_PKG.chk_integrity(
66: p_entity_name=>'PER_SOLUTIONS',
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
64: --
65: PER_RIC_PKG.chk_integrity(
66: p_entity_name=>'PER_SOLUTIONS',
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
71: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_CMPT_NAMES',PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('SOLUTION_ID', NULL,p_rec.solution_id, NULL)))),
65: PER_RIC_PKG.chk_integrity(
66: p_entity_name=>'PER_SOLUTIONS',
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
71: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_CMPT_NAMES',PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('SOLUTION_ID', NULL,p_rec.solution_id, NULL)))),
73: p_ref_type=>'DEL');
66: p_entity_name=>'PER_SOLUTIONS',
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
71: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_CMPT_NAMES',PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('SOLUTION_ID', NULL,p_rec.solution_id, NULL)))),
73: p_ref_type=>'DEL');
74: --
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
71: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_CMPT_NAMES',PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('SOLUTION_ID', NULL,p_rec.solution_id, NULL)))),
73: p_ref_type=>'DEL');
74: --
75: -- Code Ends Here
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
71: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_CMPT_NAMES',PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('SOLUTION_ID', NULL,p_rec.solution_id, NULL)))),
73: p_ref_type=>'DEL');
74: --
75: -- Code Ends Here
76: --