|
Package gb_bio_rules
This package provides the field level business validations for the BIOGRAPHICAL API (gb_bio).
|
|
p_register_entity
|
Registers the attribute/value pairs to the message cache for delete operations.
|
|
p_register_entity
|
Registers the attribute/value pairs to the message cache for create and update operations.
|
|
p_validate
|
Validates all the data in the record.
|
p_register_entity
PROCEDURE p_register_entity(p_operation_type NUMBER,
p_internal_record_id gb_common.internal_record_id_type)
Registers the attribute/value pairs to the message cache for delete operations.
This signature uses the ROWID only for the delete operations.
|
|
p_operation_type
|
Messaging operation type. Use one of gb_event.CREATE_OPERATION, gb_event.UPDATE_OPERATION gb_event.DELETE_OPERATION.
|
|
|
p_internal_record_id
|
Database ROWID
|
p_register_entity
PROCEDURE p_register_entity(p_operation_type NUMBER,
p_pidm spbpers.spbpers_pidm%TYPE,
p_ssn spbpers.spbpers_ssn%TYPE,
p_birth_date spbpers.spbpers_birth_date%TYPE,
p_lgcy_code spbpers.spbpers_lgcy_code%TYPE,
p_ethn_code spbpers.spbpers_ethn_code%TYPE,
p_mrtl_code spbpers.spbpers_mrtl_code%TYPE,
p_relg_code spbpers.spbpers_relg_code%TYPE,
p_sex spbpers.spbpers_sex%TYPE,
p_confid_ind spbpers.spbpers_confid_ind%TYPE,
p_dead_ind spbpers.spbpers_dead_ind%TYPE,
p_vetc_file_number spbpers.spbpers_vetc_file_number%TYPE,
p_legal_name spbpers.spbpers_legal_name%TYPE,
p_pref_first_name spbpers.spbpers_pref_first_name%TYPE,
p_name_prefix spbpers.spbpers_name_prefix%TYPE,
p_name_suffix spbpers.spbpers_name_suffix%TYPE,
p_vera_ind spbpers.spbpers_vera_ind%TYPE,
p_citz_ind spbpers.spbpers_citz_ind%TYPE,
p_dead_date spbpers.spbpers_dead_date%TYPE,
p_citz_code spbpers.spbpers_citz_code%TYPE,
p_hair_code spbpers.spbpers_hair_code%TYPE,
p_eyes_code spbpers.spbpers_eyes_code%TYPE,
p_city_birth spbpers.spbpers_city_birth%TYPE,
p_stat_code_birth spbpers.spbpers_stat_code_birth%TYPE,
p_driver_license spbpers.spbpers_driver_license%TYPE,
p_stat_code_driver spbpers.spbpers_stat_code_driver%TYPE,
p_natn_code_driver spbpers.spbpers_natn_code_driver%TYPE,
p_uoms_code_height spbpers.spbpers_uoms_code_height%TYPE,
p_height spbpers.spbpers_height%TYPE,
p_uoms_code_weight spbpers.spbpers_uoms_code_weight%TYPE,
p_weight spbpers.spbpers_weight%TYPE,
p_sdvet_ind spbpers.spbpers_sdvet_ind%TYPE,
p_license_issued_date spbpers.spbpers_license_issued_date%TYPE,
p_license_expires_date spbpers.spbpers_license_expires_date%TYPE,
p_incar_ind spbpers.spbpers_incar_ind%TYPE,
p_itin spbpers.spbpers_itin%TYPE,
p_active_duty_sepr_date spbpers.spbpers_active_duty_sepr_date%TYPE,
p_data_origin spbpers.spbpers_data_origin%TYPE,
p_user_id spbpers.spbpers_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_ethn_cde spbpers.spbpers_ethn_cde%TYPE,
p_confirmed_re_cde spbpers.spbpers_confirmed_re_cde%TYPE,
p_confirmed_re_date spbpers.spbpers_confirmed_re_date%TYPE,
p_armed_serv_med_vet_ind spbpers.spbpers_armed_serv_med_vet_ind%TYPE,
p_internal_record_id gb_common.internal_record_id_type)
Registers the attribute/value pairs to the message cache for create and update operations.
This signature registers all parameters.
|
|
p_operation_type
|
Messaging operation type. Use one of the following: gb_event.CREATE_OPERATION, gb_event.UPDATE_OPERATION gb_event.DELETE_OPERATION.
|
|
|
p_pidm
|
Internal Identification Number of the person. NUMBER(8) Required Key
|
|
|
p_ssn
|
The person's social security number. VARCHAR2(9)
|
|
|
p_birth_date
|
The person's birth date. DATE
|
|
|
p_lgcy_code
|
The legacy code associated with the person. VARCHAR2(1)
|
|
|
p_ethn_code
|
The ethnicity code associated with the person. VARCHAR2(2)
|
|
|
p_mrtl_code
|
The martial status associated with the person. VARCHAR2(1)
|
|
|
p_relg_code
|
The religious affiliation associated with the person. VARCHAR2(2)
|
|
|
p_sex
|
Gender of the person. VARCHAR2(1)
|
|
M
|
Male
|
|
|
F
|
Female
|
|
|
N
|
Unknown
|
|
|
|
p_confid_ind
|
Confidentiality indicator. VARCHAR2(1)
|
|
null
|
Not confidential
|
|
|
Y
|
Confidential
|
|
|
|
p_dead_ind
|
Deceased indicator. VARCHAR2(1)
|
|
null
|
Not deceased
|
|
|
Y
|
Deceased
|
|
|
|
p_vetc_file_number
|
The veteran identification number associated with the person. VARCHAR2(10)
|
|
|
p_legal_name
|
The legal name associated with the person. VARCHAR2(60)
|
|
|
p_pref_first_name
|
Preferred first name associated with the person. VARCHAR2(15)
|
|
|
p_name_prefix
|
Prefix (Mr, Mrs, etc) used before person's name. VARCHAR2(20)
|
|
|
p_name_suffix
|
Suffix (Jr, Sr, etc) used after person's name. VARCHAR2(20)
|
|
|
p_vera_ind
|
Veteran Category. VARCHAR2(1)
|
|
null
|
None
|
|
|
O
|
Other Protected Veteran Only
|
|
|
V
|
Vietnam Veteran only
|
|
|
B
|
Both Vietnam and Other Eligible Veteran
|
|
|
|
p_citz_ind
|
Citizen Indicator. VARCHAR2(1)
|
|
|
p_dead_date
|
Person's Deceased Date. DATE
|
|
|
p_citz_code
|
Person's Citizen Type. VARCHAR2(2)
|
|
|
p_hair_code
|
The hair color of the person being defined. VARCHAR2(2)
|
|
|
p_eyes_code
|
The eye color of the person being defined. VARCHAR2(2)
|
|
|
p_city_birth
|
The City where the person was born. VARCHAR2(20)
|
|
|
p_stat_code_birth
|
The State in which the person was born. VARCHAR2(3)
|
|
|
p_driver_license
|
The Driver License Number as it appears on the actual license. VARCHAR2(20)
|
|
|
p_stat_code_driver
|
The State code describing the state the driver license was issued. VARCHAR2(3)
|
|
|
p_natn_code_driver
|
The Nation code associated with the Nation the Driver license was issued. VARCHAR2(5)
|
|
|
p_uoms_code_height
|
The Unit of Measure describing the height value. VARCHAR2(4)
|
|
|
p_height
|
The number value describing the height of the person. NUMBER(2)
|
|
|
p_uoms_code_weight
|
The Unit of Measure describing the weight value. VARCHAR2(4)
|
|
|
p_weight
|
The number value describing the weight of the person. NUMBER(4)
|
|
|
p_sdvet_ind
|
Indicator to identify an individual as a special disabled veteran. VARCHAR2(1)
|
|
|
p_license_issued_date
|
The issue date of the individual's driver license. DATE
|
|
|
p_license_expires_date
|
The expiration date of the individual's driver license. DATE
|
|
|
p_incar_ind
|
The indication of the individual's incarceration. VARCHAR2(1)
|
|
|
p_itin
|
The international tax id number. NUMBER(9)
|
|
|
p_active_duty_sepr_date
|
The date that the person was separated from active duty. DATE
|
|
|
p_data_origin
|
Source system that created or updated the row. VARCHAR2(30)
|
|
|
p_user_id
|
The Oracle User ID of the person who inserted or last updated the data. VARCHAR2(30)
|
|
|
p_ethn_cde
|
The ethnic code defined by the United States government. VARCHAR2(1)
|
|
null
|
None
|
|
|
1
|
Not Hispanic or Latino
|
|
|
2
|
Hispanic or Latino
|
|
|
|
p_confirmed_re_cde
|
The race and ethnicity have been confirmed. VARCHAR2(1)
|
|
null
|
Not Confirmed
|
|
|
Y
|
Confirmed
|
|
|
N
|
Not Confirmed
|
|
|
|
p_confirmed_re_date
|
Date on which the race and ethnicity have been confirmed. DATE
|
|
|
p_armed_serv_med_vet_ind
|
Armed Forces Service Medal Indicator. VARCHAR2(1)
|
|
|
p_internal_record_id
|
Database ROWID
|
p_validate
PROCEDURE p_validate(p_pidm spbpers.spbpers_pidm%TYPE,
p_ssn spbpers.spbpers_ssn%TYPE DEFAULT NULL,
p_birth_date spbpers.spbpers_birth_date%TYPE DEFAULT NULL,
p_lgcy_code spbpers.spbpers_lgcy_code%TYPE DEFAULT NULL,
p_ethn_code spbpers.spbpers_ethn_code%TYPE DEFAULT NULL,
p_mrtl_code spbpers.spbpers_mrtl_code%TYPE DEFAULT NULL,
p_relg_code spbpers.spbpers_relg_code%TYPE DEFAULT NULL,
p_sex spbpers.spbpers_sex%TYPE DEFAULT NULL,
p_confid_ind spbpers.spbpers_confid_ind%TYPE DEFAULT NULL,
p_dead_ind spbpers.spbpers_dead_ind%TYPE DEFAULT NULL,
p_vetc_file_number spbpers.spbpers_vetc_file_number%TYPE DEFAULT NULL,
p_legal_name spbpers.spbpers_legal_name%TYPE DEFAULT NULL,
p_pref_first_name spbpers.spbpers_pref_first_name%TYPE DEFAULT NULL,
p_name_prefix spbpers.spbpers_name_prefix%TYPE DEFAULT NULL,
p_name_suffix spbpers.spbpers_name_suffix%TYPE DEFAULT NULL,
p_vera_ind spbpers.spbpers_vera_ind%TYPE DEFAULT NULL,
p_citz_ind spbpers.spbpers_citz_ind%TYPE DEFAULT NULL,
p_dead_date spbpers.spbpers_dead_date%TYPE DEFAULT NULL,
p_citz_code spbpers.spbpers_citz_code%TYPE DEFAULT NULL,
p_hair_code spbpers.spbpers_hair_code%TYPE DEFAULT NULL,
p_eyes_code spbpers.spbpers_eyes_code%TYPE DEFAULT NULL,
p_city_birth spbpers.spbpers_city_birth%TYPE DEFAULT NULL,
p_stat_code_birth spbpers.spbpers_stat_code_birth%TYPE DEFAULT NULL,
p_driver_license spbpers.spbpers_driver_license%TYPE DEFAULT NULL,
p_stat_code_driver spbpers.spbpers_stat_code_driver%TYPE DEFAULT NULL,
p_natn_code_driver spbpers.spbpers_natn_code_driver%TYPE DEFAULT NULL,
p_uoms_code_height spbpers.spbpers_uoms_code_height%TYPE DEFAULT NULL,
p_height spbpers.spbpers_height%TYPE DEFAULT NULL,
p_uoms_code_weight spbpers.spbpers_uoms_code_weight%TYPE DEFAULT NULL,
p_weight spbpers.spbpers_weight%TYPE DEFAULT NULL,
p_sdvet_ind spbpers.spbpers_sdvet_ind%TYPE DEFAULT NULL,
p_license_issued_date spbpers.spbpers_license_issued_date%TYPE DEFAULT NULL,
p_license_expires_date spbpers.spbpers_license_expires_date%TYPE DEFAULT NULL,
p_incar_ind spbpers.spbpers_incar_ind%TYPE DEFAULT NULL,
p_itin spbpers.spbpers_itin%TYPE DEFAULT NULL,
p_active_duty_sepr_date spbpers.spbpers_active_duty_sepr_date%TYPE DEFAULT NULL,
p_data_origin spbpers.spbpers_data_origin%TYPE DEFAULT NULL,
p_user_id spbpers.spbpers_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_ethn_cde spbpers.spbpers_ethn_cde%TYPE DEFAULT NULL,
p_confirmed_re_cde spbpers.spbpers_confirmed_re_cde%TYPE DEFAULT NULL,
p_confirmed_re_date spbpers.spbpers_confirmed_re_date%TYPE DEFAULT NULL,
p_armed_serv_med_vet_ind spbpers.spbpers_armed_serv_med_vet_ind%TYPE DEFAULT NULL)
Validates all the data in the record.
|
|
p_pidm
|
Internal Identification Number of Person. NUMBER(8) Required Key
|
|
|
p_ssn
|
The person's social security number. VARCHAR2(9)
|
|
|
p_birth_date
|
The person's birth date. DATE
|
|
|
p_lgcy_code
|
The legacy code associated with the person. VARCHAR2(1)
|
|
|
p_ethn_code
|
The ethnicity code associated with the person. VARCHAR2(2)
|
|
|
p_mrtl_code
|
The martial status associated with the person. VARCHAR2(1)
|
|
|
p_relg_code
|
The religious affiliation associated with the person. VARCHAR2(2)
|
|
|
p_sex
|
Gender of the person. VARCHAR2(1)
|
|
M
|
Male
|
|
|
F
|
Female
|
|
|
N
|
Unknown
|
|
|
|
p_confid_ind
|
Confidentiality indicator. VARCHAR2(1)
|
|
null
|
Not confidential
|
|
|
Y
|
Confidential
|
|
|
|
p_dead_ind
|
Deceased indicator. VARCHAR2(1)
|
|
null
|
Not deceased
|
|
|
Y
|
Deceased
|
|
|
|
p_vetc_file_number
|
The veteran identification number associated with the person. VARCHAR2(10)
|
|
|
p_legal_name
|
The legal name associated with the person. VARCHAR2(60)
|
|
|
p_pref_first_name
|
Preferred first name associated with the person. VARCHAR2(15)
|
|
|
p_name_prefix
|
Prefix (Mr, Mrs, etc) used before person's name. VARCHAR2(20)
|
|
|
p_name_suffix
|
Suffix (Jr, Sr, etc) used after person's name. VARCHAR2(20)
|
|
|
p_vera_ind
|
Veteran Category. VARCHAR2(1)
|
|
null
|
None
|
|
|
O
|
Other Protected Veteran Only
|
|
|
V
|
Vietnam Veteran only
|
|
|
B
|
Both Vietnam and Other Eligible Veteran
|
|
|
|
p_citz_ind
|
Citizen Indicator. VARCHAR2(1)
|
|
|
p_dead_date
|
Person Deceased Date. DATE
|
|
|
p_citz_code
|
Person Citizen Type. VARCHAR2(2)
|
|
|
p_hair_code
|
The hair color of the person being defined. VARCHAR2(2)
|
|
|
p_eyes_code
|
The eye color of the person being defined. VARCHAR2(2)
|
|
|
p_city_birth
|
The City where the person was born. VARCHAR2(20)
|
|
|
p_stat_code_birth
|
The State in which the person was born. VARCHAR2(3)
|
|
|
p_driver_license
|
The Driver License Number as it appears on the actual license. VARCHAR2(20)
|
|
|
p_stat_code_driver
|
The State code describing the state the driver license was issued. VARCHAR2(3)
|
|
|
p_natn_code_driver
|
The Nation code associated with the Nation the Driver license was issued. VARCHAR2(5)
|
|
|
p_uoms_code_height
|
The Unit of Measure describing the height value. VARCHAR2(4)
|
|
|
p_height
|
The number value describing the height of the person. NUMBER(2)
|
|
|
p_uoms_code_weight
|
The Unit of Measure describing the weight value. VARCHAR2(4)
|
|
|
p_weight
|
The number value describing the weight of the person. NUMBER(4)
|
|
|
p_sdvet_ind
|
Indicator to identify an individual as a special disabled veteran. VARCHAR2(1)
|
|
|
p_license_issued_date
|
The issue date of the individual's driver license. DATE
|
|
|
p_license_expires_date
|
The expiration date of the individual's driver license. DATE
|
|
|
p_incar_ind
|
The indication of the individual's incarceration. VARCHAR2(1)
|
|
|
p_itin
|
The international tax id number. NUMBER(9)
|
|
|
p_active_duty_sepr_date
|
The date that the person was separated from active duty. DATE
|
|
|
p_data_origin
|
Source system that created or updated the row. VARCHAR2(30)
|
|
|
p_ethn_cde
|
The ethnic code defined by the United States government. VARCHAR2(1)
|
|
null
|
None
|
|
|
1
|
Not Hispanic or Latino
|
|
|
2
|
Hispanic or Latino
|
|
|
|
p_confirmed_re_cde
|
The race and ethnicity has been confirmed. VARCHAR2(1)
|
|
null
|
Not Confirmed
|
|
|
Y
|
Confirmed
|
|
|
N
|
Not Confirmed
|
|
|
|
p_confirmed_re_date
|
Date on which the race and ethnicity have been confirmed. DATE
|
|
|
p_armed_serv_med_vet_ind
|
Armed Forces Service Medal Indicator. VARCHAR2(1)
|
|
|
p_user_id
|
The Oracle User ID of the person who inserted or last updated the data. VARCHAR2(30)
|