DBA Data[Home] [Help]

APPS.BEN_PLAN_REGULATORY_BODY_API dependencies on BEN_PL_REGY_BOD_F

Line 61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;

57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;

Line 62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;

58: --
59: -- Declare cursors and local variables
60: --
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
66: --

Line 63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;

59: -- Declare cursors and local variables
60: --
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
66: --
67: begin

Line 65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;

61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;

335: --
336: -- Declare cursors and local variables
337: --
338: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
342: --
343: begin

Line 340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;

336: -- Declare cursors and local variables
337: --
338: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
342: --
343: begin
344: --

Line 341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;

337: --
338: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
342: --
343: begin
344: --
345: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;

574: --
575: -- Declare cursors and local variables
576: --
577: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
581: --
582: begin

Line 579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;

575: -- Declare cursors and local variables
576: --
577: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
581: --
582: begin
583: --

Line 580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;

576: --
577: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
581: --
582: begin
583: --
584: hr_utility.set_location('Entering:'|| l_proc, 10);