|
Package rp_requirement This package provides the business process interface in support of the Requirements API (rb_requirement).This package includes those procedures and functions required in order to function as the business process API for requirements. There are three procedures defined: p_create, p_update and p_delete. In addition, there are three pass-through functions (f_exists, f_query_all and f_query_one) that call the corresponding functions in the rb_requirement package, returning the same data. |
| Program units |
| f_api_version | Returns the API version number. |
| f_exists | Checks to see if a record exists. |
| f_exists | Checks to see if a record exists. |
| f_exists | Checks to see if a record exists. |
| f_query_all | Selects all records for the entity. |
| f_query_all | Selects all records for the entity. |
| f_query_all | Selects all records for the entity. |
| f_query_one | Selects one record using key. |
| f_query_one | Selects one record using key. |
| f_query_one | Selects one record using key. |
| p_create | Creates a record. |
| p_create | Creates a record. |
| p_create | Creates a record. |
| p_delete | Deletes a record. |
| p_delete | Deletes a record. |
| p_delete | Deletes a record. |
| p_update | Updates a record. |
| p_update | Updates a record. |
| p_update | Updates a record. |
f_api_version
Function f_api_version RETURN PLS_INTEGER
Returns the API version number.
| Returns |
|
Version of the API signature. Changes only when the signature changes. |
f_exists
Function f_exists(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_period rrrareq.rrrareq_period%TYPE, -- 080900-1
p_term_code rrrareq.rrrareq_term_code%TYPE DEFAULT NULL, -- 080900-1
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks to see if a record exists.
Version 3 of the f_exists function.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_treq_desc |
The description of the one-time tracking requirement (i.e., a tracking requirement not associated with a tracking requirement code). VARCHAR2(60) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_period |
The period associated with the requirement. VARCHAR2(15) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) | |
| p_rowid |
Database ROWID of the record to be selected. VARCHAR2(18) |
| Returns |
|
Y if found, otherwise N. |
f_exists
Function f_exists(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_term_code rrrareq.rrrareq_term_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks to see if a record exists.
Version 2 of the f_exists function.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_treq_desc |
The description of the one-time tracking requirement (i.e., a tracking requirement not associated with a tracking requirement code). VARCHAR2(60) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) | |
| p_rowid |
Database ROWID of the record to be selected. VARCHAR2(18) |
| Returns |
|
Y if found, otherwise N. |
f_exists
Function f_exists(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks to see if a record exists.
Version 1 of the f_exists function.
For additional information, see Version 2 of the f_exists function.
f_query_all
Function f_query_all(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_period rrrareq.rrrareq_period%TYPE, -- 080900-1
p_term_code rrrareq.rrrareq_term_code%TYPE DEFAULT NULL)
RETURN rb_requirement.requirement_ref
Selects all records for the entity.
Version 3 of the f_query_all function.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_treq_desc |
The description of the one-time tracking requirement (i.e., a tracking requirement not associated with a tracking requirement code). VARCHAR2(60) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_period |
The period associated with the requirement. VARCHAR2(15) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
| Returns |
|
A cursor variable that will fetch the set of records. |
f_query_all
Function f_query_all(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_term_code rrrareq.rrrareq_term_code%TYPE)
RETURN rb_requirement.requirement_ref
Selects all records for the entity.
Version 2 of the f_query_all function.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_treq_desc |
The description of the one-time tracking requirement (i.e., a tracking requirement not associated with a tracking requirement code). VARCHAR2(60) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
| Returns |
|
A cursor variable that will fetch the set of records. |
f_query_all
Function f_query_all(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE)
RETURN rb_requirement.requirement_ref
Selects all records for the entity.
Version 1 of the f_query_all function.
For additional information, see Version 2 of the f_query_all function.
f_query_one
Function f_query_one(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_period rrrareq.rrrareq_period%TYPE, -- 080900-1
p_term_code rrrareq.rrrareq_term_code%TYPE DEFAULT NULL)
RETURN rb_requirement.requirement_ref
Selects one record using key.
Version 3 of the f_query_one function.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_treq_desc |
The description of the one-time tracking requirement (i.e., a tracking requirement not associated with a tracking requirement code). VARCHAR2(60) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_period |
The period associated with the requirement. VARCHAR2(15) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
| Returns |
|
A cursor variable that will fetch exactly one record. |
f_query_one
Function f_query_one(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_term_code rrrareq.rrrareq_term_code%TYPE)
RETURN rb_requirement.requirement_ref
Selects one record using key.
Version 2 of the f_query_one function.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_treq_desc |
The description of the one-time tracking requirement (i.e., a tracking requirement not associated with a tracking requirement code). VARCHAR2(60) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
| Returns |
|
A cursor variable that will fetch exactly one record. |
f_query_one
Function f_query_one(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_treq_desc rrrareq.rrrareq_treq_desc%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE)
RETURN rb_requirement.requirement_ref
Selects one record using key.
Version 1 of the f_query_one function.
For additional information, see Version 2 of the f_query_one function.
p_create
Procedure p_create(p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_pidm rrrareq.rrrareq_pidm%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_stat_date rrrareq.rrrareq_stat_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trst_code rrrareq.rrrareq_trst_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sys_ind rrrareq.rrrareq_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_period rrrareq.rrrareq_period%TYPE, -- 080900-1
p_term_code rrrareq.rrrareq_term_code%TYPE DEFAULT NULL)
Creates a record.
Version 3 of the p_create procedure.
This procedure will:
validate that aid year code value is present, valid and active
validate that PIDM value is present and valid
if necessary, insert a record into the applicant status table (RORSTAT) for the aid year and PIDM
if necessary, insert a record into the satisfactory academic progress rules table (RORSAPR) for the aid year and PIDM
insert a record to the mail table (GURMAIL) for the aid year and PIDM if a corresponding insert was made to RORSAPR
insert the requirement
perform summary requirement processing (including updates to the RORSTAT record)
| Parameters |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_stat_date |
The last date on which the status of this requirement was updated. DATE | |
| p_trst_code |
The status of the tracking requirement. VARCHAR2(1) | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sys_ind |
Indicates how the tracking requirement was created or updated. VARCHAR2(1) | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_period |
The period associated with the requirement. VARCHAR2(15) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
p_create
Procedure p_create(p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_pidm rrrareq.rrrareq_pidm%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_stat_date rrrareq.rrrareq_stat_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trst_code rrrareq.rrrareq_trst_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sys_ind rrrareq.rrrareq_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_term_code rrrareq.rrrareq_term_code%TYPE)
Creates a record.
Version 2 of the p_create procedure.
This procedure will:
validate that aid year code value is present, valid and active
validate that PIDM value is present and valid
if necessary, insert a record into the applicant status table (RORSTAT) for the aid year and PIDM
if necessary, insert a record into the satisfactory academic progress rules table (RORSAPR) for the aid year and PIDM
insert a record to the mail table (GURMAIL) for the aid year and PIDM if a corresponding insert was made to RORSAPR
insert the requirement
perform summary requirement processing (including updates to the RORSTAT record)
| Parameters |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_stat_date |
The last date on which the status of this requirement was updated. DATE | |
| p_trst_code |
The status of the tracking requirement. VARCHAR2(1) | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sys_ind |
Indicates how the tracking requirement was created or updated. VARCHAR2(1) | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
p_create
Procedure p_create(p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_pidm rrrareq.rrrareq_pidm%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_stat_date rrrareq.rrrareq_stat_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trst_code rrrareq.rrrareq_trst_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sys_ind rrrareq.rrrareq_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE)
Creates a record.
Version 1 of the p_create procedure.
For additional information, see Version 2 of the p_create procedure.
p_delete
Procedure p_delete(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_period rrrareq.rrrareq_period%TYPE, -- 080900-1
p_term_code rrrareq.rrrareq_term_code%TYPE DEFAULT NULL)
Deletes a record.
Version 3 of the p_delete procedure.
This procedure will:
delete the requirement
perform summary requirement processing (including updates to the RORSTAT record)
NOTE: The record to be deleted must be found in the key index using the parameter values supplied.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_period |
The period associated with the requirement. VARCHAR2(15) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
p_delete
Procedure p_delete(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_term_code rrrareq.rrrareq_term_code%TYPE)
Deletes a record.
Version 2 of the p_delete procedure.
This procedure will:
delete the requirement
perform summary requirement processing (including updates to the RORSTAT record)
NOTE: The record to be deleted must be found in the key index using the parameter values supplied.
| Parameters |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
p_delete
Procedure p_delete(p_pidm rrrareq.rrrareq_pidm%TYPE,
p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE)
Deletes a record.
Version 1 of the p_delete procedure.
For additional information, see Version 2 of the p_delete procedure.
p_update
Procedure p_update(p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_pidm rrrareq.rrrareq_pidm%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_stat_date rrrareq.rrrareq_stat_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trst_code rrrareq.rrrareq_trst_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sys_ind rrrareq.rrrareq_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_period rrrareq.rrrareq_period%TYPE, -- 080900-1
p_term_code rrrareq.rrrareq_term_code%TYPE DEFAULT dml_common.f_unspecified_string)
Updates a record.
Version 3 of the p_update procedure.
This procedure will:
update the requirement
perform summary requirement processing (including updates to the RORSTAT record)
NOTE: The record to be updated must be found in the key index using the parameter values supplied.
By design, this procedure will not allow updates to the key index columns (PIDM, aid year code, requirement code, fund code, requirement description and SBGI code).
| Parameters |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_stat_date |
The last date on which the status of this requirement was updated. DATE | |
| p_trst_code |
The status of the tracking requirement. VARCHAR2(1) | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sys_ind |
Indicates how the tracking requirement was created or updated. VARCHAR2(1) | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_period |
The period associated with the requirement. VARCHAR2(15) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
p_update
Procedure p_update(p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_pidm rrrareq.rrrareq_pidm%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_stat_date rrrareq.rrrareq_stat_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trst_code rrrareq.rrrareq_trst_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sys_ind rrrareq.rrrareq_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE,
p_sbgi_type_ind rrrareq.rrrareq_sbgi_type_ind%TYPE,
p_term_code rrrareq.rrrareq_term_code%TYPE)
Updates a record.
Version 2 of the p_update procedure.
This procedure will:
update the requirement
perform summary requirement processing (including updates to the RORSTAT record)
NOTE: The record to be updated must be found in the key index using the parameter values supplied.
By design, this procedure will not allow updates to the key index columns (PIDM, aid year code, requirement code, fund code, requirement description and SBGI code).
| Parameters |
| p_aidy_code |
The aid year to be associated with information in this record. VARCHAR2(4) Required Key | |
| p_pidm |
The internal system-generated student identification number for the student in this record. NUMBER(8) Required Key | |
| p_treq_code |
The code associated with the tracking requirement. VARCHAR2(6) Key | |
| p_stat_date |
The last date on which the status of this requirement was updated. DATE | |
| p_trst_code |
The status of the tracking requirement. VARCHAR2(1) | |
| p_fund_code |
The fund associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sys_ind |
Indicates how the tracking requirement was created or updated. VARCHAR2(1) | |
| p_sbgi_code |
The institution associated with the tracking requirement. VARCHAR2(6) Key | |
| p_sbgi_type_ind |
Identifies the type of the source or background institution. VARCHAR2(1) Key | |
| p_term_code |
The term associated with the accounts receivable indicator for the period. VARCHAR2(6) |
p_update
Procedure p_update(p_aidy_code rrrareq.rrrareq_aidy_code%TYPE,
p_pidm rrrareq.rrrareq_pidm%TYPE,
p_treq_code rrrareq.rrrareq_treq_code%TYPE,
p_stat_date rrrareq.rrrareq_stat_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trst_code rrrareq.rrrareq_trst_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_fund_code rrrareq.rrrareq_fund_code%TYPE,
p_sys_ind rrrareq.rrrareq_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sbgi_code rrrareq.rrrareq_sbgi_code%TYPE)
Updates a record.
Version 1 of the p_delete procedure.
For additional information, see Version 2 of the p_update procedure.