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.3.12010000.2 2008/08/05 15:22:29 ubhat ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: beprvapi.pkb 120.3.12010000.2 2008/08/05 15:22:29 ubhat 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 164: from ben_prtt_rt_val

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

Line 323: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%TYPE;

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

Line 326: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

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

Line 385: ben_prtt_rt_val_bk1.create_prtt_rt_val_b

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

Line 644: ben_prtt_rt_val_bk1.create_prtt_rt_val_a

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

Line 866: from ben_prtt_rt_val prv

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

Line 897: from ben_prtt_rt_val prv

893: l_ele_rec c_ele_entry%rowtype;
894: --
895: cursor c_prv_ovn is
896: select prv.object_version_number
897: from ben_prtt_rt_val prv
898: where prv.prtt_rt_val_id=p_prtt_rt_val_id;
899:
900: --
901: l_proc varchar2(72) := g_package||'update_prtt_rt_val';

Line 902: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

898: where prv.prtt_rt_val_id=p_prtt_rt_val_id;
899:
900: --
901: l_proc varchar2(72) := g_package||'update_prtt_rt_val';
902: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;
903: l_enrt_rt_ovn number;
904: l_old_enrt_rslt_id number;
905: l_old_rt_end_dt date;
906: l_rt_end_dt date;

Line 1083: ben_prtt_rt_val_bk2.update_prtt_rt_val_b

1079: begin
1080: --
1081: -- Start of API User Hook for the before hook of update_prtt_rt_val
1082: --
1083: ben_prtt_rt_val_bk2.update_prtt_rt_val_b
1084: (
1085: p_prtt_rt_val_id => p_prtt_rt_val_id
1086: ,p_rt_strt_dt => p_rt_strt_dt
1087: ,p_rt_end_dt => l_rt_end_dt

Line 1405: ben_prtt_rt_val_bk2.update_prtt_rt_val_a

1401: begin
1402: --
1403: -- Start of API User Hook for the after hook of update_prtt_rt_val
1404: --
1405: ben_prtt_rt_val_bk2.update_prtt_rt_val_a
1406: (
1407: p_prtt_rt_val_id => p_prtt_rt_val_id
1408: ,p_rt_strt_dt => p_rt_strt_dt
1409: ,p_rt_end_dt => l_rt_end_dt

Line 1552: from ben_prtt_rt_val prv

1548: prv.element_entry_value_id,
1549: prv.acty_base_rt_id,
1550: prv.rt_val,
1551: prv.acty_ref_perd_cd
1552: from ben_prtt_rt_val prv
1553: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
1554: prv.business_group_id=p_business_group_id;
1555: --
1556: cursor c_enrt_rt (p_prtt_rt_val_id number) is

Line 1563: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

1559: from ben_enrt_rt
1560: where prtt_rt_val_id = p_prtt_rt_val_id;
1561: --
1562: l_proc varchar2(72); -- := g_package||'delete_prtt_rt_val';
1563: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;
1564: l_enrt_rt_ovn number;
1565: l_old_rt_end_dt date;
1566: l_old_rt_strt_dt date;
1567: l_old_enrt_rslt_id number;

Line 1622: ben_prtt_rt_val_bk3.delete_prtt_rt_val_b

1618: begin
1619: --
1620: -- Start of API User Hook for the before hook of delete_prtt_rt_val
1621: --
1622: ben_prtt_rt_val_bk3.delete_prtt_rt_val_b
1623: (
1624: p_prtt_rt_val_id => p_prtt_rt_val_id
1625: ,p_object_version_number => p_object_version_number
1626: ,p_effective_date => trunc(p_effective_date)

Line 1699: ben_prtt_rt_val_bk3.delete_prtt_rt_val_a

1695: begin
1696: --
1697: -- Start of API User Hook for the after hook of delete_prtt_rt_val
1698: --
1699: ben_prtt_rt_val_bk3.delete_prtt_rt_val_a
1700: (
1701: p_prtt_rt_val_id => p_prtt_rt_val_id
1702: ,p_object_version_number => l_object_version_number
1703: ,p_effective_date => trunc(p_effective_date)

Line 1786: end ben_prtt_rt_val_api;

1782: end if;
1783: --
1784: end lck;
1785: --
1786: end ben_prtt_rt_val_api;