APPS.BEN_PROGRAM_API dependencies on BEN_PGM_F

Line 130: l_pgm_id ben_pgm_f.pgm_id%TYPE;

126: ) is
127: --
128: -- Declare cursors and local variables
129: --
130: l_pgm_id ben_pgm_f.pgm_id%TYPE;
131: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
132: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
133: l_proc varchar2(72) := g_package||'create_Program';
134: l_object_version_number ben_pgm_f.object_version_number%TYPE;

Line 131: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;

127: --
128: -- Declare cursors and local variables
129: --
130: l_pgm_id ben_pgm_f.pgm_id%TYPE;
131: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
132: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
133: l_proc varchar2(72) := g_package||'create_Program';
134: l_object_version_number ben_pgm_f.object_version_number%TYPE;
135: --

Line 132: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;

128: -- Declare cursors and local variables
129: --
130: l_pgm_id ben_pgm_f.pgm_id%TYPE;
131: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
132: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
133: l_proc varchar2(72) := g_package||'create_Program';
134: l_object_version_number ben_pgm_f.object_version_number%TYPE;
135: --
136: begin

Line 134: l_object_version_number ben_pgm_f.object_version_number%TYPE;

130: l_pgm_id ben_pgm_f.pgm_id%TYPE;
131: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
132: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
133: l_proc varchar2(72) := g_package||'create_Program';
134: l_object_version_number ben_pgm_f.object_version_number%TYPE;
135: --
136: begin
137: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 689: l_object_version_number ben_pgm_f.object_version_number%TYPE;

685: --
686: -- Declare cursors and local variables
687: --
688: l_proc varchar2(72) := g_package||'update_Program';
689: l_object_version_number ben_pgm_f.object_version_number%TYPE;
690: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
691: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
692: --
693: begin

Line 690: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;

686: -- Declare cursors and local variables
687: --
688: l_proc varchar2(72) := g_package||'update_Program';
689: l_object_version_number ben_pgm_f.object_version_number%TYPE;
690: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
691: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
692: --
693: begin
694: --

Line 691: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;

687: --
688: l_proc varchar2(72) := g_package||'update_Program';
689: l_object_version_number ben_pgm_f.object_version_number%TYPE;
690: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
691: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
692: --
693: begin
694: --
695: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1144: l_object_version_number ben_pgm_f.object_version_number%TYPE;

1140: --
1141: -- Declare cursors and local variables
1142: --
1143: l_proc varchar2(72) := g_package||'update_Program';
1144: l_object_version_number ben_pgm_f.object_version_number%TYPE;
1145: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
1146: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
1147: --
1148: begin

Line 1145: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;

1141: -- Declare cursors and local variables
1142: --
1143: l_proc varchar2(72) := g_package||'update_Program';
1144: l_object_version_number ben_pgm_f.object_version_number%TYPE;
1145: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
1146: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
1147: --
1148: begin
1149: --

Line 1146: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;

1142: --
1143: l_proc varchar2(72) := g_package||'update_Program';
1144: l_object_version_number ben_pgm_f.object_version_number%TYPE;
1145: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
1146: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
1147: --
1148: begin
1149: --
1150: hr_utility.set_location('Entering:'|| l_proc, 10);