211: -- Code Starts Here.
212: --
213:
214: BEGIN
215: PER_RIC_PKG.chk_integrity (
216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
213:
214: BEGIN
215: PER_RIC_PKG.chk_integrity (
216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
221: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
214: BEGIN
215: PER_RIC_PKG.chk_integrity (
216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
221: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
222: ),
215: PER_RIC_PKG.chk_integrity (
216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
221: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
222: ),
223: p_ref_type => 'INS');
216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
221: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
222: ),
223: p_ref_type => 'INS');
224:
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
221: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
222: ),
223: p_ref_type => 'INS');
224:
225: END;
318: -- Code Starts Here.
319: --
320:
321: BEGIN
322: PER_RIC_PKG.chk_integrity (
323: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_TL',
324: p_ref_entity => 'HR_TAB_PAGE_PROPERTIES_B',
325: p_ref_column_name => 'TAB_PAGE_PROPERTY_ID',
326: p_ref_col_value_number => X_TAB_PAGE_PROPERTY_ID,
676: -- Code Starts Here.
677: --
678:
679: BEGIN
680: PER_RIC_PKG.chk_integrity (
681: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
682: p_ref_entity => 'HR_TAB_PAGE_PROPERTIES_TL',
683: p_ref_column_name => 'TAB_PAGE_PROPERTY_ID',
684: p_ref_col_value_number => X_TAB_PAGE_PROPERTY_ID,