Function to Retrieve Rate Amounts for Exports
This function calculates a rate amount based on the specified input parameters for the export date. It may be used as a formula when configuring the column details for an export.
This function internally calls pkg_rate_price.get_daily_rate_summary() so that the retrieved amount is the same as that displayed on the Rate Info screen in PMS.
The function pkg_rate_price.get_daily_rate_summary() returns a PL/SQL table with one rate amount per day (depending on the Number of Nights parameter). The records in the PL/SQL table have three amount columns:
R_AMOUNT = room revenue amount
P_AMOUNT = package amount
T_AMOUNT = tax amount
The get_rate_amount function will always return the R_AMOUNT. If parameter Include Packages YN is 'Y' then the P_AMOUNT will be added and in case parameter Include Taxes YN is 'Y' the T_AMOUNT will be added as well.
exp_gen.get_rate_amount()
Parameter 
Description 
Rate Code Name 
Rate code for which amount is to be calculated. 
Room Type Label 
Room type for which amount is to be calculated. 
Include Packages YN 
Should packages be included? Y or N. Default = N. 
Include Taxes YN 
Should taxes be included? Default = N. 
Arrival Date 
Arrival date. Default = pms_p.business_date. 
Number of Nights 
Nights included in stay. Default = 1. If the Number of Nights is greater than 1, the function will add together the rate amounts for the number of nights. 
Resort 
Resort ID. Default = pms_p.resort 
Number of Adults 
Adults on reservation. Default = 1. 
Number of Children 
Children on reservation. Default = 0. If any of the Number of Children in Age Group parameters are used, they will overwrite any Number of Children value. 
Number of Children in Age Group 1 
Where Child Age Buckets are used, the number of children in age bucket 1. Default = 0. 
Number of Children in Age Group 2 
Where Child Age Buckets are used, the number of children in age bucket 2. Default = 0. 
Number of Children in Age Group 3 
Where Child Age Buckets are used, the number of children in age bucket 3. Default = 0. 


Assume that the Rate Info for the rate code AA for the room type DLX displays the following amounts:
Room Revenue: 2017
Packages: 20
Generates (Taxes): 145.19
When the function is executed with the parameters shown
exp_gen.get_rate_amount('AA','DLX','Y','Y',pms_p.business_date,1);
The result is 2182.19
The results are as follows with the noted parameter variations:
Changed parameters to exp_gen.get_rate_amount('AA','DLX','N','N');
 Result 2017
Changed parameters to exp_gen.get_rate_amount('AA','DLX','Y','N');
 Result 2037
Changed parameters to exp_gen.get_rate_amount('AA','DLX','N','Y');
 Result 2162.19