51: --
52:
53: BEGIN
54:
55: per_RIC_pkg.chk_integrity (
56: p_entity_name => 'HR_FORM_CANVASES_B',
57: p_ref_entity => 'HR_FORM_WINDOWS_B',
58: p_ref_column_name => 'FORM_WINDOW_ID',
59: p_ref_col_value_number => X_FORM_WINDOW_ID,
99: --
100:
101: BEGIN
102:
103: per_RIC_pkg.chk_integrity (
104: p_entity_name => 'HR_FORM_CANVASES_TL',
105: p_ref_entity => 'HR_FORM_CANVASES_B',
106: p_ref_column_name => 'FORM_CANVAS_ID',
107: p_ref_col_value_number => X_FORM_CANVAS_ID,
276: -- Code Starts Here.
277: --
278: BEGIN
279:
280: per_RIC_pkg.chk_integrity (
281: p_entity_name => 'HR_FORM_CANVASES_B',
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
278: BEGIN
279:
280: per_RIC_pkg.chk_integrity (
281: p_entity_name => 'HR_FORM_CANVASES_B',
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
279:
280: per_RIC_pkg.chk_integrity (
281: p_entity_name => 'HR_FORM_CANVASES_B',
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
280: per_RIC_pkg.chk_integrity (
281: p_entity_name => 'HR_FORM_CANVASES_B',
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
281: p_entity_name => 'HR_FORM_CANVASES_B',
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
293: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
293: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
294: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL)))
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
293: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
294: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL)))
295: ),
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
293: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
294: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL)))
295: ),
296: p_ref_type => 'DEL');
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
293: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
294: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL)))
295: ),
296: p_ref_type => 'DEL');
297:
290: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
291: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
292: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
293: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
294: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL)))
295: ),
296: p_ref_type => 'DEL');
297:
298: END;