|
Package gb_medical_rules This package provides support for messaging and data validation for the MEDICAL API (gb_medical). |
| Program units |
| 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.
| Parameters |
| p_operation_type |
Type of DML operation: create, update, or delete. NUMBER Required | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_register_entity
PROCEDURE p_register_entity(p_operation_type NUMBER,
p_pidm sprmedi.sprmedi_pidm%TYPE,
p_medi_code sprmedi.sprmedi_medi_code%TYPE,
p_mdeq_code sprmedi.sprmedi_mdeq_code%TYPE,
p_comment sprmedi.sprmedi_comment%TYPE,
p_disa_code sprmedi.sprmedi_disa_code%TYPE,
p_spsr_code sprmedi.sprmedi_spsr_code%TYPE,
p_onset_age sprmedi.sprmedi_onset_age%TYPE,
p_disb_ind sprmedi.sprmedi_disb_ind%TYPE,
p_user_id sprmedi.sprmedi_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_medi_code_date sprmedi.sprmedi_medi_code_date%TYPE,
p_data_origin sprmedi.sprmedi_data_origin%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 the all parameters.
| Parameters |
| p_operation_type |
Type of DML operation: create, update, or delete. NUMBER Required | |
| p_pidm |
Internal identification number. NUMBER(8) Required Key | |
| p_medi_code |
The medical code representing the person's medical condition or physical impairment. The code must be previously defined on the Medical Code Validation table. VARCHAR2(10) Required Key | |
| p_mdeq_code |
The medical equipment code representing what equipment is necessary to respond to the person's medical condition or physical impairment. The code must be previously defined on the Medical Equipment Code Validation table. VARCHAR2(3) | |
| p_comment |
Freeform comment related to the person's medical condition or physical impairment. VARCHAR2(4000) | |
| p_disa_code |
The disability type code representing the nature of the person's medical condition or physical impairment. The code must be previously defined on the Disability Type Code Validation table. VARCHAR2(2) | |
| p_spsr_code |
The disability service code representing services available to the person. The code must be previously defined on the Disability Service Validation table. VARCHAR2(2) | |
| p_onset_age |
The age at which the person developed medical condition or physical impairment. NUMBER(2) | |
| p_disb_ind |
Indicates if the person's medical condition or physical impairment is their primary disability. Only one primary disability is allowed per person. VARCHAR2(1) | |
| p_user_id |
The Oracle ID of the user who changed the record. VARCHAR2(30) | |
| p_medi_code_date |
Date associated with the Medical Code. DATE | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_pidm sprmedi.sprmedi_pidm%TYPE,
p_medi_code sprmedi.sprmedi_medi_code%TYPE,
p_mdeq_code sprmedi.sprmedi_mdeq_code%TYPE DEFAULT NULL,
p_comment sprmedi.sprmedi_comment%TYPE DEFAULT NULL,
p_disa_code sprmedi.sprmedi_disa_code%TYPE DEFAULT NULL,
p_spsr_code sprmedi.sprmedi_spsr_code%TYPE DEFAULT NULL,
p_onset_age sprmedi.sprmedi_onset_age%TYPE DEFAULT NULL,
p_disb_ind sprmedi.sprmedi_disb_ind%TYPE DEFAULT NULL,
p_user_id sprmedi.sprmedi_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_medi_code_date sprmedi.sprmedi_medi_code_date%TYPE DEFAULT NULL,
p_data_origin sprmedi.sprmedi_data_origin%TYPE DEFAULT NULL,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_pidm |
Internal identification number. NUMBER(8) Required Key | |
| p_medi_code |
The medical code representing the person's medical condition or physical impairment. The code must be previously defined on the Medical Code Validation table. VARCHAR2(10) Required Key | |
| p_mdeq_code |
The medical equipment code representing what equipment is necessary to respond to the person's medical condition or physical impairment. The code must be previously defined on the Medical Equipment Code Validation table. VARCHAR2(3) | |
| p_comment |
Freeform comment related to the person's medical condition or physical impairment. VARCHAR2(4000) | |
| p_disa_code |
The disability type code representing the nature of the person's medical condition or physical impairment. The code must be previously defined on the Disability Type Code Validation table. VARCHAR2(2) | |
| p_spsr_code |
The disability service code representing services available to the person. The code must be previously defined on the Disability Service Validation table. VARCHAR2(2) | |
| p_onset_age |
The age at which the person developed medical condition or physical impairment. NUMBER(2) | |
| p_disb_ind |
Indicates if the person's medical condition or physical impairment is their primary disability. Only one primary disability is allowed per person. VARCHAR2(1) | |
| p_user_id |
The Oracle ID of the user who changed the record. VARCHAR2(30) | |
| p_medi_code_date |
Date associated with the Medical Code. DATE | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) |