67: -- Code Starts Here.
68: --
69:
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL))),
69:
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL)))
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL)))
78: ),
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL)))
78: ),
79: p_ref_type => 'DEL');
72: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL)))
78: ),
79: p_ref_type => 'DEL');
80:
73: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
74: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
75: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL))),
76: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
77: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,p_rec.template_window_id,NULL)))
78: ),
79: p_ref_type => 'DEL');
80:
81: END;