1 Package ben_cwb_mtrx_utils AUTHID CURRENT_USER as
2 /* $Header: bencwbmtrxutils.pkh 120.0 2005/05/28 13:36 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------------< POP_TRG_AMTS >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- This procedure is used to populate the target values for all employees
12 -- under a manager depending upon the criterion values entered in
13 -- Matrix through Budget Allocation Wizard in Compensation Workbench.
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate No boolean If true, the database remains
18 -- unchanged. If false then the
19 -- person will be updated.
20 -- p_acting_mgr_pil_id Yes number Acting Manager's GroupPerInLerId
21 -- p_mgr_pil_ids Yes varchar List of Managers GroupPerInLerId
22 -- whose employees records needs to
23 -- be updated using the crit values
24 -- p_lvl_num Yes number Level Number used to get the
25 -- population for a Manager
26 -- p_grp_pl_id Yes number Group Plan Id
27 -- p_grp_oipl_id Yes number Group Option Id
28 -- p_name_type No varchar Display Employee Name Type
29 -- p_crit_cd1 Yes varchar First Criterion selected by
30 -- the user
31 -- p_crit_cd2 No varchar Second Criterion
32 -- p_crit_vals1 Yes varchar Values for First Criterion
33 -- p_crit_vals2 No varchar Values for Second Criterion
34 -- p_alct_by No varchar Used for Populating Recommended
35 -- values either using % of EligSal
36 -- or Per Employee Amount
37 -- p_trg_val Yes varchar Value either in Pct of Elig Sal
38 -- or in Per Emp Amt for the Crit Vals
39 -- depending on the p_alct_by field
40 --
41 -- Post Failure:
42 -- None
43 --
44 -- Access Status:
45 -- Public
46 --
47 -- {End Of Comments}
48 --
49 procedure pop_trg_amts
50 (p_validate in boolean
51 ,p_acting_mgr_pil_id in number
52 ,p_mgr_pil_ids in BEN_CWB_ACCESS_STRING_ARRAY
53 ,p_lvl_num in number
54 ,p_grp_pl_id in number
55 ,p_grp_oipl_id in number
56 ,p_name_type in varchar2
57 ,p_crit_cd1 in varchar2
58 ,p_crit_cd2 in varchar2
59 ,p_crit_vals1 in BEN_CWB_ACCESS_STRING_ARRAY
60 ,p_crit_vals2 in BEN_CWB_ACCESS_STRING_ARRAY
61 ,p_alct_by in varchar2
62 ,p_trg_val in BEN_CWB_ACCESS_STRING_ARRAY
63 );
64 --
65 end ben_cwb_mtrx_utils;