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_PRTT_ENRT_ACTN_API dependencies on BEN_PRTT_ENRT_ACTN_F

Line 104: from ben_prtt_enrt_actn_f act,

100: --bug#5621152
101: cursor c_cmpltd_actn
102: is
103: select 'X'
104: from ben_prtt_enrt_actn_f act,
105: ben_per_in_ler pil
106: where act.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
107: and act.per_in_ler_id = pil.per_in_ler_id
108: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;

237: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
244: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
245: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

Line 242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

238: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
244: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
245: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
246: --

Line 243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

239: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
240: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
244: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
245: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
246: --
247: begin

Line 245: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

241: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
242: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
243: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
244: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
245: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
246: --
247: begin
248: --
249: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;

614: l_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
621: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
622: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

Line 619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

615: l_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
621: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
622: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
623: l_per_in_ler_id number;

Line 620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

616: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
617: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
621: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
622: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
623: l_per_in_ler_id number;
624: --

Line 622: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

618: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%TYPE;
619: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
620: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
621: l_proc varchar2(72) := g_package||'create_PRTT_ENRT_ACTN';
622: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
623: l_per_in_ler_id number;
624: --
625: begin
626: --

Line 983: from ben_prtt_enrt_actn_f pea

979: --
980: cursor c_pea is
981: select pea.effective_start_date,
982: pea.cmpltd_dt
983: from ben_prtt_enrt_actn_f pea
984: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
985: and pea.business_group_id = p_business_group_id
986: and p_effective_date between
987: pea.effective_start_date and pea.effective_end_date;

Line 1019: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

1015: l_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%TYPE;
1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1017: --
1018: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1019: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1020: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1021: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1022: l_pcm_effective_start_date date;
1023: l_pcm_effective_end_date date;

Line 1020: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

1016: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1017: --
1018: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1019: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1020: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1021: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1022: l_pcm_effective_start_date date;
1023: l_pcm_effective_end_date date;
1024: --

Line 1021: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

1017: --
1018: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1019: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1020: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1021: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1022: l_pcm_effective_start_date date;
1023: l_pcm_effective_end_date date;
1024: --
1025: begin

Line 1427: from ben_prtt_enrt_actn_f pea

1423: --
1424: cursor c_pea is
1425: select pea.effective_start_date,
1426: pea.cmpltd_dt
1427: from ben_prtt_enrt_actn_f pea
1428: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1429: and pea.business_group_id = p_business_group_id
1430: and p_effective_date between
1431: pea.effective_start_date and pea.effective_end_date;

Line 1465: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

1461: l_pgm_id ben_prtt_enrt_rslt_f.pgm_id%TYPE;
1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;
1463: --
1464: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1465: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1466: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1467: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1468: l_pcm_effective_start_date date;
1469: l_pcm_effective_end_date date;

Line 1466: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

1462: l_per_in_ler_id ben_prtt_enrt_rslt_f.per_in_ler_id%TYPE;
1463: --
1464: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1465: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1466: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1467: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1468: l_pcm_effective_start_date date;
1469: l_pcm_effective_end_date date;
1470: --

Line 1467: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

1463: --
1464: l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
1465: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1466: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1467: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1468: l_pcm_effective_start_date date;
1469: l_pcm_effective_end_date date;
1470: --
1471: begin

Line 1888: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

1884: and effective_end_date;
1885: --
1886: --
1887: l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_ACTN';
1888: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1889: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1890: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1891: --
1892: begin

Line 1889: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

1885: --
1886: --
1887: l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_ACTN';
1888: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1889: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1890: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1891: --
1892: begin
1893: --

Line 1890: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

1886: --
1887: l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_ACTN';
1888: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
1889: l_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
1890: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1891: --
1892: begin
1893: --
1894: hr_utility.set_location('Entering:'|| l_proc, 10);