351: --
352: -- Added the following code as a part of Zero Downtime Patching Project.
353: -- Code Starts Here.
354: --
355: PER_RIC_PKG.chk_integrity(
356: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
357: p_ref_entity_info=>
358: PER_RIC_PKG.ref_entity_tbl(
359: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
354: --
355: PER_RIC_PKG.chk_integrity(
356: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
357: p_ref_entity_info=>
358: PER_RIC_PKG.ref_entity_tbl(
359: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
361: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,l_template_id, NULL)))),
355: PER_RIC_PKG.chk_integrity(
356: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
357: p_ref_entity_info=>
358: PER_RIC_PKG.ref_entity_tbl(
359: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
361: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,l_template_id, NULL)))),
363: p_ref_type=>'INS');
356: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
357: p_ref_entity_info=>
358: PER_RIC_PKG.ref_entity_tbl(
359: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
361: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,l_template_id, NULL)))),
363: p_ref_type=>'INS');
364: --
357: p_ref_entity_info=>
358: PER_RIC_PKG.ref_entity_tbl(
359: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
361: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,l_template_id, NULL)))),
363: p_ref_type=>'INS');
364: --
365: -- Code Ends Here
358: PER_RIC_PKG.ref_entity_tbl(
359: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
361: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,l_template_id, NULL)))),
363: p_ref_type=>'INS');
364: --
365: -- Code Ends Here
366: --