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

Line 55: and nvl(p_wv_prtn_rsn_ctfn_ptip_id,hr_api.g_number)

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

Line 126: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd,hr_api.g_varchar2)

122: p_object_version_number => p_object_version_number);
123: --
124: if (l_api_updating
125: and p_wv_prtn_ctfn_typ_cd
126: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd,hr_api.g_varchar2)
127: or not l_api_updating) and
128: p_wv_prtn_ctfn_typ_cd is not null then
129: --
130: -- check if value of lookup falls within lookup type.

Line 133: if hr_api.not_exists_in_hr_lookups

129: --
130: -- check if value of lookup falls within lookup type.
131: --
132: --
133: if hr_api.not_exists_in_hr_lookups
134: (p_lookup_type => 'BEN_WV_PRTN_CTFN_TYP',
135: p_lookup_code => p_wv_prtn_ctfn_typ_cd,
136: p_effective_date => p_effective_date) then
137: --

Line 196: <> nvl(ben_wct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_pfd_flag
196: <> nvl(ben_wct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
197: or not l_api_updating)
198: and p_pfd_flag is not null then
199: --
200: -- check if value of lookup falls within lookup type.

Line 202: if hr_api.not_exists_in_hr_lookups

198: and p_pfd_flag is not null then
199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'YES_NO',
204: p_lookup_code => p_pfd_flag,
205: p_effective_date => p_effective_date) then
206: --

Line 281: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)

277: p_effective_date => p_effective_date,
278: p_object_version_number => p_object_version_number);
279: --
280: if (l_api_updating
281: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
282: <> ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
283: or not l_api_updating)
284: and p_ctfn_rqd_when_rl is not null then
285: --

Line 361: <> nvl(ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)

357: p_object_version_number => p_object_version_number);
358: --
359: if (l_api_updating
360: and p_lack_ctfn_sspnd_wvr_flag
361: <> nvl(ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)
362: or not l_api_updating)
363: and p_lack_ctfn_sspnd_wvr_flag is not null then
364: --
365: -- check if value of lookup falls within lookup type.

Line 367: if hr_api.not_exists_in_hr_lookups

363: and p_lack_ctfn_sspnd_wvr_flag is not null then
364: --
365: -- check if value of lookup falls within lookup type.
366: --
367: if hr_api.not_exists_in_hr_lookups
368: (p_lookup_type => 'YES_NO',
369: p_lookup_code => p_lack_ctfn_sspnd_wvr_flag,
370: p_effective_date => p_effective_date) then
371: --

Line 431: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd,hr_api.g_varchar2)

427: p_object_version_number => p_object_version_number);
428: --
429: if (l_api_updating
430: and p_wv_prtn_ctfn_cd
431: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd,hr_api.g_varchar2)
432: or not l_api_updating)
433: and p_wv_prtn_ctfn_cd is not null then
434: --
435: -- check if value of lookup falls within lookup type.

Line 437: if hr_api.not_exists_in_hr_lookups

433: and p_wv_prtn_ctfn_cd is not null then
434: --
435: -- check if value of lookup falls within lookup type.
436: --
437: if hr_api.not_exists_in_hr_lookups
438: (p_lookup_type => 'BEN_WV_PRTN_CTFN_TYP',
439: p_lookup_code => p_wv_prtn_ctfn_cd,
440: p_effective_date => p_effective_date) then
441: --

Line 485: (p_ctfn_rqd_when_rl in number default hr_api.g_number,

481: --
482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: Procedure dt_update_validate
485: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
486: p_wv_prtn_rsn_ptip_id in number default hr_api.g_number,
487: p_datetrack_mode in varchar2,
488: p_validation_start_date in date,
489: p_validation_end_date in date) Is

Line 486: p_wv_prtn_rsn_ptip_id in number default hr_api.g_number,

482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: Procedure dt_update_validate
485: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
486: p_wv_prtn_rsn_ptip_id in number default hr_api.g_number,
487: p_datetrack_mode in varchar2,
488: p_validation_start_date in date,
489: p_validation_end_date in date) Is
490: --

Line 500: hr_api.mandatory_arg_error

496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- Ensure that the p_datetrack_mode argument is not null
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'datetrack_mode',
503: p_argument_value => p_datetrack_mode);
504: --

Line 512: hr_api.mandatory_arg_error

508: --
509: --
510: -- Ensure the arguments are not null
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc,
514: p_argument => 'validation_start_date',
515: p_argument_value => p_validation_start_date);
516: --

Line 517: hr_api.mandatory_arg_error

513: (p_api_name => l_proc,
514: p_argument => 'validation_start_date',
515: p_argument_value => p_validation_start_date);
516: --
517: hr_api.mandatory_arg_error
518: (p_api_name => l_proc,
519: p_argument => 'validation_end_date',
520: p_argument_value => p_validation_end_date);
521: --

Line 522: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and

518: (p_api_name => l_proc,
519: p_argument => 'validation_end_date',
520: p_argument_value => p_validation_end_date);
521: --
522: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and
523: NOT (dt_api.check_min_max_dates
524: (p_base_table_name => 'ff_formulas_f',
525: p_base_key_column => 'formula_id',
526: p_base_key_value => p_ctfn_rqd_when_rl,

Line 532: If ((nvl(p_wv_prtn_rsn_ptip_id, hr_api.g_number) <> hr_api.g_number) and

528: p_to_date => p_validation_end_date))) Then
529: l_table_name := 'ff_formulas_f';
530: Raise l_integrity_error;
531: End If;
532: If ((nvl(p_wv_prtn_rsn_ptip_id, hr_api.g_number) <> hr_api.g_number) and
533: NOT (dt_api.check_min_max_dates
534: (p_base_table_name => 'ben_wv_prtn_rsn_ptip_f',
535: p_base_key_column => 'wv_prtn_rsn_ptip_id',
536: p_base_key_value => p_wv_prtn_rsn_ptip_id,

Line 616: hr_api.mandatory_arg_error

612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- Ensure that the p_datetrack_mode argument is not null
615: --
616: hr_api.mandatory_arg_error
617: (p_api_name => l_proc,
618: p_argument => 'datetrack_mode',
619: p_argument_value => p_datetrack_mode);
620: --

Line 630: hr_api.mandatory_arg_error

626: --
627: --
628: -- Ensure the arguments are not null
629: --
630: hr_api.mandatory_arg_error
631: (p_api_name => l_proc,
632: p_argument => 'validation_start_date',
633: p_argument_value => p_validation_start_date);
634: --

Line 635: hr_api.mandatory_arg_error

631: (p_api_name => l_proc,
632: p_argument => 'validation_start_date',
633: p_argument_value => p_validation_start_date);
634: --
635: hr_api.mandatory_arg_error
636: (p_api_name => l_proc,
637: p_argument => 'validation_end_date',
638: p_argument_value => p_validation_end_date);
639: --

Line 640: hr_api.mandatory_arg_error

636: (p_api_name => l_proc,
637: p_argument => 'validation_end_date',
638: p_argument_value => p_validation_end_date);
639: --
640: hr_api.mandatory_arg_error
641: (p_api_name => l_proc,
642: p_argument => 'wv_prtn_rsn_ctfn_ptip_id',
643: p_argument_value => p_wv_prtn_rsn_ctfn_ptip_id);
644: --

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

684: --
685: -- Call all supporting business operations
686: --
687: --
688: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
689: --
690: chk_wv_prtn_rsn_ctfn_ptip_id
691: (p_wv_prtn_rsn_ctfn_ptip_id => p_rec.wv_prtn_rsn_ctfn_ptip_id,
692: p_effective_date => p_effective_date,

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

743: --
744: -- Call all supporting business operations
745: --
746: --
747: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
748: --
749: chk_wv_prtn_rsn_ctfn_ptip_id
750: (p_wv_prtn_rsn_ctfn_ptip_id => p_rec.wv_prtn_rsn_ctfn_ptip_id,
751: p_effective_date => p_effective_date,

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

847: hr_utility.set_location('Entering:'|| l_proc, 10);
848: --
849: -- Ensure that all the mandatory parameter are not null
850: --
851: hr_api.mandatory_arg_error(p_api_name => l_proc,
852: p_argument => 'wv_prtn_rsn_ctfn_ptip_id',
853: p_argument_value => p_wv_prtn_rsn_ctfn_ptip_id);
854: --
855: open csr_leg_code;