DBA Data[Home] [Help]

APPS.PER_SLT_BUS dependencies on HR_API

Line 51: hr_api.mandatory_arg_error

47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error
52: (p_api_name => l_proc
53: ,p_argument => 'solution_type_name'
54: ,p_argument_value => p_solution_type_name
55: );

Line 77: hr_api.set_security_group_id

73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --

Line 121: hr_api.mandatory_arg_error

117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error
122: (p_api_name => l_proc
123: ,p_argument => 'solution_type_name'
124: ,p_argument_value => p_solution_type_name
125: );

Line 127: if ( nvl(per_slt_bus.g_solution_type_name, hr_api.g_varchar2)

123: ,p_argument => 'solution_type_name'
124: ,p_argument_value => p_solution_type_name
125: );
126: --
127: if ( nvl(per_slt_bus.g_solution_type_name, hr_api.g_varchar2)
128: = p_solution_type_name) then
129: --
130: -- The legislation code has already been found with a previous
131: -- call to this function. Just return the value in the global

Line 219: hr_api.mandatory_arg_error

215: hr_utility.set_location('Entering:'|| l_proc, 10);
216: --
217: -- Check mandatory parameters have been set
218: --
219: hr_api.mandatory_arg_error
220: (p_api_name => l_proc
221: ,p_argument => 'effective date'
222: ,p_argument_value => p_effective_date
223: );

Line 236: and nvl(per_slt_shd.g_old_rec.solution_category, hr_api.g_varchar2)

232: (p_solution_type_name => p_solution_type_name
233: ,p_object_version_number => p_object_version_number
234: );
235: if ((l_api_updating
236: and nvl(per_slt_shd.g_old_rec.solution_category, hr_api.g_varchar2)
237: <> nvl(p_solution_category,hr_api.g_varchar2))
238: or
239: (NOT l_api_updating))
240: then

Line 237: <> nvl(p_solution_category,hr_api.g_varchar2))

233: ,p_object_version_number => p_object_version_number
234: );
235: if ((l_api_updating
236: and nvl(per_slt_shd.g_old_rec.solution_category, hr_api.g_varchar2)
237: <> nvl(p_solution_category,hr_api.g_varchar2))
238: or
239: (NOT l_api_updating))
240: then
241: hr_utility.set_location(l_proc, 40);

Line 252: if hr_api.not_exists_in_hrstanlookups

248: -- lookup type 'PER_SOLUTION_CATEGORIES' with an enabled flag set to 'Y'
249: -- and that the effective date is between start date
250: -- active and end date active in HR_STANDARD_LOOKUPS.
251: --
252: if hr_api.not_exists_in_hrstanlookups
253: (p_effective_date => p_effective_date
254: ,p_lookup_type => 'PER_SOLUTION_CATEGORIES'
255: ,p_lookup_code => p_solution_category
256: )

Line 320: hr_api.mandatory_arg_error

316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Check mandatory parameters have been set
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'effective date'
323: ,p_argument_value => p_effective_date
324: );

Line 326: hr_api.mandatory_arg_error

322: ,p_argument => 'effective date'
323: ,p_argument_value => p_effective_date
324: );
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc
328: ,p_argument => 'updateable'
329: ,p_argument_value => p_updateable
330: );

Line 341: and nvl(per_slt_shd.g_old_rec.updateable, hr_api.g_varchar2)

337: (p_solution_type_name => p_solution_type_name
338: ,p_object_version_number => p_object_version_number
339: );
340: if ((l_api_updating
341: and nvl(per_slt_shd.g_old_rec.updateable, hr_api.g_varchar2)
342: <> nvl(p_updateable,hr_api.g_varchar2))
343: or
344: (NOT l_api_updating))
345: then

Line 342: <> nvl(p_updateable,hr_api.g_varchar2))

338: ,p_object_version_number => p_object_version_number
339: );
340: if ((l_api_updating
341: and nvl(per_slt_shd.g_old_rec.updateable, hr_api.g_varchar2)
342: <> nvl(p_updateable,hr_api.g_varchar2))
343: or
344: (NOT l_api_updating))
345: then
346: hr_utility.set_location(l_proc, 40);

Line 357: if hr_api.not_exists_in_hrstanlookups

353: -- lookup type 'YES_NO' with an enabled flag set to 'Y'
354: -- and that the effective date is between start date
355: -- active and end date active in HR_STANDARD_LOOKUPS.
356: --
357: if hr_api.not_exists_in_hrstanlookups
358: (p_effective_date => p_effective_date
359: ,p_lookup_type => 'YES_NO'
360: ,p_lookup_code => p_updateable
361: )