DBA Data[Home] [Help]

APPS.BEN_NOC_BUS dependencies on HR_API

Line 54: and nvl(p_no_othr_cvg_rt_id,hr_api.g_number)

50: p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_no_othr_cvg_rt_id,hr_api.g_number)
55: <> ben_noc_shd.g_old_rec.no_othr_cvg_rt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 124: <> nvl(ben_noc_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_coord_ben_no_cvg_flag
124: <> nvl(ben_noc_shd.g_old_rec.coord_ben_no_cvg_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_coord_ben_no_cvg_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 180: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure dt_update_validate
180: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
181: p_datetrack_mode in varchar2,
182: p_validation_start_date in date,
183: p_validation_end_date in date) Is
184: --

Line 194: hr_api.mandatory_arg_error

190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: -- Ensure that the p_datetrack_mode argument is not null
193: --
194: hr_api.mandatory_arg_error
195: (p_api_name => l_proc,
196: p_argument => 'datetrack_mode',
197: p_argument_value => p_datetrack_mode);
198: --

Line 206: hr_api.mandatory_arg_error

202: --
203: --
204: -- Ensure the arguments are not null
205: --
206: hr_api.mandatory_arg_error
207: (p_api_name => l_proc,
208: p_argument => 'validation_start_date',
209: p_argument_value => p_validation_start_date);
210: --

Line 211: hr_api.mandatory_arg_error

207: (p_api_name => l_proc,
208: p_argument => 'validation_start_date',
209: p_argument_value => p_validation_start_date);
210: --
211: hr_api.mandatory_arg_error
212: (p_api_name => l_proc,
213: p_argument => 'validation_end_date',
214: p_argument_value => p_validation_end_date);
215: --

Line 216: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

212: (p_api_name => l_proc,
213: p_argument => 'validation_end_date',
214: p_argument_value => p_validation_end_date);
215: --
216: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
217: NOT (dt_api.check_min_max_dates
218: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
219: p_base_key_column => 'vrbl_rt_prfl_id',
220: p_base_key_value => p_vrbl_rt_prfl_id,

Line 299: hr_api.mandatory_arg_error

295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Ensure that the p_datetrack_mode argument is not null
298: --
299: hr_api.mandatory_arg_error
300: (p_api_name => l_proc,
301: p_argument => 'datetrack_mode',
302: p_argument_value => p_datetrack_mode);
303: --

Line 313: hr_api.mandatory_arg_error

309: --
310: --
311: -- Ensure the arguments are not null
312: --
313: hr_api.mandatory_arg_error
314: (p_api_name => l_proc,
315: p_argument => 'validation_start_date',
316: p_argument_value => p_validation_start_date);
317: --

Line 318: hr_api.mandatory_arg_error

314: (p_api_name => l_proc,
315: p_argument => 'validation_start_date',
316: p_argument_value => p_validation_start_date);
317: --
318: hr_api.mandatory_arg_error
319: (p_api_name => l_proc,
320: p_argument => 'validation_end_date',
321: p_argument_value => p_validation_end_date);
322: --

Line 323: hr_api.mandatory_arg_error

319: (p_api_name => l_proc,
320: p_argument => 'validation_end_date',
321: p_argument_value => p_validation_end_date);
322: --
323: hr_api.mandatory_arg_error
324: (p_api_name => l_proc,
325: p_argument => 'no_othr_cvg_rt_id',
326: p_argument_value => p_no_othr_cvg_rt_id);
327: --

Line 371: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

367: --
368: -- Call all supporting business operations
369: --
370: --
371: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
372: --
373: chk_no_othr_cvg_rt_id
374: (p_no_othr_cvg_rt_id => p_rec.no_othr_cvg_rt_id,
375: p_effective_date => p_effective_date,

Line 405: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

401: --
402: -- Call all supporting business operations
403: --
404: --
405: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
406: --
407: chk_no_othr_cvg_rt_id
408: (p_no_othr_cvg_rt_id => p_rec.no_othr_cvg_rt_id,
409: p_effective_date => p_effective_date,

Line 483: hr_api.mandatory_arg_error(p_api_name => l_proc,

479: hr_utility.set_location('Entering:'|| l_proc, 10);
480: --
481: -- Ensure that all the mandatory parameter are not null
482: --
483: hr_api.mandatory_arg_error(p_api_name => l_proc,
484: p_argument => 'no_othr_cvg_rt_id',
485: p_argument_value => p_no_othr_cvg_rt_id);
486: --
487: open csr_leg_code;