87: -- Code Starts Here.
88: --
89:
90: BEGIN
91: PER_RIC_PKG.chk_integrity (
92: p_entity_name => 'HR_ORG_INFORMATION_TYPES_TL',
93: p_ref_entity => 'HR_ORG_INFORMATION_TYPES',
94: p_ref_column_name => 'ORG_INFORMATION_TYPE',
95: p_ref_col_value_number => NULL,
262: -- Code Starts Here.
263: --
264:
265: BEGIN
266: PER_RIC_PKG.chk_integrity (
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
264:
265: BEGIN
266: PER_RIC_PKG.chk_integrity (
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(
272: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL)))
265: BEGIN
266: PER_RIC_PKG.chk_integrity (
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(
272: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL)))
273: ),
266: PER_RIC_PKG.chk_integrity (
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(
272: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL)))
273: ),
274: p_ref_type => 'DEL');
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(
272: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL)))
273: ),
274: p_ref_type => 'DEL');
275:
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(
272: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL)))
273: ),
274: p_ref_type => 'DEL');
275:
276: END;