DBA Data[Home] [Help]

APPS.BEN_PROGRAM_API dependencies on BEN_PGM_F

Line 129: l_pgm_id ben_pgm_f.pgm_id%TYPE;

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

Line 130: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;

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

Line 131: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;

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

Line 133: l_object_version_number ben_pgm_f.object_version_number%TYPE;

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

Line 684: l_object_version_number ben_pgm_f.object_version_number%TYPE;

680: --
681: -- Declare cursors and local variables
682: --
683: l_proc varchar2(72) := g_package||'update_Program';
684: l_object_version_number ben_pgm_f.object_version_number%TYPE;
685: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
686: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
687: --
688: begin

Line 685: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;

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

Line 686: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;

682: --
683: l_proc varchar2(72) := g_package||'update_Program';
684: l_object_version_number ben_pgm_f.object_version_number%TYPE;
685: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
686: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
687: --
688: begin
689: --
690: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1136: l_object_version_number ben_pgm_f.object_version_number%TYPE;

1132: --
1133: -- Declare cursors and local variables
1134: --
1135: l_proc varchar2(72) := g_package||'update_Program';
1136: l_object_version_number ben_pgm_f.object_version_number%TYPE;
1137: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
1138: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
1139: --
1140: begin

Line 1137: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;

1133: -- Declare cursors and local variables
1134: --
1135: l_proc varchar2(72) := g_package||'update_Program';
1136: l_object_version_number ben_pgm_f.object_version_number%TYPE;
1137: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
1138: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
1139: --
1140: begin
1141: --

Line 1138: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;

1134: --
1135: l_proc varchar2(72) := g_package||'update_Program';
1136: l_object_version_number ben_pgm_f.object_version_number%TYPE;
1137: l_effective_start_date ben_pgm_f.effective_start_date%TYPE;
1138: l_effective_end_date ben_pgm_f.effective_end_date%TYPE;
1139: --
1140: begin
1141: --
1142: hr_utility.set_location('Entering:'|| l_proc, 10);