|
Package ab_proposal_history_rules Support subprograms for the Proposal History API (ab_proposal_history). |
| 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 ambprph.ambprph_pidm%TYPE,
p_prop_code ambprph.ambprph_prop_code%TYPE,
p_seq_no ambprph.ambprph_seq_no%TYPE,
p_user_id ambprph.ambprph_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin ambprph.ambprph_data_origin%TYPE,
p_prst_code_chg_ind ambprph.ambprph_prst_code_chg_ind%TYPE,
p_prst_code ambprph.ambprph_prst_code%TYPE,
p_prst_date_chg_ind ambprph.ambprph_prst_date_chg_ind%TYPE,
p_prst_date ambprph.ambprph_prst_date%TYPE,
p_staff_pidm_chg_ind ambprph.ambprph_staff_pidm_chg_ind%TYPE,
p_staff_pidm ambprph.ambprph_staff_pidm%TYPE,
p_staff_iden_chg_ind ambprph.ambprph_staff_iden_chg_ind%TYPE,
p_staff_iden_code ambprph.ambprph_staff_iden_code%TYPE,
p_due_date_chg_ind ambprph.ambprph_due_date_chg_ind%TYPE,
p_due_date ambprph.ambprph_due_date%TYPE,
p_finance_code_chg_ind ambprph.ambprph_finance_code_chg_ind%TYPE,
p_finance_code ambprph.ambprph_finance_code%TYPE,
p_ask_amount_chg_ind ambprph.ambprph_ask_amount_chg_ind%TYPE,
p_ask_amount ambprph.ambprph_ask_amount%TYPE,
p_comment_chg_ind ambprph.ambprph_comment_chg_ind%TYPE,
p_comment ambprph.ambprph_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_seq_no |
The sequence number of the history for the Proposal. 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_prst_code_chg_ind |
Change indicator for the Status Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_code |
The Status Code of the Proposal for the Prospect. VARCHAR2(4) | |
| p_prst_date_chg_ind |
Change indicator for the Status Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_date |
The Date of the Proposal Status for the Prospect. DATE | |
| p_staff_pidm_chg_ind |
Change indicator for the Staff Internal ID, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_staff_pidm |
The internal system generated ID number of the Staff. NUMBER(8) | |
| p_staff_iden_chg_ind |
Change indicator for the Staff Identification Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_staff_iden_code |
The identification code of the Staff. VARCHAR2(20) | |
| p_due_date_chg_ind |
Change indicator for the Due Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_due_date |
The Due Date of the Proposal. DATE | |
| p_finance_code_chg_ind |
Change indicator for the Grant Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_finance_code |
Grant code associated from Banner Finance, not yet implemented. VARCHAR2(36) | |
| p_ask_amount_chg_ind |
Change indicator for the Ask Amount, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_ask_amount |
The Ask Amount for the Proposal for this prospect. NUMBER(13,2) | |
| p_comment_chg_ind |
Change indicator for the Proposal Comment, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_comment |
Free Format column for entry of Proposal Comments. CLOB | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
Procedure p_validate(p_pidm ambprph.ambprph_pidm%TYPE,
p_prop_code ambprph.ambprph_prop_code%TYPE,
p_seq_no ambprph.ambprph_seq_no%TYPE,
p_user_id ambprph.ambprph_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin ambprph.ambprph_data_origin%TYPE,
p_prst_code_chg_ind ambprph.ambprph_prst_code_chg_ind%TYPE DEFAULT NULL,
p_prst_code ambprph.ambprph_prst_code%TYPE DEFAULT NULL,
p_prst_date_chg_ind ambprph.ambprph_prst_date_chg_ind%TYPE DEFAULT NULL,
p_prst_date ambprph.ambprph_prst_date%TYPE DEFAULT NULL,
p_staff_pidm_chg_ind ambprph.ambprph_staff_pidm_chg_ind%TYPE DEFAULT NULL,
p_staff_pidm ambprph.ambprph_staff_pidm%TYPE DEFAULT NULL,
p_staff_iden_chg_ind ambprph.ambprph_staff_iden_chg_ind%TYPE DEFAULT NULL,
p_staff_iden_code ambprph.ambprph_staff_iden_code%TYPE DEFAULT NULL,
p_due_date_chg_ind ambprph.ambprph_due_date_chg_ind%TYPE DEFAULT NULL,
p_due_date ambprph.ambprph_due_date%TYPE DEFAULT NULL,
p_finance_code_chg_ind ambprph.ambprph_finance_code_chg_ind%TYPE DEFAULT NULL,
p_finance_code ambprph.ambprph_finance_code%TYPE DEFAULT NULL,
p_ask_amount_chg_ind ambprph.ambprph_ask_amount_chg_ind%TYPE DEFAULT NULL,
p_ask_amount ambprph.ambprph_ask_amount%TYPE DEFAULT NULL,
p_comment_chg_ind ambprph.ambprph_comment_chg_ind%TYPE DEFAULT NULL,
p_comment ambprph.ambprph_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_seq_no |
The sequence number of the history for the Proposal. 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_prst_code_chg_ind |
Change indicator for the Status Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_code |
The Status Code of the Proposal for the Prospect. VARCHAR2(4) | |
| p_prst_date_chg_ind |
Change indicator for the Status Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_prst_date |
The Date of the Proposal Status for the Prospect. DATE | |
| p_staff_pidm_chg_ind |
Change indicator for the Staff Internal ID, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_staff_pidm |
The internal system generated ID number of the Staff. NUMBER(8) | |
| p_staff_iden_chg_ind |
Change indicator for the Staff Identification Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_staff_iden_code |
The identification code of the Staff. VARCHAR2(20) | |
| p_due_date_chg_ind |
Change indicator for the Due Date, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_due_date |
The Due Date of the Proposal. DATE | |
| p_finance_code_chg_ind |
Change indicator for the Grant Code, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_finance_code |
Grant code associated from Banner Finance, not yet implemented. VARCHAR2(36) | |
| p_ask_amount_chg_ind |
Change indicator for the Ask Amount, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_ask_amount |
The Ask Amount for the Proposal for this prospect. NUMBER(13,2) | |
| p_comment_chg_ind |
Change indicator for the Proposal Comment, Y = changed, N = unchanged. VARCHAR2(4) | |
| p_comment |
Free Format column for entry of Proposal Comments. CLOB |