index

Package ab_gift_auxl_hold

This package provides the Common Business interface for the Gift Auxiliary Hold API (ab_gift_auxl_hold).
 
Each pending gift can have one or more Auxiliary Values and Benefit or Premium Codes associated with it.  When the pending gift is pushed into the gift tables, the information in this table will be pushed to the Gift Auxiliary Value table (AGRGAUX).

When creating Gift Auxiliary Hold records, the combination of the ID Number and Gift Number must exist in the External Gift Detail Hold table (AGBGHLD).  If the Internal ID is supplied, the combination of the ID Number, Internal ID, and Gift Number must exist in the External Gift Detail Hold table (AGBGHLD).

Program units
f_api_version   Returns the API version number.
f_exists   Checks if a record exists.
f_isequal   Compares two records for equality.
f_query_all   Selects all records for the entity.
f_query_one   Selects one record using the key.
f_query_by_rowid   Selects one record using the ROWID.
f_query_one_lock   Selects one record and locks it.
p_create   Creates a record.
p_delete   Deletes a record.
p_lock   Locks a record.
p_update   Updates a record.

Types
gift_auxl_hold_rec   Business Entity record type
gift_auxl_hold_ref   Entity cursor variable type
gift_auxl_hold_tab   Entity table type

Constants
M_ENTITY_NAME   Business Entity name
M_BASE_TABLE_NAME   Base table name

M_ENTITY_NAME 

M_ENTITY_NAME        CONSTANT VARCHAR2(19) := 'GIFT_AUXL_HOLD';

Business Entity name

M_BASE_TABLE_NAME 

M_BASE_TABLE_NAME    CONSTANT VARCHAR2(7) := 'AGRAUXH';

Base table name

gift_auxl_hold_rec 

TYPE gift_auxl_hold_rec IS RECORD (
  r_id                      agrauxh.agrauxh_id%TYPE,
  r_gift_no                 agrauxh.agrauxh_gift_no%TYPE,
  r_auxl_code               agrauxh.agrauxh_auxl_code%TYPE,
  r_auxl_desc               agrauxh.agrauxh_auxl_desc%TYPE,
  r_dcpr_cost               agrauxh.agrauxh_dcpr_cost%TYPE,
  r_user_id                 agrauxh.agrauxh_user_id%TYPE,
  r_data_origin             agrauxh.agrauxh_data_origin%TYPE,
  r_auxl_value_date         agrauxh.agrauxh_auxl_value_date%TYPE,
  r_pidm                    agrauxh.agrauxh_pidm%TYPE,
  r_dcpr_code               agrauxh.agrauxh_dcpr_code%TYPE,
  r_issue_date              agrauxh.agrauxh_issue_date%TYPE,
  r_dcpr_value              agrauxh.agrauxh_dcpr_value%TYPE,
  r_desc                    agrauxh.agrauxh_desc%TYPE,
  r_acc_rej_ind             agrauxh.agrauxh_acc_rej_ind%TYPE,
  r_acc_rej_date            agrauxh.agrauxh_acc_rej_date%TYPE,
  r_donr_code               agrauxh.agrauxh_donr_code%TYPE,
  r_pref_clas               agrauxh.agrauxh_pref_clas%TYPE,
  r_deduct_for_taxes        agrauxh.agrauxh_deduct_for_taxes%TYPE,
  r_comment                 agrauxh.agrauxh_comment%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type

gift_auxl_hold_ref 

TYPE gift_auxl_hold_ref IS REF CURSOR RETURN gift_auxl_hold_rec;

Entity cursor variable type

gift_auxl_hold_tab 

TYPE gift_auxl_hold_tab IS TABLE OF gift_auxl_hold_rec INDEX BY BINARY_INTEGER;

Entity table type

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_rowid gb_common.internal_record_id_type)
  RETURN VARCHAR2

Checks if a record exists.

Parameters
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18)

Returns
Y if found, otherwise N.

f_isequal 

Function f_isequal(rec_one gift_auxl_hold_rec, rec_two gift_auxl_hold_rec)
  RETURN VARCHAR2

Compares two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.

Parameters
rec_one   The first record to compare. Type gift_auxl_hold_rec Required
rec_two   The second record to compare. Type gift_auxl_hold_rec Required

Returns
Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_query_all 

Function f_query_all(p_id               agrauxh.agrauxh_id%TYPE,
                     p_gift_no          agrauxh.agrauxh_gift_no%TYPE,
                     p_auxl_code        agrauxh.agrauxh_auxl_code%TYPE,
                     p_auxl_desc        agrauxh.agrauxh_auxl_desc%TYPE,
                     p_dcpr_cost        agrauxh.agrauxh_dcpr_cost%TYPE,
                     p_user_id          agrauxh.agrauxh_user_id%TYPE,
                     p_data_origin      agrauxh.agrauxh_data_origin%TYPE,
                     p_auxl_value_date  agrauxh.agrauxh_auxl_value_date%TYPE,
                     p_pidm             agrauxh.agrauxh_pidm%TYPE,
                     p_dcpr_code        agrauxh.agrauxh_dcpr_code%TYPE,
                     p_issue_date       agrauxh.agrauxh_issue_date%TYPE,
                     p_dcpr_value       agrauxh.agrauxh_dcpr_value%TYPE,
                     p_desc             agrauxh.agrauxh_desc%TYPE,
                     p_acc_rej_ind      agrauxh.agrauxh_acc_rej_ind%TYPE,
                     p_acc_rej_date     agrauxh.agrauxh_acc_rej_date%TYPE,
                     p_donr_code        agrauxh.agrauxh_donr_code%TYPE,
                     p_pref_clas        agrauxh.agrauxh_pref_clas%TYPE,
                     p_deduct_for_taxes agrauxh.agrauxh_deduct_for_taxes%TYPE,
                     p_comment          agrauxh.agrauxh_comment%TYPE)
  RETURN gift_auxl_hold_ref

Selects all records for the entity.

Parameters
p_id   Banner ID associated with the gift. VARCHAR2(36) Required
p_gift_no   The system assigned number for the gift. VARCHAR2(28) Required
p_auxl_code   Auxiliary code associated with the gift. VARCHAR2(20) Required
p_auxl_desc   Description for the auxiliary code for the gift. VARCHAR2(240) Required
p_dcpr_cost   Actual cost to institution of benefit/premium. NUMBER(11,2) Required
p_user_id   System maintained field specifying user name. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_auxl_value_date   Date the Auxiliary Value was determined. DATE Required
p_pidm   Internal system generated identification number. NUMBER(8)
p_dcpr_code   Benefit/premium associated with the gift. VARCHAR2(16)
p_issue_date   Date the benefit/premium was issued. DATE
p_dcpr_value   Market value of benefit/premium. NUMBER(11,2)
p_desc   Brief description of the benefit/premium. VARCHAR2(240)
p_acc_rej_ind   Indicator for whether benefit/premium was accepted/rejected. VARCHAR2(4)
p_acc_rej_date   Date benefit/premium was accepted/rejected. DATE
p_donr_code   Donor category code for ID associated with gift. VARCHAR2(16)
p_pref_clas   Preferred class year for ID. VARCHAR2(16)
p_deduct_for_taxes   Indicator for whether premium is to be deducted for taxes. VARCHAR2(4)
p_comment   Free format comment for associated amount/benefit/premium. CLOB

Returns
A cursor variable that will fetch a set of records.

f_query_one 

Function f_query_one(p_id               agrauxh.agrauxh_id%TYPE,
                     p_gift_no          agrauxh.agrauxh_gift_no%TYPE,
                     p_auxl_code        agrauxh.agrauxh_auxl_code%TYPE,
                     p_auxl_desc        agrauxh.agrauxh_auxl_desc%TYPE,
                     p_dcpr_cost        agrauxh.agrauxh_dcpr_cost%TYPE,
                     p_user_id          agrauxh.agrauxh_user_id%TYPE,
                     p_data_origin      agrauxh.agrauxh_data_origin%TYPE,
                     p_auxl_value_date  agrauxh.agrauxh_auxl_value_date%TYPE,
                     p_pidm             agrauxh.agrauxh_pidm%TYPE,
                     p_dcpr_code        agrauxh.agrauxh_dcpr_code%TYPE,
                     p_issue_date       agrauxh.agrauxh_issue_date%TYPE,
                     p_dcpr_value       agrauxh.agrauxh_dcpr_value%TYPE,
                     p_desc             agrauxh.agrauxh_desc%TYPE,
                     p_acc_rej_ind      agrauxh.agrauxh_acc_rej_ind%TYPE,
                     p_acc_rej_date     agrauxh.agrauxh_acc_rej_date%TYPE,
                     p_donr_code        agrauxh.agrauxh_donr_code%TYPE,
                     p_pref_clas        agrauxh.agrauxh_pref_clas%TYPE,
                     p_deduct_for_taxes agrauxh.agrauxh_deduct_for_taxes%TYPE,
                     p_comment          agrauxh.agrauxh_comment%TYPE)
  RETURN gift_auxl_hold_ref

Selects one record using the key.

Parameters
p_id   Banner ID associated with the gift. VARCHAR2(36) Required
p_gift_no   The system assigned number for the gift. VARCHAR2(28) Required
p_auxl_code   Auxiliary code associated with the gift. VARCHAR2(20) Required
p_auxl_desc   Description for the auxiliary code for the gift. VARCHAR2(240) Required
p_dcpr_cost   Actual cost to institution of benefit/premium. NUMBER(11,2) Required
p_user_id   System maintained field specifying user name. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_auxl_value_date   Date the Auxiliary Value was determined. DATE Required
p_pidm   Internal system generated identification number. NUMBER(8)
p_dcpr_code   Benefit/premium associated with the gift. VARCHAR2(16)
p_issue_date   Date the benefit/premium was issued. DATE
p_dcpr_value   Market value of benefit/premium. NUMBER(11,2)
p_desc   Brief description of the benefit/premium. VARCHAR2(240)
p_acc_rej_ind   Indicator for whether benefit/premium was accepted/rejected. VARCHAR2(4)
p_acc_rej_date   Date benefit/premium was accepted/rejected. DATE
p_donr_code   Donor category code for ID associated with gift. VARCHAR2(16)
p_pref_clas   Preferred class year for ID. VARCHAR2(16)
p_deduct_for_taxes   Indicator for whether premium is to be deducted for taxes. VARCHAR2(4)
p_comment   Free format comment for associated amount/benefit/premium. CLOB

Returns
A cursor variable that will fetch exactly one record.

f_query_by_rowid 

Function f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
  RETURN gift_auxl_hold_ref

Selects one record using the ROWID.

Parameters
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18) Required

Returns
A cursor variable that will fetch exactly one record.

f_query_one_lock 

Function f_query_one_lock(p_id               agrauxh.agrauxh_id%TYPE,
                          p_gift_no          agrauxh.agrauxh_gift_no%TYPE,
                          p_auxl_code        agrauxh.agrauxh_auxl_code%TYPE,
                          p_auxl_desc        agrauxh.agrauxh_auxl_desc%TYPE,
                          p_dcpr_cost        agrauxh.agrauxh_dcpr_cost%TYPE,
                          p_user_id          agrauxh.agrauxh_user_id%TYPE,
                          p_data_origin      agrauxh.agrauxh_data_origin%TYPE,
                          p_auxl_value_date  agrauxh.agrauxh_auxl_value_date%TYPE,
                          p_pidm             agrauxh.agrauxh_pidm%TYPE,
                          p_dcpr_code        agrauxh.agrauxh_dcpr_code%TYPE,
                          p_issue_date       agrauxh.agrauxh_issue_date%TYPE,
                          p_dcpr_value       agrauxh.agrauxh_dcpr_value%TYPE,
                          p_desc             agrauxh.agrauxh_desc%TYPE,
                          p_acc_rej_ind      agrauxh.agrauxh_acc_rej_ind%TYPE,
                          p_acc_rej_date     agrauxh.agrauxh_acc_rej_date%TYPE,
                          p_donr_code        agrauxh.agrauxh_donr_code%TYPE,
                          p_pref_clas        agrauxh.agrauxh_pref_clas%TYPE,
                          p_deduct_for_taxes agrauxh.agrauxh_deduct_for_taxes%TYPE,
                          p_comment          agrauxh.agrauxh_comment%TYPE,
                          p_rowid            gb_common.internal_record_id_type)
  RETURN gift_auxl_hold_ref

Selects one record and locks it.

Parameters
p_id   Banner ID associated with the gift. VARCHAR2(36) Required
p_gift_no   The system assigned number for the gift. VARCHAR2(28) Required
p_auxl_code   Auxiliary code associated with the gift. VARCHAR2(20) Required
p_auxl_desc   Description for the auxiliary code for the gift. VARCHAR2(240) Required
p_dcpr_cost   Actual cost to institution of benefit/premium. NUMBER(11,2) Required
p_user_id   System maintained field specifying user name. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_auxl_value_date   Date the Auxiliary Value was determined. DATE Required
p_pidm   Internal system generated identification number. NUMBER(8)
p_dcpr_code   Benefit/premium associated with the gift. VARCHAR2(16)
p_issue_date   Date the benefit/premium was issued. DATE
p_dcpr_value   Market value of benefit/premium. NUMBER(11,2)
p_desc   Brief description of the benefit/premium. VARCHAR2(240)
p_acc_rej_ind   Indicator for whether benefit/premium was accepted/rejected. VARCHAR2(4)
p_acc_rej_date   Date benefit/premium was accepted/rejected. DATE
p_donr_code   Donor category code for ID associated with gift. VARCHAR2(16)
p_pref_clas   Preferred class year for ID. VARCHAR2(16)
p_deduct_for_taxes   Indicator for whether premium is to be deducted for taxes. VARCHAR2(4)
p_comment   Free format comment for associated amount/benefit/premium. CLOB
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18)

Returns
A cursor variable for one record, locking the record.

p_create 

Procedure p_create(p_id               agrauxh.agrauxh_id%TYPE,
                   p_gift_no          agrauxh.agrauxh_gift_no%TYPE,
                   p_auxl_code        agrauxh.agrauxh_auxl_code%TYPE,
                   p_auxl_desc        agrauxh.agrauxh_auxl_desc%TYPE,
                   p_dcpr_cost        agrauxh.agrauxh_dcpr_cost%TYPE,
                   p_user_id          agrauxh.agrauxh_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin      agrauxh.agrauxh_data_origin%TYPE,
                   p_auxl_value_date  agrauxh.agrauxh_auxl_value_date%TYPE,
                   p_pidm             agrauxh.agrauxh_pidm%TYPE DEFAULT NULL,
                   p_dcpr_code        agrauxh.agrauxh_dcpr_code%TYPE DEFAULT NULL,
                   p_issue_date       agrauxh.agrauxh_issue_date%TYPE DEFAULT NULL,
                   p_dcpr_value       agrauxh.agrauxh_dcpr_value%TYPE DEFAULT NULL,
                   p_desc             agrauxh.agrauxh_desc%TYPE DEFAULT NULL,
                   p_acc_rej_ind      agrauxh.agrauxh_acc_rej_ind%TYPE DEFAULT NULL,
                   p_acc_rej_date     agrauxh.agrauxh_acc_rej_date%TYPE DEFAULT NULL,
                   p_donr_code        agrauxh.agrauxh_donr_code%TYPE DEFAULT NULL,
                   p_pref_clas        agrauxh.agrauxh_pref_clas%TYPE DEFAULT NULL,
                   p_deduct_for_taxes agrauxh.agrauxh_deduct_for_taxes%TYPE DEFAULT NULL,
                   p_comment          agrauxh.agrauxh_comment%TYPE DEFAULT NULL,
                   p_rowid_out        OUT gb_common.internal_record_id_type)

Creates a record.

Parameters
p_id   Banner ID associated with the gift. VARCHAR2(36) Required
p_gift_no   The system assigned number for the gift. VARCHAR2(28) Required
p_auxl_code   Auxiliary code associated with the gift. VARCHAR2(20) Required
p_auxl_desc   Description for the auxiliary code for the gift. VARCHAR2(240) Required
p_dcpr_cost   Actual cost to institution of benefit/premium. NUMBER(11,2) Required
p_user_id   System maintained field specifying user name. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_auxl_value_date   Date the Auxiliary Value was determined. DATE Required
p_pidm   Internal system generated identification number. NUMBER(8)
p_dcpr_code   Benefit/premium associated with the gift. VARCHAR2(16)
p_issue_date   Date the benefit/premium was issued. DATE
p_dcpr_value   Market value of benefit/premium. NUMBER(11,2)
p_desc   Brief description of the benefit/premium. VARCHAR2(240)
p_acc_rej_ind   Indicator for whether benefit/premium was accepted/rejected. VARCHAR2(4)
p_acc_rej_date   Date benefit/premium was accepted/rejected. DATE
p_donr_code   Donor category code for ID associated with gift. VARCHAR2(16)
p_pref_clas   Preferred class year for ID. VARCHAR2(16)
p_deduct_for_taxes   Indicator for whether premium is to be deducted for taxes. VARCHAR2(4)
p_comment   Free format comment for associated amount/benefit/premium. CLOB
p_rowid_out   Database ROWID of the record to be created. VARCHAR2(18) Required

p_delete 

Procedure p_delete(p_id               agrauxh.agrauxh_id%TYPE,
                   p_gift_no          agrauxh.agrauxh_gift_no%TYPE,
                   p_auxl_code        agrauxh.agrauxh_auxl_code%TYPE,
                   p_auxl_desc        agrauxh.agrauxh_auxl_desc%TYPE,
                   p_dcpr_cost        agrauxh.agrauxh_dcpr_cost%TYPE,
                   p_user_id          agrauxh.agrauxh_user_id%TYPE,
                   p_data_origin      agrauxh.agrauxh_data_origin%TYPE,
                   p_auxl_value_date  agrauxh.agrauxh_auxl_value_date%TYPE,
                   p_pidm             agrauxh.agrauxh_pidm%TYPE,
                   p_dcpr_code        agrauxh.agrauxh_dcpr_code%TYPE,
                   p_issue_date       agrauxh.agrauxh_issue_date%TYPE,
                   p_dcpr_value       agrauxh.agrauxh_dcpr_value%TYPE,
                   p_desc             agrauxh.agrauxh_desc%TYPE,
                   p_acc_rej_ind      agrauxh.agrauxh_acc_rej_ind%TYPE,
                   p_acc_rej_date     agrauxh.agrauxh_acc_rej_date%TYPE,
                   p_donr_code        agrauxh.agrauxh_donr_code%TYPE,
                   p_pref_clas        agrauxh.agrauxh_pref_clas%TYPE,
                   p_deduct_for_taxes agrauxh.agrauxh_deduct_for_taxes%TYPE,
                   p_comment          agrauxh.agrauxh_comment%TYPE,
                   p_rowid            gb_common.internal_record_id_type)

Deletes a record.

Parameters
p_id   Banner ID associated with the gift. VARCHAR2(36) Required
p_gift_no   The system assigned number for the gift. VARCHAR2(28) Required
p_auxl_code   Auxiliary code associated with the gift. VARCHAR2(20) Required
p_auxl_desc   Description for the auxiliary code for the gift. VARCHAR2(240) Required
p_dcpr_cost   Actual cost to institution of benefit/premium. NUMBER(11,2) Required
p_user_id   System maintained field specifying user name. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_auxl_value_date   Date the Auxiliary Value was determined. DATE Required
p_pidm   Internal system generated identification number. NUMBER(8)
p_dcpr_code   Benefit/premium associated with the gift. VARCHAR2(16)
p_issue_date   Date the benefit/premium was issued. DATE
p_dcpr_value   Market value of benefit/premium. NUMBER(11,2)
p_desc   Brief description of the benefit/premium. VARCHAR2(240)
p_acc_rej_ind   Indicator for whether benefit/premium was accepted/rejected. VARCHAR2(4)
p_acc_rej_date   Date benefit/premium was accepted/rejected. DATE
p_donr_code   Donor category code for ID associated with gift. VARCHAR2(16)
p_pref_clas   Preferred class year for ID. VARCHAR2(16)
p_deduct_for_taxes   Indicator for whether premium is to be deducted for taxes. VARCHAR2(4)
p_comment   Free format comment for associated amount/benefit/premium. CLOB
p_rowid   Database ROWID of the record to be deleted. VARCHAR2(18)

p_lock 

Procedure p_lock(p_rowid_inout IN OUT NOCOPY gb_common.internal_record_id_type)

Locks a record.
If the ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout.

Parameters
p_rowid_inout   Database ROWID of the record to be locked. VARCHAR2(18) Required

p_update 

Procedure p_update(p_id               agrauxh.agrauxh_id%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_gift_no          agrauxh.agrauxh_gift_no%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_auxl_code        agrauxh.agrauxh_auxl_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_auxl_desc        agrauxh.agrauxh_auxl_desc%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_dcpr_cost        agrauxh.agrauxh_dcpr_cost%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_user_id          agrauxh.agrauxh_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin      agrauxh.agrauxh_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_auxl_value_date  agrauxh.agrauxh_auxl_value_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_pidm             agrauxh.agrauxh_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_dcpr_code        agrauxh.agrauxh_dcpr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_issue_date       agrauxh.agrauxh_issue_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_dcpr_value       agrauxh.agrauxh_dcpr_value%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_desc             agrauxh.agrauxh_desc%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_acc_rej_ind      agrauxh.agrauxh_acc_rej_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_acc_rej_date     agrauxh.agrauxh_acc_rej_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_donr_code        agrauxh.agrauxh_donr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pref_clas        agrauxh.agrauxh_pref_clas%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_deduct_for_taxes agrauxh.agrauxh_deduct_for_taxes%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_comment          agrauxh.agrauxh_comment%TYPE DEFAULT dml_common.f_unspecified_clob,
                   p_rowid            gb_common.internal_record_id_type)

Updates a record.

Parameters
p_id   Banner ID associated with the gift. VARCHAR2(36) Required
p_gift_no   The system assigned number for the gift. VARCHAR2(28) Required
p_auxl_code   Auxiliary code associated with the gift. VARCHAR2(20) Required
p_auxl_desc   Description for the auxiliary code for the gift. VARCHAR2(240) Required
p_dcpr_cost   Actual cost to institution of benefit/premium. NUMBER(11,2) Required
p_user_id   System maintained field specifying user name. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_auxl_value_date   Date the Auxiliary Value was determined. DATE Required
p_pidm   Internal system generated identification number. NUMBER(8)
p_dcpr_code   Benefit/premium associated with the gift. VARCHAR2(16)
p_issue_date   Date the benefit/premium was issued. DATE
p_dcpr_value   Market value of benefit/premium. NUMBER(11,2)
p_desc   Brief description of the benefit/premium. VARCHAR2(240)
p_acc_rej_ind   Indicator for whether benefit/premium was accepted/rejected. VARCHAR2(4)
p_acc_rej_date   Date benefit/premium was accepted/rejected. DATE
p_donr_code   Donor category code for ID associated with gift. VARCHAR2(16)
p_pref_clas   Preferred class year for ID. VARCHAR2(16)
p_deduct_for_taxes   Indicator for whether premium is to be deducted for taxes. VARCHAR2(4)
p_comment   Free format comment for associated amount/benefit/premium. CLOB
p_rowid   Database ROWID of the record to be updated. VARCHAR2(18)