52: --
53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.
55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PQH_ATTRIBUTES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PQH_ATTRIBUTES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PQH_ATTRIBUTES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
57: p_entity_name=>'PQH_ATTRIBUTES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,p_rec.attribute_id, NULL)))),
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,p_rec.attribute_id, NULL)))),
68: p_ref_type=>'DEL');
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,p_rec.attribute_id, NULL)))),
68: p_ref_type=>'DEL');
69: --
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,p_rec.attribute_id, NULL)))),
68: p_ref_type=>'DEL');
69: --
70: --
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,p_rec.attribute_id, NULL)))),
68: p_ref_type=>'DEL');
69: --
70: --
71: -- Code Ends Here