203: -- Code Starts Here.
204: --
205:
206: BEGIN
207: PER_RIC_PKG.chk_integrity (
208: p_entity_name => 'HR_FORM_TEMPLATES_TL',
209: p_ref_entity => 'HR_FORM_TEMPLATES_B',
210: p_ref_column_name => 'FORM_TEMPLATE_ID',
211: p_ref_col_value_number => X_FORM_TEMPLATE_ID,
576: -- Code Starts Here.
577: --
578:
579: BEGIN
580: PER_RIC_PKG.chk_integrity (
581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
578:
579: BEGIN
580: PER_RIC_PKG.chk_integrity (
581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
579: BEGIN
580: PER_RIC_PKG.chk_integrity (
581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
580: PER_RIC_PKG.chk_integrity (
581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
595: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
595: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
596: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL)))
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
595: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
596: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL)))
597: ),
590: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_FROM',NULL,X_FORM_TEMPLATE_ID,NULL))),
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
595: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
596: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL)))
597: ),
598: p_ref_type => 'DEL');
591: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
595: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
596: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL)))
597: ),
598: p_ref_type => 'DEL');
599:
592: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
593: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
594: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
595: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
596: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL)))
597: ),
598: p_ref_type => 'DEL');
599:
600: END;