582: --
583: -- Added the following code as a part of Zero Downtime Patching Project.
584: -- Code Starts Here.
585: --
586: PER_RIC_PKG.chk_integrity (
587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
585: --
586: PER_RIC_PKG.chk_integrity (
587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
586: PER_RIC_PKG.chk_integrity (
587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
594: p_ref_type=>'INS');
587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
594: p_ref_type=>'INS');
595: --
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
594: p_ref_type=>'INS');
595: --
596: -- Code Ends Here
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
594: p_ref_type=>'INS');
595: --
596: -- Code Ends Here
597: --