DBA Data[Home] [Help]

APPS.BEN_ACRS_PTIP_CVG_API dependencies on BEN_ACRS_PTIP_CVG_F

Line 59: l_acrs_ptip_cvg_id ben_acrs_ptip_cvg_f.acrs_ptip_cvg_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_acrs_ptip_cvg_id ben_acrs_ptip_cvg_f.acrs_ptip_cvg_id%TYPE;
60: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_acrs_ptip_cvg';
63: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;

Line 60: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_acrs_ptip_cvg_id ben_acrs_ptip_cvg_f.acrs_ptip_cvg_id%TYPE;
60: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_acrs_ptip_cvg';
63: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;
64: --

Line 61: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_acrs_ptip_cvg_id ben_acrs_ptip_cvg_f.acrs_ptip_cvg_id%TYPE;
60: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_acrs_ptip_cvg';
63: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;
64: --
65: begin

Line 63: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;

59: l_acrs_ptip_cvg_id ben_acrs_ptip_cvg_f.acrs_ptip_cvg_id%TYPE;
60: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_acrs_ptip_cvg';
63: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 334: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;

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

Line 335: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;

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

Line 336: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;

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

Line 577: l_object_version_number ben_acrs_ptip_cvg_f.object_version_number%TYPE;

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

Line 578: l_effective_start_date ben_acrs_ptip_cvg_f.effective_start_date%TYPE;

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

Line 579: l_effective_end_date ben_acrs_ptip_cvg_f.effective_end_date%TYPE;

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