APPS.BEN_SAZ_BUS dependencies on HR_API

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

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

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

105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_pstl_zip_rng_id in number default hr_api.g_number,
110: p_svc_area_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_svc_area_id in number default hr_api.g_number,

106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure dt_update_validate
109: (p_pstl_zip_rng_id in number default hr_api.g_number,
110: p_svc_area_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_pstl_zip_rng_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_pstl_zip_rng_id, hr_api.g_number) <> hr_api.g_number) and
147: NOT (dt_api.check_min_max_dates
148: (p_base_table_name => 'ben_pstl_zip_rng_f',
149: p_base_key_column => 'pstl_zip_rng_id',
150: p_base_key_value => p_pstl_zip_rng_id,

Line 156: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and

152: p_to_date => p_validation_end_date))) Then
153: l_table_name := 'ben_pstl_zip_rng_f';
154: Raise l_integrity_error;
155: End If;
156: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and
157: NOT (dt_api.check_min_max_dates
158: (p_base_table_name => 'ben_svc_area_f',
159: p_base_key_column => 'svc_area_id',
160: p_base_key_value => p_svc_area_id,

Line 238: hr_api.mandatory_arg_error

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

Line 252: hr_api.mandatory_arg_error

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

Line 257: hr_api.mandatory_arg_error

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

Line 262: hr_api.mandatory_arg_error

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

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

304: --
305: -- Call all supporting business operations
306: --
307: --
308: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
309: --
310: chk_svc_area_pstl_zip_rng_id
311: (p_svc_area_pstl_zip_rng_id => p_rec.svc_area_pstl_zip_rng_id,
312: p_effective_date => p_effective_date,

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

332: --
333: -- Call all supporting business operations
334: --
335: --
336: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
337: --
338: chk_svc_area_pstl_zip_rng_id
339: (p_svc_area_pstl_zip_rng_id => p_rec.svc_area_pstl_zip_rng_id,
340: p_effective_date => p_effective_date,

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

405: hr_utility.set_location('Entering:'|| l_proc, 10);
406: --
407: -- Ensure that all the mandatory parameter are not null
408: --
409: hr_api.mandatory_arg_error(p_api_name => l_proc,
410: p_argument => 'svc_area_pstl_zip_rng_id',
411: p_argument_value => p_svc_area_pstl_zip_rng_id);
412: --
413: open csr_leg_code;