DBA Data[Home] [Help]

APPS.PQH_TCT_INS dependencies on PER_RIC_PKG

Line 59: PER_RIC_PKG.chk_integrity (

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

Line 62: PER_RIC_PKG.ref_entity_tbl(

58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.master_table_route_id, NULL)))),

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

59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.master_table_route_id, NULL)))),
67: p_ref_type=>'INS');

Line 64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),

60: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.master_table_route_id, NULL)))),
67: p_ref_type=>'INS');
68: --

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

61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.master_table_route_id, NULL)))),
67: p_ref_type=>'INS');
68: --
69: --

Line 66: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.master_table_route_id, NULL)))),

62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.master_table_route_id, NULL)))),
67: p_ref_type=>'INS');
68: --
69: --
70: -- Code Ends Here