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

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

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

Line 124: <> nvl(ben_pbc_shd.g_old_rec.bnf_ctfn_rqd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_bnf_ctfn_rqd_flag
124: <> nvl(ben_pbc_shd.g_old_rec.bnf_ctfn_rqd_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_bnf_ctfn_rqd_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 192: and pl_bnf_ctfn_prvdd_id <> nvl(p_pl_bnf_ctfn_prvdd_id, hr_api.g_number)

188: select null
189: from ben_pl_bnf_ctfn_prvdd_f
190: where pl_bnf_id = p_pl_bnf_id
191: and bnf_ctfn_typ_cd = p_bnf_ctfn_typ_cd
192: and pl_bnf_ctfn_prvdd_id <> nvl(p_pl_bnf_ctfn_prvdd_id, hr_api.g_number)
193: and business_group_id + 0 = p_business_group_id
194: and p_validation_start_date <= effective_end_date
195: and p_validation_end_date >= effective_start_date
196: ;

Line 210: <> nvl(ben_pbc_shd.g_old_rec.bnf_ctfn_typ_cd,hr_api.g_varchar2)

206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and p_bnf_ctfn_typ_cd
210: <> nvl(ben_pbc_shd.g_old_rec.bnf_ctfn_typ_cd,hr_api.g_varchar2)
211: or not l_api_updating) then
212: --
213: -- check if value of lookup falls within lookup type.
214: --

Line 216: if hr_api.not_exists_in_hr_lookups

212: --
213: -- check if value of lookup falls within lookup type.
214: --
215: --
216: if hr_api.not_exists_in_hr_lookups
217: (p_lookup_type => 'BEN_BNF_CTFN_TYP',
218: p_lookup_code => p_bnf_ctfn_typ_cd,
219: p_effective_date => p_effective_date) then
220: --

Line 278: (p_pl_bnf_id in number default hr_api.g_number,

274: --
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure dt_update_validate
278: (p_pl_bnf_id in number default hr_api.g_number,
279: p_prtt_enrt_actn_id in number default hr_api.g_number,
280: p_datetrack_mode in varchar2,
281: p_validation_start_date in date,
282: p_validation_end_date in date) Is

Line 279: p_prtt_enrt_actn_id in number default hr_api.g_number,

275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure dt_update_validate
278: (p_pl_bnf_id in number default hr_api.g_number,
279: p_prtt_enrt_actn_id in number default hr_api.g_number,
280: p_datetrack_mode in varchar2,
281: p_validation_start_date in date,
282: p_validation_end_date in date) Is
283: --

Line 293: hr_api.mandatory_arg_error

289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Ensure that the p_datetrack_mode argument is not null
292: --
293: hr_api.mandatory_arg_error
294: (p_api_name => l_proc,
295: p_argument => 'datetrack_mode',
296: p_argument_value => p_datetrack_mode);
297: --

Line 305: hr_api.mandatory_arg_error

301: --
302: --
303: -- Ensure the arguments are not null
304: --
305: hr_api.mandatory_arg_error
306: (p_api_name => l_proc,
307: p_argument => 'validation_start_date',
308: p_argument_value => p_validation_start_date);
309: --

Line 310: hr_api.mandatory_arg_error

306: (p_api_name => l_proc,
307: p_argument => 'validation_start_date',
308: p_argument_value => p_validation_start_date);
309: --
310: hr_api.mandatory_arg_error
311: (p_api_name => l_proc,
312: p_argument => 'validation_end_date',
313: p_argument_value => p_validation_end_date);
314: --

Line 315: If ((nvl(p_pl_bnf_id, hr_api.g_number) <> hr_api.g_number) and

311: (p_api_name => l_proc,
312: p_argument => 'validation_end_date',
313: p_argument_value => p_validation_end_date);
314: --
315: If ((nvl(p_pl_bnf_id, hr_api.g_number) <> hr_api.g_number) and
316: NOT (dt_api.check_min_max_dates
317: (p_base_table_name => 'ben_pl_bnf_f',
318: p_base_key_column => 'pl_bnf_id',
319: p_base_key_value => p_pl_bnf_id,

Line 325: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and

321: p_to_date => p_validation_end_date))) Then
322: l_table_name := 'ben_pl_bnf_f';
323: Raise l_integrity_error;
324: End If;
325: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
326: NOT (dt_api.check_min_max_dates
327: (p_base_table_name => 'ben_prtt_enrt_actn_f',
328: p_base_key_column => 'prtt_enrt_actn_id',
329: p_base_key_value => p_prtt_enrt_actn_id,

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 423: hr_api.mandatory_arg_error

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

Line 428: hr_api.mandatory_arg_error

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

Line 433: hr_api.mandatory_arg_error

429: (p_api_name => l_proc,
430: p_argument => 'validation_end_date',
431: p_argument_value => p_validation_end_date);
432: --
433: hr_api.mandatory_arg_error
434: (p_api_name => l_proc,
435: p_argument => 'pl_bnf_ctfn_prvdd_id',
436: p_argument_value => p_pl_bnf_ctfn_prvdd_id);
437: --

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

477: --
478: -- Call all supporting business operations
479: --
480: --
481: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
482: --
483: chk_pl_bnf_ctfn_prvdd_id
484: (p_pl_bnf_ctfn_prvdd_id => p_rec.pl_bnf_ctfn_prvdd_id,
485: p_effective_date => p_effective_date,

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

521: --
522: -- Call all supporting business operations
523: --
524: --
525: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
526: --
527: chk_pl_bnf_ctfn_prvdd_id
528: (p_pl_bnf_ctfn_prvdd_id => p_rec.pl_bnf_ctfn_prvdd_id,
529: p_effective_date => p_effective_date,

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

610: hr_utility.set_location('Entering:'|| l_proc, 10);
611: --
612: -- Ensure that all the mandatory parameter are not null
613: --
614: hr_api.mandatory_arg_error(p_api_name => l_proc,
615: p_argument => 'pl_bnf_ctfn_prvdd_id',
616: p_argument_value => p_pl_bnf_ctfn_prvdd_id);
617: --
618: open csr_leg_code;