index

Package gb_visa_rules

Support subprograms for the VISA API (gb_visa).

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,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               gorvisa.gorvisa_pidm%TYPE,
                            p_seq_no             gorvisa.gorvisa_seq_no%TYPE,
                            p_vtyp_code          gorvisa.gorvisa_vtyp_code%TYPE,
                            p_visa_number        gorvisa.gorvisa_visa_number%TYPE,
                            p_natn_code_issue    gorvisa.gorvisa_natn_code_issue%TYPE,
                            p_viss_code          gorvisa.gorvisa_viss_code%TYPE,
                            p_visa_start_date    gorvisa.gorvisa_visa_start_date%TYPE,
                            p_visa_expire_date   gorvisa.gorvisa_visa_expire_date%TYPE,
                            p_entry_ind          gorvisa.gorvisa_entry_ind%TYPE,
                            p_user_id            gorvisa.gorvisa_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_visa_req_date      gorvisa.gorvisa_visa_req_date%TYPE,
                            p_visa_issue_date    gorvisa.gorvisa_visa_issue_date%TYPE,
                            p_pent_code          gorvisa.gorvisa_pent_code%TYPE,
                            p_no_entries         gorvisa.gorvisa_no_entries%TYPE,
                            p_data_origin        gorvisa.gorvisa_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_seq_no   A record sequence number. NUMBER(3) Required Key
p_vtyp_code   The type of Visa issued. VARCHAR2(2) Required Key
p_visa_number   A unique identification number assigned to a Visa. VARCHAR2(18)
p_natn_code_issue   The country code of the nation issuing the Visa. VARCHAR2(5)
p_viss_code   The agency authorizing the Visa. VARCHAR2(6)
p_visa_start_date   The date the Visa begins. DATE
p_visa_expire_date   The date the Visa expires. DATE
p_entry_ind   This field indicates whether the Visa is for entry into the country. VARCHAR2(1)
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30) Required
p_visa_req_date   The date the Visa was requested. DATE
p_visa_issue_date   The date the Visa was Issued. DATE
p_pent_code   The port of entry into the country. VARCHAR2(3)
p_no_entries   The number of entries into the country. VARCHAR2(2)
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             gorvisa.gorvisa_pidm%TYPE,
                     p_seq_no           gorvisa.gorvisa_seq_no%TYPE,
                     p_vtyp_code        gorvisa.gorvisa_vtyp_code%TYPE,
                     p_visa_number      gorvisa.gorvisa_visa_number%TYPE DEFAULT NULL,
                     p_natn_code_issue  gorvisa.gorvisa_natn_code_issue%TYPE DEFAULT NULL,
                     p_viss_code        gorvisa.gorvisa_viss_code%TYPE DEFAULT NULL,
                     p_visa_start_date  gorvisa.gorvisa_visa_start_date%TYPE DEFAULT NULL,
                     p_visa_expire_date gorvisa.gorvisa_visa_expire_date%TYPE DEFAULT NULL,
                     p_entry_ind        gorvisa.gorvisa_entry_ind%TYPE,
                     p_user_id          gorvisa.gorvisa_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_visa_req_date    gorvisa.gorvisa_visa_req_date%TYPE DEFAULT NULL,
                     p_visa_issue_date  gorvisa.gorvisa_visa_issue_date%TYPE DEFAULT NULL,
                     p_pent_code        gorvisa.gorvisa_pent_code%TYPE DEFAULT NULL,
                     p_no_entries       gorvisa.gorvisa_no_entries%TYPE DEFAULT NULL,
                     p_data_origin      gorvisa.gorvisa_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_pidm   Internal identification number. NUMBER(8) Required Key
p_seq_no   A record sequence number. NUMBER(3) Required Key
p_vtyp_code   The type of Visa issued. VARCHAR2(2) Required Key
p_visa_number   A unique identification number assigned to a Visa. VARCHAR2(18)
p_natn_code_issue   The country code of the nation issuing the Visa. VARCHAR2(5)
p_viss_code   The agency authorizing the Visa. VARCHAR2(6)
p_visa_start_date   The date the Visa begins. DATE
p_visa_expire_date   The date the Visa expires. DATE
p_entry_ind   This field indicates whether the Visa is for entry into the country. VARCHAR2(1)
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30) Required
p_visa_req_date   The date the Visa was requested. DATE
p_visa_issue_date   The date the Visa was Issued. DATE
p_pent_code   The port of entry into the country. VARCHAR2(3)
p_no_entries   The number of entries into the country. VARCHAR2(2)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)