DBA Data[Home] [Help]

APPS.BEN_ENRT_PERD_FOR_PL_API dependencies on BEN_ENRT_PERD_FOR_PL_F

Line 66: l_enrt_perd_for_pl_id ben_enrt_perd_for_pl_f.enrt_perd_for_pl_id%TYPE;

62: ) is
63: --
64: -- Declare cursors and local variables
65: --
66: l_enrt_perd_for_pl_id ben_enrt_perd_for_pl_f.enrt_perd_for_pl_id%TYPE;
67: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
68: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_enrt_perd_for_pl';
70: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;

Line 67: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;

63: --
64: -- Declare cursors and local variables
65: --
66: l_enrt_perd_for_pl_id ben_enrt_perd_for_pl_f.enrt_perd_for_pl_id%TYPE;
67: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
68: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_enrt_perd_for_pl';
70: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
71: --

Line 68: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;

64: -- Declare cursors and local variables
65: --
66: l_enrt_perd_for_pl_id ben_enrt_perd_for_pl_f.enrt_perd_for_pl_id%TYPE;
67: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
68: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_enrt_perd_for_pl';
70: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
71: --
72: begin

Line 70: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;

66: l_enrt_perd_for_pl_id ben_enrt_perd_for_pl_f.enrt_perd_for_pl_id%TYPE;
67: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
68: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_enrt_perd_for_pl';
70: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
71: --
72: begin
73: --
74: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 369: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;

365: --
366: -- Declare cursors and local variables
367: --
368: l_proc varchar2(72) := g_package||'update_enrt_perd_for_pl';
369: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
370: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
371: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
372: --
373: begin

Line 370: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;

366: -- Declare cursors and local variables
367: --
368: l_proc varchar2(72) := g_package||'update_enrt_perd_for_pl';
369: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
370: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
371: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
372: --
373: begin
374: --

Line 371: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;

367: --
368: l_proc varchar2(72) := g_package||'update_enrt_perd_for_pl';
369: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
370: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
371: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
372: --
373: begin
374: --
375: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 628: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;

624: --
625: -- Declare cursors and local variables
626: --
627: l_proc varchar2(72) := g_package||'update_enrt_perd_for_pl';
628: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
629: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
630: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
631: --
632: begin

Line 629: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;

625: -- Declare cursors and local variables
626: --
627: l_proc varchar2(72) := g_package||'update_enrt_perd_for_pl';
628: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
629: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
630: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
631: --
632: begin
633: --

Line 630: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;

626: --
627: l_proc varchar2(72) := g_package||'update_enrt_perd_for_pl';
628: l_object_version_number ben_enrt_perd_for_pl_f.object_version_number%TYPE;
629: l_effective_start_date ben_enrt_perd_for_pl_f.effective_start_date%TYPE;
630: l_effective_end_date ben_enrt_perd_for_pl_f.effective_end_date%TYPE;
631: --
632: begin
633: --
634: hr_utility.set_location('Entering:'|| l_proc, 10);