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_CWB_PERSON_RATES_API dependencies on BEN_CWB_PERSON_RATES

Line 1: Package Body BEN_CWB_PERSON_RATES_API as

1: Package Body BEN_CWB_PERSON_RATES_API as
2: /* $Header: bertsapi.pkb 120.5.12000000.1 2007/01/19 23:09:06 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bertsapi.pkb 120.5.12000000.1 2007/01/19 23:09:06 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PERSON_RATES_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: cursor csr_rates(v_group_per_in_ler_id number
9: ,v_pl_id number
10: ,v_oipl_id number) is

Line 12: from ben_cwb_person_rates

8: cursor csr_rates(v_group_per_in_ler_id number
9: ,v_pl_id number
10: ,v_oipl_id number) is
11: select *
12: from ben_cwb_person_rates
13: where group_per_in_ler_id = v_group_per_in_ler_id
14: and pl_id = v_pl_id
15: and oipl_id = v_oipl_id;
16: --

Line 80: l_person_rate_id ben_cwb_person_rates.person_rate_id%type;

76: ) is
77: --
78: -- Declare cursors and local variables
79: --
80: l_person_rate_id ben_cwb_person_rates.person_rate_id%type;
81: l_object_version_number number;
82: --
83: l_proc varchar2(72) := g_package||'create_person_rate';
84: begin

Line 96: ben_cwb_person_rates_bk1.create_person_rate_b

92: --
93: -- Call Before Process User Hook
94: --
95: begin
96: ben_cwb_person_rates_bk1.create_person_rate_b
97: (p_group_per_in_ler_id => p_group_per_in_ler_id
98: ,p_pl_id => p_pl_id
99: ,p_oipl_id => p_oipl_id
100: ,p_group_pl_id => p_group_pl_id

Line 220: ben_cwb_person_rates_bk1.create_person_rate_a

216: --
217: -- Call After Process User Hook
218: --
219: begin
220: ben_cwb_person_rates_bk1.create_person_rate_a
221: (p_person_rate_id => l_person_rate_id
222: ,p_group_per_in_ler_id => p_group_per_in_ler_id
223: ,p_pl_id => p_pl_id
224: ,p_oipl_id => p_oipl_id

Line 410: -- update the summary table after updating the ben_cwb_person_rates.

406: -- |---------------------< update_person_rates_summary >---------------------|
407: -- --------------------------------------------------------------------------
408: -- Description
409: -- This is an internal procedure called only by update_person_rates to
410: -- update the summary table after updating the ben_cwb_person_rates.
411: --
412: procedure update_rates_summary(p_rates_old csr_rates%rowtype,
413: p_rates_new csr_rates%rowtype) is
414: --cursor to fetch the managers of the person

Line 699: -- record particular changes in the values of BEN_CWB_PERSON_RATES.

695: -- ----------------------------------------------------------------------------
696: --
697: -- Description
698: -- This is an internal procedure to write into the BEN_CWB_AUDIT table to
699: -- record particular changes in the values of BEN_CWB_PERSON_RATES.
700: -- Changes evaluated:
701: -- Code Desciption
702: -- CA Update Compensation Amount
703: -- ES Update Eligible Salary

Line 1208: from ben_cwb_person_rates rts

1204: ,ws_incr_val
1205: ,rec_mn_val
1206: ,rec_mx_val
1207: ,rec_incr_val
1208: from ben_cwb_person_rates rts
1209: where group_per_in_ler_id = p_group_per_in_ler_id
1210: and pl_id = p_pl_id
1211: and oipl_id = p_oipl_id;
1212: --

Line 1237: ben_cwb_person_rates_bk2.update_person_rate_b

1233: --
1234: -- Call Before Process User Hook
1235: --
1236: begin
1237: ben_cwb_person_rates_bk2.update_person_rate_b
1238: (p_group_per_in_ler_id => p_group_per_in_ler_id
1239: ,p_pl_id => p_pl_id
1240: ,p_oipl_id => p_oipl_id
1241: ,p_group_pl_id => p_group_pl_id

Line 1445: ben_cwb_person_rates_bk2.update_person_rate_a

1441: --
1442: -- Call After Process User Hook
1443: --
1444: begin
1445: ben_cwb_person_rates_bk2.update_person_rate_a
1446: (p_group_per_in_ler_id => p_group_per_in_ler_id
1447: ,p_pl_id => p_pl_id
1448: ,p_oipl_id => p_oipl_id
1449: ,p_group_pl_id => p_group_pl_id

Line 1590: ben_cwb_person_rates_bk3.delete_person_rate_b

1586: --
1587: -- Call Before Process User Hook
1588: --
1589: begin
1590: ben_cwb_person_rates_bk3.delete_person_rate_b
1591: (p_group_per_in_ler_id => p_group_per_in_ler_id
1592: ,p_pl_id => p_pl_id
1593: ,p_oipl_id => p_oipl_id
1594: ,p_object_version_number => p_object_version_number

Line 1620: ben_cwb_person_rates_bk3.delete_person_rate_a

1616: --
1617: -- Call After Process User Hook
1618: --
1619: begin
1620: ben_cwb_person_rates_bk3.delete_person_rate_a
1621: (p_group_per_in_ler_id => p_group_per_in_ler_id
1622: ,p_pl_id => p_pl_id
1623: ,p_oipl_id => p_oipl_id
1624: ,p_object_version_number => p_object_version_number

Line 1679: end ben_cwb_person_rates_api;

1675: raise;
1676: end delete_person_rate;
1677: --
1678: --
1679: end ben_cwb_person_rates_api;