67: -- Code Starts Here.
68: --
69:
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
69:
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
78: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
78: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
79: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL)))
72: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
78: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
79: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL)))
80: ),
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
78: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
79: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL)))
80: ),
81: p_ref_type => 'DEL');
74: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
78: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
79: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL)))
80: ),
81: p_ref_type => 'DEL');
82:
75: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL))),
78: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
79: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,P_REC.TEMPLATE_ITEM_ID,NULL)))
80: ),
81: p_ref_type => 'DEL');
82:
83: END;