APPS.BEN_WPN_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_wpn_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_wv_prtn_rsn_cd
124: <> nvl(ben_wpn_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_wv_prtn_rsn_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_wv_prtn_rsn_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_WV_PRTN_RSN',
132: p_lookup_code => p_wv_prtn_rsn_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 193: <> nvl(ben_wpn_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_dflt_flag
193: <> nvl(ben_wpn_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
194: or not l_api_updating) then
195: --
196: -- check if value of lookup falls within lookup type.
197: --

Line 199: if hr_api.not_exists_in_hr_lookups

195: --
196: -- check if value of lookup falls within lookup type.
197: --
198: --
199: if hr_api.not_exists_in_hr_lookups
200: (p_lookup_type => 'YES_NO',
201: p_lookup_code => p_dflt_flag,
202: p_effective_date => p_effective_date) then
203: --

Line 247: (p_pl_id in number default hr_api.g_number,

243: --
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure dt_update_validate
247: (p_pl_id in number default hr_api.g_number,
248: p_datetrack_mode in varchar2,
249: p_validation_start_date in date,
250: p_validation_end_date in date) Is
251: --

Line 261: hr_api.mandatory_arg_error

257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: -- Ensure that the p_datetrack_mode argument is not null
260: --
261: hr_api.mandatory_arg_error
262: (p_api_name => l_proc,
263: p_argument => 'datetrack_mode',
264: p_argument_value => p_datetrack_mode);
265: --

Line 273: hr_api.mandatory_arg_error

269: --
270: --
271: -- Ensure the arguments are not null
272: --
273: hr_api.mandatory_arg_error
274: (p_api_name => l_proc,
275: p_argument => 'validation_start_date',
276: p_argument_value => p_validation_start_date);
277: --

Line 278: hr_api.mandatory_arg_error

274: (p_api_name => l_proc,
275: p_argument => 'validation_start_date',
276: p_argument_value => p_validation_start_date);
277: --
278: hr_api.mandatory_arg_error
279: (p_api_name => l_proc,
280: p_argument => 'validation_end_date',
281: p_argument_value => p_validation_end_date);
282: --

Line 283: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

279: (p_api_name => l_proc,
280: p_argument => 'validation_end_date',
281: p_argument_value => p_validation_end_date);
282: --
283: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
284: NOT (dt_api.check_min_max_dates
285: (p_base_table_name => 'ben_pl_f',
286: p_base_key_column => 'pl_id',
287: p_base_key_value => p_pl_id,

Line 367: hr_api.mandatory_arg_error

363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Ensure that the p_datetrack_mode argument is not null
366: --
367: hr_api.mandatory_arg_error
368: (p_api_name => l_proc,
369: p_argument => 'datetrack_mode',
370: p_argument_value => p_datetrack_mode);
371: --

Line 381: hr_api.mandatory_arg_error

377: --
378: --
379: -- Ensure the arguments are not null
380: --
381: hr_api.mandatory_arg_error
382: (p_api_name => l_proc,
383: p_argument => 'validation_start_date',
384: p_argument_value => p_validation_start_date);
385: --

Line 386: hr_api.mandatory_arg_error

382: (p_api_name => l_proc,
383: p_argument => 'validation_start_date',
384: p_argument_value => p_validation_start_date);
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc,
388: p_argument => 'validation_end_date',
389: p_argument_value => p_validation_end_date);
390: --

Line 391: hr_api.mandatory_arg_error

387: (p_api_name => l_proc,
388: p_argument => 'validation_end_date',
389: p_argument_value => p_validation_end_date);
390: --
391: hr_api.mandatory_arg_error
392: (p_api_name => l_proc,
393: p_argument => 'wv_prtn_rsn_pl_id',
394: p_argument_value => p_wv_prtn_rsn_pl_id);
395: --

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

435: --
436: -- Call all supporting business operations
437: --
438: --
439: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
440: --
441: chk_wv_prtn_rsn_pl_id
442: (p_wv_prtn_rsn_pl_id => p_rec.wv_prtn_rsn_pl_id,
443: p_effective_date => p_effective_date,

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

475: --
476: -- Call all supporting business operations
477: --
478: --
479: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
480: --
481: chk_wv_prtn_rsn_pl_id
482: (p_wv_prtn_rsn_pl_id => p_rec.wv_prtn_rsn_pl_id,
483: p_effective_date => p_effective_date,

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

559: hr_utility.set_location('Entering:'|| l_proc, 10);
560: --
561: -- Ensure that all the mandatory parameter are not null
562: --
563: hr_api.mandatory_arg_error(p_api_name => l_proc,
564: p_argument => 'wv_prtn_rsn_pl_id',
565: p_argument_value => p_wv_prtn_rsn_pl_id);
566: --
567: open csr_leg_code;