DBA Data[Home] [Help]

APPS.BEN_RGR_BUS dependencies on HR_API

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

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

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

195: p_effective_date => p_effective_date,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_rptg_grp_id,hr_api.g_number)
200: <> nvl(ben_rgr_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
201: or not l_api_updating)
202: -- and p_rptg_grp_id is not null /* Moved the check condition below bug 2690186 */
203: then

Line 200: <> nvl(ben_rgr_shd.g_old_rec.rptg_grp_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_rptg_grp_id,hr_api.g_number)
200: <> nvl(ben_rgr_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
201: or not l_api_updating)
202: -- and p_rptg_grp_id is not null /* Moved the check condition below bug 2690186 */
203: then
204: --

Line 288: and rptg_grp_id = nvl(p_rptg_grp_id, hr_api.g_number)

284: cursor crs_pl_id is
285: select null
286: from ben_popl_rptg_grp_f
287: where pl_id = p_pl_id
288: and rptg_grp_id = nvl(p_rptg_grp_id, hr_api.g_number)
289: and business_group_id + 0 = p_business_group_id
290: and p_validate_start_date <= effective_end_date
291: and p_validate_end_date >= effective_start_date;
292: --iRec

Line 427: and rptg_grp_id = nvl(p_rptg_grp_id, hr_api.g_number)

423: cursor csr_pgm_id is
424: select null
425: from ben_popl_rptg_grp_f
426: where pgm_id = p_pgm_id
427: and rptg_grp_id = nvl(p_rptg_grp_id, hr_api.g_number)
428: and business_group_id + 0 = p_business_group_id
429: and p_validate_start_date <= effective_end_date
430: and p_validate_end_date >= effective_start_date;
431: --

Line 555: (p_pgm_id in number default hr_api.g_number,

551: --
552: -- {End Of Comments}
553: -- ----------------------------------------------------------------------------
554: Procedure dt_update_validate
555: (p_pgm_id in number default hr_api.g_number,
556: p_pl_id in number default hr_api.g_number,
557: p_datetrack_mode in varchar2,
558: p_validation_start_date in date,
559: p_validation_end_date in date) Is

Line 556: p_pl_id in number default hr_api.g_number,

552: -- {End Of Comments}
553: -- ----------------------------------------------------------------------------
554: Procedure dt_update_validate
555: (p_pgm_id in number default hr_api.g_number,
556: p_pl_id in number default hr_api.g_number,
557: p_datetrack_mode in varchar2,
558: p_validation_start_date in date,
559: p_validation_end_date in date) Is
560: --

Line 570: hr_api.mandatory_arg_error

566: hr_utility.set_location('Entering:'||l_proc, 5);
567: --
568: -- Ensure that the p_datetrack_mode argument is not null
569: --
570: hr_api.mandatory_arg_error
571: (p_api_name => l_proc,
572: p_argument => 'datetrack_mode',
573: p_argument_value => p_datetrack_mode);
574: --

Line 582: hr_api.mandatory_arg_error

578: --
579: --
580: -- Ensure the arguments are not null
581: --
582: hr_api.mandatory_arg_error
583: (p_api_name => l_proc,
584: p_argument => 'validation_start_date',
585: p_argument_value => p_validation_start_date);
586: --

Line 587: hr_api.mandatory_arg_error

583: (p_api_name => l_proc,
584: p_argument => 'validation_start_date',
585: p_argument_value => p_validation_start_date);
586: --
587: hr_api.mandatory_arg_error
588: (p_api_name => l_proc,
589: p_argument => 'validation_end_date',
590: p_argument_value => p_validation_end_date);
591: --

Line 592: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

588: (p_api_name => l_proc,
589: p_argument => 'validation_end_date',
590: p_argument_value => p_validation_end_date);
591: --
592: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
593: NOT (dt_api.check_min_max_dates
594: (p_base_table_name => 'ben_pgm_f',
595: p_base_key_column => 'pgm_id',
596: p_base_key_value => p_pgm_id,

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

598: p_to_date => p_validation_end_date))) Then
599: l_table_name := 'ben_pgm_f';
600: Raise l_integrity_error;
601: End If;
602: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
603: NOT (dt_api.check_min_max_dates
604: (p_base_table_name => 'ben_pl_f',
605: p_base_key_column => 'pl_id',
606: p_base_key_value => p_pl_id,

Line 687: hr_api.mandatory_arg_error

683: hr_utility.set_location('Entering:'||l_proc, 5);
684: --
685: -- Ensure that the p_datetrack_mode argument is not null
686: --
687: hr_api.mandatory_arg_error
688: (p_api_name => l_proc,
689: p_argument => 'datetrack_mode',
690: p_argument_value => p_datetrack_mode);
691: --

Line 701: hr_api.mandatory_arg_error

697: --
698: --
699: -- Ensure the arguments are not null
700: --
701: hr_api.mandatory_arg_error
702: (p_api_name => l_proc,
703: p_argument => 'validation_start_date',
704: p_argument_value => p_validation_start_date);
705: --

Line 706: hr_api.mandatory_arg_error

702: (p_api_name => l_proc,
703: p_argument => 'validation_start_date',
704: p_argument_value => p_validation_start_date);
705: --
706: hr_api.mandatory_arg_error
707: (p_api_name => l_proc,
708: p_argument => 'validation_end_date',
709: p_argument_value => p_validation_end_date);
710: --

Line 711: hr_api.mandatory_arg_error

707: (p_api_name => l_proc,
708: p_argument => 'validation_end_date',
709: p_argument_value => p_validation_end_date);
710: --
711: hr_api.mandatory_arg_error
712: (p_api_name => l_proc,
713: p_argument => 'popl_rptg_grp_id',
714: p_argument_value => p_popl_rptg_grp_id);
715: --

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

758: --
759: -- CWB Changes
760: if p_rec.business_group_id is not null then
761: --
762: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
763: --
764: end if;
765: --
766: chk_popl_rptg_grp_id

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

825: --
826: -- CWB Changes
827: if p_rec.business_group_id is not null then
828: --
829: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
830: --
831: end if;
832: --
833: chk_popl_rptg_grp_id

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

937: hr_utility.set_location('Entering:'|| l_proc, 10);
938: --
939: -- Ensure that all the mandatory parameter are not null
940: --
941: hr_api.mandatory_arg_error(p_api_name => l_proc,
942: p_argument => 'popl_rptg_grp_id',
943: p_argument_value => p_popl_rptg_grp_id);
944: --
945: open csr_leg_code;