APPS.BEN_WPT_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_wpt_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_wpt_shd.g_old_rec.wv_prtn_rsn_cd,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 => '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_wpt_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_wpt_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
194: or not l_api_updating)
195: and p_dflt_flag is not null then
196: --
197: -- check if value of lookup falls within lookup type.

Line 199: if hr_api.not_exists_in_hr_lookups

195: and p_dflt_flag is not null then
196: --
197: -- check if value of lookup falls within lookup type.
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 308: (p_ptip_id in number default hr_api.g_number,

304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure dt_update_validate
308: (p_ptip_id in number default hr_api.g_number,
309: p_datetrack_mode in varchar2,
310: p_validation_start_date in date,
311: p_validation_end_date in date) Is
312: --

Line 322: hr_api.mandatory_arg_error

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Ensure that the p_datetrack_mode argument is not null
321: --
322: hr_api.mandatory_arg_error
323: (p_api_name => l_proc,
324: p_argument => 'datetrack_mode',
325: p_argument_value => p_datetrack_mode);
326: --

Line 334: hr_api.mandatory_arg_error

330: --
331: --
332: -- Ensure the arguments are not null
333: --
334: hr_api.mandatory_arg_error
335: (p_api_name => l_proc,
336: p_argument => 'validation_start_date',
337: p_argument_value => p_validation_start_date);
338: --

Line 339: hr_api.mandatory_arg_error

335: (p_api_name => l_proc,
336: p_argument => 'validation_start_date',
337: p_argument_value => p_validation_start_date);
338: --
339: hr_api.mandatory_arg_error
340: (p_api_name => l_proc,
341: p_argument => 'validation_end_date',
342: p_argument_value => p_validation_end_date);
343: --

Line 344: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

340: (p_api_name => l_proc,
341: p_argument => 'validation_end_date',
342: p_argument_value => p_validation_end_date);
343: --
344: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
345: NOT (dt_api.check_min_max_dates
346: (p_base_table_name => 'ben_ptip_f',
347: p_base_key_column => 'ptip_id',
348: p_base_key_value => p_ptip_id,

Line 428: hr_api.mandatory_arg_error

424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: hr_api.mandatory_arg_error
429: (p_api_name => l_proc,
430: p_argument => 'datetrack_mode',
431: p_argument_value => p_datetrack_mode);
432: --

Line 442: hr_api.mandatory_arg_error

438: --
439: --
440: -- Ensure the arguments are not null
441: --
442: hr_api.mandatory_arg_error
443: (p_api_name => l_proc,
444: p_argument => 'validation_start_date',
445: p_argument_value => p_validation_start_date);
446: --

Line 447: hr_api.mandatory_arg_error

443: (p_api_name => l_proc,
444: p_argument => 'validation_start_date',
445: p_argument_value => p_validation_start_date);
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'validation_end_date',
450: p_argument_value => p_validation_end_date);
451: --

Line 452: hr_api.mandatory_arg_error

448: (p_api_name => l_proc,
449: p_argument => 'validation_end_date',
450: p_argument_value => p_validation_end_date);
451: --
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'wv_prtn_rsn_ptip_id',
455: p_argument_value => p_wv_prtn_rsn_ptip_id);
456: --

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

504: --
505: -- Call all supporting business operations
506: --
507: --
508: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
509: --
510: chk_wv_prtn_rsn_ptip_id
511: (p_wv_prtn_rsn_ptip_id => p_rec.wv_prtn_rsn_ptip_id,
512: p_effective_date => p_effective_date,

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

551: --
552: -- Call all supporting business operations
553: --
554: --
555: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
556: --
557: chk_wv_prtn_rsn_ptip_id
558: (p_wv_prtn_rsn_ptip_id => p_rec.wv_prtn_rsn_ptip_id,
559: p_effective_date => p_effective_date,

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

642: hr_utility.set_location('Entering:'|| l_proc, 10);
643: --
644: -- Ensure that all the mandatory parameter are not null
645: --
646: hr_api.mandatory_arg_error(p_api_name => l_proc,
647: p_argument => 'wv_prtn_rsn_ptip_id',
648: p_argument_value => p_wv_prtn_rsn_ptip_id);
649: --
650: open csr_leg_code;