Prorated Elements

For any proratedelement (regardless of its classification) that is , the additional configuration steps need to be performed.

After the element is created using the element template, a formula is generated with the name: '<Element Name> Earnings'.

The following updates to the generated formula should be performed.

Flat Amount - Element

If the element is created using the 'Flat Amount' calculation rule then:
  • Add the code at line number 332:
     l_monthly_amount = 0
     SET_INPUT ('monthly_amount', l_value)
     SET_INPUT ('p_prorate_end', prorate_end) /* Comment or remove this line for Percentage of Earnings */
     EXECUTE('ORA_HRX_FR_GET_FULL_AMOUNT')
     l_monthly_amount = GET_OUTPUT('l_monthly_amount',0)    
     temp = PAY_INTERNAL_LOG_WRITE('(GLBEARN) France l_monthly_amount - ' + to_char(l_monthly_amount))
  • Add a new line at line 566 after "RETURN l_value," statement:
    l_monthly_amount

Unit* Rate - Element

If the element is created using the 'Unit * Rate' calculation rule then:
  • Add the code provided above in line number 407:
     l_monthly_amount = 0
     SET_INPUT ('monthly_amount', l_value)
     SET_INPUT ('p_prorate_end', prorate_end) /* Comment or remove this line for Percentage of Earnings */
     EXECUTE('ORA_HRX_FR_GET_FULL_AMOUNT')
     l_monthly_amount = GET_OUTPUT('l_monthly_amount',0)    
     temp = PAY_INTERNAL_LOG_WRITE('(GLBEARN) France l_monthly_amount - ' + to_char(l_monthly_amount))
  • Add a new line in line 693 after "RETURN l_value," statement:
    l_monthly_amount

Percentage of Earnings - Element

If the element is created using the 'Percentage of Earnings' calculation rule then:
  • Add the code provided above in line number 163:
     l_monthly_amount = 0
     SET_INPUT ('monthly_amount', l_value)
     SET_INPUT ('p_prorate_end', prorate_end) /* Comment or remove this line for Percentage of Earnings */
     EXECUTE('ORA_HRX_FR_GET_FULL_AMOUNT')
     l_monthly_amount = GET_OUTPUT('l_monthly_amount',0)    
     temp = PAY_INTERNAL_LOG_WRITE('(GLBEARN) France l_monthly_amount - ' + to_char(l_monthly_amount))
  • Add a new line text in line 227 after "RETURN l_value," statement:
    l_monthly_amount

Formula Result Rule

This step is required for all types of prorated elements for which the template generated formula has been modified as mentioned above.

  1. Search and select the element.
  2. Navigate to Status Processing Rules on the left pane.
In the Formula Result Rules section, add the details as shown:
Field Value
Result Returned L_monthly_amount
Result Rule Direct Result
Target Input Value Full Amount
Unit of Measure Money
Effective Start Date As applicable