68: -- Code Starts Here.
69: --
70:
71: BEGIN
72: PER_RIC_PKG.chk_integrity (
73: p_entity_name => 'HR_FORM_WINDOWS_TL',
74: p_ref_entity => 'HR_FORM_WINDOWS_B',
75: p_ref_column_name => 'FORM_WINDOW_ID',
76: p_ref_col_value_number => X_FORM_WINDOW_ID,
244: -- Code Starts Here.
245: --
246:
247: BEGIN
248: PER_RIC_PKG.chk_integrity (
249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
246:
247: BEGIN
248: PER_RIC_PKG.chk_integrity (
249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
247: BEGIN
248: PER_RIC_PKG.chk_integrity (
249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
248: PER_RIC_PKG.chk_integrity (
249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
258: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL)))
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
258: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL)))
259: ),
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
258: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL)))
259: ),
260: p_ref_type => 'DEL');
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
258: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL)))
259: ),
260: p_ref_type => 'DEL');
261:
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
258: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL)))
259: ),
260: p_ref_type => 'DEL');
261:
262: END;