67: -- Added the following code as a part of Zero Downtime Patching Project.
68: -- Code Starts Here.
69: --
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_FORM_DATA_GROUPS_TL',
73: p_ref_entity => 'HR_FORM_DATA_GROUPS_B',
74: p_ref_column_name => 'FORM_DATA_GROUP_ID',
75: p_ref_col_value_number => X_FORM_DATA_GROUP_ID,
243: -- Code Starts Here.
244: --
245:
246: BEGIN
247: PER_RIC_PKG.chk_integrity (
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
245:
246: BEGIN
247: PER_RIC_PKG.chk_integrity (
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
246: BEGIN
247: PER_RIC_PKG.chk_integrity (
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
247: PER_RIC_PKG.chk_integrity (
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
255: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL)))
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
255: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL)))
256: ),
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
255: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL)))
256: ),
257: p_ref_type => 'DEL');
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
255: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL)))
256: ),
257: p_ref_type => 'DEL');
258:
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
255: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL)))
256: ),
257: p_ref_type => 'DEL');
258:
259: END;