DBA Data[Home] [Help]

APPS.BEN_RRB_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_rrb_shd.g_old_rec.regn_admin_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_regn_admin_cd
124: <> nvl(ben_rrb_shd.g_old_rec.regn_admin_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_regn_admin_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_regn_admin_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'BEN_REGN_ADMN',
132: p_lookup_code => p_regn_admin_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 197: and regn_for_regy_body_id <> nvl(p_regn_for_regy_body_id,hr_api.g_number)

193: select null
194: from ben_regn_for_regy_body_f
195: where organization_id = p_organization_id
196: and regn_id = p_regn_id
197: and regn_for_regy_body_id <> nvl(p_regn_for_regy_body_id,hr_api.g_number)
198: and business_group_id + 0 = p_business_group_id
199: and p_validation_start_date <= effective_end_date
200: and p_validation_end_date >= effective_start_date
201: ;

Line 269: (p_regn_id in number default hr_api.g_number,

265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure dt_update_validate
269: (p_regn_id in number default hr_api.g_number,
270: p_datetrack_mode in varchar2,
271: p_validation_start_date in date,
272: p_validation_end_date in date) Is
273: --

Line 283: hr_api.mandatory_arg_error

279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Ensure that the p_datetrack_mode argument is not null
282: --
283: hr_api.mandatory_arg_error
284: (p_api_name => l_proc,
285: p_argument => 'datetrack_mode',
286: p_argument_value => p_datetrack_mode);
287: --

Line 295: hr_api.mandatory_arg_error

291: --
292: --
293: -- Ensure the arguments are not null
294: --
295: hr_api.mandatory_arg_error
296: (p_api_name => l_proc,
297: p_argument => 'validation_start_date',
298: p_argument_value => p_validation_start_date);
299: --

Line 300: hr_api.mandatory_arg_error

296: (p_api_name => l_proc,
297: p_argument => 'validation_start_date',
298: p_argument_value => p_validation_start_date);
299: --
300: hr_api.mandatory_arg_error
301: (p_api_name => l_proc,
302: p_argument => 'validation_end_date',
303: p_argument_value => p_validation_end_date);
304: --

Line 305: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and

301: (p_api_name => l_proc,
302: p_argument => 'validation_end_date',
303: p_argument_value => p_validation_end_date);
304: --
305: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
306: NOT (dt_api.check_min_max_dates
307: (p_base_table_name => 'ben_regn_f',
308: p_base_key_column => 'regn_id',
309: p_base_key_value => p_regn_id,

Line 389: hr_api.mandatory_arg_error

385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Ensure that the p_datetrack_mode argument is not null
388: --
389: hr_api.mandatory_arg_error
390: (p_api_name => l_proc,
391: p_argument => 'datetrack_mode',
392: p_argument_value => p_datetrack_mode);
393: --

Line 403: hr_api.mandatory_arg_error

399: --
400: --
401: -- Ensure the arguments are not null
402: --
403: hr_api.mandatory_arg_error
404: (p_api_name => l_proc,
405: p_argument => 'validation_start_date',
406: p_argument_value => p_validation_start_date);
407: --

Line 408: hr_api.mandatory_arg_error

404: (p_api_name => l_proc,
405: p_argument => 'validation_start_date',
406: p_argument_value => p_validation_start_date);
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc,
410: p_argument => 'validation_end_date',
411: p_argument_value => p_validation_end_date);
412: --

Line 413: hr_api.mandatory_arg_error

409: (p_api_name => l_proc,
410: p_argument => 'validation_end_date',
411: p_argument_value => p_validation_end_date);
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc,
415: p_argument => 'regn_for_regy_body_id',
416: p_argument_value => p_regn_for_regy_body_id);
417: --

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

457: --
458: -- Call all supporting business operations
459: --
460: --
461: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
462: --
463: chk_regn_for_regy_body_id
464: (p_regn_for_regy_body_id => p_rec.regn_for_regy_body_id,
465: p_effective_date => p_effective_date,

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

501: --
502: -- Call all supporting business operations
503: --
504: --
505: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
506: --
507: chk_regn_for_regy_body_id
508: (p_regn_for_regy_body_id => p_rec.regn_for_regy_body_id,
509: p_effective_date => p_effective_date,

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

590: hr_utility.set_location('Entering:'|| l_proc, 10);
591: --
592: -- Ensure that all the mandatory parameter are not null
593: --
594: hr_api.mandatory_arg_error(p_api_name => l_proc,
595: p_argument => 'regn_for_regy_body_id',
596: p_argument_value => p_regn_for_regy_body_id);
597: --
598: open csr_leg_code;