|
Package ab_project_history_rules Support subprograms for the Project History API(ab_project_history). |
| Program units |
| f_parent_exists | |
| 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. |
f_parent_exists
Function f_parent_exists(p_pidm amrprph.amrprph_pidm%TYPE,
p_prop_code amrprph.amrprph_prop_code%TYPE,
p_prop_seq_no amrprph.amrprph_prop_seq_no%TYPE,
p_proj_code amrprph.amrprph_proj_code%TYPE)
RETURN VARCHAR2
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 amrprph.amrprph_pidm%TYPE,
p_prop_code amrprph.amrprph_prop_code%TYPE,
p_prop_seq_no amrprph.amrprph_prop_seq_no%TYPE,
p_proj_code amrprph.amrprph_proj_code%TYPE,
p_seq_no amrprph.amrprph_seq_no%TYPE,
p_user_id amrprph.amrprph_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin amrprph.amrprph_data_origin%TYPE,
p_givh_code_chg_ind amrprph.amrprph_givh_code_chg_ind%TYPE,
p_givh_code amrprph.amrprph_givh_code%TYPE,
p_target_ask_amt_chg_ind amrprph.amrprph_target_ask_amt_chg_ind%TYPE,
p_target_ask_amount amrprph.amrprph_target_ask_amount%TYPE,
p_target_ask_dte_chg_ind amrprph.amrprph_target_ask_dte_chg_ind%TYPE,
p_target_ask_date amrprph.amrprph_target_ask_date%TYPE,
p_prst_code_chg_ind amrprph.amrprph_prst_code_chg_ind%TYPE,
p_prst_code amrprph.amrprph_prst_code%TYPE,
p_prst_date_chg_ind amrprph.amrprph_prst_date_chg_ind%TYPE,
p_prst_date amrprph.amrprph_prst_date%TYPE,
p_proj_from_date_chg_ind amrprph.amrprph_proj_from_date_chg_ind%TYPE,
p_proj_eff_from_date amrprph.amrprph_proj_eff_from_date%TYPE,
p_proj_to_date_chg_ind amrprph.amrprph_proj_to_date_chg_ind%TYPE,
p_proj_eff_to_date amrprph.amrprph_proj_eff_to_date%TYPE,
p_proj_text_chg_ind amrprph.amrprph_proj_text_chg_ind%TYPE,
p_proj_text amrprph.amrprph_proj_text%TYPE,
p_frbprop_code_chg_ind amrprph.amrprph_frbprop_code_chg_ind%TYPE,
p_frbprop_code amrprph.amrprph_frbprop_code%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 associated to the Prospect. VARCHAR2(24) Required Key | |
| p_prop_seq_no |
The sequence number of the Proposal code which is associated to the Prospect. VARCHAR2(24) 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 history for the Project. 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_givh_code_chg_ind |
Change indicator for the Giving Vehicle Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_givh_code |
The Giving Vehicle Code for the Proposal/Project. VARCHAR2(8) | |
| p_target_ask_amt_chg_ind |
Change indicator for the Target Ask Amount, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_target_ask_amount |
The desired Asking Amount for the Proposal/Project. NUMBER(11,2) | |
| p_target_ask_dte_chg_ind |
Change indicator for the Target Ask Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_target_ask_date |
The Date the desired Amount was asked. DATE | |
| p_prst_code_chg_ind |
Change indicator for the Project Status, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_code |
The Status of the project for the prospect. VARCHAR2(4) | |
| p_prst_date_chg_ind |
Change indicator for the Project Status Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_date |
The Date of the project status for the prospect. DATE | |
| p_proj_from_date_chg_ind |
Change indicator for the Project Effective Begin Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_proj_eff_from_date |
The Begin date that the project is effective. DATE | |
| p_proj_to_date_chg_ind |
Change indicator for the Project Effective End Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_proj_eff_to_date |
The End date that the project is effective. DATE | |
| p_proj_text_chg_ind |
Change indicator for the Project Text, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_proj_text |
Free format Text about the project. VARCHAR2(4000) | |
| p_frbprop_code |
Finance Proposal Code for the project. VARCHAR2(9) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) Required |
p_validate
Procedure p_validate(p_pidm amrprph.amrprph_pidm%TYPE,
p_prop_code amrprph.amrprph_prop_code%TYPE,
p_prop_seq_no amrprph.amrprph_prop_seq_no%TYPE,
p_proj_code amrprph.amrprph_proj_code%TYPE,
p_seq_no amrprph.amrprph_seq_no%TYPE,
p_user_id amrprph.amrprph_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin amrprph.amrprph_data_origin%TYPE,
p_givh_code_chg_ind amrprph.amrprph_givh_code_chg_ind%TYPE DEFAULT NULL,
p_givh_code amrprph.amrprph_givh_code%TYPE DEFAULT NULL,
p_target_ask_amt_chg_ind amrprph.amrprph_target_ask_amt_chg_ind%TYPE DEFAULT NULL,
p_target_ask_amount amrprph.amrprph_target_ask_amount%TYPE DEFAULT NULL,
p_target_ask_dte_chg_ind amrprph.amrprph_target_ask_dte_chg_ind%TYPE DEFAULT NULL,
p_target_ask_date amrprph.amrprph_target_ask_date%TYPE DEFAULT NULL,
p_prst_code_chg_ind amrprph.amrprph_prst_code_chg_ind%TYPE DEFAULT NULL,
p_prst_code amrprph.amrprph_prst_code%TYPE DEFAULT NULL,
p_prst_date_chg_ind amrprph.amrprph_prst_date_chg_ind%TYPE DEFAULT NULL,
p_prst_date amrprph.amrprph_prst_date%TYPE DEFAULT NULL,
p_proj_from_date_chg_ind amrprph.amrprph_proj_from_date_chg_ind%TYPE DEFAULT NULL,
p_proj_eff_from_date amrprph.amrprph_proj_eff_from_date%TYPE DEFAULT NULL,
p_proj_to_date_chg_ind amrprph.amrprph_proj_to_date_chg_ind%TYPE DEFAULT NULL,
p_proj_eff_to_date amrprph.amrprph_proj_eff_to_date%TYPE DEFAULT NULL,
p_proj_text_chg_ind amrprph.amrprph_proj_text_chg_ind%TYPE DEFAULT NULL,
p_proj_text amrprph.amrprph_proj_text%TYPE DEFAULT NULL,
p_frbprop_code_chg_ind amrprph.amrprph_frbprop_code_chg_ind%TYPE DEFAULT NULL,
p_frbprop_code amrprph.amrprph_frbprop_code%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 associated to the Prospect. VARCHAR2(24) Required Key | |
| p_prop_seq_no |
The sequence number of the Proposal code which is associated to the Prospect. VARCHAR2(24) 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 history for the Project. 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_givh_code_chg_ind |
Change indicator for the Giving Vehicle Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_givh_code |
The Giving Vehicle Code for the Proposal/Project. VARCHAR2(8) | |
| p_target_ask_amt_chg_ind |
Change indicator for the Target Ask Amount, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_target_ask_amount |
The desired Asking Amount for the Proposal/Project. NUMBER(11,2) | |
| p_target_ask_dte_chg_ind |
Change indicator for the Target Ask Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_target_ask_date |
The Date the desired Amount was asked. DATE | |
| p_prst_code_chg_ind |
Change indicator for the Project Status, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_code |
The Status of the project for the prospect. VARCHAR2(4) | |
| p_prst_date_chg_ind |
Change indicator for the Project Status Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_date |
The Date of the project status for the prospect. DATE | |
| p_proj_from_date_chg_ind |
Change indicator for the Project Effective Begin Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_proj_eff_from_date |
The Begin date that the project is effective. DATE | |
| p_proj_to_date_chg_ind |
Change indicator for the Project Effective End Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_proj_eff_to_date |
The End date that the project is effective. DATE | |
| p_proj_text_chg_ind |
Change indicator for the Project Text, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_proj_text |
Free format Text about the project. VARCHAR2(4000) | |
| p_frbprop_code |
Finance Proposal Code for the project. VARCHAR2(9) |