eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_LMM_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_lmm_shd.g_old_rec.lbr_mmbr_flag,hr_api.g_varchar2)

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

Line 199: and lbr_mmbr_rt_id <> nvl(p_lbr_mmbr_rt_id,hr_api.g_number)

195: select null
196: from ben_lbr_mmbr_rt_f
197: where lbr_mmbr_flag = p_lbr_mmbr_flag
198: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
199: and lbr_mmbr_rt_id <> nvl(p_lbr_mmbr_rt_id,hr_api.g_number)
200: and business_group_id + 0 = p_business_group_id
201: and p_validation_start_date <= effective_end_date
202: and p_validation_end_date >= effective_start_date;
203: --

Line 214: and p_lbr_mmbr_flag <> nvl(ben_lmm_shd.g_old_rec.lbr_mmbr_flag,hr_api.g_varchar2)

210: p_effective_date => p_effective_date,
211: p_object_version_number => p_object_version_number);
212: --
213: if (l_api_updating
214: and p_lbr_mmbr_flag <> nvl(ben_lmm_shd.g_old_rec.lbr_mmbr_flag,hr_api.g_varchar2)
215: or not l_api_updating) then
216:
217: open c_dup;
218: fetch c_dup into l_exists;

Line 341: <> nvl(ben_lmm_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

337: p_object_version_number => p_object_version_number);
338: --
339: if (l_api_updating
340: and p_excld_flag
341: <> nvl(ben_lmm_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
342: or not l_api_updating) then
343: --
344: -- check if value of lookup falls within lookup type.
345: --

Line 347: if hr_api.not_exists_in_hr_lookups

343: --
344: -- check if value of lookup falls within lookup type.
345: --
346: --
347: if hr_api.not_exists_in_hr_lookups
348: (p_lookup_type => 'YES_NO',
349: p_lookup_code => p_excld_flag,
350: p_effective_date => p_effective_date) then
351: --

Line 395: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: Procedure dt_update_validate
395: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
396: p_datetrack_mode in varchar2,
397: p_validation_start_date in date,
398: p_validation_end_date in date) Is
399: --

Line 409: hr_api.mandatory_arg_error

405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Ensure that the p_datetrack_mode argument is not null
408: --
409: hr_api.mandatory_arg_error
410: (p_api_name => l_proc,
411: p_argument => 'datetrack_mode',
412: p_argument_value => p_datetrack_mode);
413: --

Line 421: hr_api.mandatory_arg_error

417: --
418: --
419: -- Ensure the arguments are not null
420: --
421: hr_api.mandatory_arg_error
422: (p_api_name => l_proc,
423: p_argument => 'validation_start_date',
424: p_argument_value => p_validation_start_date);
425: --

Line 426: hr_api.mandatory_arg_error

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

Line 431: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

427: (p_api_name => l_proc,
428: p_argument => 'validation_end_date',
429: p_argument_value => p_validation_end_date);
430: --
431: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
432: NOT (dt_api.check_min_max_dates
433: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
434: p_base_key_column => 'vrbl_rt_prfl_id',
435: p_base_key_value => p_vrbl_rt_prfl_id,

Line 513: hr_api.mandatory_arg_error

509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Ensure that the p_datetrack_mode argument is not null
512: --
513: hr_api.mandatory_arg_error
514: (p_api_name => l_proc,
515: p_argument => 'datetrack_mode',
516: p_argument_value => p_datetrack_mode);
517: --

Line 527: hr_api.mandatory_arg_error

523: --
524: --
525: -- Ensure the arguments are not null
526: --
527: hr_api.mandatory_arg_error
528: (p_api_name => l_proc,
529: p_argument => 'validation_start_date',
530: p_argument_value => p_validation_start_date);
531: --

Line 532: hr_api.mandatory_arg_error

528: (p_api_name => l_proc,
529: p_argument => 'validation_start_date',
530: p_argument_value => p_validation_start_date);
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'validation_end_date',
535: p_argument_value => p_validation_end_date);
536: --

Line 537: hr_api.mandatory_arg_error

533: (p_api_name => l_proc,
534: p_argument => 'validation_end_date',
535: p_argument_value => p_validation_end_date);
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc,
539: p_argument => 'lbr_mmbr_rt_id',
540: p_argument_value => p_lbr_mmbr_rt_id);
541: --

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

581: --
582: -- Call all supporting business operations
583: --
584: --
585: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
586: --
587: chk_lbr_mmbr_rt_id
588: (p_lbr_mmbr_rt_id => p_rec.lbr_mmbr_rt_id,
589: p_effective_date => p_effective_date,

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

638: --
639: -- Call all supporting business operations
640: --
641: --
642: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
643: --
644: chk_lbr_mmbr_rt_id
645: (p_lbr_mmbr_rt_id => p_rec.lbr_mmbr_rt_id,
646: p_effective_date => p_effective_date,

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

739: hr_utility.set_location('Entering:'|| l_proc, 10);
740: --
741: -- Ensure that all the mandatory parameter are not null
742: --
743: hr_api.mandatory_arg_error(p_api_name => l_proc,
744: p_argument => 'lbr_mmbr_rt_id',
745: p_argument_value => p_lbr_mmbr_rt_id);
746: --
747: open csr_leg_code;