APPS.PQH_TCA_INS dependencies on PER_RIC_PKG

Line 60: PER_RIC_PKG.chk_integrity (

56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59:
60: PER_RIC_PKG.chk_integrity (
61: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
62: p_ref_entity_info=>
63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

Line 63: PER_RIC_PKG.ref_entity_tbl(

59:
60: PER_RIC_PKG.chk_integrity (
61: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
62: p_ref_entity_info=>
63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),

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

60: PER_RIC_PKG.chk_integrity (
61: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
62: p_ref_entity_info=>
63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(

Line 65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),

61: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
62: p_ref_entity_info=>
63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,p_rec.transaction_category_id, NULL)))),

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

62: p_ref_entity_info=>
63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,p_rec.transaction_category_id, NULL)))),
70: p_ref_type=>'INS');

Line 67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),

63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,p_rec.transaction_category_id, NULL)))),
70: p_ref_type=>'INS');
71: --

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

64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,p_rec.transaction_category_id, NULL)))),
70: p_ref_type=>'INS');
71: --
72: -- Code Ends Here

Line 69: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,p_rec.transaction_category_id, NULL)))),

65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_rec.attribute_id, NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,p_rec.transaction_category_id, NULL)))),
70: p_ref_type=>'INS');
71: --
72: -- Code Ends Here
73: --