DBA Data[Home] [Help]

APPS.BEN_ABP_BUS dependencies on HR_API

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

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

Line 85: (p_acty_base_rt_id in number default hr_api.g_number,

81: -- ----------------------------------------------------------------------------
82: -- |--------------------------< chk_abr_dups >--------------------------|
83: -- ----------------------------------------------------------------------------
84: Procedure chk_abr_dups
85: (p_acty_base_rt_id in number default hr_api.g_number,
86: p_bnft_prvdr_pool_id in number default hr_api.g_number,
87: p_aplcn_to_bnft_pool_id in number default hr_api.g_number,
88: p_effective_date in date
89: ) Is

Line 86: p_bnft_prvdr_pool_id in number default hr_api.g_number,

82: -- |--------------------------< chk_abr_dups >--------------------------|
83: -- ----------------------------------------------------------------------------
84: Procedure chk_abr_dups
85: (p_acty_base_rt_id in number default hr_api.g_number,
86: p_bnft_prvdr_pool_id in number default hr_api.g_number,
87: p_aplcn_to_bnft_pool_id in number default hr_api.g_number,
88: p_effective_date in date
89: ) Is
90:

Line 87: p_aplcn_to_bnft_pool_id in number default hr_api.g_number,

83: -- ----------------------------------------------------------------------------
84: Procedure chk_abr_dups
85: (p_acty_base_rt_id in number default hr_api.g_number,
86: p_bnft_prvdr_pool_id in number default hr_api.g_number,
87: p_aplcn_to_bnft_pool_id in number default hr_api.g_number,
88: p_effective_date in date
89: ) Is
90:
91: l_proc varchar2(72) := g_package||'chk_abr_dups';

Line 159: (p_acty_base_rt_id in number default hr_api.g_number,

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_update_validate
159: (p_acty_base_rt_id in number default hr_api.g_number,
160: p_bnft_prvdr_pool_id in number default hr_api.g_number,
161: p_datetrack_mode in varchar2,
162: p_validation_start_date in date,
163: p_validation_end_date in date) Is

Line 160: p_bnft_prvdr_pool_id in number default hr_api.g_number,

156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_update_validate
159: (p_acty_base_rt_id in number default hr_api.g_number,
160: p_bnft_prvdr_pool_id in number default hr_api.g_number,
161: p_datetrack_mode in varchar2,
162: p_validation_start_date in date,
163: p_validation_end_date in date) Is
164: --

Line 174: hr_api.mandatory_arg_error

170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: -- Ensure that the p_datetrack_mode argument is not null
173: --
174: hr_api.mandatory_arg_error
175: (p_api_name => l_proc,
176: p_argument => 'datetrack_mode',
177: p_argument_value => p_datetrack_mode);
178: --

Line 186: hr_api.mandatory_arg_error

182: --
183: --
184: -- Ensure the arguments are not null
185: --
186: hr_api.mandatory_arg_error
187: (p_api_name => l_proc,
188: p_argument => 'validation_start_date',
189: p_argument_value => p_validation_start_date);
190: --

Line 191: hr_api.mandatory_arg_error

187: (p_api_name => l_proc,
188: p_argument => 'validation_start_date',
189: p_argument_value => p_validation_start_date);
190: --
191: hr_api.mandatory_arg_error
192: (p_api_name => l_proc,
193: p_argument => 'validation_end_date',
194: p_argument_value => p_validation_end_date);
195: --

Line 196: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

192: (p_api_name => l_proc,
193: p_argument => 'validation_end_date',
194: p_argument_value => p_validation_end_date);
195: --
196: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
197: NOT (dt_api.check_min_max_dates
198: (p_base_table_name => 'ben_acty_base_rt_f',
199: p_base_key_column => 'acty_base_rt_id',
200: p_base_key_value => p_acty_base_rt_id,

Line 206: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and

202: p_to_date => p_validation_end_date))) Then
203: l_table_name := 'ben_acty_base_rt_f';
204: Raise l_integrity_error;
205: End If;
206: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and
207: NOT (dt_api.check_min_max_dates
208: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
209: p_base_key_column => 'bnft_prvdr_pool_id',
210: p_base_key_value => p_bnft_prvdr_pool_id,

Line 289: hr_api.mandatory_arg_error

285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- Ensure that the p_datetrack_mode argument is not null
288: --
289: hr_api.mandatory_arg_error
290: (p_api_name => l_proc,
291: p_argument => 'datetrack_mode',
292: p_argument_value => p_datetrack_mode);
293: --

Line 303: hr_api.mandatory_arg_error

299: --
300: --
301: -- Ensure the arguments are not null
302: --
303: hr_api.mandatory_arg_error
304: (p_api_name => l_proc,
305: p_argument => 'validation_start_date',
306: p_argument_value => p_validation_start_date);
307: --

Line 308: hr_api.mandatory_arg_error

304: (p_api_name => l_proc,
305: p_argument => 'validation_start_date',
306: p_argument_value => p_validation_start_date);
307: --
308: hr_api.mandatory_arg_error
309: (p_api_name => l_proc,
310: p_argument => 'validation_end_date',
311: p_argument_value => p_validation_end_date);
312: --

Line 313: hr_api.mandatory_arg_error

309: (p_api_name => l_proc,
310: p_argument => 'validation_end_date',
311: p_argument_value => p_validation_end_date);
312: --
313: hr_api.mandatory_arg_error
314: (p_api_name => l_proc,
315: p_argument => 'aplcn_to_bnft_pool_id',
316: p_argument_value => p_aplcn_to_bnft_pool_id);
317: --

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

356: --
357: -- Call all supporting business operations
358: --
359: --
360: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
361: --
362: chk_aplcn_to_bnft_pool_id
363: (p_aplcn_to_bnft_pool_id => p_rec.aplcn_to_bnft_pool_id,
364: p_effective_date => p_effective_date,

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

392: --
393: -- Call all supporting business operations
394: --
395: --
396: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
397: --
398: chk_aplcn_to_bnft_pool_id
399: (p_aplcn_to_bnft_pool_id => p_rec.aplcn_to_bnft_pool_id,
400: p_effective_date => p_effective_date,

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

473: hr_utility.set_location('Entering:'|| l_proc, 10);
474: --
475: -- Ensure that all the mandatory parameter are not null
476: --
477: hr_api.mandatory_arg_error(p_api_name => l_proc,
478: p_argument => 'aplcn_to_bnft_pool_id',
479: p_argument_value => p_aplcn_to_bnft_pool_id);
480: --
481: open csr_leg_code;