DBA Data[Home] [Help]

APPS.BEN_PRT_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_prt_shd.g_old_rec.poe_nnmntry_uom,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_poe_nnmntry_uom
124: <> nvl(ben_prt_shd.g_old_rec.poe_nnmntry_uom,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_poe_nnmntry_uom 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_poe_nnmntry_uom 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 => 'BEN_RQD_PERD_ENRT_NENRT_TM_UOM',
132: p_lookup_code => p_poe_nnmntry_uom,
133: p_effective_date => p_effective_date) then
134: --

Line 204: and nvl(p_rndg_rl,hr_api.g_number)

200: p_effective_date => p_effective_date,
201: p_object_version_number => p_object_version_number);
202: --
203: if (l_api_updating
204: and nvl(p_rndg_rl,hr_api.g_number)
205: <> ben_prt_shd.g_old_rec.rndg_rl
206: or not l_api_updating)
207: and p_rndg_rl is not null then
208: --

Line 281: <> nvl(ben_prt_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and p_rndg_cd
281: <> nvl(ben_prt_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
282: or not l_api_updating)
283: and p_rndg_cd is not null then
284: --
285: -- check if value of lookup falls within lookup type.

Line 287: if hr_api.not_exists_in_hr_lookups

283: and p_rndg_cd is not null then
284: --
285: -- check if value of lookup falls within lookup type.
286: --
287: if hr_api.not_exists_in_hr_lookups
288: (p_lookup_type => 'BEN_RNDG',
289: p_lookup_code => p_rndg_cd,
290: p_effective_date => p_effective_date) then
291: --

Line 350: <> nvl(ben_prt_shd.g_old_rec.no_mx_poe_flag,hr_api.g_varchar2)

346: p_object_version_number => p_object_version_number);
347: --
348: if (l_api_updating
349: and p_no_mx_poe_flag
350: <> nvl(ben_prt_shd.g_old_rec.no_mx_poe_flag,hr_api.g_varchar2)
351: or not l_api_updating) then
352: --
353: -- check if value of lookup falls within lookup type.
354: --

Line 356: if hr_api.not_exists_in_hr_lookups

352: --
353: -- check if value of lookup falls within lookup type.
354: --
355: --
356: if hr_api.not_exists_in_hr_lookups
357: (p_lookup_type => 'YES_NO',
358: p_lookup_code => p_no_mx_poe_flag,
359: p_effective_date => p_effective_date) then
360: --

Line 419: <> nvl(ben_prt_shd.g_old_rec.no_mn_poe_flag,hr_api.g_varchar2)

415: p_object_version_number => p_object_version_number);
416: --
417: if (l_api_updating
418: and p_no_mn_poe_flag
419: <> nvl(ben_prt_shd.g_old_rec.no_mn_poe_flag,hr_api.g_varchar2)
420: or not l_api_updating) then
421: --
422: -- check if value of lookup falls within lookup type.
423: --

Line 425: if hr_api.not_exists_in_hr_lookups

421: --
422: -- check if value of lookup falls within lookup type.
423: --
424: --
425: if hr_api.not_exists_in_hr_lookups
426: (p_lookup_type => 'YES_NO',
427: p_lookup_code => p_no_mn_poe_flag,
428: p_effective_date => p_effective_date) then
429: --

Line 488: <> nvl(ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag,hr_api.g_varchar2)

484: p_object_version_number => p_object_version_number);
485: --
486: if (l_api_updating
487: and p_cbr_dsblty_apls_flag
488: <> nvl(ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag,hr_api.g_varchar2)
489: or not l_api_updating) then
490: --
491: -- check if value of lookup falls within lookup type.
492: --

Line 494: if hr_api.not_exists_in_hr_lookups

490: --
491: -- check if value of lookup falls within lookup type.
492: --
493: --
494: if hr_api.not_exists_in_hr_lookups
495: (p_lookup_type => 'YES_NO',
496: p_lookup_code => p_cbr_dsblty_apls_flag,
497: p_effective_date => p_effective_date) then
498: --

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

636: --
637: -- {End Of Comments}
638: -- ----------------------------------------------------------------------------
639: Procedure dt_update_validate
640: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
641: p_datetrack_mode in varchar2,
642: p_validation_start_date in date,
643: p_validation_end_date in date) Is
644: --

Line 654: hr_api.mandatory_arg_error

650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: -- Ensure that the p_datetrack_mode argument is not null
653: --
654: hr_api.mandatory_arg_error
655: (p_api_name => l_proc,
656: p_argument => 'datetrack_mode',
657: p_argument_value => p_datetrack_mode);
658: --

Line 666: hr_api.mandatory_arg_error

662: --
663: --
664: -- Ensure the arguments are not null
665: --
666: hr_api.mandatory_arg_error
667: (p_api_name => l_proc,
668: p_argument => 'validation_start_date',
669: p_argument_value => p_validation_start_date);
670: --

Line 671: hr_api.mandatory_arg_error

667: (p_api_name => l_proc,
668: p_argument => 'validation_start_date',
669: p_argument_value => p_validation_start_date);
670: --
671: hr_api.mandatory_arg_error
672: (p_api_name => l_proc,
673: p_argument => 'validation_end_date',
674: p_argument_value => p_validation_end_date);
675: --

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

672: (p_api_name => l_proc,
673: p_argument => 'validation_end_date',
674: p_argument_value => p_validation_end_date);
675: --
676: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
677: NOT (dt_api.check_min_max_dates
678: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
679: p_base_key_column => 'vrbl_rt_prfl_id',
680: p_base_key_value => p_vrbl_rt_prfl_id,

Line 759: hr_api.mandatory_arg_error

755: hr_utility.set_location('Entering:'||l_proc, 5);
756: --
757: -- Ensure that the p_datetrack_mode argument is not null
758: --
759: hr_api.mandatory_arg_error
760: (p_api_name => l_proc,
761: p_argument => 'datetrack_mode',
762: p_argument_value => p_datetrack_mode);
763: --

Line 773: hr_api.mandatory_arg_error

769: --
770: --
771: -- Ensure the arguments are not null
772: --
773: hr_api.mandatory_arg_error
774: (p_api_name => l_proc,
775: p_argument => 'validation_start_date',
776: p_argument_value => p_validation_start_date);
777: --

Line 778: hr_api.mandatory_arg_error

774: (p_api_name => l_proc,
775: p_argument => 'validation_start_date',
776: p_argument_value => p_validation_start_date);
777: --
778: hr_api.mandatory_arg_error
779: (p_api_name => l_proc,
780: p_argument => 'validation_end_date',
781: p_argument_value => p_validation_end_date);
782: --

Line 783: hr_api.mandatory_arg_error

779: (p_api_name => l_proc,
780: p_argument => 'validation_end_date',
781: p_argument_value => p_validation_end_date);
782: --
783: hr_api.mandatory_arg_error
784: (p_api_name => l_proc,
785: p_argument => 'poe_rt_id',
786: p_argument_value => p_poe_rt_id);
787: --

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

826: hr_utility.set_location('Entering:'||l_proc, 5);
827: --
828: -- Call all supporting business operations
829: --
830: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
831: --
832: chk_poe_rt_id
833: (p_poe_rt_id => p_rec.poe_rt_id,
834: p_effective_date => p_effective_date,

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

897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: -- Call all supporting business operations
900: --
901: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
902: --
903: chk_poe_rt_id
904: (p_poe_rt_id => p_rec.poe_rt_id,
905: p_effective_date => p_effective_date,

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

1013: hr_utility.set_location('Entering:'|| l_proc, 10);
1014: --
1015: -- Ensure that all the mandatory parameter are not null
1016: --
1017: hr_api.mandatory_arg_error(p_api_name => l_proc,
1018: p_argument => 'poe_rt_id',
1019: p_argument_value => p_poe_rt_id);
1020: --
1021: open csr_leg_code;