DBA Data[Home] [Help]

APPS.BEN_CGP_BUS dependencies on HR_API

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

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

Line 140: and nvl(p_cntng_frmr_prtt_dsge_rl,hr_api.g_number)

136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_cntng_frmr_prtt_dsge_rl,hr_api.g_number)
141: <> ben_cgp_shd.g_old_rec.cntng_frmr_prtt_dsge_rl
142: or not l_api_updating)
143: and p_cntng_frmr_prtt_dsge_rl is not null then
144: --

Line 225: and nvl(p_cntng_frmr_prtt_rl,hr_api.g_number)

221: p_effective_date => p_effective_date,
222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and nvl(p_cntng_frmr_prtt_rl,hr_api.g_number)
226: <> ben_cgp_shd.g_old_rec.cntng_frmr_prtt_rl
227: or not l_api_updating)
228: and p_cntng_frmr_prtt_rl is not null then
229: --

Line 302: <> nvl(ben_cgp_shd.g_old_rec.dsge_must_be_redsgd_flag,hr_api.g_varchar2)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and p_dsge_must_be_redsgd_flag
302: <> nvl(ben_cgp_shd.g_old_rec.dsge_must_be_redsgd_flag,hr_api.g_varchar2)
303: or not l_api_updating) then
304: --
305: -- check if value of lookup falls within lookup type.
306: --

Line 308: if hr_api.not_exists_in_hr_lookups

304: --
305: -- check if value of lookup falls within lookup type.
306: --
307: --
308: if hr_api.not_exists_in_hr_lookups
309: (p_lookup_type => 'ENTER-LKP-TYPE',
310: p_lookup_code => p_dsge_must_be_redsgd_flag,
311: p_effective_date => p_effective_date) then
312: --

Line 388: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)

384: p_effective_date => p_effective_date,
385: p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating
388: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
389: <> ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl
390: or not l_api_updating)
391: and p_pymt_must_be_rcvd_rl is not null then
392: --

Line 468: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom,hr_api.g_varchar2)

464: p_object_version_number => p_object_version_number);
465: --
466: if (l_api_updating
467: and p_pymt_must_be_rcvd_uom
468: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom,hr_api.g_varchar2)
469: or not l_api_updating) then
470: --
471: -- check if value of lookup falls within lookup type.
472: --

Line 474: if hr_api.not_exists_in_hr_lookups

470: --
471: -- check if value of lookup falls within lookup type.
472: --
473: if p_pymt_must_be_rcvd_uom is not null then
474: if hr_api.not_exists_in_hr_lookups
475: (p_lookup_type => 'BEN_TM_UOM',
476: p_lookup_code => p_pymt_must_be_rcvd_uom,
477: p_effective_date => p_effective_date) then
478: --

Line 547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)

543: p_effective_date => p_effective_date,
544: p_object_version_number => p_object_version_number);
545: --
546: if (l_api_updating
547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)

Line 548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or

544: p_object_version_number => p_object_version_number);
545: --
546: if (l_api_updating
547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)

Line 549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)

545: --
546: if (l_api_updating
547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)
553: or not l_api_updating) then

Line 550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or

546: if (l_api_updating
547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)
553: or not l_api_updating) then
554: --

Line 551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)

547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)
553: or not l_api_updating) then
554: --
555: if (p_pymt_must_be_rcvd_num is not null and p_pymt_must_be_rcvd_uom is null) then

Line 552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)

548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)
553: or not l_api_updating) then
554: --
555: if (p_pymt_must_be_rcvd_num is not null and p_pymt_must_be_rcvd_uom is null) then
556: -- num without uom - raise error

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

607: --
608: -- {End Of Comments}
609: -- ----------------------------------------------------------------------------
610: Procedure dt_update_validate
611: (p_eligy_prfl_id in number default hr_api.g_number,
612: p_datetrack_mode in varchar2,
613: p_validation_start_date in date,
614: p_validation_end_date in date) Is
615: --

Line 625: hr_api.mandatory_arg_error

621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Ensure that the p_datetrack_mode argument is not null
624: --
625: hr_api.mandatory_arg_error
626: (p_api_name => l_proc,
627: p_argument => 'datetrack_mode',
628: p_argument_value => p_datetrack_mode);
629: --

Line 637: hr_api.mandatory_arg_error

633: --
634: --
635: -- Ensure the arguments are not null
636: --
637: hr_api.mandatory_arg_error
638: (p_api_name => l_proc,
639: p_argument => 'validation_start_date',
640: p_argument_value => p_validation_start_date);
641: --

Line 642: hr_api.mandatory_arg_error

638: (p_api_name => l_proc,
639: p_argument => 'validation_start_date',
640: p_argument_value => p_validation_start_date);
641: --
642: hr_api.mandatory_arg_error
643: (p_api_name => l_proc,
644: p_argument => 'validation_end_date',
645: p_argument_value => p_validation_end_date);
646: --

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

643: (p_api_name => l_proc,
644: p_argument => 'validation_end_date',
645: p_argument_value => p_validation_end_date);
646: --
647: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
648: NOT (dt_api.check_min_max_dates
649: (p_base_table_name => 'ben_eligy_prfl_f',
650: p_base_key_column => 'eligy_prfl_id',
651: p_base_key_value => p_eligy_prfl_id,

Line 730: hr_api.mandatory_arg_error

726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- Ensure that the p_datetrack_mode argument is not null
729: --
730: hr_api.mandatory_arg_error
731: (p_api_name => l_proc,
732: p_argument => 'datetrack_mode',
733: p_argument_value => p_datetrack_mode);
734: --

Line 744: hr_api.mandatory_arg_error

740: --
741: --
742: -- Ensure the arguments are not null
743: --
744: hr_api.mandatory_arg_error
745: (p_api_name => l_proc,
746: p_argument => 'validation_start_date',
747: p_argument_value => p_validation_start_date);
748: --

Line 749: hr_api.mandatory_arg_error

745: (p_api_name => l_proc,
746: p_argument => 'validation_start_date',
747: p_argument_value => p_validation_start_date);
748: --
749: hr_api.mandatory_arg_error
750: (p_api_name => l_proc,
751: p_argument => 'validation_end_date',
752: p_argument_value => p_validation_end_date);
753: --

Line 754: hr_api.mandatory_arg_error

750: (p_api_name => l_proc,
751: p_argument => 'validation_end_date',
752: p_argument_value => p_validation_end_date);
753: --
754: hr_api.mandatory_arg_error
755: (p_api_name => l_proc,
756: p_argument => 'cntng_prtn_elig_prfl_id',
757: p_argument_value => p_cntng_prtn_elig_prfl_id);
758: --

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

805: --
806: -- Call all supporting business operations
807: --
808: --
809: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
810: --
811: chk_cntng_prtn_elig_prfl_id
812: (p_cntng_prtn_elig_prfl_id => p_rec.cntng_prtn_elig_prfl_id,
813: p_effective_date => p_effective_date,

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

874: --
875: -- Call all supporting business operations
876: --
877: --
878: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
879: --
880: chk_cntng_prtn_elig_prfl_id
881: (p_cntng_prtn_elig_prfl_id => p_rec.cntng_prtn_elig_prfl_id,
882: p_effective_date => p_effective_date,

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

989: hr_utility.set_location('Entering:'|| l_proc, 10);
990: --
991: -- Ensure that all the mandatory parameter are not null
992: --
993: hr_api.mandatory_arg_error(p_api_name => l_proc,
994: p_argument => 'cntng_prtn_elig_prfl_id',
995: p_argument_value => p_cntng_prtn_elig_prfl_id);
996: --
997: open csr_leg_code;