DBA Data[Home] [Help]

APPS.BEN_POPL_ORG_API dependencies on BEN_POPL_ORG_F

Line 61: l_popl_org_id ben_popl_org_f.popl_org_id%TYPE;

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

Line 62: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;

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

Line 63: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;

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

Line 65: l_object_version_number ben_popl_org_f.object_version_number%TYPE;

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

Line 349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;

345: --
346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_POPL_ORG';
349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
352: --
353: begin

Line 350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;

346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_POPL_ORG';
349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
352: --
353: begin
354: --

Line 351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;

347: --
348: l_proc varchar2(72) := g_package||'update_POPL_ORG';
349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
352: --
353: begin
354: --
355: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;

593: --
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_POPL_ORG';
597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
600: --
601: begin

Line 598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;

594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_POPL_ORG';
597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
600: --
601: begin
602: --

Line 599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;

595: --
596: l_proc varchar2(72) := g_package||'update_POPL_ORG';
597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
600: --
601: begin
602: --
603: hr_utility.set_location('Entering:'|| l_proc, 10);