DBA Data[Home] [Help]

APPS.BEN_REGULATIONS_API dependencies on BEN_REGN_F

Line 58: l_regn_id ben_regn_f.regn_id%TYPE;

54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_regn_id ben_regn_f.regn_id%TYPE;
59: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
60: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Regulations';
62: l_object_version_number ben_regn_f.object_version_number%TYPE;

Line 59: l_effective_start_date ben_regn_f.effective_start_date%TYPE;

55: --
56: -- Declare cursors and local variables
57: --
58: l_regn_id ben_regn_f.regn_id%TYPE;
59: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
60: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Regulations';
62: l_object_version_number ben_regn_f.object_version_number%TYPE;
63: --

Line 60: l_effective_end_date ben_regn_f.effective_end_date%TYPE;

56: -- Declare cursors and local variables
57: --
58: l_regn_id ben_regn_f.regn_id%TYPE;
59: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
60: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Regulations';
62: l_object_version_number ben_regn_f.object_version_number%TYPE;
63: --
64: begin

Line 62: l_object_version_number ben_regn_f.object_version_number%TYPE;

58: l_regn_id ben_regn_f.regn_id%TYPE;
59: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
60: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Regulations';
62: l_object_version_number ben_regn_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 333: l_object_version_number ben_regn_f.object_version_number%TYPE;

329: --
330: -- Declare cursors and local variables
331: --
332: l_proc varchar2(72) := g_package||'update_Regulations';
333: l_object_version_number ben_regn_f.object_version_number%TYPE;
334: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
335: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
336: --
337: begin

Line 334: l_effective_start_date ben_regn_f.effective_start_date%TYPE;

330: -- Declare cursors and local variables
331: --
332: l_proc varchar2(72) := g_package||'update_Regulations';
333: l_object_version_number ben_regn_f.object_version_number%TYPE;
334: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
335: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
336: --
337: begin
338: --

Line 335: l_effective_end_date ben_regn_f.effective_end_date%TYPE;

331: --
332: l_proc varchar2(72) := g_package||'update_Regulations';
333: l_object_version_number ben_regn_f.object_version_number%TYPE;
334: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
335: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
336: --
337: begin
338: --
339: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 572: l_object_version_number ben_regn_f.object_version_number%TYPE;

568: --
569: -- Declare cursors and local variables
570: --
571: l_proc varchar2(72) := g_package||'update_Regulations';
572: l_object_version_number ben_regn_f.object_version_number%TYPE;
573: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
574: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
575: --
576: begin

Line 573: l_effective_start_date ben_regn_f.effective_start_date%TYPE;

569: -- Declare cursors and local variables
570: --
571: l_proc varchar2(72) := g_package||'update_Regulations';
572: l_object_version_number ben_regn_f.object_version_number%TYPE;
573: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
574: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
575: --
576: begin
577: --

Line 574: l_effective_end_date ben_regn_f.effective_end_date%TYPE;

570: --
571: l_proc varchar2(72) := g_package||'update_Regulations';
572: l_object_version_number ben_regn_f.object_version_number%TYPE;
573: l_effective_start_date ben_regn_f.effective_start_date%TYPE;
574: l_effective_end_date ben_regn_f.effective_end_date%TYPE;
575: --
576: begin
577: --
578: hr_utility.set_location('Entering:'|| l_proc, 10);