Package sb_learnercurricstatus

Package sb_learnercurricstatus_rules

This package provides the support subprograms for the Learner Curriculum Status API (sb_learnercurricstatus).

The validation procedure is called by the API, but may be called directly by an application if data validation is needed prior to calling the API.
The API will always run the validation checks regardless.

Program units

p_register_entity

p_validate

p_register_entity

Procedure p_register_entity(
      p_operation_type            NUMBER,
      p_cact_code          sobcact.sobcact_cact_code%TYPE         ,
      p_active_ind         sobcact.sobcact_active_ind%TYPE        ,
      p_sys_req_ind        sobcact.sobcact_sys_req_ind%TYPE       ,
      p_user_id            sobcact.sobcact_user_id%TYPE
        DEFAULT gb_common.f_sct_user,
      p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache.
This signature registers all the parameters.

Parameters

p_cact_code

Activity status code for the curriculum. VARCHAR2(15) Required Key

p_active_ind

Curriculum Status indicator. VARCHAR2(1) Required

	Y	Curriculum is active.
	N	Curriculum is not active.

p_sys_req_ind

Curriculum active status system required indicator. VARCHAR2(1) Required

	Y	Data is required for the system.
	N	Data is not required for the system.

p_user_id

Oracle ID of the most recent user to create or update a record. VARCHAR2(30) Required

p_internal_record_id

Database ROWID. VARCHAR2(18) Required