Compensation Hierarchy Determination YouTube Tutorial Example

 /*

FF Type : Compensation Hierarchy Determination

FF Name: CMP_HIERARCHY

Purpose: Pass the persons managers manager as his hierarchy, if the Managers manager not available

         pass manager as hierarchy 

*/

DEFAULT FOR PER_ASG_MGR_FULL_NAME is 'XXX'

DEFAULT FOR PER_ASG_MGR_MANAGER_ID is -999

DEFAULT FOR PER_ASG_MGR_MANAGER_ASG_ID is -999

DEFAULT FOR PER_PER_FULL_NAME is ' '

INPUTS ARE CMP_IV_PLAN_START_DATE (text), CMP_IV_PLAN_END_DATE (text), 

       CMP_IV_PLAN_ELIG_DATE(text),CMP_IV_PLAN_EXTRACTION_DATE(text), 

       CMP_IV_PERFORMANCE_EFF_DATE(text), CMP_IV_PROMOTION_EFF_DATE (text), 

       CMP_IV_XCHG_RATE_DATE (text), CMP_IV_PLAN_ID (number), 

       CMP_IV_PERIOD_ID(number)

l_log= set_log('****************ENTERING CMP_HIERARCHY')

eDate = GET_CONTEXT(EFFECTIVE_DATE, '1900/01/01 00:00:00' (date) )

personid = GET_CONTEXT( PERSON_ID, -1 )

assignid = GET_CONTEXT( HR_ASSIGNMENT_ID, -1 )

l_log= set_log('EFF DATE ' + TO_CHAR(eDate) )

l_log= set_log('personid ' + TO_CHAR(personid) )

l_log= set_log('assignid ' + TO_CHAR(assignid) )

l_log= set_log('PER_PER_FULL_NAME ' + PER_PER_FULL_NAME )

l_log= set_log('CMP_IV_PLAN_ID ' + TO_CHAR(CMP_IV_PLAN_ID) )

l_log= set_log('CMP_IV_PERIOD_ID ' + TO_CHAR(CMP_IV_PERIOD_ID) )

l_log= set_log('CMP_IV_PLAN_START_DATE ' + CMP_IV_PLAN_START_DATE )

L_ASSIGNMENT_ID = -999

L_PERSON_ID     = -999

l_name          = ' '

if assignid != -1 then (

   L_PERSON_ID      = PER_ASG_MGR_MANAGER_ID

   L_ASSIGNMENT_ID  = PER_ASG_MGR_MANAGER_ASG_ID    

   l_name           = PER_ASG_MGR_FULL_NAME

   l_log= set_log('Manager Name ' + l_name )

   IF PER_ASG_MGR_MANAGER_ASG_ID WAS NOT DEFAULTED THEN (

      CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = L_ASSIGNMENT_ID)

      (

           assignid1 = GET_CONTEXT( HR_ASSIGNMENT_ID, -1 )

           l_log= set_log('assignid 1 ' + TO_CHAR(assignid1) )

           IF PER_ASG_MGR_MANAGER_ASG_ID WAS NOT DEFAULTED THEN (

              L_PERSON_ID      = PER_ASG_MGR_MANAGER_ID

              L_ASSIGNMENT_ID  = PER_ASG_MGR_MANAGER_ASG_ID    

              l_name           = PER_ASG_MGR_FULL_NAME

              l_log= set_log('Manager mgr Name ' + l_name )

           )ELSE (

              l_log= set_log('Manager mgr not found  '  )

           )

      )

   )

)

l_log= set_log('****************Leaving CMP_HIERARCHY')

RETURN  L_ASSIGNMENT_ID, L_PERSON_ID