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_RT_VAL_API dependencies on BEN_PRTT_RT_VAL

Line 1: Package Body ben_prtt_rt_val_api as

1: Package Body ben_prtt_rt_val_api as
2: /* $Header: beprvapi.pkb 120.7.12020000.2 2012/07/19 07:48:08 stee ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' ben_prtt_rt_val_api.';

2: /* $Header: beprvapi.pkb 120.7.12020000.2 2012/07/19 07:48:08 stee ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_prtt_rt_val_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: g_abr_name varchar2(255);
9: --
10: -- ---------------------------------------------------------------------------

Line 165: from ben_prtt_rt_val

161:
162: cursor c_overlap_rt is
163: select rt_strt_dt,
164: rt_end_dt
165: from ben_prtt_rt_val
166: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
167: and acty_base_rt_id = p_acty_base_rt_id
168: and prtt_rt_val_id <> nvl(p_prtt_rt_val_id,-1)
169: and prtt_rt_val_stat_cd is null

Line 324: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%TYPE;

320: l_rcrrg_cd varchar2(100);
321: l_recurring_rt boolean;
322: l_abr_name varchar2(300);
323: --
324: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%TYPE;
325: l_enrt_rt_ovn number;
326: l_proc varchar2(72) ; -- := g_package||'create_prtt_rt_val';
327: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;
328: --

Line 327: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

323: --
324: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%TYPE;
325: l_enrt_rt_ovn number;
326: l_proc varchar2(72) ; -- := g_package||'create_prtt_rt_val';
327: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;
328: --
329: l_dummy_number number;
330: l_rt_end_dt date ;
331: l_prtt_rt_val_ctfn_prvdd_id number;

Line 386: ben_prtt_rt_val_bk1.create_prtt_rt_val_b

382: begin
383: --
384: -- Start of API User Hook for the before hook of create_prtt_rt_val
385: --
386: ben_prtt_rt_val_bk1.create_prtt_rt_val_b
387: (
388: p_rt_strt_dt => p_rt_strt_dt
389: ,p_rt_end_dt => l_rt_end_dt
390: ,p_rt_typ_cd => p_rt_typ_cd

Line 647: ben_prtt_rt_val_bk1.create_prtt_rt_val_a

643: begin
644: --
645: -- Start of API User Hook for the after hook of create_prtt_rt_val
646: --
647: ben_prtt_rt_val_bk1.create_prtt_rt_val_a
648: (
649: p_prtt_rt_val_id => l_prtt_rt_val_id
650: ,p_rt_strt_dt => p_rt_strt_dt
651: ,p_rt_end_dt => l_rt_end_dt

Line 869: from ben_prtt_rt_val prv

865: prv.ann_rt_val,
866: prv.acty_ref_perd_cd,
867: prv.per_in_ler_id,
868: prv.prtt_rt_val_stat_cd
869: from ben_prtt_rt_val prv
870: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
871: prv.business_group_id=p_business_group_id;
872: --
873: cursor c_ele_entry (p_element_entry_value_id number,

Line 900: from ben_prtt_rt_val prv

896: l_ele_rec c_ele_entry%rowtype;
897: --
898: cursor c_prv_ovn is
899: select prv.object_version_number
900: from ben_prtt_rt_val prv
901: where prv.prtt_rt_val_id=p_prtt_rt_val_id;
902: --
903: -- 12583091
904: --

Line 918: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

914: --
915: -- end 12583091
916: --
917: l_proc varchar2(72) := g_package||'update_prtt_rt_val';
918: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;
919: l_enrt_rt_ovn number;
920: l_old_enrt_rslt_id number;
921: l_old_rt_end_dt date;
922: l_rt_end_dt date;

Line 1099: ben_prtt_rt_val_bk2.update_prtt_rt_val_b

1095: begin
1096: --
1097: -- Start of API User Hook for the before hook of update_prtt_rt_val
1098: --
1099: ben_prtt_rt_val_bk2.update_prtt_rt_val_b
1100: (
1101: p_prtt_rt_val_id => p_prtt_rt_val_id
1102: ,p_rt_strt_dt => p_rt_strt_dt
1103: ,p_rt_end_dt => l_rt_end_dt

Line 1456: ben_prtt_rt_val_bk2.update_prtt_rt_val_a

1452: begin
1453: --
1454: -- Start of API User Hook for the after hook of update_prtt_rt_val
1455: --
1456: ben_prtt_rt_val_bk2.update_prtt_rt_val_a
1457: (
1458: p_prtt_rt_val_id => p_prtt_rt_val_id
1459: ,p_rt_strt_dt => p_rt_strt_dt
1460: ,p_rt_end_dt => l_rt_end_dt

Line 1603: from ben_prtt_rt_val prv

1599: prv.element_entry_value_id,
1600: prv.acty_base_rt_id,
1601: prv.rt_val,
1602: prv.acty_ref_perd_cd
1603: from ben_prtt_rt_val prv
1604: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
1605: prv.business_group_id=p_business_group_id;
1606: --
1607: cursor c_enrt_rt (p_prtt_rt_val_id number) is

Line 1614: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

1610: from ben_enrt_rt
1611: where prtt_rt_val_id = p_prtt_rt_val_id;
1612: --
1613: l_proc varchar2(72); -- := g_package||'delete_prtt_rt_val';
1614: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;
1615: l_enrt_rt_ovn number;
1616: l_old_rt_end_dt date;
1617: l_old_rt_strt_dt date;
1618: l_old_enrt_rslt_id number;

Line 1673: ben_prtt_rt_val_bk3.delete_prtt_rt_val_b

1669: begin
1670: --
1671: -- Start of API User Hook for the before hook of delete_prtt_rt_val
1672: --
1673: ben_prtt_rt_val_bk3.delete_prtt_rt_val_b
1674: (
1675: p_prtt_rt_val_id => p_prtt_rt_val_id
1676: ,p_object_version_number => p_object_version_number
1677: ,p_effective_date => trunc(p_effective_date)

Line 1750: ben_prtt_rt_val_bk3.delete_prtt_rt_val_a

1746: begin
1747: --
1748: -- Start of API User Hook for the after hook of delete_prtt_rt_val
1749: --
1750: ben_prtt_rt_val_bk3.delete_prtt_rt_val_a
1751: (
1752: p_prtt_rt_val_id => p_prtt_rt_val_id
1753: ,p_object_version_number => l_object_version_number
1754: ,p_effective_date => trunc(p_effective_date)

Line 1837: end ben_prtt_rt_val_api;

1833: end if;
1834: --
1835: end lck;
1836: --
1837: end ben_prtt_rt_val_api;