APPS.BEN_CPO_BUS dependencies on HR_API

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

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

Line 129: and nvl(p_organization_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_organization_id,hr_api.g_number)
130: <> nvl(ben_cpo_shd.g_old_rec.organization_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if organization_id value exists in hr_all_organization_units table

Line 130: <> nvl(ben_cpo_shd.g_old_rec.organization_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_organization_id,hr_api.g_number)
130: <> nvl(ben_cpo_shd.g_old_rec.organization_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if organization_id value exists in hr_all_organization_units table
134: --

Line 240: (p_pl_id in number default hr_api.g_number,

236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure dt_update_validate
240: (p_pl_id in number default hr_api.g_number,
241: p_pgm_id in number default hr_api.g_number,
242: p_datetrack_mode in varchar2,
243: p_validation_start_date in date,
244: p_validation_end_date in date) Is

Line 241: p_pgm_id in number default hr_api.g_number,

237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure dt_update_validate
240: (p_pl_id in number default hr_api.g_number,
241: p_pgm_id in number default hr_api.g_number,
242: p_datetrack_mode in varchar2,
243: p_validation_start_date in date,
244: p_validation_end_date in date) Is
245: --

Line 255: hr_api.mandatory_arg_error

251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- Ensure that the p_datetrack_mode argument is not null
254: --
255: hr_api.mandatory_arg_error
256: (p_api_name => l_proc,
257: p_argument => 'datetrack_mode',
258: p_argument_value => p_datetrack_mode);
259: --

Line 267: hr_api.mandatory_arg_error

263: --
264: --
265: -- Ensure the arguments are not null
266: --
267: hr_api.mandatory_arg_error
268: (p_api_name => l_proc,
269: p_argument => 'validation_start_date',
270: p_argument_value => p_validation_start_date);
271: --

Line 272: hr_api.mandatory_arg_error

268: (p_api_name => l_proc,
269: p_argument => 'validation_start_date',
270: p_argument_value => p_validation_start_date);
271: --
272: hr_api.mandatory_arg_error
273: (p_api_name => l_proc,
274: p_argument => 'validation_end_date',
275: p_argument_value => p_validation_end_date);
276: --

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

273: (p_api_name => l_proc,
274: p_argument => 'validation_end_date',
275: p_argument_value => p_validation_end_date);
276: --
277: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
278: NOT (dt_api.check_min_max_dates
279: (p_base_table_name => 'ben_pl_f',
280: p_base_key_column => 'pl_id',
281: p_base_key_value => p_pl_id,

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

283: p_to_date => p_validation_end_date))) Then
284: l_table_name := 'ben_pl_f';
285: Raise l_integrity_error;
286: End If;
287: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
288: NOT (dt_api.check_min_max_dates
289: (p_base_table_name => 'ben_pgm_f',
290: p_base_key_column => 'pgm_id',
291: p_base_key_value => p_pgm_id,

Line 371: hr_api.mandatory_arg_error

367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- Ensure that the p_datetrack_mode argument is not null
370: --
371: hr_api.mandatory_arg_error
372: (p_api_name => l_proc,
373: p_argument => 'datetrack_mode',
374: p_argument_value => p_datetrack_mode);
375: --

Line 385: hr_api.mandatory_arg_error

381: --
382: --
383: -- Ensure the arguments are not null
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc,
387: p_argument => 'validation_start_date',
388: p_argument_value => p_validation_start_date);
389: --

Line 390: hr_api.mandatory_arg_error

386: (p_api_name => l_proc,
387: p_argument => 'validation_start_date',
388: p_argument_value => p_validation_start_date);
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc,
392: p_argument => 'validation_end_date',
393: p_argument_value => p_validation_end_date);
394: --

Line 395: hr_api.mandatory_arg_error

391: (p_api_name => l_proc,
392: p_argument => 'validation_end_date',
393: p_argument_value => p_validation_end_date);
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'popl_org_id',
398: p_argument_value => p_popl_org_id);
399: --

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

439: --
440: -- Call all supporting business operations
441: --
442: --
443: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
444: --
445: chk_popl_org_id
446: (p_popl_org_id => p_rec.popl_org_id,
447: p_effective_date => p_effective_date,

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

478: --
479: -- Call all supporting business operations
480: --
481: --
482: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
483: --
484: chk_popl_org_id
485: (p_popl_org_id => p_rec.popl_org_id,
486: p_effective_date => p_effective_date,

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

562: hr_utility.set_location('Entering:'|| l_proc, 10);
563: --
564: -- Ensure that all the mandatory parameter are not null
565: --
566: hr_api.mandatory_arg_error(p_api_name => l_proc,
567: p_argument => 'popl_org_id',
568: p_argument_value => p_popl_org_id);
569: --
570: open csr_leg_code;