DBA Data[Home] [Help]

APPS.BEN_PCT_BUS dependencies on HR_API

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

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

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

136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
141: <> ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
142: or not l_api_updating)
143: and p_ctfn_rqd_when_rl is not null then
144: --

Line 217: <> nvl(ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd,hr_api.g_varchar2)

213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating
216: and p_rmbmt_ctfn_typ_cd
217: <> nvl(ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd,hr_api.g_varchar2)
218: or not l_api_updating) then
219: --
220: -- check if value of lookup falls within lookup type.
221: --

Line 223: if hr_api.not_exists_in_hr_lookups

219: --
220: -- check if value of lookup falls within lookup type.
221: --
222: --
223: if hr_api.not_exists_in_hr_lookups
224: (p_lookup_type => 'BEN_REIMBMT_CTFN_TYP',
225: p_lookup_code => p_rmbmt_ctfn_typ_cd,
226: p_effective_date => p_effective_date) then
227: --

Line 286: <> nvl(ben_pct_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

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

Line 292: if hr_api.not_exists_in_hr_lookups

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

Line 355: <> nvl(ben_pct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_pfd_flag
355: <> nvl(ben_pct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
356: or not l_api_updating)
357: and p_pfd_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.

Line 361: if hr_api.not_exists_in_hr_lookups

357: and p_pfd_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'YES_NO',
363: p_lookup_code => p_pfd_flag,
364: p_effective_date => p_effective_date) then
365: --

Line 409: (p_ctfn_rqd_when_rl in number default hr_api.g_number,

405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure dt_update_validate
409: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
410: p_pl_gd_or_svc_id in number default hr_api.g_number,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) Is

Line 410: p_pl_gd_or_svc_id in number default hr_api.g_number,

406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure dt_update_validate
409: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
410: p_pl_gd_or_svc_id in number default hr_api.g_number,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) Is
414: --

Line 424: hr_api.mandatory_arg_error

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

Line 436: hr_api.mandatory_arg_error

432: --
433: --
434: -- Ensure the arguments are not null
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'validation_start_date',
439: p_argument_value => p_validation_start_date);
440: --

Line 441: hr_api.mandatory_arg_error

437: (p_api_name => l_proc,
438: p_argument => 'validation_start_date',
439: p_argument_value => p_validation_start_date);
440: --
441: hr_api.mandatory_arg_error
442: (p_api_name => l_proc,
443: p_argument => 'validation_end_date',
444: p_argument_value => p_validation_end_date);
445: --

Line 446: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and

442: (p_api_name => l_proc,
443: p_argument => 'validation_end_date',
444: p_argument_value => p_validation_end_date);
445: --
446: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and
447: NOT (dt_api.check_min_max_dates
448: (p_base_table_name => 'ff_formulas_f',
449: p_base_key_column => 'formula_id',
450: p_base_key_value => p_ctfn_rqd_when_rl,

Line 456: If ((nvl(p_pl_gd_or_svc_id, hr_api.g_number) <> hr_api.g_number) and

452: p_to_date => p_validation_end_date))) Then
453: l_table_name := 'ff_formulas_f';
454: Raise l_integrity_error;
455: End If;
456: If ((nvl(p_pl_gd_or_svc_id, hr_api.g_number) <> hr_api.g_number) and
457: NOT (dt_api.check_min_max_dates
458: (p_base_table_name => 'ben_pl_gd_or_svc_f',
459: p_base_key_column => 'pl_gd_or_svc_id',
460: p_base_key_value => p_pl_gd_or_svc_id,

Line 466: /*If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

462: p_to_date => p_validation_end_date))) Then
463: l_table_name := 'ben_pl_gd_or_svc_f';
464: Raise l_integrity_error;
465: End If;
466: /*If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
467: NOT (dt_api.check_min_max_dates
468: (p_base_table_name => 'ben_pl_f',
469: p_base_key_column => 'pl_id',
470: p_base_key_value => p_pl_id,

Line 550: hr_api.mandatory_arg_error

546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- Ensure that the p_datetrack_mode argument is not null
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc,
552: p_argument => 'datetrack_mode',
553: p_argument_value => p_datetrack_mode);
554: --

Line 564: hr_api.mandatory_arg_error

560: --
561: --
562: -- Ensure the arguments are not null
563: --
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc,
566: p_argument => 'validation_start_date',
567: p_argument_value => p_validation_start_date);
568: --

Line 569: hr_api.mandatory_arg_error

565: (p_api_name => l_proc,
566: p_argument => 'validation_start_date',
567: p_argument_value => p_validation_start_date);
568: --
569: hr_api.mandatory_arg_error
570: (p_api_name => l_proc,
571: p_argument => 'validation_end_date',
572: p_argument_value => p_validation_end_date);
573: --

Line 574: hr_api.mandatory_arg_error

570: (p_api_name => l_proc,
571: p_argument => 'validation_end_date',
572: p_argument_value => p_validation_end_date);
573: --
574: hr_api.mandatory_arg_error
575: (p_api_name => l_proc,
576: p_argument => 'pl_gd_r_svc_ctfn_id',
577: p_argument_value => p_pl_gd_r_svc_ctfn_id);
578: --

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

618: --
619: -- Call all supporting business operations
620: --
621: --
622: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
623: --
624: chk_pl_gd_r_svc_ctfn_id
625: (p_pl_gd_r_svc_ctfn_id => p_rec.pl_gd_r_svc_ctfn_id,
626: p_effective_date => p_effective_date,

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

671: --
672: -- Call all supporting business operations
673: --
674: --
675: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
676: --
677: chk_pl_gd_r_svc_ctfn_id
678: (p_pl_gd_r_svc_ctfn_id => p_rec.pl_gd_r_svc_ctfn_id,
679: p_effective_date => p_effective_date,

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

768: hr_utility.set_location('Entering:'|| l_proc, 10);
769: --
770: -- Ensure that all the mandatory parameter are not null
771: --
772: hr_api.mandatory_arg_error(p_api_name => l_proc,
773: p_argument => 'pl_gd_r_svc_ctfn_id',
774: p_argument_value => p_pl_gd_r_svc_ctfn_id);
775: --
776: open csr_leg_code;