DBA Data[Home] [Help]

APPS.BEN_WCN_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_wcn_shd.g_old_rec.wv_prtn_ctfn_typ_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_ctfn_typ_cd
124: <> nvl(ben_wcn_shd.g_old_rec.wv_prtn_ctfn_typ_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_CTFN_TYP',
132: p_lookup_code => p_wv_prtn_ctfn_typ_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 209: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)

205: p_effective_date => p_effective_date,
206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
210: <> ben_wcn_shd.g_old_rec.ctfn_rqd_when_rl
211: or not l_api_updating)
212: and p_ctfn_rqd_when_rl is not null then
213: --

Line 288: <> nvl(ben_wcn_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and p_rqd_flag
288: <> nvl(ben_wcn_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
289: or not l_api_updating) then
290: --
291: -- check if value of lookup falls within lookup type.
292: --

Line 294: if hr_api.not_exists_in_hr_lookups

290: --
291: -- check if value of lookup falls within lookup type.
292: --
293: --
294: if hr_api.not_exists_in_hr_lookups
295: (p_lookup_type => 'YES_NO',
296: p_lookup_code => p_rqd_flag,
297: p_effective_date => p_effective_date) then
298: --

Line 357: <> nvl(ben_wcn_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)

353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and p_lack_ctfn_sspnd_wvr_flag
357: <> nvl(ben_wcn_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)
358: or not l_api_updating) then
359: --
360: -- check if value of lookup falls within lookup type.
361: --

Line 363: if hr_api.not_exists_in_hr_lookups

359: --
360: -- check if value of lookup falls within lookup type.
361: --
362: --
363: if hr_api.not_exists_in_hr_lookups
364: (p_lookup_type => 'YES_NO',
365: p_lookup_code => p_lack_ctfn_sspnd_wvr_flag,
366: p_effective_date => p_effective_date) then
367: --

Line 426: <> nvl(ben_wcn_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

422: p_object_version_number => p_object_version_number);
423: --
424: if (l_api_updating
425: and p_pfd_flag
426: <> nvl(ben_wcn_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
427: or not l_api_updating) then
428: --
429: -- check if value of lookup falls within lookup type.
430: --

Line 432: if hr_api.not_exists_in_hr_lookups

428: --
429: -- check if value of lookup falls within lookup type.
430: --
431: --
432: if hr_api.not_exists_in_hr_lookups
433: (p_lookup_type => 'YES_NO',
434: p_lookup_code => p_pfd_flag,
435: p_effective_date => p_effective_date) then
436: --

Line 480: (p_wv_prtn_rsn_pl_id in number default hr_api.g_number,

476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure dt_update_validate
480: (p_wv_prtn_rsn_pl_id in number default hr_api.g_number,
481: p_datetrack_mode in varchar2,
482: p_validation_start_date in date,
483: p_validation_end_date in date) Is
484: --

Line 494: hr_api.mandatory_arg_error

490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: -- Ensure that the p_datetrack_mode argument is not null
493: --
494: hr_api.mandatory_arg_error
495: (p_api_name => l_proc,
496: p_argument => 'datetrack_mode',
497: p_argument_value => p_datetrack_mode);
498: --

Line 506: hr_api.mandatory_arg_error

502: --
503: --
504: -- Ensure the arguments are not null
505: --
506: hr_api.mandatory_arg_error
507: (p_api_name => l_proc,
508: p_argument => 'validation_start_date',
509: p_argument_value => p_validation_start_date);
510: --

Line 511: hr_api.mandatory_arg_error

507: (p_api_name => l_proc,
508: p_argument => 'validation_start_date',
509: p_argument_value => p_validation_start_date);
510: --
511: hr_api.mandatory_arg_error
512: (p_api_name => l_proc,
513: p_argument => 'validation_end_date',
514: p_argument_value => p_validation_end_date);
515: --

Line 516: If ((nvl(p_wv_prtn_rsn_pl_id, hr_api.g_number) <> hr_api.g_number) and

512: (p_api_name => l_proc,
513: p_argument => 'validation_end_date',
514: p_argument_value => p_validation_end_date);
515: --
516: If ((nvl(p_wv_prtn_rsn_pl_id, hr_api.g_number) <> hr_api.g_number) and
517: NOT (dt_api.check_min_max_dates
518: (p_base_table_name => 'ben_wv_prtn_rsn_pl_f',
519: p_base_key_column => 'wv_prtn_rsn_pl_id',
520: p_base_key_value => p_wv_prtn_rsn_pl_id,

Line 600: hr_api.mandatory_arg_error

596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: -- Ensure that the p_datetrack_mode argument is not null
599: --
600: hr_api.mandatory_arg_error
601: (p_api_name => l_proc,
602: p_argument => 'datetrack_mode',
603: p_argument_value => p_datetrack_mode);
604: --

Line 614: hr_api.mandatory_arg_error

610: --
611: --
612: -- Ensure the arguments are not null
613: --
614: hr_api.mandatory_arg_error
615: (p_api_name => l_proc,
616: p_argument => 'validation_start_date',
617: p_argument_value => p_validation_start_date);
618: --

Line 619: hr_api.mandatory_arg_error

615: (p_api_name => l_proc,
616: p_argument => 'validation_start_date',
617: p_argument_value => p_validation_start_date);
618: --
619: hr_api.mandatory_arg_error
620: (p_api_name => l_proc,
621: p_argument => 'validation_end_date',
622: p_argument_value => p_validation_end_date);
623: --

Line 624: hr_api.mandatory_arg_error

620: (p_api_name => l_proc,
621: p_argument => 'validation_end_date',
622: p_argument_value => p_validation_end_date);
623: --
624: hr_api.mandatory_arg_error
625: (p_api_name => l_proc,
626: p_argument => 'wv_prtn_rsn_ctfn_pl_id',
627: p_argument_value => p_wv_prtn_rsn_ctfn_pl_id);
628: --

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

668: --
669: -- Call all supporting business operations
670: --
671: --
672: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
673: --
674: chk_wv_prtn_rsn_ctfn_pl_id
675: (p_wv_prtn_rsn_ctfn_pl_id => p_rec.wv_prtn_rsn_ctfn_pl_id,
676: p_effective_date => p_effective_date,

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

727: --
728: -- Call all supporting business operations
729: --
730: --
731: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
732: --
733: chk_wv_prtn_rsn_ctfn_pl_id
734: (p_wv_prtn_rsn_ctfn_pl_id => p_rec.wv_prtn_rsn_ctfn_pl_id,
735: p_effective_date => p_effective_date,

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

830: hr_utility.set_location('Entering:'|| l_proc, 10);
831: --
832: -- Ensure that all the mandatory parameter are not null
833: --
834: hr_api.mandatory_arg_error(p_api_name => l_proc,
835: p_argument => 'wv_prtn_rsn_ctfn_pl_id',
836: p_argument_value => p_wv_prtn_rsn_ctfn_pl_id);
837: --
838: open csr_leg_code;