APPS.BEN_APL_BUS dependencies on HR_API

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

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

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

105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_acty_base_rt_id in number default hr_api.g_number,
110: p_ptd_lmt_id in number default hr_api.g_number,
111: p_datetrack_mode in varchar2,
112: p_validation_start_date in date,
113: p_validation_end_date in date) Is

Line 110: p_ptd_lmt_id in number default hr_api.g_number,

106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_acty_base_rt_id in number default hr_api.g_number,
110: p_ptd_lmt_id in number default hr_api.g_number,
111: p_datetrack_mode in varchar2,
112: p_validation_start_date in date,
113: p_validation_end_date in date) Is
114: --

Line 124: hr_api.mandatory_arg_error

120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: -- Ensure that the p_datetrack_mode argument is not null
123: --
124: hr_api.mandatory_arg_error
125: (p_api_name => l_proc,
126: p_argument => 'datetrack_mode',
127: p_argument_value => p_datetrack_mode);
128: --

Line 136: hr_api.mandatory_arg_error

132: --
133: --
134: -- Ensure the arguments are not null
135: --
136: hr_api.mandatory_arg_error
137: (p_api_name => l_proc,
138: p_argument => 'validation_start_date',
139: p_argument_value => p_validation_start_date);
140: --

Line 141: hr_api.mandatory_arg_error

137: (p_api_name => l_proc,
138: p_argument => 'validation_start_date',
139: p_argument_value => p_validation_start_date);
140: --
141: hr_api.mandatory_arg_error
142: (p_api_name => l_proc,
143: p_argument => 'validation_end_date',
144: p_argument_value => p_validation_end_date);
145: --

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

142: (p_api_name => l_proc,
143: p_argument => 'validation_end_date',
144: p_argument_value => p_validation_end_date);
145: --
146: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
147: NOT (dt_api.check_min_max_dates
148: (p_base_table_name => 'ben_acty_base_rt_f',
149: p_base_key_column => 'acty_base_rt_id',
150: p_base_key_value => p_acty_base_rt_id,

Line 157: If ((nvl(p_ptd_lmt_id, hr_api.g_number) <> hr_api.g_number) and

153: l_table_name := 'ben_acty_base_rt_f';
154: Raise l_integrity_error;
155: End If;
156: --
157: If ((nvl(p_ptd_lmt_id, hr_api.g_number) <> hr_api.g_number) and
158: NOT (dt_api.check_min_max_dates
159: (p_base_table_name => 'ben_ptd_lmt_f',
160: p_base_key_column => 'ptd_lmt_id',
161: p_base_key_value => p_ptd_lmt_id,

Line 239: hr_api.mandatory_arg_error

235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- Ensure that the p_datetrack_mode argument is not null
238: --
239: hr_api.mandatory_arg_error
240: (p_api_name => l_proc,
241: p_argument => 'datetrack_mode',
242: p_argument_value => p_datetrack_mode);
243: --

Line 253: hr_api.mandatory_arg_error

249: --
250: --
251: -- Ensure the arguments are not null
252: --
253: hr_api.mandatory_arg_error
254: (p_api_name => l_proc,
255: p_argument => 'validation_start_date',
256: p_argument_value => p_validation_start_date);
257: --

Line 258: hr_api.mandatory_arg_error

254: (p_api_name => l_proc,
255: p_argument => 'validation_start_date',
256: p_argument_value => p_validation_start_date);
257: --
258: hr_api.mandatory_arg_error
259: (p_api_name => l_proc,
260: p_argument => 'validation_end_date',
261: p_argument_value => p_validation_end_date);
262: --

Line 263: hr_api.mandatory_arg_error

259: (p_api_name => l_proc,
260: p_argument => 'validation_end_date',
261: p_argument_value => p_validation_end_date);
262: --
263: hr_api.mandatory_arg_error
264: (p_api_name => l_proc,
265: p_argument => 'acty_rt_ptd_lmt_id',
266: p_argument_value => p_acty_rt_ptd_lmt_id);
267: --

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

308: --
309: -- Call all supporting business operations
310: --
311: --
312: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
313: --
314: chk_acty_rt_ptd_lmt_id
315: (p_acty_rt_ptd_lmt_id => p_rec.acty_rt_ptd_lmt_id,
316: p_effective_date => p_effective_date,

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

336: --
337: -- Call all supporting business operations
338: --
339: --
340: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
341: --
342: chk_acty_rt_ptd_lmt_id
343: (p_acty_rt_ptd_lmt_id => p_rec.acty_rt_ptd_lmt_id,
344: p_effective_date => p_effective_date,

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

409: hr_utility.set_location('Entering:'|| l_proc, 10);
410: --
411: -- Ensure that all the mandatory parameter are not null
412: --
413: hr_api.mandatory_arg_error(p_api_name => l_proc,
414: p_argument => 'acty_rt_ptd_lmt_id',
415: p_argument_value => p_acty_rt_ptd_lmt_id);
416: --
417: open csr_leg_code;