DBA Data[Home] [Help]

APPS.BEN_PRM_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_prm_shd.g_old_rec.alctd_val_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_alctd_val_flag
124: <> nvl(ben_prm_shd.g_old_rec.alctd_val_flag,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 => 'YES_NO',
132: p_lookup_code => p_alctd_val_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 195: <> nvl(ben_prm_shd.g_old_rec.cr_mnl_adj_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_cr_mnl_adj_flag
195: <> nvl(ben_prm_shd.g_old_rec.cr_mnl_adj_flag,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 201: if hr_api.not_exists_in_hr_lookups

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

Line 268: and nvl(p_antcpd_prtt_cntr_uom,hr_api.g_varchar2)

264: p_effective_date => p_effective_date,
265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_antcpd_prtt_cntr_uom,hr_api.g_varchar2)
269: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)
270: or not l_api_updating) then
271: --
272: -- check if uom value exists in fnd_currencies_tl table.

Line 269: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)

265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_antcpd_prtt_cntr_uom,hr_api.g_varchar2)
269: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)
270: or not l_api_updating) then
271: --
272: -- check if uom value exists in fnd_currencies_tl table.
273: --

Line 342: and nvl(p_uom,hr_api.g_varchar2)

338: p_effective_date => p_effective_date,
339: p_object_version_number => p_object_version_number);
340: --
341: if (l_api_updating
342: and nvl(p_uom,hr_api.g_varchar2)
343: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)
344: or not l_api_updating) then
345: --
346: -- check if uom value exists in fnd_currencies_tl table.

Line 343: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)

339: p_object_version_number => p_object_version_number);
340: --
341: if (l_api_updating
342: and nvl(p_uom,hr_api.g_varchar2)
343: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)
344: or not l_api_updating) then
345: --
346: -- check if uom value exists in fnd_currencies_tl table.
347: --

Line 413: <> nvl(ben_prm_shd.g_old_rec.mnl_adj_flag,hr_api.g_varchar2)

409: p_object_version_number => p_object_version_number);
410: --
411: if (l_api_updating
412: and p_mnl_adj_flag
413: <> nvl(ben_prm_shd.g_old_rec.mnl_adj_flag,hr_api.g_varchar2)
414: or not l_api_updating) then
415: --
416: -- check if value of lookup falls within lookup type.
417: --

Line 419: if hr_api.not_exists_in_hr_lookups

415: --
416: -- check if value of lookup falls within lookup type.
417: --
418: --
419: if hr_api.not_exists_in_hr_lookups
420: (p_lookup_type => 'YES_NO',
421: p_lookup_code => p_mnl_adj_flag,
422: p_effective_date => p_effective_date) then
423: --

Line 469: (p_prtt_prem_id in number default hr_api.g_number,

465: --
466: -- {End Of Comments}
467: -- ----------------------------------------------------------------------------
468: Procedure dt_update_validate
469: (p_prtt_prem_id in number default hr_api.g_number,
470: p_datetrack_mode in varchar2,
471: p_validation_start_date in date,
472: p_validation_end_date in date) Is
473: --

Line 483: hr_api.mandatory_arg_error

479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: -- Ensure that the p_datetrack_mode argument is not null
482: --
483: hr_api.mandatory_arg_error
484: (p_api_name => l_proc,
485: p_argument => 'datetrack_mode',
486: p_argument_value => p_datetrack_mode);
487: --

Line 495: hr_api.mandatory_arg_error

491: --
492: --
493: -- Ensure the arguments are not null
494: --
495: hr_api.mandatory_arg_error
496: (p_api_name => l_proc,
497: p_argument => 'validation_start_date',
498: p_argument_value => p_validation_start_date);
499: --

Line 500: hr_api.mandatory_arg_error

496: (p_api_name => l_proc,
497: p_argument => 'validation_start_date',
498: p_argument_value => p_validation_start_date);
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'validation_end_date',
503: p_argument_value => p_validation_end_date);
504: --

Line 505: If ((nvl(p_prtt_prem_id, hr_api.g_number) <> hr_api.g_number) and

501: (p_api_name => l_proc,
502: p_argument => 'validation_end_date',
503: p_argument_value => p_validation_end_date);
504: --
505: If ((nvl(p_prtt_prem_id, hr_api.g_number) <> hr_api.g_number) and
506: NOT (dt_api.check_min_max_dates
507: (p_base_table_name => 'ben_prtt_prem_f',
508: p_base_key_column => 'prtt_prem_id',
509: p_base_key_value => p_prtt_prem_id,

Line 587: hr_api.mandatory_arg_error

583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Ensure that the p_datetrack_mode argument is not null
586: --
587: hr_api.mandatory_arg_error
588: (p_api_name => l_proc,
589: p_argument => 'datetrack_mode',
590: p_argument_value => p_datetrack_mode);
591: --

Line 601: hr_api.mandatory_arg_error

597: --
598: --
599: -- Ensure the arguments are not null
600: --
601: hr_api.mandatory_arg_error
602: (p_api_name => l_proc,
603: p_argument => 'validation_start_date',
604: p_argument_value => p_validation_start_date);
605: --

Line 606: hr_api.mandatory_arg_error

602: (p_api_name => l_proc,
603: p_argument => 'validation_start_date',
604: p_argument_value => p_validation_start_date);
605: --
606: hr_api.mandatory_arg_error
607: (p_api_name => l_proc,
608: p_argument => 'validation_end_date',
609: p_argument_value => p_validation_end_date);
610: --

Line 611: hr_api.mandatory_arg_error

607: (p_api_name => l_proc,
608: p_argument => 'validation_end_date',
609: p_argument_value => p_validation_end_date);
610: --
611: hr_api.mandatory_arg_error
612: (p_api_name => l_proc,
613: p_argument => 'prtt_prem_by_mo_id',
614: p_argument_value => p_prtt_prem_by_mo_id);
615: --

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

653: --
654: -- Call all supporting business operations
655: --
656: --
657: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
658: --
659: chk_prtt_prem_by_mo_id
660: (p_prtt_prem_by_mo_id => p_rec.prtt_prem_by_mo_id,
661: p_effective_date => p_effective_date,

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

711: --
712: -- Call all supporting business operations
713: --
714: --
715: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
716: --
717: chk_prtt_prem_by_mo_id
718: (p_prtt_prem_by_mo_id => p_rec.prtt_prem_by_mo_id,
719: p_effective_date => p_effective_date,

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

813: hr_utility.set_location('Entering:'|| l_proc, 10);
814: --
815: -- Ensure that all the mandatory parameter are not null
816: --
817: hr_api.mandatory_arg_error(p_api_name => l_proc,
818: p_argument => 'prtt_prem_by_mo_id',
819: p_argument_value => p_prtt_prem_by_mo_id);
820: --
821: open csr_leg_code;