42: -- Code Starts Here.
43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
53: ),
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
53: ),
54: p_ref_type => 'INS');
47: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
53: ),
54: p_ref_type => 'INS');
55:
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
53: ),
54: p_ref_type => 'INS');
55:
56: END;
444: -- Code Starts Here.
445: --
446:
447: BEGIN
448: PER_RIC_PKG.chk_integrity (
449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
446:
447: BEGIN
448: PER_RIC_PKG.chk_integrity (
449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
453: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
454: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
447: BEGIN
448: PER_RIC_PKG.chk_integrity (
449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
453: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
454: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
455: ),
448: PER_RIC_PKG.chk_integrity (
449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
453: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
454: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
455: ),
456: p_ref_type => 'INS');
449: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXT_PAGES',
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
453: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
454: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
455: ),
456: p_ref_type => 'INS');
457:
450: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
451: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
452: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
453: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
454: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL)))
455: ),
456: p_ref_type => 'INS');
457:
458: END;