|
Package gb_payment_rules Support subprograms for the PAYMENT (gb_payment). |
| 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_id gorccau.gorccau_id%TYPE,
p_pidm gorccau.gorccau_pidm%TYPE,
p_term_code gorccau.gorccau_term_code%TYPE,
p_location gorccau.gorccau_location%TYPE,
p_detail gorccau.gorccau_detail%TYPE,
p_street_line1 gorccau.gorccau_street_line1%TYPE,
p_street_line2 gorccau.gorccau_street_line2%TYPE,
p_stat_code gorccau.gorccau_stat_code%TYPE,
p_zip gorccau.gorccau_zip%TYPE,
p_natn_code gorccau.gorccau_natn_code%TYPE,
p_merchant_id gorccau.gorccau_merchant_id%TYPE,
p_debug_msg gorccau.gorccau_debug_msg%TYPE,
p_status gorccau.gorccau_status%TYPE,
p_street_line3 gorccau.gorccau_street_line3%TYPE,
p_street_line4 gorccau.gorccau_street_line4%TYPE,
p_pay_trans_id gorccau.gorccau_pay_trans_id%TYPE,
p_vendor_status gorccau.gorccau_vendor_status%TYPE,
p_banner_status gorccau.gorccau_banner_status%TYPE,
p_vendor_error_msg gorccau.gorccau_vendor_error_msg%TYPE,
p_application_data gorccau.gorccau_application_data%TYPE,
p_update_function gorccau.gorccau_update_function%TYPE,
p_success_url gorccau.gorccau_success_url%TYPE,
p_failure_url gorccau.gorccau_failure_url%TYPE,
p_vendor_auth_code gorccau.gorccau_vendor_auth_code%TYPE,
p_last_name gorccau.gorccau_last_name%TYPE,
p_first_name gorccau.gorccau_first_name%TYPE,
p_middle_name gorccau.gorccau_middle_name%TYPE,
p_surname_prefix gorccau.gorccau_surname_prefix%TYPE,
p_name_prefix gorccau.gorccau_name_prefix%TYPE,
p_name_suffix gorccau.gorccau_name_suffix%TYPE,
p_sub_code gorccau.gorccau_sub_code%TYPE,
p_proc_code gorccau.gorccau_proc_code%TYPE,
p_sysi_code gorccau.gorccau_sysi_code%TYPE,
p_appl_no gorccau.gorccau_appl_no%TYPE,
p_city gorccau.gorccau_city%TYPE,
p_house_number gorccau.gorccau_house_number%TYPE,
p_aidm gorccau.gorccau_aidm%TYPE,
p_gift_no gorccau.gorccau_gift_no%TYPE,
p_vendor_refer_no gorccau.gorccau_vendor_refer_no%TYPE,
p_amount gorccau.gorccau_amount%TYPE,
p_cart_id gorccau.gorccau_cart_id%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_id |
ID of user requesting credit card transaction. VARCHAR2(9) Required | |
| p_pidm |
PIDM of user requesting credit card transaction. NUMBER(8) | |
| p_term_code |
Term Code associated with credit card transaction. VARCHAR2(6) | |
| p_location |
Point in transaction when record was created. VARCHAR2(120) | |
| p_detail |
Detail/Gift Code associated with transaction. VARCHAR2(20) | |
| p_street_line1 |
Street line 1 of address data for transaction. VARCHAR2(75) | |
| p_street_line2 |
Street line 2 of address data for transaction. VARCHAR2(75) | |
| p_stat_code |
State/Province of address data for transaction. VARCHAR2(3) | |
| p_zip |
Zip/Postal Code of address data for transaction. VARCHAR2(30) | |
| p_natn_code |
Nation code of address data for transaction. VARCHAR2(5) | |
| p_merchant_id |
3rd party trans code for transaction. VARCHAR2(20) | |
| p_debug_msg |
Debug message for troubleshooting process. VARCHAR2(100) | |
| p_status |
Status of transaction. VARCHAR2(40) | |
| p_street_line3 |
Street line 3 of address data for transaction. VARCHAR2(75) | |
| p_street_line4 |
Street line 4 of address data for transaction. VARCHAR2(75) | |
| p_pay_trans_id |
The unique transaction id associated with the external vendor payment. NUMBER Required Key | |
| p_vendor_status |
The last status associated with the transaction from a payment vendor perspective. VARCHAR2(40) | |
| p_banner_status |
The last status associated with the transaction from a Banner perspective. VARCHAR2(40) | |
| p_vendor_error_msg |
The error message from the payment vendor, if applicable, related to a failed transaction. VARCHAR2(4000) | |
| p_application_data |
Any extra information that may be associated with this specific transaction. VARCHAR2(4000) | |
| p_update_function |
The name of the function that will be called upon a successful pre-authorization return from the payment vendor. VARCHAR2(100) | |
| p_success_url |
The URL that will be used upon a successful transaction. VARCHAR2(1020) | |
| p_failure_url |
The URL that will be used upon an unsuccessful transaction. VARCHAR2(1020) | |
| p_vendor_auth_code |
The authorization code returned from the payment vendor that can be tied back to the payment transaction. VARCHAR2(50) | |
| p_last_name |
The last name associated with this transaction. VARCHAR2(60) | |
| p_first_name |
The first name associated with this transaction. VARCHAR2(60) | |
| p_middle_name |
The middle name associated with this transaction. VARCHAR2(60) | |
| p_surname_prefix |
The surname prefix associated with this transaction. VARCHAR2(60) | |
| p_name_prefix |
The name prefix associated with this transaction. VARCHAR2(20) | |
| p_name_suffix |
The name suffix associated with this transaction. VARCHAR2(20) | |
| p_sub_code |
Merchant Id based upon calling application. VARCHAR2(20) | |
| p_proc_code |
Process Name Code associated with the transaction. VARCHAR2(30) | |
| p_sysi_code |
System Code associated with the transaction. VARCHAR2(2) | |
| p_appl_no |
Person Application Sequence Number. NUMBER(3) | |
| p_city |
City of address data for transaction. VARCHAR2(50) | |
| p_house_number |
House number of address data for transaction. VARCHAR2(10) | |
| p_aidm |
AIDM of user requesting credit card transaction. NUMBER(8) | |
| p_gift_no |
Advancement gift number associated with the transaction. VARCHAR2(7) | |
| p_vendor_refer_no |
The reference number returned from the payment vendor that can be tied back to the payment transaction. VARCHAR2(30) | |
| p_amount |
Payment amount of transaction. NUMBER(12,2) | |
| p_cart_id |
The shopping cart id associated with the external vendor payment. VARCHAR2(60) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_id gorccau.gorccau_id%TYPE,
p_pidm gorccau.gorccau_pidm%TYPE DEFAULT NULL,
p_term_code gorccau.gorccau_term_code%TYPE DEFAULT NULL,
p_location gorccau.gorccau_location%TYPE DEFAULT NULL,
p_detail gorccau.gorccau_detail%TYPE DEFAULT NULL,
p_street_line1 gorccau.gorccau_street_line1%TYPE DEFAULT NULL,
p_street_line2 gorccau.gorccau_street_line2%TYPE DEFAULT NULL,
p_stat_code gorccau.gorccau_stat_code%TYPE DEFAULT NULL,
p_zip gorccau.gorccau_zip%TYPE DEFAULT NULL,
p_natn_code gorccau.gorccau_natn_code%TYPE DEFAULT NULL,
p_merchant_id gorccau.gorccau_merchant_id%TYPE DEFAULT NULL,
p_debug_msg gorccau.gorccau_debug_msg%TYPE DEFAULT NULL,
p_status gorccau.gorccau_status%TYPE DEFAULT NULL,
p_street_line3 gorccau.gorccau_street_line3%TYPE DEFAULT NULL,
p_street_line4 gorccau.gorccau_street_line4%TYPE DEFAULT NULL,
p_pay_trans_id gorccau.gorccau_pay_trans_id%TYPE,
p_vendor_status gorccau.gorccau_vendor_status%TYPE DEFAULT NULL,
p_banner_status gorccau.gorccau_banner_status%TYPE DEFAULT NULL,
p_vendor_error_msg gorccau.gorccau_vendor_error_msg%TYPE DEFAULT NULL,
p_application_data gorccau.gorccau_application_data%TYPE DEFAULT NULL,
p_update_function gorccau.gorccau_update_function%TYPE DEFAULT NULL,
p_success_url gorccau.gorccau_success_url%TYPE DEFAULT NULL,
p_failure_url gorccau.gorccau_failure_url%TYPE DEFAULT NULL,
p_vendor_auth_code gorccau.gorccau_vendor_auth_code%TYPE DEFAULT NULL,
p_last_name gorccau.gorccau_last_name%TYPE DEFAULT NULL,
p_first_name gorccau.gorccau_first_name%TYPE DEFAULT NULL,
p_middle_name gorccau.gorccau_middle_name%TYPE DEFAULT NULL,
p_surname_prefix gorccau.gorccau_surname_prefix%TYPE DEFAULT NULL,
p_name_prefix gorccau.gorccau_name_prefix%TYPE DEFAULT NULL,
p_name_suffix gorccau.gorccau_name_suffix%TYPE DEFAULT NULL,
p_sub_code gorccau.gorccau_sub_code%TYPE DEFAULT NULL,
p_proc_code gorccau.gorccau_proc_code%TYPE DEFAULT NULL,
p_sysi_code gorccau.gorccau_sysi_code%TYPE DEFAULT NULL,
p_appl_no gorccau.gorccau_appl_no%TYPE DEFAULT NULL,
p_city gorccau.gorccau_city%TYPE DEFAULT NULL,
p_house_number gorccau.gorccau_house_number%TYPE DEFAULT NULL,
p_aidm gorccau.gorccau_aidm%TYPE DEFAULT NULL,
p_gift_no gorccau.gorccau_gift_no%TYPE DEFAULT NULL,
p_vendor_refer_no gorccau.gorccau_vendor_refer_no%TYPE DEFAULT NULL,
p_amount gorccau.gorccau_amount%TYPE DEFAULT NULL,
p_cart_id gorccau.gorccau_cart_id%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_id |
ID of user requesting credit card transaction. VARCHAR2(9) Required | |
| p_pidm |
PIDM of user requesting credit card transaction. NUMBER(8) | |
| p_term_code |
Term Code associated with credit card transaction. VARCHAR2(6) | |
| p_location |
Point in transaction when record was created. VARCHAR2(120) | |
| p_detail |
Detail/Gift Code associated with transaction. VARCHAR2(20) | |
| p_street_line1 |
Street line 1 of address data for transaction. VARCHAR2(75) | |
| p_street_line2 |
Street line 2 of address data for transaction. VARCHAR2(75) | |
| p_stat_code |
State/Province of address data for transaction. VARCHAR2(3) | |
| p_zip |
Zip/Postal Code of address data for transaction. VARCHAR2(30) | |
| p_natn_code |
Nation code of address data for transaction. VARCHAR2(5) | |
| p_merchant_id |
3rd party trans code for transaction. VARCHAR2(20) | |
| p_debug_msg |
Debug message for troubleshooting process. VARCHAR2(100) | |
| p_status |
Status of transaction. VARCHAR2(40) | |
| p_street_line3 |
Street line 3 of address data for transaction. VARCHAR2(75) | |
| p_street_line4 |
Street line 4 of address data for transaction. VARCHAR2(75) | |
| p_pay_trans_id |
The unique transaction id associated with the external vendor payment. NUMBER Required Key | |
| p_vendor_status |
The last status associated with the transaction from a payment vendor perspective. VARCHAR2(40) | |
| p_banner_status |
The last status associated with the transaction from a Banner perspective. VARCHAR2(40) | |
| p_vendor_error_msg |
The error message from the payment vendor, if applicable, related to a failed transaction. VARCHAR2(4000) | |
| p_application_data |
Any extra information that may be associated with this specific transaction. VARCHAR2(4000) | |
| p_update_function |
The name of the function that will be called upon a successful pre-authorization return from the payment vendor. VARCHAR2(100) | |
| p_success_url |
The URL that will be used upon a successful transaction. VARCHAR2(1020) | |
| p_failure_url |
The URL that will be used upon an unsuccessful transaction. VARCHAR2(1020) | |
| p_vendor_auth_code |
The authorization code returned from the payment vendor that can be tied back to the payment transaction. VARCHAR2(50) | |
| p_last_name |
The last name associated with this transaction. VARCHAR2(60) | |
| p_first_name |
The first name associated with this transaction. VARCHAR2(60) | |
| p_middle_name |
The middle name associated with this transaction. VARCHAR2(60) | |
| p_surname_prefix |
The surname prefix associated with this transaction. VARCHAR2(60) | |
| p_name_prefix |
The name prefix associated with this transaction. VARCHAR2(20) | |
| p_name_suffix |
The name suffix associated with this transaction. VARCHAR2(20) | |
| p_sub_code |
Merchant Id based upon calling application. VARCHAR2(20) | |
| p_proc_code |
Process Name Code associated with the transaction. VARCHAR2(30) | |
| p_sysi_code |
System Code associated with the transaction. VARCHAR2(2) | |
| p_appl_no |
Person Application Sequence Number. NUMBER(3) | |
| p_city |
City of address data for transaction. VARCHAR2(50) | |
| p_house_number |
House number of address data for transaction. VARCHAR2(10) | |
| p_aidm |
AIDM of user requesting credit card transaction. NUMBER(8) | |
| p_gift_no |
Advancement gift number associated with the transaction. VARCHAR2(7) | |
| p_vendor_refer_no |
The reference number returned from the payment vendor that can be tied back to the payment transaction. VARCHAR2(30) | |
| p_amount |
Payment amount of transaction. NUMBER(12,2) | |
| p_cart_id |
The shopping cart id associated with the external vendor payment. VARCHAR2(60) |