Package rp_award

Package rp_award_schedule

This package provides the business process interface for the Award Schedule Business Process API (rp_award_schedule).

This package includes those procedures and functions required in order to function as the business process API for award schedules.

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_award_schedule package, returning the same data.

Program units

f_api_version	Returns the API version number.
f_exists	Checks if a record exists.
f_exists	Checks if a record exists.
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.
p_create	Creates an Award Schedule record.
p_create	Creates an Award Schedule record.
p_delete	Deletes an Award Schedule record.
p_delete	Deletes an Award Schedule record.
p_update	Updates an Award Schedule record.
p_update	Updates an Award Schedule 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_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                  p_pidm      rpratrm.rpratrm_pidm%TYPE,
                  p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                  p_term_code rpratrm.rpratrm_term_code%TYPE,
                  p_rowid     gb_common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks if a record exists.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_exists

Function f_exists(p_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                  p_pidm      rpratrm.rpratrm_pidm%TYPE,
                  p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                  p_period    rpratrm.rpratrm_period%TYPE, -- 080900-1
                  p_term_code rpratrm.rpratrm_term_code%TYPE DEFAULT NULL, -- 080900-1
                  p_rowid     gb_common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks if a record exists.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_period	The period associated with the award schedule. VARCHAR2(15) Required Key
	p_term_code	The term code 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_query_all

Function f_query_all(p_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                     p_pidm      rpratrm.rpratrm_pidm%TYPE,
                     p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                     p_term_code rpratrm.rpratrm_term_code%TYPE)
  RETURN rb_award_schedule.award_schedule_ref

Selects all records for the entity.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6) Required Key

Returns

A cursor variable that will fetch a set of records.

f_query_all

Function f_query_all(p_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                     p_pidm      rpratrm.rpratrm_pidm%TYPE,
                     p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                     p_period    rpratrm.rpratrm_period%TYPE, -- 080900-1
                     p_term_code rpratrm.rpratrm_term_code%TYPE DEFAULT NULL)
  RETURN rb_award_schedule.award_schedule_ref

Selects all records for the entity.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_period	The period associated with the award schedule. VARCHAR2(15) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6)

Returns

A cursor variable that will fetch a set of records.

f_query_one

Function f_query_one(p_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                     p_pidm      rpratrm.rpratrm_pidm%TYPE,
                     p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                     p_term_code rpratrm.rpratrm_term_code%TYPE)
  RETURN rb_award_schedule.award_schedule_ref

Selects one record using key.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6) Required Key

Returns

A cursor variable that will fetch exactly one record.

f_query_one

Function f_query_one(p_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                     p_pidm      rpratrm.rpratrm_pidm%TYPE,
                     p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                     p_period    rpratrm.rpratrm_period%TYPE, -- 080900-1
                     p_term_code rpratrm.rpratrm_term_code%TYPE DEFAULT NULL)
  RETURN rb_award_schedule.award_schedule_ref

Selects one record using key.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_period	The period associated with the award schedule. VARCHAR2(15) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6)

Returns

A cursor variable that will fetch exactly one record.

p_create

Procedure p_create(p_aidy_code          rpratrm.rpratrm_aidy_code%TYPE,
                   p_pidm               rpratrm.rpratrm_pidm%TYPE,
                   p_fund_code          rpratrm.rpratrm_fund_code%TYPE,
                   p_period             rpratrm.rpratrm_period%TYPE, -- 080900-1
                   p_term_code          rpratrm.rpratrm_term_code%TYPE DEFAULT NULL, -- 080900-1
                   p_offer_amt          rpratrm.rpratrm_offer_amt%TYPE,
                   p_offer_date         rpratrm.rpratrm_offer_date%TYPE DEFAULT NULL,
                   p_memo_exp_date      rpratrm.rpratrm_memo_exp_date%TYPE DEFAULT NULL,
                   p_accept_amt         rpratrm.rpratrm_accept_amt%TYPE DEFAULT NULL,
                   p_accept_date        rpratrm.rpratrm_accept_date%TYPE DEFAULT NULL,
                   p_pckg_load_ind      rpratrm.rpratrm_pckg_load_ind%TYPE DEFAULT NULL,
                   p_nslds_ovrd_ind     rpratrm.rpratrm_nslds_ovrd_ind%TYPE DEFAULT NULL,
                   p_pell_awrd_load_opt rpratrm.rpratrm_pell_awrd_load_opt%TYPE DEFAULT NULL,
                   p_lock_ind           rpratrm.rpratrm_lock_ind%TYPE DEFAULT NULL,
                   p_cip_override_code  rpratrm.rpratrm_cip_override_code%TYPE DEFAULT NULL,
                   p_majr_override_code rpratrm.rpratrm_majr_override_code%TYPE DEFAULT NULL,
                   p_override_disb_rule rpratrm.rpratrm_override_disb_rule%TYPE DEFAULT NULL, -- 80000-1
                   p_awst_code          rpratrm.rpratrm_awst_code%TYPE DEFAULT NULL, -- 81801-1
                   p_awst_date          rpratrm.rpratrm_awst_date%TYPE DEFAULT NULL, -- 81801-1
                   p_offer_exp_date     rpratrm.rpratrm_offer_exp_date%TYPE DEFAULT NULL, -- 81801-1
                   p_bbay_code          rpratrm.rpratrm_bbay_code%TYPE DEFAULT NULL, -- 82201-1
                   p_aidy_code_funds    rpratrm.rpratrm_aidy_code_funds%TYPE DEFAULT NULL)

Creates an Award Schedule record.

Version 2 of the p_create procedure.
Includes the p_override_disb_rule parameter not found in Version 1.

The following are the minimum parameters required to create an award:
       P_AIDY_CODE
       P_PIDM
       P_FUND_CODE
       P_PERIOD
       P_OFFER_AMT

This procedure will:
     - If no corresponding Award exists on the Applicant Award Table (RPRAWRD).
         - If necessary, create an entry on the Applicant Status Table (RORSTAT).
         - Create an award on the Applicant Award Table (RPRAWRD).
         - If necessary, update the award letter indicator on the Applicant
            Status Table (RORSTAT).
         - Create the award schedule record in the Applicant Award Schedule
            Table (RPRATRM).
         - Update the corresponding fund record totals on the Fund Aid Year
            Specific Data (RFRASPC).
         - Create any related tracking requirements on the Applicant Requirements
            Table (RRRAREQ).
         - Create any promissory note requirements associated with the fund on
            the Promissory Note Requirement Table (RFRPROM) if the promissory
            note required indicator (RFRASPC_PROM_REQ_IND) = 'Y'.
         - Create a corresponding period record on the Applicant Award Disbursement
            Table (RPRADSB) if the disburse indicator for the fund
            (RFRASPC_DISBURSE_IND) = 'S' and the auto schedule indicator
            (RFRASPC_AUTO_SCHED_IND) = 'Y'.

     - If the corresponding Award exists in the Applicant Award Table (RPRAWRD).
         - Create the award schedule record in the Applicant Award Schedule
            Table (RPRATRM).
         - Maintain and update the award amounts on the Applicant Award Table
            (RPRAWRD) if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
         - Update the corresponding fund record totals on the Fund Aid Year
            Specific Data (RFRASPC) if the auto schedule indicator
            (RFRASPC_AUTO_SCHED_IND) = 'Y'.
         - Create any related tracking requirements on the Applicant Requirements
            Table (RRRAREQ).
         - Create any promissory note requirements associated with the fund on
            the Promissory Note Requirement Table (RFRPROM) if the promissory
            note required indicator (RFRASPC_PROM_REQ_IND) = 'Y'.
         - Create a corresponding period record on the Applicant Award Disbursement
            Table (RPRADSB) if the disburse indicator for the fund
            (RFRASPC_DISBURSE_IND) = 'S' and the auto schedule indicator
            (RFRASPC_AUTO_SCHED_IND) = 'Y'.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_period	The period associated with the award schedule. VARCHAR2(15) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6)
	p_offer_amt	The offered dollar amount of the award for the period. NUMBER(11,2) Required
	p_offer_date	The date the award was offered for the period. DATE Required
	p_memo_exp_date	The date the memo of this award for this period will be cancelled. DATE
	p_accept_amt	The accepted dollar amount of the award for this period. NUMBER(11,2)
	p_accept_date	The date the award was accepted for this period. DATE
	p_pckg_load_ind	The enrollment status for this period. VARCHAR2(1) Required
	p_nslds_ovrd_ind	Indicates the rules which have been overridden for the award for the period. VARCHAR2(1)
	p_pell_awrd_load_opt	The enrollment option used when the Pell award was packaged for the period. VARCHAR2(1)
	p_lock_ind	Indicates if the award has been locked for the period. VARCHAR2(1)
	p_cip_override_code	The Classification of Instructional Program Code for the program the student intends to major in if the school does not require students to declare a major by their junior year. VARCHAR2(6)
	p_override_disb_rule	Indicates whether the fund disbursement rule will be overriden when disbursing a fund to the student for a period. VARCHAR2(1) Required
	p_majr_override_code	The Major Code for the program the student intends to major in if the school does not require students to declare a major by their junior year. VARCHAR2(4)
	p_awst_code	The code associated with the curent status of the award schedule. VARCHAR2(4)
	p_awst_date	The date the award status was effective. DATE
	p_offer_exp_date	The expiration date of the award schedule offer. DATE

p_create

Procedure p_create(p_aidy_code          rpratrm.rpratrm_aidy_code%TYPE,
                   p_pidm               rpratrm.rpratrm_pidm%TYPE,
                   p_fund_code          rpratrm.rpratrm_fund_code%TYPE,
                   p_term_code          rpratrm.rpratrm_term_code%TYPE,
                   p_offer_amt          rpratrm.rpratrm_offer_amt%TYPE,
                   p_offer_date         rpratrm.rpratrm_offer_date%TYPE DEFAULT NULL,
                   p_memo_exp_date      rpratrm.rpratrm_memo_exp_date%TYPE DEFAULT NULL,
                   p_accept_amt         rpratrm.rpratrm_accept_amt%TYPE DEFAULT NULL,
                   p_accept_date        rpratrm.rpratrm_accept_date%TYPE DEFAULT NULL,
                   p_pckg_load_ind      rpratrm.rpratrm_pckg_load_ind%TYPE DEFAULT NULL,
                   p_nslds_ovrd_ind     rpratrm.rpratrm_nslds_ovrd_ind%TYPE DEFAULT NULL,
                   p_pell_awrd_load_opt rpratrm.rpratrm_pell_awrd_load_opt%TYPE DEFAULT NULL,
                   p_lock_ind           rpratrm.rpratrm_lock_ind%TYPE DEFAULT NULL,
                   p_cip_override_code  rpratrm.rpratrm_cip_override_code%TYPE DEFAULT NULL,
                   p_majr_override_code rpratrm.rpratrm_majr_override_code%TYPE DEFAULT NULL)

Creates an Award Schedule 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_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                   p_pidm      rpratrm.rpratrm_pidm%TYPE,
                   p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                   p_term_code rpratrm.rpratrm_term_code%TYPE)

Deletes an Award Schedule record.

The following are the minimum parameters required to delete an award:
       P_AIDY_CODE
       P_PIDM
       P_FUND_CODE
       P_TERM_CODE

This procedure will:
     - Delete the award schedule record on the Applicant Award Schedule
        Table (RPRATRM).
     - Maintain and update the award amounts on the Applicant Award Table (RPRAWRD)
        if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
     - Update the corresponding fund record totals on the Fund Aid Year Specific
        Data (RFRASPC) if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
     - Delete the corresponding period record on the Applicant Award Disbursement
        Table (RPRADSB).
     - Delete any promissory note requirements associated with the fund on the
        Promissory Note Requirement Table (RFRPROM) if the promissory note required
        indicator (RFRASPC_PROM_REQ_IND) = 'Y'.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6) Required Key

p_delete

Procedure p_delete(p_aidy_code rpratrm.rpratrm_aidy_code%TYPE,
                   p_pidm      rpratrm.rpratrm_pidm%TYPE,
                   p_fund_code rpratrm.rpratrm_fund_code%TYPE,
                   p_period    rpratrm.rpratrm_period%TYPE, -- 080900-1
                   p_term_code rpratrm.rpratrm_term_code%TYPE DEFAULT NULL)

Deletes an Award Schedule record.

The following are the minimum parameters required to delete an award:
       P_AIDY_CODE
       P_PIDM
       P_FUND_CODE
       P_PERIOD

This procedure will:
     - Delete the award schedule record on the Applicant Award Schedule
        Table (RPRATRM).
     - Maintain and update the award amounts on the Applicant Award Table (RPRAWRD)
        if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
     - Update the corresponding fund record totals on the Fund Aid Year Specific
        Data (RFRASPC) if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
     - Delete the corresponding period record on the Applicant Award Disbursement
        Table (RPRADSB).
     - Delete any promissory note requirements associated with the fund on the
        Promissory Note Requirement Table (RFRPROM) if the promissory note required
        indicator (RFRASPC_PROM_REQ_IND) = 'Y'.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_period	The period associated with the award schedule. VARCHAR2(15) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6)

p_update

Procedure p_update(p_aidy_code          rpratrm.rpratrm_aidy_code%TYPE,
                   p_pidm               rpratrm.rpratrm_pidm%TYPE,
                   p_fund_code          rpratrm.rpratrm_fund_code%TYPE,
                   p_period             rpratrm.rpratrm_period%TYPE, -- 080900-1
                   p_term_code          rpratrm.rpratrm_term_code%TYPE DEFAULT dml_common.f_unspecified_string, -- 080900-1
                   p_offer_amt          rpratrm.rpratrm_offer_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_offer_date         rpratrm.rpratrm_offer_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_memo_exp_date      rpratrm.rpratrm_memo_exp_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_accept_amt         rpratrm.rpratrm_accept_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_accept_date        rpratrm.rpratrm_accept_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_pckg_load_ind      rpratrm.rpratrm_pckg_load_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_nslds_ovrd_ind     rpratrm.rpratrm_nslds_ovrd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pell_awrd_load_opt rpratrm.rpratrm_pell_awrd_load_opt%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_lock_ind           rpratrm.rpratrm_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_cip_override_code  rpratrm.rpratrm_cip_override_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_majr_override_code rpratrm.rpratrm_majr_override_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_override_disb_rule rpratrm.rpratrm_override_disb_rule%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_awst_code          rpratrm.rpratrm_awst_code%TYPE DEFAULT dml_common.f_unspecified_string, -- 81801-1
                   p_awst_date          rpratrm.rpratrm_awst_date%TYPE DEFAULT dml_common.f_unspecified_date, -- 81801-1
                   p_offer_exp_date     rpratrm.rpratrm_offer_exp_date%TYPE DEFAULT dml_common.f_unspecified_date, -- 81801-1
                   p_bbay_code          rpratrm.rpratrm_bbay_code%TYPE DEFAULT dml_common.f_unspecified_string, -- 82201-1
                   p_aidy_code_funds    rpratrm.rpratrm_aidy_code_funds%TYPE DEFAULT dml_common.f_unspecified_string)

Updates an Award Schedule record.

Version 2 of the p_update procedure.
Includes the p_override_disb_rule parameter not found in Version 1.

The following are the minimum parameters required to create an award:
       P_AIDY_CODE
       P_PIDM
       P_FUND_CODE
       P_PERIOD

This procedure will:
     - Update the award schedule record in the Applicant Award Schedule
        Table (RPRATRM).
     - Maintain and update the award amounts on the Applicant Award Table (RPRAWRD)
        if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
     - Update the corresponding fund record totals on the Fund Aid Year Specific
        Data (RFRASPC) if the auto schedule indicator (RFRASPC_AUTO_SCHED_IND) = 'Y'.
     - Maintain any corresponding period records on the Applicant Award Disbursement
        Table (RPRADSB) if the disburse indicator for the fund
        (RFRASPC_DISBURSE_IND) = 'S' and the paid amount (RPRATRM_PAID_AMT) is null
        and the memo amount (RPRATRM_MEMO_AMT) is null and the authorize amount
        (RPRATRM_AUTHORIZE_AMT) is null.

If the award schedule is a Direct Loan (RFRASPC_DIRECT_LOAN_IND is not null), an Electronic Loan (RFRASPC_EL_IND is not null) or a Manual Loan (RFRASPC_MANUAL_LOAN_IND is not null), the award status cannot be updated.

If period awarding has not been enabled for the fund (RFRASPC_ENABLE_PERIOD_AWARDING = 'Y'), the award status must be of the same type as the award's award status.

If the award schedule is locked, the award status can be updated if the Award Status Updates When Locked Indicator is checked (ROBINST_UPD_LOCKED_AWARD_IND = 'Y'). Only the award status can be updated, the amount of the award cannot be updated.

Parameters

	p_aidy_code	The aid year associated with the award schedule. VARCHAR2(4) Required Key
	p_pidm	The internal system generated student identification number. NUMBER(8) Required Key
	p_fund_code	The fund code associated with the award schedule. VARCHAR2(6) Required Key
	p_period	The period associated with the award schedule. VARCHAR2(15) Required Key
	p_term_code	The term code associated with the accounts receivable indicator for the period. VARCHAR2(6)
	p_offer_amt	The offered dollar amount of the award for the period. NUMBER(11,2) Required
	p_offer_date	The date the award was offered for the period. DATE Required
	p_memo_exp_date	The date the memo of this award for this period will be cancelled. DATE
	p_accept_amt	The accepted dollar amount of the award for this period. NUMBER(11,2)
	p_accept_date	The date the award was accepted for this period. DATE
	p_pckg_load_ind	The enrollment status for this period. VARCHAR2(1) Required
	p_nslds_ovrd_ind	Indicates the rules which have been overridden for the award for the period. VARCHAR2(1)
	p_pell_awrd_load_opt	The enrollment option used when the Pell award was packaged for the period. VARCHAR2(1)
	p_lock_ind	Indicates if the award has been locked for the period. VARCHAR2(1)
	p_cip_override_code	The Classification of Instructional Program Code for the program the student intends to major in if the school does not require students to declare a major by their junior year. VARCHAR2(6)
	p_majr_override_code	The Major Code for the program the student intends to major in if the school does not require students to declare a major by their junior year. VARCHAR2(4)
	p_override_disb_rule	Indicates whether the fund disbursement rule will be overriden when disbursing a fund to the student for a period. VARCHAR2(1) Required
	p_awst_code	The code associated with the curent status of the award schedule. VARCHAR2(4)
	p_awst_date	The date the award status was effective. DATE
	p_offer_exp_date	The expiration date of the award schedule offer. DATE

p_update

Procedure p_update(p_aidy_code          rpratrm.rpratrm_aidy_code%TYPE,
                   p_pidm               rpratrm.rpratrm_pidm%TYPE,
                   p_fund_code          rpratrm.rpratrm_fund_code%TYPE,
                   p_term_code          rpratrm.rpratrm_term_code%TYPE,
                   p_offer_amt          rpratrm.rpratrm_offer_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_offer_date         rpratrm.rpratrm_offer_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_memo_exp_date      rpratrm.rpratrm_memo_exp_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_accept_amt         rpratrm.rpratrm_accept_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_accept_date        rpratrm.rpratrm_accept_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_pckg_load_ind      rpratrm.rpratrm_pckg_load_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_nslds_ovrd_ind     rpratrm.rpratrm_nslds_ovrd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pell_awrd_load_opt rpratrm.rpratrm_pell_awrd_load_opt%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_lock_ind           rpratrm.rpratrm_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_cip_override_code  rpratrm.rpratrm_cip_override_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_majr_override_code rpratrm.rpratrm_majr_override_code%TYPE DEFAULT dml_common.f_unspecified_string)

Updates an Award Schedule record.

Version 1 of the p_update procedure.
For additional information, see Version 2 of the p_update procedure.