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 141: 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))

137: (select NOA_FAMILY_CODE from ghr_noa_families
138: where nature_of_action_id =
139: (select nature_of_action_id
140: from ghr_nature_of_actions
141: 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))
142: ) and proc_method_flag = 'Y';
143: ----7577249
144:
145: l_errbuf VARCHAR2(2000);

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

219: --7577249
220:
221: l_pa_request_num_prefix := p_pa_request_rec.rpa_type;
222: -- l_pa_request_rec.noa_Family_Code := 'GHR_SAL_PAY_ADJ';
223: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');
224: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
225: hr_utility.set_location(l_proc,10);
226: if ghr_msl_pkg.g_first_noa_code is not null then
227: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';

Line 226: if ghr_msl_pkg.g_first_noa_code is not null then

222: -- l_pa_request_rec.noa_Family_Code := 'GHR_SAL_PAY_ADJ';
223: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');
224: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
225: hr_utility.set_location(l_proc,10);
226: if ghr_msl_pkg.g_first_noa_code is not null then
227: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';
228: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
229: else
230: l_pa_request_rec.noa_family_code := 'GHR_SAL_LOCAL_PAY';

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

224: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
225: hr_utility.set_location(l_proc,10);
226: if ghr_msl_pkg.g_first_noa_code is not null then
227: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';
228: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
229: else
230: l_pa_request_rec.noa_family_code := 'GHR_SAL_LOCAL_PAY';
231: l_pa_request_rec.first_noa_code := '895';
232: end if;

Line 257: hr_utility.set_location('In MASS_NOA_SEL '|| ghr_msl_pkg.g_first_noa_code,220);

253: Elsif p_mass_action_type = 'MASS_TRANSFER_IN' Then
254: l_pa_request_num_prefix := 'MTI';
255: --Begin Bug# 14055214
256: ELSIF p_mass_action_type = 'MASS_NOA_SEL' THEN
257: hr_utility.set_location('In MASS_NOA_SEL '|| ghr_msl_pkg.g_first_noa_code,220);
258: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
259: open get_family_code(p_effective_date => l_pa_request_rec.effective_date);
260: fetch get_family_code into l_pa_request_rec.noa_Family_Code;
261: close get_family_code;

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

254: l_pa_request_num_prefix := 'MTI';
255: --Begin Bug# 14055214
256: ELSIF p_mass_action_type = 'MASS_NOA_SEL' THEN
257: hr_utility.set_location('In MASS_NOA_SEL '|| ghr_msl_pkg.g_first_noa_code,220);
258: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
259: open get_family_code(p_effective_date => l_pa_request_rec.effective_date);
260: fetch get_family_code into l_pa_request_rec.noa_Family_Code;
261: close get_family_code;
262: l_pa_request_num_prefix := 'MNOA';