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_BUR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_bur_shd.g_old_rec.brgng_unit_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_brgng_unit_cd
124: <> nvl(ben_bur_shd.g_old_rec.brgng_unit_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_brgng_unit_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_brgng_unit_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 => 'BARGAINING_UNIT_CODE',
132: p_lookup_code => p_brgng_unit_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 199: and brgng_unit_rt_id <> nvl(p_brgng_unit_rt_id,hr_api.g_number)

195: select null
196: from ben_brgng_unit_rt_f
197: where brgng_unit_cd = p_brgng_unit_cd
198: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
199: and brgng_unit_rt_id <> nvl(p_brgng_unit_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 nvl(p_brgng_unit_cd,hr_api.g_varchar2) <> nvl(ben_bur_shd.g_old_rec.brgng_unit_cd,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 nvl(p_brgng_unit_cd,hr_api.g_varchar2) <> nvl(ben_bur_shd.g_old_rec.brgng_unit_cd,hr_api.g_varchar2)
215: or not l_api_updating) then
216:
217: open c_dup;
218: fetch c_dup into l_exists;

Line 282: <> nvl(ben_bur_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

278: p_object_version_number => p_object_version_number);
279: --
280: if (l_api_updating
281: and p_excld_flag
282: <> nvl(ben_bur_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
283: or not l_api_updating) then
284: --
285: -- check if value of lookup falls within lookup type.
286: --

Line 288: if hr_api.not_exists_in_hr_lookups

284: --
285: -- check if value of lookup falls within lookup type.
286: --
287: --
288: if hr_api.not_exists_in_hr_lookups
289: (p_lookup_type => 'YES_NO',
290: p_lookup_code => p_excld_flag,
291: p_effective_date => p_effective_date) then
292: --

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

332: --
333: -- {End Of Comments}
334: -- ----------------------------------------------------------------------------
335: Procedure dt_update_validate
336: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
337: p_datetrack_mode in varchar2,
338: p_validation_start_date in date,
339: p_validation_end_date in date) Is
340: --

Line 350: hr_api.mandatory_arg_error

346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Ensure that the p_datetrack_mode argument is not null
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'datetrack_mode',
353: p_argument_value => p_datetrack_mode);
354: --

Line 362: hr_api.mandatory_arg_error

358: --
359: --
360: -- Ensure the arguments are not null
361: --
362: hr_api.mandatory_arg_error
363: (p_api_name => l_proc,
364: p_argument => 'validation_start_date',
365: p_argument_value => p_validation_start_date);
366: --

Line 367: hr_api.mandatory_arg_error

363: (p_api_name => l_proc,
364: p_argument => 'validation_start_date',
365: p_argument_value => p_validation_start_date);
366: --
367: hr_api.mandatory_arg_error
368: (p_api_name => l_proc,
369: p_argument => 'validation_end_date',
370: p_argument_value => p_validation_end_date);
371: --

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

368: (p_api_name => l_proc,
369: p_argument => 'validation_end_date',
370: p_argument_value => p_validation_end_date);
371: --
372: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
373: NOT (dt_api.check_min_max_dates
374: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
375: p_base_key_column => 'vrbl_rt_prfl_id',
376: p_base_key_value => p_vrbl_rt_prfl_id,

Line 515: hr_api.mandatory_arg_error

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

Line 529: hr_api.mandatory_arg_error

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

Line 534: hr_api.mandatory_arg_error

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

Line 539: hr_api.mandatory_arg_error

535: (p_api_name => l_proc,
536: p_argument => 'validation_end_date',
537: p_argument_value => p_validation_end_date);
538: --
539: hr_api.mandatory_arg_error
540: (p_api_name => l_proc,
541: p_argument => 'brgng_unit_rt_id',
542: p_argument_value => p_brgng_unit_rt_id);
543: --

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

582: --
583: -- Call all supporting business operations
584: --
585: --
586: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
587: --
588: chk_brgng_unit_rt_id
589: (p_brgng_unit_rt_id => p_rec.brgng_unit_rt_id,
590: p_effective_date => p_effective_date,

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

643: --
644: -- Call all supporting business operations
645: --
646: --
647: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
648: --
649: chk_brgng_unit_rt_id
650: (p_brgng_unit_rt_id => p_rec.brgng_unit_rt_id,
651: p_effective_date => p_effective_date,

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

753: hr_utility.set_location('Entering:'|| l_proc, 10);
754: --
755: -- Ensure that all the mandatory parameter are not null
756: --
757: hr_api.mandatory_arg_error(p_api_name => l_proc,
758: p_argument => 'brgng_unit_rt_id',
759: p_argument_value => p_brgng_unit_rt_id);
760: --
761: open csr_leg_code;