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.

[Home] [Help]

APPS.PQH_TCT_WIZARD_PKG dependencies on PER_RIC_PKG

Line 2503: PER_RIC_PKG.chk_integrity (

2499: -- Added the following code as a part of Zero Downtime Patching Project.
2500: -- Code Starts Here.
2501: --
2502:
2503: PER_RIC_PKG.chk_integrity (
2504: p_entity_name=>'PQH_ATTRIBUTE_RANGES',
2505: p_ref_entity_info=>
2506: PER_RIC_PKG.ref_entity_tbl(
2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(

Line 2506: PER_RIC_PKG.ref_entity_tbl(

2502:
2503: PER_RIC_PKG.chk_integrity (
2504: p_entity_name=>'PQH_ATTRIBUTE_RANGES',
2505: p_ref_entity_info=>
2506: PER_RIC_PKG.ref_entity_tbl(
2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),

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

2503: PER_RIC_PKG.chk_integrity (
2504: p_entity_name=>'PQH_ATTRIBUTE_RANGES',
2505: p_ref_entity_info=>
2506: PER_RIC_PKG.ref_entity_tbl(
2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(

Line 2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),

2504: p_entity_name=>'PQH_ATTRIBUTE_RANGES',
2505: p_ref_entity_info=>
2506: PER_RIC_PKG.ref_entity_tbl(
2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(
2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),

Line 2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(

2505: p_ref_entity_info=>
2506: PER_RIC_PKG.ref_entity_tbl(
2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(
2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),
2513: p_ref_type=>'INS');

Line 2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),

2506: PER_RIC_PKG.ref_entity_tbl(
2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(
2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),
2513: p_ref_type=>'INS');
2514:

Line 2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(

2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(
2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),
2513: p_ref_type=>'INS');
2514:
2515: --

Line 2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),

2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(
2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),
2513: p_ref_type=>'INS');
2514:
2515: --
2516: -- Code Ends Here