DBA Data[Home] [Help]

APPS.BEN_PSL_BUS dependencies on HR_API

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

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

Line 138: and nvl(p_per_info_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_per_info_chg_cs_ler_rl,hr_api.g_number)
139: <> ben_psl_shd.g_old_rec.per_info_chg_cs_ler_rl
140: or not l_api_updating)
141: and p_per_info_chg_cs_ler_rl is not null then
142: --

Line 227: hr_api.g_number)

223: ,p_business_group_id number) IS
224: SELECT 'x'
225: FROM ben_per_info_chg_cs_ler_f
226: WHERE per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
227: hr_api.g_number)
228: AND source_table = p_source_table
229: AND source_column = p_source_column
230: AND new_val = nvl(p_new_val, hr_api.g_varchar2)
231: AND old_val = nvl(p_old_val, hr_api.g_varchar2)

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

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

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

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

Line 313: hr_api.g_number)

309: ,p_business_group_id number) IS
310: SELECT 'x'
311: FROM ben_per_info_chg_cs_ler_f
312: WHERE per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
313: hr_api.g_number)
314: AND name = nvl(p_name, hr_api.g_varchar2)
315: AND business_group_id + 0 = p_business_group_id
316: AND p_effective_date between effective_start_date
317: AND effective_end_date;

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

310: SELECT 'x'
311: FROM ben_per_info_chg_cs_ler_f
312: WHERE per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
313: hr_api.g_number)
314: AND name = nvl(p_name, hr_api.g_varchar2)
315: AND business_group_id + 0 = p_business_group_id
316: AND p_effective_date between effective_start_date
317: AND effective_end_date;
318: --

Line 382: hr_api.g_number)

378: SELECT 'x'
379: FROM ben_per_info_chg_cs_ler_f
380: WHERE whatif_lbl_txt = p_whatif_lbl_txt
381: AND per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
382: hr_api.g_number)
383: AND business_group_id + 0 = p_business_group_id
384: AND p_effective_date between effective_start_date
385: AND effective_end_date;
386: --

Line 459: hr_api.mandatory_arg_error

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

Line 471: hr_api.mandatory_arg_error

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

Line 476: hr_api.mandatory_arg_error

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

Line 554: hr_api.mandatory_arg_error

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

Line 568: hr_api.mandatory_arg_error

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

Line 573: hr_api.mandatory_arg_error

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

Line 578: hr_api.mandatory_arg_error

574: (p_api_name => l_proc,
575: p_argument => 'validation_end_date',
576: p_argument_value => p_validation_end_date);
577: --
578: hr_api.mandatory_arg_error
579: (p_api_name => l_proc,
580: p_argument => 'per_info_chg_cs_ler_id',
581: p_argument_value => p_per_info_chg_cs_ler_id);
582: --

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

628: --
629: -- Call all supporting business operations
630: --
631: --
632: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
633: --
634: chk_per_info_chg_cs_ler_id
635: (p_per_info_chg_cs_ler_id => p_rec.per_info_chg_cs_ler_id,
636: p_effective_date => p_effective_date,

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

687: --
688: -- Call all supporting business operations
689: --
690: --
691: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
692: --
693: chk_per_info_chg_cs_ler_id
694: (p_per_info_chg_cs_ler_id => p_rec.per_info_chg_cs_ler_id,
695: p_effective_date => p_effective_date,

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

790: hr_utility.set_location('Entering:'|| l_proc, 10);
791: --
792: -- Ensure that all the mandatory parameter are not null
793: --
794: hr_api.mandatory_arg_error(p_api_name => l_proc,
795: p_argument => 'per_info_chg_cs_ler_id',
796: p_argument_value => p_per_info_chg_cs_ler_id);
797: --
798: open csr_leg_code;