DBA Data[Home] [Help]

APPS.BEN_CM_TYP_TRGR_API dependencies on BEN_CM_TYP_TRGR_F

Line 57: l_cm_typ_trgr_id ben_cm_typ_trgr_f.cm_typ_trgr_id%TYPE;

53: ,p_effective_date in date) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_cm_typ_trgr_id ben_cm_typ_trgr_f.cm_typ_trgr_id%TYPE;
58: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_cm_typ_trgr';
61: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;

Line 58: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;

54: --
55: -- Declare cursors and local variables
56: --
57: l_cm_typ_trgr_id ben_cm_typ_trgr_f.cm_typ_trgr_id%TYPE;
58: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_cm_typ_trgr';
61: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
62: --

Line 59: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;

55: -- Declare cursors and local variables
56: --
57: l_cm_typ_trgr_id ben_cm_typ_trgr_f.cm_typ_trgr_id%TYPE;
58: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_cm_typ_trgr';
61: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
62: --
63: begin

Line 61: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;

57: l_cm_typ_trgr_id ben_cm_typ_trgr_f.cm_typ_trgr_id%TYPE;
58: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_cm_typ_trgr';
61: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 328: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;

324: --
325: -- Declare cursors and local variables
326: --
327: l_proc varchar2(72) := g_package||'update_cm_typ_trgr';
328: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
329: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
330: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
331: --
332: begin

Line 329: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;

325: -- Declare cursors and local variables
326: --
327: l_proc varchar2(72) := g_package||'update_cm_typ_trgr';
328: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
329: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
330: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
331: --
332: begin
333: --

Line 330: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;

326: --
327: l_proc varchar2(72) := g_package||'update_cm_typ_trgr';
328: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
329: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
330: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
331: --
332: begin
333: --
334: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 564: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;

560: --
561: -- Declare cursors and local variables
562: --
563: l_proc varchar2(72) := g_package||'update_cm_typ_trgr';
564: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
565: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
566: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
567: --
568: begin

Line 565: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;

561: -- Declare cursors and local variables
562: --
563: l_proc varchar2(72) := g_package||'update_cm_typ_trgr';
564: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
565: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
566: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
567: --
568: begin
569: --

Line 566: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;

562: --
563: l_proc varchar2(72) := g_package||'update_cm_typ_trgr';
564: l_object_version_number ben_cm_typ_trgr_f.object_version_number%TYPE;
565: l_effective_start_date ben_cm_typ_trgr_f.effective_start_date%TYPE;
566: l_effective_end_date ben_cm_typ_trgr_f.effective_end_date%TYPE;
567: --
568: begin
569: --
570: hr_utility.set_location('Entering:'|| l_proc, 10);