APPS.BEN_PRB_BUS dependencies on HR_API

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

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

Line 129: and nvl(p_rptg_grp_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_rptg_grp_id,hr_api.g_number)
130: <> nvl(ben_prb_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_rptg_grp_id is not null then
133: --

Line 130: <> nvl(ben_prb_shd.g_old_rec.rptg_grp_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_rptg_grp_id,hr_api.g_number)
130: <> nvl(ben_prb_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_rptg_grp_id is not null then
133: --
134: -- check if rptg_grp_id value exists in ben_rptg_grp table

Line 279: and nvl(p_organization_id,hr_api.g_number)

275: p_effective_date => p_effective_date,
276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and nvl(p_organization_id,hr_api.g_number)
280: <> nvl(ben_prb_shd.g_old_rec.organization_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_organization_id is not null then
283: --

Line 280: <> nvl(ben_prb_shd.g_old_rec.organization_id,hr_api.g_number)

276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and nvl(p_organization_id,hr_api.g_number)
280: <> nvl(ben_prb_shd.g_old_rec.organization_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_organization_id is not null then
283: --
284: -- check if organization_id value exists in hr_all_organization_units table

Line 355: <> nvl(ben_prb_shd.g_old_rec.quald_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_quald_flag
355: <> nvl(ben_prb_shd.g_old_rec.quald_flag,hr_api.g_varchar2)
356: or not l_api_updating)
357: and p_quald_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.

Line 361: if hr_api.not_exists_in_hr_lookups

357: and p_quald_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'YES_NO',
363: p_lookup_code => p_quald_flag,
364: p_effective_date => p_effective_date) then
365: --

Line 473: (p_pl_id in number default hr_api.g_number,

469: --
470: -- {End Of Comments}
471: -- ----------------------------------------------------------------------------
472: Procedure dt_update_validate
473: (p_pl_id in number default hr_api.g_number,
474: p_datetrack_mode in varchar2,
475: p_validation_start_date in date,
476: p_validation_end_date in date) Is
477: --

Line 487: hr_api.mandatory_arg_error

483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Ensure that the p_datetrack_mode argument is not null
486: --
487: hr_api.mandatory_arg_error
488: (p_api_name => l_proc,
489: p_argument => 'datetrack_mode',
490: p_argument_value => p_datetrack_mode);
491: --

Line 499: hr_api.mandatory_arg_error

495: --
496: --
497: -- Ensure the arguments are not null
498: --
499: hr_api.mandatory_arg_error
500: (p_api_name => l_proc,
501: p_argument => 'validation_start_date',
502: p_argument_value => p_validation_start_date);
503: --

Line 504: hr_api.mandatory_arg_error

500: (p_api_name => l_proc,
501: p_argument => 'validation_start_date',
502: p_argument_value => p_validation_start_date);
503: --
504: hr_api.mandatory_arg_error
505: (p_api_name => l_proc,
506: p_argument => 'validation_end_date',
507: p_argument_value => p_validation_end_date);
508: --

Line 509: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

505: (p_api_name => l_proc,
506: p_argument => 'validation_end_date',
507: p_argument_value => p_validation_end_date);
508: --
509: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
510: NOT (dt_api.check_min_max_dates
511: (p_base_table_name => 'ben_pl_f',
512: p_base_key_column => 'pl_id',
513: p_base_key_value => p_pl_id,

Line 593: hr_api.mandatory_arg_error

589: hr_utility.set_location('Entering:'||l_proc, 5);
590: --
591: -- Ensure that the p_datetrack_mode argument is not null
592: --
593: hr_api.mandatory_arg_error
594: (p_api_name => l_proc,
595: p_argument => 'datetrack_mode',
596: p_argument_value => p_datetrack_mode);
597: --

Line 607: hr_api.mandatory_arg_error

603: --
604: --
605: -- Ensure the arguments are not null
606: --
607: hr_api.mandatory_arg_error
608: (p_api_name => l_proc,
609: p_argument => 'validation_start_date',
610: p_argument_value => p_validation_start_date);
611: --

Line 612: hr_api.mandatory_arg_error

608: (p_api_name => l_proc,
609: p_argument => 'validation_start_date',
610: p_argument_value => p_validation_start_date);
611: --
612: hr_api.mandatory_arg_error
613: (p_api_name => l_proc,
614: p_argument => 'validation_end_date',
615: p_argument_value => p_validation_end_date);
616: --

Line 617: hr_api.mandatory_arg_error

613: (p_api_name => l_proc,
614: p_argument => 'validation_end_date',
615: p_argument_value => p_validation_end_date);
616: --
617: hr_api.mandatory_arg_error
618: (p_api_name => l_proc,
619: p_argument => 'pl_regy_bod_id',
620: p_argument_value => p_pl_regy_bod_id);
621: --

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

668: --
669: -- CWB Changes
670: if p_rec.business_group_id is not null then
671: --
672: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
673: --
674: end if;
675: --
676: chk_pl_regy_bod_id

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

724: --
725: -- CWB Changes
726: if p_rec.business_group_id is not null then
727: --
728: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
729: --
730: end if;
731: --
732: chk_pl_regy_bod_id

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

822: hr_utility.set_location('Entering:'|| l_proc, 10);
823: --
824: -- Ensure that all the mandatory parameter are not null
825: --
826: hr_api.mandatory_arg_error(p_api_name => l_proc,
827: p_argument => 'pl_regy_bod_id',
828: p_argument_value => p_pl_regy_bod_id);
829: --
830: open csr_leg_code;