43: -- Code Starts Here.
44: --
45:
46: BEGIN
47: PER_RIC_PKG.chk_integrity (
48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
45:
46: BEGIN
47: PER_RIC_PKG.chk_integrity (
48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(
53: PER_RIC_PKG.col_info_rec('ITEM_CONTEXT_ID',NULL,X_ITEM_CONTEXT_ID,NULL)))
46: BEGIN
47: PER_RIC_PKG.chk_integrity (
48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(
53: PER_RIC_PKG.col_info_rec('ITEM_CONTEXT_ID',NULL,X_ITEM_CONTEXT_ID,NULL)))
54: ),
47: PER_RIC_PKG.chk_integrity (
48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(
53: PER_RIC_PKG.col_info_rec('ITEM_CONTEXT_ID',NULL,X_ITEM_CONTEXT_ID,NULL)))
54: ),
55: p_ref_type => 'INS');
48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(
53: PER_RIC_PKG.col_info_rec('ITEM_CONTEXT_ID',NULL,X_ITEM_CONTEXT_ID,NULL)))
54: ),
55: p_ref_type => 'INS');
56:
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(
53: PER_RIC_PKG.col_info_rec('ITEM_CONTEXT_ID',NULL,X_ITEM_CONTEXT_ID,NULL)))
54: ),
55: p_ref_type => 'INS');
56:
57: END;
159: -- Code Starts Here.
160: --
161:
162: BEGIN
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
161:
162: BEGIN
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
162: BEGIN
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
170: ),
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
170: ),
171: p_ref_type => 'DEL');
164: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
170: ),
171: p_ref_type => 'DEL');
172:
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(
169: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
170: ),
171: p_ref_type => 'DEL');
172:
173: END;