APPS.BEN_CTU_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_ctu_shd.g_old_rec.all_r_any_cd,hr_api.g_varchar2)

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

Line 195: and nvl(p_cm_usg_rl,hr_api.g_number)

191: p_effective_date => p_effective_date,
192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and nvl(p_cm_usg_rl,hr_api.g_number)
196: <> ben_ctu_shd.g_old_rec.cm_usg_rl
197: or not l_api_updating)
198: and p_cm_usg_rl is not null then
199: --

Line 251: (p_pgm_id in number default hr_api.g_number,

247: --
248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure dt_update_validate
251: (p_pgm_id in number default hr_api.g_number,
252: p_cm_typ_id in number default hr_api.g_number,
253: p_pl_id in number default hr_api.g_number,
254: p_pl_typ_id in number default hr_api.g_number,
255: p_datetrack_mode in varchar2,

Line 252: p_cm_typ_id in number default hr_api.g_number,

248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure dt_update_validate
251: (p_pgm_id in number default hr_api.g_number,
252: p_cm_typ_id in number default hr_api.g_number,
253: p_pl_id in number default hr_api.g_number,
254: p_pl_typ_id in number default hr_api.g_number,
255: p_datetrack_mode in varchar2,
256: p_validation_start_date in date,

Line 253: p_pl_id in number default hr_api.g_number,

249: -- ----------------------------------------------------------------------------
250: Procedure dt_update_validate
251: (p_pgm_id in number default hr_api.g_number,
252: p_cm_typ_id in number default hr_api.g_number,
253: p_pl_id in number default hr_api.g_number,
254: p_pl_typ_id in number default hr_api.g_number,
255: p_datetrack_mode in varchar2,
256: p_validation_start_date in date,
257: p_validation_end_date in date) Is

Line 254: p_pl_typ_id in number default hr_api.g_number,

250: Procedure dt_update_validate
251: (p_pgm_id in number default hr_api.g_number,
252: p_cm_typ_id in number default hr_api.g_number,
253: p_pl_id in number default hr_api.g_number,
254: p_pl_typ_id in number default hr_api.g_number,
255: p_datetrack_mode in varchar2,
256: p_validation_start_date in date,
257: p_validation_end_date in date) Is
258: --

Line 268: hr_api.mandatory_arg_error

264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Ensure that the p_datetrack_mode argument is not null
267: --
268: hr_api.mandatory_arg_error
269: (p_api_name => l_proc,
270: p_argument => 'datetrack_mode',
271: p_argument_value => p_datetrack_mode);
272: --

Line 280: hr_api.mandatory_arg_error

276: --
277: --
278: -- Ensure the arguments are not null
279: --
280: hr_api.mandatory_arg_error
281: (p_api_name => l_proc,
282: p_argument => 'validation_start_date',
283: p_argument_value => p_validation_start_date);
284: --

Line 285: hr_api.mandatory_arg_error

281: (p_api_name => l_proc,
282: p_argument => 'validation_start_date',
283: p_argument_value => p_validation_start_date);
284: --
285: hr_api.mandatory_arg_error
286: (p_api_name => l_proc,
287: p_argument => 'validation_end_date',
288: p_argument_value => p_validation_end_date);
289: --

Line 290: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

286: (p_api_name => l_proc,
287: p_argument => 'validation_end_date',
288: p_argument_value => p_validation_end_date);
289: --
290: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
291: NOT (dt_api.check_min_max_dates
292: (p_base_table_name => 'ben_pgm_f',
293: p_base_key_column => 'pgm_id',
294: p_base_key_value => p_pgm_id,

Line 300: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and

296: p_to_date => p_validation_end_date))) Then
297: l_table_name := 'ben_pgm_f';
298: Raise l_integrity_error;
299: End If;
300: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
301: NOT (dt_api.check_min_max_dates
302: (p_base_table_name => 'ben_cm_typ_f',
303: p_base_key_column => 'cm_typ_id',
304: p_base_key_value => p_cm_typ_id,

Line 310: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

306: p_to_date => p_validation_end_date))) Then
307: l_table_name := 'ben_cm_typ_f';
308: Raise l_integrity_error;
309: End If;
310: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
311: NOT (dt_api.check_min_max_dates
312: (p_base_table_name => 'ben_pl_f',
313: p_base_key_column => 'pl_id',
314: p_base_key_value => p_pl_id,

Line 320: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and

316: p_to_date => p_validation_end_date))) Then
317: l_table_name := 'ben_pl_f';
318: Raise l_integrity_error;
319: End If;
320: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
321: NOT (dt_api.check_min_max_dates
322: (p_base_table_name => 'ben_pl_typ_f',
323: p_base_key_column => 'pl_typ_id',
324: p_base_key_value => p_pl_typ_id,

Line 402: hr_api.mandatory_arg_error

398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Ensure that the p_datetrack_mode argument is not null
401: --
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc,
404: p_argument => 'datetrack_mode',
405: p_argument_value => p_datetrack_mode);
406: --

Line 416: hr_api.mandatory_arg_error

412: --
413: --
414: -- Ensure the arguments are not null
415: --
416: hr_api.mandatory_arg_error
417: (p_api_name => l_proc,
418: p_argument => 'validation_start_date',
419: p_argument_value => p_validation_start_date);
420: --

Line 421: hr_api.mandatory_arg_error

417: (p_api_name => l_proc,
418: p_argument => 'validation_start_date',
419: p_argument_value => p_validation_start_date);
420: --
421: hr_api.mandatory_arg_error
422: (p_api_name => l_proc,
423: p_argument => 'validation_end_date',
424: p_argument_value => p_validation_end_date);
425: --

Line 426: hr_api.mandatory_arg_error

422: (p_api_name => l_proc,
423: p_argument => 'validation_end_date',
424: p_argument_value => p_validation_end_date);
425: --
426: hr_api.mandatory_arg_error
427: (p_api_name => l_proc,
428: p_argument => 'cm_typ_usg_id',
429: p_argument_value => p_cm_typ_usg_id);
430: --

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

476: --
477: -- Call all supporting business operations
478: --
479: --
480: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
481: --
482: chk_cm_typ_usg_id
483: (p_cm_typ_usg_id => p_rec.cm_typ_usg_id,
484: p_effective_date => p_effective_date,

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

517: --
518: -- Call all supporting business operations
519: --
520: --
521: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
522: --
523: chk_cm_typ_usg_id
524: (p_cm_typ_usg_id => p_rec.cm_typ_usg_id,
525: p_effective_date => p_effective_date,

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

605: hr_utility.set_location('Entering:'|| l_proc, 10);
606: --
607: -- Ensure that all the mandatory parameter are not null
608: --
609: hr_api.mandatory_arg_error(p_api_name => l_proc,
610: p_argument => 'cm_typ_usg_id',
611: p_argument_value => p_cm_typ_usg_id);
612: --
613: open csr_leg_code;