DBA Data[Home] [Help]

APPS.BEN_CM_TYP_USG_API dependencies on BEN_CM_TYP_USG_F

Line 64: l_cm_typ_usg_id ben_cm_typ_usg_f.cm_typ_usg_id%TYPE;

60: ,p_effective_date in date) is
61: --
62: -- Declare cursors and local variables
63: --
64: l_cm_typ_usg_id ben_cm_typ_usg_f.cm_typ_usg_id%TYPE;
65: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
66: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_cm_typ_usg';
68: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;

Line 65: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;

61: --
62: -- Declare cursors and local variables
63: --
64: l_cm_typ_usg_id ben_cm_typ_usg_f.cm_typ_usg_id%TYPE;
65: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
66: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_cm_typ_usg';
68: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
69: --

Line 66: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;

62: -- Declare cursors and local variables
63: --
64: l_cm_typ_usg_id ben_cm_typ_usg_f.cm_typ_usg_id%TYPE;
65: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
66: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_cm_typ_usg';
68: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
69: --
70: begin

Line 68: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;

64: l_cm_typ_usg_id ben_cm_typ_usg_f.cm_typ_usg_id%TYPE;
65: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
66: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_cm_typ_usg';
68: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
69: --
70: begin
71: --
72: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 363: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;

359: --
360: -- Declare cursors and local variables
361: --
362: l_proc varchar2(72) := g_package||'update_cm_typ_usg';
363: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
364: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
365: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
366: --
367: begin

Line 364: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;

360: -- Declare cursors and local variables
361: --
362: l_proc varchar2(72) := g_package||'update_cm_typ_usg';
363: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
364: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
365: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
366: --
367: begin
368: --

Line 365: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;

361: --
362: l_proc varchar2(72) := g_package||'update_cm_typ_usg';
363: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
364: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
365: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
366: --
367: begin
368: --
369: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 620: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;

616: --
617: -- Declare cursors and local variables
618: --
619: l_proc varchar2(72) := g_package||'update_cm_typ_usg';
620: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
621: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
622: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
623: --
624: begin

Line 621: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;

617: -- Declare cursors and local variables
618: --
619: l_proc varchar2(72) := g_package||'update_cm_typ_usg';
620: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
621: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
622: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
623: --
624: begin
625: --

Line 622: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;

618: --
619: l_proc varchar2(72) := g_package||'update_cm_typ_usg';
620: l_object_version_number ben_cm_typ_usg_f.object_version_number%TYPE;
621: l_effective_start_date ben_cm_typ_usg_f.effective_start_date%TYPE;
622: l_effective_end_date ben_cm_typ_usg_f.effective_end_date%TYPE;
623: --
624: begin
625: --
626: hr_utility.set_location('Entering:'|| l_proc, 10);