APPS.BEN_EXT_CHLG dependencies on HR_GENERAL

Line 110: 27-Dec-05 rtagarra 115.57 Function "HR_GENERAL.DECODE_LOOKUP" has been called for

106: and AMA both were triggered at the same time only APA was logged .
107: Chaged the code so as to log the events independent of each other.
108: 31-Oct-05 rbingi 115.55 4705814, passing person_type ( Initially passed NULLs )
109: to Old, New Values for 'A%PTU' change event
110: 27-Dec-05 rtagarra 115.57 Function "HR_GENERAL.DECODE_LOOKUP" has been called for
111: bug#4699913 so that meaning ll be
112: populated instead of lookup code for Assignment Category.
113: 01-Sep-06 tjesumic 115.59 new change event added to log changes of contact of any person type
114: CCNFN,CCNDB,CCNDD,CCNSS,CCNGE,CCNRE,CCNPC,CCNPA,CCNMA

Line 3250: l_old_val1(l_tab_counter) := HR_GENERAL.DECODE_LOOKUP('EMP_CAT',p_old_rec.employment_category); --bug#4699913

3246: l_prmtr_04_tab(l_tab_counter) := null;
3247: l_prmtr_05_tab(l_tab_counter) := null;
3248: l_prmtr_06_tab(l_tab_counter) := null;
3249: l_prmtr_07_tab(l_tab_counter) := null;
3250: l_old_val1(l_tab_counter) := HR_GENERAL.DECODE_LOOKUP('EMP_CAT',p_old_rec.employment_category); --bug#4699913
3251: l_new_val1(l_tab_counter) := HR_GENERAL.DECODE_LOOKUP('EMP_CAT',p_new_rec.employment_category); --bug#4699913;
3252: end if;
3253: if nvl(p_old_rec.assignment_type, '$') <> 'B' and p_new_rec.assignment_type = 'B' then
3254: l_tab_counter := l_tab_counter + 1;

Line 3251: l_new_val1(l_tab_counter) := HR_GENERAL.DECODE_LOOKUP('EMP_CAT',p_new_rec.employment_category); --bug#4699913;

3247: l_prmtr_05_tab(l_tab_counter) := null;
3248: l_prmtr_06_tab(l_tab_counter) := null;
3249: l_prmtr_07_tab(l_tab_counter) := null;
3250: l_old_val1(l_tab_counter) := HR_GENERAL.DECODE_LOOKUP('EMP_CAT',p_old_rec.employment_category); --bug#4699913
3251: l_new_val1(l_tab_counter) := HR_GENERAL.DECODE_LOOKUP('EMP_CAT',p_new_rec.employment_category); --bug#4699913;
3252: end if;
3253: if nvl(p_old_rec.assignment_type, '$') <> 'B' and p_new_rec.assignment_type = 'B' then
3254: l_tab_counter := l_tab_counter + 1;
3255: l_chg_evt_tab(l_tab_counter) := 'ABA';