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

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

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

Line 128: and nvl(p_pgm_id,hr_api.g_number)

124: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_pgm_id,hr_api.g_number)
129: <> nvl(ben_ecq_shd.g_old_rec.pgm_id,hr_api.g_number)
130: or not l_api_updating) and p_pgm_id is not null then
131: --
132: -- check if pgm_id value exists in ben_pgm_f table

Line 129: <> nvl(ben_ecq_shd.g_old_rec.pgm_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_pgm_id,hr_api.g_number)
129: <> nvl(ben_ecq_shd.g_old_rec.pgm_id,hr_api.g_number)
130: or not l_api_updating) and p_pgm_id is not null then
131: --
132: -- check if pgm_id value exists in ben_pgm_f table
133: --

Line 205: and nvl(p_ptip_id,hr_api.g_number)

201: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
202: p_object_version_number => p_object_version_number);
203: --
204: if (l_api_updating
205: and nvl(p_ptip_id,hr_api.g_number)
206: <> nvl(ben_ecq_shd.g_old_rec.ptip_id,hr_api.g_number)
207: or not l_api_updating) and p_ptip_id is not null then
208: --
209: -- check if ptip_id value exists in ben_ptip_f table

Line 206: <> nvl(ben_ecq_shd.g_old_rec.ptip_id,hr_api.g_number)

202: p_object_version_number => p_object_version_number);
203: --
204: if (l_api_updating
205: and nvl(p_ptip_id,hr_api.g_number)
206: <> nvl(ben_ecq_shd.g_old_rec.ptip_id,hr_api.g_number)
207: or not l_api_updating) and p_ptip_id is not null then
208: --
209: -- check if ptip_id value exists in ben_ptip_f table
210: --

Line 278: <> nvl(ben_ecq_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)

274: p_object_version_number => p_object_version_number);
275: --
276: if (l_api_updating
277: and p_quald_bnf_flag
278: <> nvl(ben_ecq_shd.g_old_rec.quald_bnf_flag,hr_api.g_varchar2)
279: or not l_api_updating) then
280: --
281: -- check if value of lookup falls within lookup type.
282: --

Line 284: if hr_api.not_exists_in_hr_lookups

280: --
281: -- check if value of lookup falls within lookup type.
282: --
283: --
284: if hr_api.not_exists_in_hr_lookups
285: (p_lookup_type => 'YES_NO',
286: p_lookup_code => p_quald_bnf_flag,
287: p_effective_date => p_effective_date) then
288: --

Line 392: (p_eligy_prfl_id in number default hr_api.g_number,

388: --
389: -- {End Of Comments}
390: -- ----------------------------------------------------------------------------
391: Procedure dt_update_validate
392: (p_eligy_prfl_id in number default hr_api.g_number,
393: p_pgm_id in number default hr_api.g_number,
394: p_ptip_id in number default hr_api.g_number,
395: p_datetrack_mode in varchar2,
396: p_validation_start_date in date,

Line 393: p_pgm_id in number default hr_api.g_number,

389: -- {End Of Comments}
390: -- ----------------------------------------------------------------------------
391: Procedure dt_update_validate
392: (p_eligy_prfl_id in number default hr_api.g_number,
393: p_pgm_id in number default hr_api.g_number,
394: p_ptip_id in number default hr_api.g_number,
395: p_datetrack_mode in varchar2,
396: p_validation_start_date in date,
397: p_validation_end_date in date) Is

Line 394: p_ptip_id in number default hr_api.g_number,

390: -- ----------------------------------------------------------------------------
391: Procedure dt_update_validate
392: (p_eligy_prfl_id in number default hr_api.g_number,
393: p_pgm_id in number default hr_api.g_number,
394: p_ptip_id in number default hr_api.g_number,
395: p_datetrack_mode in varchar2,
396: p_validation_start_date in date,
397: p_validation_end_date in date) Is
398: --

Line 408: hr_api.mandatory_arg_error

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

Line 420: hr_api.mandatory_arg_error

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

Line 425: hr_api.mandatory_arg_error

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

Line 430: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

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

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

436: p_to_date => p_validation_end_date))) Then
437: l_table_name := 'ben_eligy_prfl_f';
438: Raise l_integrity_error;
439: End If;
440: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
441: NOT (dt_api.check_min_max_dates
442: (p_base_table_name => 'ben_pgm_f',
443: p_base_key_column => 'pgm_id',
444: p_base_key_value => p_pgm_id,

Line 450: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

446: p_to_date => p_validation_end_date))) Then
447: l_table_name := 'ben_pgm_f';
448: Raise l_integrity_error;
449: End If;
450: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
451: NOT (dt_api.check_min_max_dates
452: (p_base_table_name => 'ben_ptip_f',
453: p_base_key_column => 'ptip_id',
454: p_base_key_value => p_ptip_id,

Line 533: hr_api.mandatory_arg_error

529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: -- Ensure that the p_datetrack_mode argument is not null
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc,
535: p_argument => 'datetrack_mode',
536: p_argument_value => p_datetrack_mode);
537: --

Line 547: hr_api.mandatory_arg_error

543: --
544: --
545: -- Ensure the arguments are not null
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc,
549: p_argument => 'validation_start_date',
550: p_argument_value => p_validation_start_date);
551: --

Line 552: hr_api.mandatory_arg_error

548: (p_api_name => l_proc,
549: p_argument => 'validation_start_date',
550: p_argument_value => p_validation_start_date);
551: --
552: hr_api.mandatory_arg_error
553: (p_api_name => l_proc,
554: p_argument => 'validation_end_date',
555: p_argument_value => p_validation_end_date);
556: --

Line 557: hr_api.mandatory_arg_error

553: (p_api_name => l_proc,
554: p_argument => 'validation_end_date',
555: p_argument_value => p_validation_end_date);
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc,
559: p_argument => 'elig_cbr_quald_bnf_id',
560: p_argument_value => p_elig_cbr_quald_bnf_id);
561: --

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

601: --
602: -- Call all supporting business operations
603: --
604: --
605: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
606: --
607: chk_elig_cbr_quald_bnf_id
608: (p_elig_cbr_quald_bnf_id => p_rec.elig_cbr_quald_bnf_id,
609: p_effective_date => p_effective_date,

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

653: --
654: -- Call all supporting business operations
655: --
656: --
657: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
658: --
659: chk_elig_cbr_quald_bnf_id
660: (p_elig_cbr_quald_bnf_id => p_rec.elig_cbr_quald_bnf_id,
661: p_effective_date => p_effective_date,

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

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