BANINST1@S10B80

index

Package sb_pagefieldconfig_rules

Support subprograms for the Page And Field Configuration API (sb_pagefieldconfig).

Program units
p_register_entity   Register 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 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)

Register the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only, for 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_wspg_code          sorwscr.sorwscr_wspg_code%TYPE,
                            p_wsfd_code          sorwscr.sorwscr_wsfd_code%TYPE,
                            p_term_code_eff      sorwscr.sorwscr_term_code_eff%TYPE,
                            p_persona_cde        sorwscr.sorwscr_persona_cde%TYPE,
                            p_system_req_ind     sorwscr.sorwscr_system_req_ind%TYPE,
                            p_required_ind       sorwscr.sorwscr_required_ind%TYPE,
                            p_display_ind        sorwscr.sorwscr_display_ind%TYPE,
                            p_display_number     sorwscr.sorwscr_display_number%TYPE,
                            p_display_text       sorwscr.sorwscr_display_text%TYPE,
                            p_user_id            sorwscr.sorwscr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        sorwscr.sorwscr_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 all parameters.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_wspg_code   Code used to identify the page/panel that the configuration is applicable to. VARCHAR2(10) Required Key
p_wsfd_code   Code used to identify the page field configured. VARCHAR2(10) Required Key
p_term_code_eff   The term this configuration becomes effective. VARCHAR2(6) Required Key
p_persona_cde   The persona to which this configuration is applicable. Valid values are: 01=Anonymous, 02=Student, 03=Faculty, 04=Admin. VARCHAR2(2) Required Key
p_system_req_ind   Indicates if this is a system required record.  Valid values are (Y)es or (N)o. VARCHAR2(1) Required
p_required_ind   Indicates if the field is required to be displayed. Valid values are (Y)es or (N)o. VARCHAR2(1) Required
p_display_ind   Indicates if the field is displayed. Valid values are (Y)es or (N)o. VARCHAR2(1) Required
p_display_number   The order that the field displays on the page. NUMBER(4)
p_display_text   The text to display as the label for the field on the page. VARCHAR2(60) Optional
p_user_id   The user ID of the person who inserted or last updated this record. VARCHAR2(30)
p_data_origin   Source system that created or updated the data. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_wspg_code      sorwscr.sorwscr_wspg_code%TYPE,
                     p_wsfd_code      sorwscr.sorwscr_wsfd_code%TYPE,
                     p_term_code_eff  sorwscr.sorwscr_term_code_eff%TYPE,
                     p_persona_cde    sorwscr.sorwscr_persona_cde%TYPE,
                     p_system_req_ind sorwscr.sorwscr_system_req_ind%TYPE,
                     p_required_ind   sorwscr.sorwscr_required_ind%TYPE,
                     p_display_ind    sorwscr.sorwscr_display_ind%TYPE,
                     p_display_number sorwscr.sorwscr_display_number%TYPE DEFAULT NULL,
                     p_display_text   sorwscr.sorwscr_display_text%TYPE DEFAULT NULL,
                     p_user_id        sorwscr.sorwscr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin    sorwscr.sorwscr_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_wspg_code   Code used to identify the page/panel that the configuration is applicable to. VARCHAR2(10) Required Key
p_wsfd_code   Code used to identify the page field configured. VARCHAR2(10) Required Key
p_term_code_eff   The term this configuration becomes effective. VARCHAR2(6) Required Key
p_persona_cde   The persona to which this configuration is applicable. Valid values are: 01=Anonymous, 02=Student, 03=Faculty, 04=Admin. VARCHAR2(2) Required Key
p_system_req_ind   Indicates if this is a system required record.  Valid values are (Y)es or (N)o. VARCHAR2(1) Required
p_required_ind   Indicates if the field is required to be displayed. Valid values are (Y)es or (N)o. VARCHAR2(1) Required
p_display_ind   Indicates if the field is displayed. Valid values are (Y)es or (N)o. VARCHAR2(1) Required
p_display_number   The order that the field displays on the page. NUMBER(4)
p_display_text   The text to display as the label for the field on the page. VARCHAR2(60) Optional
p_user_id   The user ID of the person who inserted or last updated this record. VARCHAR2(30)
p_data_origin   Source system that created or updated the data. VARCHAR2(30)