DBA Data[Home] [Help]

APPS.BEN_RCL_BUS dependencies on HR_API

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

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

Line 138: and nvl(p_rltd_per_chg_cs_ler_rl,hr_api.g_number)

134: p_effective_date => p_effective_date,
135: p_object_version_number => p_object_version_number);
136: --
137: if (l_api_updating
138: and nvl(p_rltd_per_chg_cs_ler_rl,hr_api.g_number)
139: <> ben_rcl_shd.g_old_rec.rltd_per_chg_cs_ler_rl
140: or not l_api_updating)
141: and p_rltd_per_chg_cs_ler_rl is not null then
142: --

Line 225: hr_api.g_number)

221: ,p_business_group_id number) IS
222: SELECT 'x'
223: FROM ben_rltd_per_chg_cs_ler_f
224: WHERE rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
225: hr_api.g_number)
226: AND source_table = p_source_table
227: AND source_column = p_source_column
228: AND new_val = nvl(p_new_val, hr_api.g_varchar2)
229: AND old_val = nvl(p_old_val, hr_api.g_varchar2)

Line 228: AND new_val = nvl(p_new_val, hr_api.g_varchar2)

224: WHERE rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
225: hr_api.g_number)
226: AND source_table = p_source_table
227: AND source_column = p_source_column
228: AND new_val = nvl(p_new_val, hr_api.g_varchar2)
229: AND old_val = nvl(p_old_val, hr_api.g_varchar2)
230: AND business_group_id + 0 = p_business_group_id
231: AND p_effective_date between effective_start_date
232: AND effective_end_date;

Line 229: AND old_val = nvl(p_old_val, hr_api.g_varchar2)

225: hr_api.g_number)
226: AND source_table = p_source_table
227: AND source_column = p_source_column
228: AND new_val = nvl(p_new_val, hr_api.g_varchar2)
229: AND old_val = nvl(p_old_val, hr_api.g_varchar2)
230: AND business_group_id + 0 = p_business_group_id
231: AND p_effective_date between effective_start_date
232: AND effective_end_date;
233: --

Line 308: hr_api.g_number)

304: ,p_business_group_id number) IS
305: SELECT 'x'
306: FROM ben_rltd_per_chg_cs_ler_f
307: WHERE rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
308: hr_api.g_number)
309: AND name = nvl(p_name, hr_api.g_varchar2)
310: AND business_group_id + 0 = p_business_group_id
311: AND p_effective_date between effective_start_date
312: AND effective_end_date;

Line 309: AND name = nvl(p_name, hr_api.g_varchar2)

305: SELECT 'x'
306: FROM ben_rltd_per_chg_cs_ler_f
307: WHERE rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
308: hr_api.g_number)
309: AND name = nvl(p_name, hr_api.g_varchar2)
310: AND business_group_id + 0 = p_business_group_id
311: AND p_effective_date between effective_start_date
312: AND effective_end_date;
313: --

Line 378: hr_api.g_number)

374: SELECT 'x'
375: FROM ben_rltd_per_chg_cs_ler_f
376: WHERE whatif_lbl_txt = p_whatif_lbl_txt
377: and rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
378: hr_api.g_number)
379: AND business_group_id + 0 = p_business_group_id
380: AND p_effective_date between effective_start_date
381: AND effective_end_date;
382: --

Line 456: hr_api.mandatory_arg_error

452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Ensure that the p_datetrack_mode argument is not null
455: --
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'datetrack_mode',
459: p_argument_value => p_datetrack_mode);
460: --

Line 468: hr_api.mandatory_arg_error

464: --
465: --
466: -- Ensure the arguments are not null
467: --
468: hr_api.mandatory_arg_error
469: (p_api_name => l_proc,
470: p_argument => 'validation_start_date',
471: p_argument_value => p_validation_start_date);
472: --

Line 473: hr_api.mandatory_arg_error

469: (p_api_name => l_proc,
470: p_argument => 'validation_start_date',
471: p_argument_value => p_validation_start_date);
472: --
473: hr_api.mandatory_arg_error
474: (p_api_name => l_proc,
475: p_argument => 'validation_end_date',
476: p_argument_value => p_validation_end_date);
477: --

Line 551: hr_api.mandatory_arg_error

547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Ensure that the p_datetrack_mode argument is not null
550: --
551: hr_api.mandatory_arg_error
552: (p_api_name => l_proc,
553: p_argument => 'datetrack_mode',
554: p_argument_value => p_datetrack_mode);
555: --

Line 565: hr_api.mandatory_arg_error

561: --
562: --
563: -- Ensure the arguments are not null
564: --
565: hr_api.mandatory_arg_error
566: (p_api_name => l_proc,
567: p_argument => 'validation_start_date',
568: p_argument_value => p_validation_start_date);
569: --

Line 570: hr_api.mandatory_arg_error

566: (p_api_name => l_proc,
567: p_argument => 'validation_start_date',
568: p_argument_value => p_validation_start_date);
569: --
570: hr_api.mandatory_arg_error
571: (p_api_name => l_proc,
572: p_argument => 'validation_end_date',
573: p_argument_value => p_validation_end_date);
574: --

Line 575: hr_api.mandatory_arg_error

571: (p_api_name => l_proc,
572: p_argument => 'validation_end_date',
573: p_argument_value => p_validation_end_date);
574: --
575: hr_api.mandatory_arg_error
576: (p_api_name => l_proc,
577: p_argument => 'rltd_per_chg_cs_ler_id',
578: p_argument_value => p_rltd_per_chg_cs_ler_id);
579: --

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

625: --
626: -- Call all supporting business operations
627: --
628: --
629: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
630: --
631: chk_rltd_per_chg_cs_ler_id
632: (p_rltd_per_chg_cs_ler_id => p_rec.rltd_per_chg_cs_ler_id,
633: p_effective_date => p_effective_date,

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

683: --
684: -- Call all supporting business operations
685: --
686: --
687: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
688: --
689: chk_rltd_per_chg_cs_ler_id
690: (p_rltd_per_chg_cs_ler_id => p_rec.rltd_per_chg_cs_ler_id,
691: p_effective_date => p_effective_date,

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

786: hr_utility.set_location('Entering:'|| l_proc, 10);
787: --
788: -- Ensure that all the mandatory parameter are not null
789: --
790: hr_api.mandatory_arg_error(p_api_name => l_proc,
791: p_argument => 'rltd_per_chg_cs_ler_id',
792: p_argument_value => p_rltd_per_chg_cs_ler_id);
793: --
794: open csr_leg_code;