eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TCA_SHD dependencies on PER_RIC_PKG

Line 474: PER_RIC_PKG.chk_integrity (

470: -- Added the following code as a part of Zero Downtime Patching Project.
471: -- Code Starts Here.
472: --
473:
474: PER_RIC_PKG.chk_integrity (
475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

Line 477: PER_RIC_PKG.ref_entity_tbl(

473:
474: PER_RIC_PKG.chk_integrity (
475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),

Line 478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

474: PER_RIC_PKG.chk_integrity (
475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(

Line 479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),

475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),

Line 480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(

476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
484: p_ref_type=>'INS');

Line 481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),

477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
484: p_ref_type=>'INS');
485:

Line 482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(

478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
484: p_ref_type=>'INS');
485:
486: --

Line 483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),

479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
484: p_ref_type=>'INS');
485:
486: --
487: -- Code Ends Here

Line 542: PER_RIC_PKG.chk_integrity (

538: --
539: -- Added the following code as a part of Zero Downtime Patching Project.
540: -- Code Starts Here.
541: --
542: PER_RIC_PKG.chk_integrity (
543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

Line 545: PER_RIC_PKG.ref_entity_tbl(

541: --
542: PER_RIC_PKG.chk_integrity (
543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),

Line 546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

542: PER_RIC_PKG.chk_integrity (
543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(

Line 547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),

543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),

Line 548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(

544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
552: p_ref_type=>'INS');

Line 549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),

545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
552: p_ref_type=>'INS');
553: --

Line 550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(

546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
552: p_ref_type=>'INS');
553: --
554: -- Code Ends Here

Line 551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),

547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
552: p_ref_type=>'INS');
553: --
554: -- Code Ends Here
555: --