DBA Data[Home] [Help]

APPS.BEN_PRP_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_prp_shd.g_old_rec.pl_regy_prps_cd,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

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

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure dt_update_validate
180: (p_pl_regy_bod_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_pl_regy_bod_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_pl_regy_bod_id, hr_api.g_number) <> hr_api.g_number) and
217: NOT (dt_api.check_min_max_dates
218: (p_base_table_name => 'ben_pl_regy_bod_f',
219: p_base_key_column => 'pl_regy_bod_id',
220: p_base_key_value => p_pl_regy_bod_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 => 'pl_regy_prps_id',
326: p_argument_value => p_pl_regy_prps_id);
327: --

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

366: --
367: -- Call all supporting business operations
368: --
369: --
370: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
371: --
372: chk_pl_regy_prps_id
373: (p_pl_regy_prps_id => p_rec.pl_regy_prps_id,
374: p_effective_date => p_effective_date,

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

400: --
401: -- Call all supporting business operations
402: --
403: --
404: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
405: --
406: chk_pl_regy_prps_id
407: (p_pl_regy_prps_id => p_rec.pl_regy_prps_id,
408: p_effective_date => p_effective_date,

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

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