64: --
65: -- Added the following code as a part of Zero Downtime Patching Project.
66: -- Code Starts Here.
67: --
68: PER_RIC_PKG.chk_integrity (
69: p_entity_name=>'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
70: p_ref_entity_info=>
71: PER_RIC_PKG.ref_entity_tbl(
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
67: --
68: PER_RIC_PKG.chk_integrity (
69: p_entity_name=>'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
70: p_ref_entity_info=>
71: PER_RIC_PKG.ref_entity_tbl(
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
68: PER_RIC_PKG.chk_integrity (
69: p_entity_name=>'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
70: p_ref_entity_info=>
71: PER_RIC_PKG.ref_entity_tbl(
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
76: PER_RIC_PKG.column_info_tbl(
69: p_entity_name=>'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
70: p_ref_entity_info=>
71: PER_RIC_PKG.ref_entity_tbl(
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
76: PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,p_rec.template_tab_page_id,NULL)))),
70: p_ref_entity_info=>
71: PER_RIC_PKG.ref_entity_tbl(
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
76: PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,p_rec.template_tab_page_id,NULL)))),
78: p_ref_type=>'INS');
71: PER_RIC_PKG.ref_entity_tbl(
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
76: PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,p_rec.template_tab_page_id,NULL)))),
78: p_ref_type=>'INS');
79: --
72: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
76: PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,p_rec.template_tab_page_id,NULL)))),
78: p_ref_type=>'INS');
79: --
80: -- Code Ends Here
73: PER_RIC_PKG.column_info_tbl(
74: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id,NULL))),
75: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B',
76: PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,p_rec.template_tab_page_id,NULL)))),
78: p_ref_type=>'INS');
79: --
80: -- Code Ends Here
81: --