70: -- Code Starts Here.
71: --
72:
73: BEGIN
74: PER_RIC_PKG.chk_integrity (
75: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
76: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
77: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,p_rec.form_template_id ,NULL))),
72:
73: BEGIN
74: PER_RIC_PKG.chk_integrity (
75: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
76: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
77: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,p_rec.form_template_id ,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,p_rec.form_window_id ,NULL)))
73: BEGIN
74: PER_RIC_PKG.chk_integrity (
75: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
76: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
77: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,p_rec.form_template_id ,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,p_rec.form_window_id ,NULL)))
81: ),
74: PER_RIC_PKG.chk_integrity (
75: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
76: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
77: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,p_rec.form_template_id ,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,p_rec.form_window_id ,NULL)))
81: ),
82: p_ref_type => 'INS');
75: p_entity_name => 'HR_TEMPLATE_WINDOWS_B',
76: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
77: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,p_rec.form_template_id ,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,p_rec.form_window_id ,NULL)))
81: ),
82: p_ref_type => 'INS');
83:
76: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
77: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,p_rec.form_template_id ,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,p_rec.form_window_id ,NULL)))
81: ),
82: p_ref_type => 'INS');
83:
84: END;