APPS.BEN_CER_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_cer_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_mndtry_flag
124: <> nvl(ben_cer_shd.g_old_rec.mndtry_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_mndtry_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 195: <> nvl(ben_cer_shd.g_old_rec.drvbl_fctr_apls_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_drvbl_fctr_apls_flag
195: <> nvl(ben_cer_shd.g_old_rec.drvbl_fctr_apls_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_drvbl_fctr_apls_flag,
204: p_effective_date => p_effective_date) then
205: --

Line 282: and nvl(p_formula_id,hr_api.g_number)

278: p_effective_date => p_effective_date,
279: p_object_version_number => p_object_version_number);
280: --
281: if (l_api_updating
282: and nvl(p_formula_id,hr_api.g_number)
283: <> ben_cer_shd.g_old_rec.formula_id
284: or not l_api_updating)
285: and p_formula_id is not null then
286: --

Line 508: (p_prtn_elig_id in number default hr_api.g_number,

504: --
505: -- {End Of Comments}
506: -- ----------------------------------------------------------------------------
507: Procedure dt_update_validate
508: (p_prtn_elig_id in number default hr_api.g_number,
509: p_datetrack_mode in varchar2,
510: p_validation_start_date in date,
511: p_validation_end_date in date) Is
512: --

Line 522: hr_api.mandatory_arg_error

518: hr_utility.set_location('Entering:'||l_proc, 5);
519: --
520: -- Ensure that the p_datetrack_mode argument is not null
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc,
524: p_argument => 'datetrack_mode',
525: p_argument_value => p_datetrack_mode);
526: --

Line 534: hr_api.mandatory_arg_error

530: --
531: --
532: -- Ensure the arguments are not null
533: --
534: hr_api.mandatory_arg_error
535: (p_api_name => l_proc,
536: p_argument => 'validation_start_date',
537: p_argument_value => p_validation_start_date);
538: --

Line 539: hr_api.mandatory_arg_error

535: (p_api_name => l_proc,
536: p_argument => 'validation_start_date',
537: p_argument_value => p_validation_start_date);
538: --
539: hr_api.mandatory_arg_error
540: (p_api_name => l_proc,
541: p_argument => 'validation_end_date',
542: p_argument_value => p_validation_end_date);
543: --

Line 544: If ((nvl(p_prtn_elig_id, hr_api.g_number) <> hr_api.g_number) and

540: (p_api_name => l_proc,
541: p_argument => 'validation_end_date',
542: p_argument_value => p_validation_end_date);
543: --
544: If ((nvl(p_prtn_elig_id, hr_api.g_number) <> hr_api.g_number) and
545: NOT (dt_api.check_min_max_dates
546: (p_base_table_name => 'ben_prtn_elig_f',
547: p_base_key_column => 'prtn_elig_id',
548: p_base_key_value => p_prtn_elig_id,

Line 628: hr_api.mandatory_arg_error

624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- Ensure that the p_datetrack_mode argument is not null
627: --
628: hr_api.mandatory_arg_error
629: (p_api_name => l_proc,
630: p_argument => 'datetrack_mode',
631: p_argument_value => p_datetrack_mode);
632: --

Line 642: hr_api.mandatory_arg_error

638: --
639: --
640: -- Ensure the arguments are not null
641: --
642: hr_api.mandatory_arg_error
643: (p_api_name => l_proc,
644: p_argument => 'validation_start_date',
645: p_argument_value => p_validation_start_date);
646: --

Line 647: hr_api.mandatory_arg_error

643: (p_api_name => l_proc,
644: p_argument => 'validation_start_date',
645: p_argument_value => p_validation_start_date);
646: --
647: hr_api.mandatory_arg_error
648: (p_api_name => l_proc,
649: p_argument => 'validation_end_date',
650: p_argument_value => p_validation_end_date);
651: --

Line 652: hr_api.mandatory_arg_error

648: (p_api_name => l_proc,
649: p_argument => 'validation_end_date',
650: p_argument_value => p_validation_end_date);
651: --
652: hr_api.mandatory_arg_error
653: (p_api_name => l_proc,
654: p_argument => 'prtn_eligy_rl_id',
655: p_argument_value => p_prtn_eligy_rl_id);
656: --

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

696: --
697: -- Call all supporting business operations
698: --
699: --
700: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
701: --
702: chk_prtn_eligy_rl_id
703: (p_prtn_eligy_rl_id => p_rec.prtn_eligy_rl_id,
704: p_effective_date => p_effective_date,

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

755: --
756: -- Call all supporting business operations
757: --
758: --
759: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
760: --
761: chk_prtn_eligy_rl_id
762: (p_prtn_eligy_rl_id => p_rec.prtn_eligy_rl_id,
763: p_effective_date => p_effective_date,

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

858: hr_utility.set_location('Entering:'|| l_proc, 10);
859: --
860: -- Ensure that all the mandatory parameter are not null
861: --
862: hr_api.mandatory_arg_error(p_api_name => l_proc,
863: p_argument => 'prtn_eligy_rl_id',
864: p_argument_value => p_prtn_eligy_rl_id);
865: --
866: open csr_leg_code;