index

Package ab_project_results_rules

Support subprograms for the PROJECT_RESULTS (ab_project_results).

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

Registers 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_pidm               amrprrs.amrprrs_pidm%TYPE,
                            p_prop_code          amrprrs.amrprrs_prop_code%TYPE,
                            p_prop_seq_no        amrprrs.amrprrs_prop_seq_no%TYPE,
                            p_proj_code          amrprrs.amrprrs_proj_code%TYPE,
                            p_seq_no             amrprrs.amrprrs_seq_no%TYPE,
                            p_user_id            amrprrs.amrprrs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        amrprrs.amrprrs_data_origin%TYPE,
                            p_result_date        amrprrs.amrprrs_result_date%TYPE,
                            p_gift_no            amrprrs.amrprrs_gift_no%TYPE,
                            p_pledge_no          amrprrs.amrprrs_pledge_no%TYPE,
                            p_campaign           amrprrs.amrprrs_campaign%TYPE,
                            p_desg               amrprrs.amrprrs_desg%TYPE,
                            p_value              amrprrs.amrprrs_value%TYPE,
                            p_comment            amrprrs.amrprrs_comment%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_pidm   The internal system generated ID number of a Prospect. NUMBER(8) Required Key
p_prop_code   The Proposal code which is being associated to the Prospect. VARCHAR2(24) Required Key
p_prop_seq_no   The sequence number of the Proposal record. NUMBER(3) Required Key
p_proj_code   The Project code which is being associated to the Proposal. VARCHAR2(24) Required Key
p_seq_no   The sequence number of the result record. NUMBER(3) Required Key
p_user_id   User ID of the person who created/updated the record. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_result_date   Date the result was recorded. DATE Required
p_gift_no   The Gift Number associated with the result. VARCHAR2(28)
p_pledge_no   The Pledge Number associated with the result. VARCHAR2(28)
p_campaign   The Campaign associated with the result. VARCHAR2(20)
p_desg   The Designation associated with the result. VARCHAR2(40)
p_value   The value of the result. NUMBER(17,2)
p_comment   The comment associated with the result. VARCHAR2(4000)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_pidm        amrprrs.amrprrs_pidm%TYPE,
                     p_prop_code   amrprrs.amrprrs_prop_code%TYPE,
                     p_prop_seq_no amrprrs.amrprrs_prop_seq_no%TYPE,
                     p_proj_code   amrprrs.amrprrs_proj_code%TYPE,
                     p_seq_no      amrprrs.amrprrs_seq_no%TYPE,
                     p_user_id     amrprrs.amrprrs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin amrprrs.amrprrs_data_origin%TYPE,
                     p_result_date amrprrs.amrprrs_result_date%TYPE,
                     p_gift_no     amrprrs.amrprrs_gift_no%TYPE DEFAULT NULL,
                     p_pledge_no   amrprrs.amrprrs_pledge_no%TYPE DEFAULT NULL,
                     p_campaign    amrprrs.amrprrs_campaign%TYPE DEFAULT NULL,
                     p_desg        amrprrs.amrprrs_desg%TYPE DEFAULT NULL,
                     p_value       amrprrs.amrprrs_value%TYPE DEFAULT NULL,
                     p_comment     amrprrs.amrprrs_comment%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_pidm   The internal system generated ID number of a Prospect. NUMBER(8) Required Key
p_prop_code   The Proposal code which is being associated to the Prospect. VARCHAR2(24) Required Key
p_prop_seq_no   The sequence number of the Proposal record. NUMBER(3) Required Key
p_proj_code   The Project code which is being associated to the Proposal. VARCHAR2(24) Required Key
p_seq_no   The sequence number of the result record. NUMBER(3) Required Key
p_user_id   User ID of the person who created/updated the record. VARCHAR2(120) Required
p_data_origin   System maintained field specifying the origin of the data. VARCHAR2(120) Required
p_result_date   Date the result was recorded. DATE Required
p_gift_no   The Gift Number associated with the result. VARCHAR2(28)
p_pledge_no   The Pledge Number associated with the result. VARCHAR2(28)
p_campaign   The Campaign associated with the result. VARCHAR2(20)
p_desg   The Designation associated with the result. VARCHAR2(40)
p_value   The value of the result. NUMBER(17,2)
p_comment   The comment associated with the result. VARCHAR2(4000)