APPS.PER_RTX_BUS dependencies on HR_API

Line 57: hr_api.mandatory_arg_error

53: hr_utility.set_location('Entering:'|| l_proc, 10);
54: --
55: -- Ensure that all the mandatory parameter are not null
56: --
57: hr_api.mandatory_arg_error
58: (p_api_name => l_proc
59: ,p_argument => 'rating_level_id'
60: ,p_argument_value => p_rating_level_id
61: );

Line 84: hr_api.set_security_group_id

80: close csr_sec_grp;
81: --
82: -- Set the security_group_id in CLIENT_INFO
83: --
84: hr_api.set_security_group_id
85: (p_security_group_id => l_security_group_id
86: );
87: end if;
88: --

Line 129: hr_api.mandatory_arg_error

125: hr_utility.set_location('Entering:'|| l_proc, 10);
126: --
127: -- Ensure that all the mandatory parameter are not null
128: --
129: hr_api.mandatory_arg_error
130: (p_api_name => l_proc
131: ,p_argument => 'rating_level_id'
132: ,p_argument_value => p_rating_level_id
133: );

Line 136: if (( nvl(per_rtx_bus.g_rating_level_id, hr_api.g_number)

132: ,p_argument_value => p_rating_level_id
133: );
134: --
135: --
136: if (( nvl(per_rtx_bus.g_rating_level_id, hr_api.g_number)
137: = p_rating_level_id)
138: and ( nvl(per_rtx_bus.g_language, hr_api.g_varchar2)
139: = p_language)) then
140: --

Line 138: and ( nvl(per_rtx_bus.g_language, hr_api.g_varchar2)

134: --
135: --
136: if (( nvl(per_rtx_bus.g_rating_level_id, hr_api.g_number)
137: = p_rating_level_id)
138: and ( nvl(per_rtx_bus.g_language, hr_api.g_varchar2)
139: = p_language)) then
140: --
141: -- The legislation code has already been found with a previous
142: -- call to this function. Just return the value in the global

Line 288: and ( (nvl(rtl.competence_id,hr_api.g_number)

284: and ( (p_rating_level_id is null)
285: or(p_rating_level_id <> rtx.rating_level_id)
286: )
287: and rtx.name = p_name
288: and ( (nvl(rtl.competence_id,hr_api.g_number)
289: = nvl(p_competence_id,hr_api.g_number) )
290: and(nvl(rtl.rating_scale_id,hr_api.g_number)
291: = nvl(p_rating_scale_id,hr_api.g_number))
292: );

Line 289: = nvl(p_competence_id,hr_api.g_number) )

285: or(p_rating_level_id <> rtx.rating_level_id)
286: )
287: and rtx.name = p_name
288: and ( (nvl(rtl.competence_id,hr_api.g_number)
289: = nvl(p_competence_id,hr_api.g_number) )
290: and(nvl(rtl.rating_scale_id,hr_api.g_number)
291: = nvl(p_rating_scale_id,hr_api.g_number))
292: );
293: --

Line 290: and(nvl(rtl.rating_scale_id,hr_api.g_number)

286: )
287: and rtx.name = p_name
288: and ( (nvl(rtl.competence_id,hr_api.g_number)
289: = nvl(p_competence_id,hr_api.g_number) )
290: and(nvl(rtl.rating_scale_id,hr_api.g_number)
291: = nvl(p_rating_scale_id,hr_api.g_number))
292: );
293: --
294: begin

Line 291: = nvl(p_rating_scale_id,hr_api.g_number))

287: and rtx.name = p_name
288: and ( (nvl(rtl.competence_id,hr_api.g_number)
289: = nvl(p_competence_id,hr_api.g_number) )
290: and(nvl(rtl.rating_scale_id,hr_api.g_number)
291: = nvl(p_rating_scale_id,hr_api.g_number))
292: );
293: --
294: begin
295: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 306: <> nvl(p_name,hr_api.g_varchar2))

302: (p_rating_level_id => p_rating_level_id
303: ,p_language => p_language);
304: --
305: if ( (l_api_updating and (per_rtx_shd.g_old_rec.name
306: <> nvl(p_name,hr_api.g_varchar2))
307: ) or
308: (NOT l_api_updating)
309: ) then
310: --