eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MASS_CHANGES dependencies on GHR_MSL_PKG

Line 130: where code = nvl(ghr_msl_pkg.g_first_noa_code,'894') and p_effective_date between date_from and nvl(date_to,p_effective_date))

126: (select NOA_FAMILY_CODE from ghr_noa_families
127: where nature_of_action_id =
128: (select nature_of_action_id
129: from ghr_nature_of_actions
130: where code = nvl(ghr_msl_pkg.g_first_noa_code,'894') and p_effective_date between date_from and nvl(date_to,p_effective_date))
131: ) and proc_method_flag = 'Y';
132: ----7577249
133:
134: l_errbuf VARCHAR2(2000);

Line 205: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');

201: --7577249
202:
203: l_pa_request_num_prefix := p_pa_request_rec.rpa_type;
204: -- l_pa_request_rec.noa_Family_Code := 'GHR_SAL_PAY_ADJ';
205: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');
206: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
207: hr_utility.set_location(l_proc,10);
208: if ghr_msl_pkg.g_first_noa_code is not null then
209: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';

Line 208: if ghr_msl_pkg.g_first_noa_code is not null then

204: -- l_pa_request_rec.noa_Family_Code := 'GHR_SAL_PAY_ADJ';
205: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');
206: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
207: hr_utility.set_location(l_proc,10);
208: if ghr_msl_pkg.g_first_noa_code is not null then
209: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';
210: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
211: else
212: l_pa_request_rec.noa_family_code := 'GHR_SAL_LOCAL_PAY';

Line 210: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;

206: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
207: hr_utility.set_location(l_proc,10);
208: if ghr_msl_pkg.g_first_noa_code is not null then
209: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';
210: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
211: else
212: l_pa_request_rec.noa_family_code := 'GHR_SAL_LOCAL_PAY';
213: l_pa_request_rec.first_noa_code := '895';
214: end if;