eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_TYPE_API dependencies on BEN_PL_TYP_F

Line 69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;

65: ) is
66: --
67: -- Declare cursors and local variables
68: --
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;

Line 70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;

66: --
67: -- Declare cursors and local variables
68: --
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
74: --

Line 71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;

67: -- Declare cursors and local variables
68: --
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
74: --
75: begin

Line 73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;

69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;

386: --
387: -- Declare cursors and local variables
388: --
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;

Line 391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;

387: -- Declare cursors and local variables
388: --
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
395: --

Line 392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;

388: --
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
395: --
396: cursor c_old_pl_typ is

Line 393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;

389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
395: --
396: cursor c_old_pl_typ is
397: select plt.opt_dsply_fmt_cd

Line 398: from ben_pl_typ_f plt

394: l_ordr_num number;
395: --
396: cursor c_old_pl_typ is
397: select plt.opt_dsply_fmt_cd
398: from ben_pl_typ_f plt
399: where plt.pl_typ_id = p_pl_typ_id
400: and p_effective_date between plt.effective_start_date and plt.effective_end_date;
401: --
402: begin

Line 758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;

754: --
755: -- Declare cursors and local variables
756: --
757: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
761: --
762: begin

Line 759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;

755: -- Declare cursors and local variables
756: --
757: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
761: --
762: begin
763: --

Line 760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;

756: --
757: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
761: --
762: begin
763: --
764: hr_utility.set_location('Entering:'|| l_proc, 10);