1 Package BEN_DERIVE_FACTORS as
2 /* $Header: bendefct.pkh 120.0.12000000.1 2007/01/19 15:39:49 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Derive Factors (external version)
12
13 Purpose:
14 This program determines values for the six 'derivable factors' for a given person.
15 For example DETERMINE_AGE will calculate the input persons age as of the age factor date.
16 Each procedure can be called externally.
17
18 History:
19 Date Who Version What?
20 ---- --- ------- -----
21 21 May 98 Ty Hayden 110.0 Created.
22 25 Aug 98 J K Mohapatra 115.2 Added LOS and COMB_AGE_LOS Procedures.
23 21 Dec 98 jcarpent 115.3 Added p_change_date to det age
24 18 Jan 99 G Perry 115.4 LED V ED
25 09 Mar 99 G Perry 115.5 IS to AS.
26 10 Sep 99 maagrawa 115.6 Added p_start_date to determine_los
27 14 Mar 00 maagrawa 115.7 Added p_calc_bal_to_date to
28 determine_compensation.
29 29 May 00 mhoyes 115.8 - Added p_per_dob to
30 determine_age.
31 26 Jun 00 gperry 115.9 Added p_parent_person_id to
32 determine_age process.
33 07 Dec 00 rchase 115.10 - Bug 1518211.
34 Make p_per_dob an in/out parm.
35 26 Mar 02 kmahendr 115.11 - Bug#1833008 - Added a parameter to p_cal_for to
36 determine_compensation.
37 16 Dec 02 hnarayan 115.12 Added NOCOPY hint
38 18 Apr 04 mmudigon 115.13 Universal Eligibility
39 13 Aug 04 tjesumic 115.14 fonm parameter added
40 */
41 --------------------------------------------------------------------------------
42 PROCEDURE determine_compensation
43 (p_comp_lvl_fctr_id in number,
44 p_person_id in number,
45 p_pgm_id in number default null,
46 p_pl_id in number default null,
47 p_oipl_id in number default null,
48 p_comp_obj_mode in boolean default true,
49 p_per_in_ler_id in number,
50 p_business_group_id in number,
51 p_perform_rounding_flg in boolean default true,
52 p_effective_date in date,
53 p_lf_evt_ocrd_dt in date default null,
54 p_fonm_cvg_strt_dt in date default null,
55 p_fonm_rt_strt_dt in date default null,
56 p_calc_bal_to_date in date default null,
57 p_cal_for in varchar2 default null,
58 p_value out nocopy number);
59 --
60 PROCEDURE determine_age
61 (p_person_id in number
62 --RCHASE out added
63 ,p_per_dob in out nocopy date
64 --End RCHASE
65 ,p_age_fctr_id in number
66 ,p_pgm_id in number default null
67 ,p_pl_id in number default null
68 ,p_oipl_id in number default null
69 ,p_comp_obj_mode in boolean default true
70 ,p_per_in_ler_id in number
71 ,p_effective_date in date
72 ,p_lf_evt_ocrd_dt in date default null
73 ,p_fonm_cvg_strt_dt in date default null
74 ,p_fonm_rt_strt_dt in date default null
75 ,p_business_group_id in number
76 ,p_perform_rounding_flg in boolean default true
77 ,p_value out nocopy number
78 ,p_change_date out nocopy date
79 ,p_parent_person_id in number default null);
80 --
81 PROCEDURE determine_los
82 (p_person_id in number,
83 p_los_fctr_id in number,
84 p_pgm_id in number default null,
85 p_pl_id in number default null,
86 p_oipl_id in number default null,
87 p_comp_obj_mode in boolean default true,
88 p_per_in_ler_id in number,
89 p_effective_date in date,
90 p_lf_evt_ocrd_dt in date default null,
91 p_fonm_cvg_strt_dt in date default null,
92 p_fonm_rt_strt_dt in date default null,
93 p_business_group_id in number,
94 p_perform_rounding_flg in boolean default true,
95 p_value out nocopy number,
96 p_start_date out nocopy date);
97 --
98 PROCEDURE determine_comb_age_los
99 (p_person_id in number,
100 p_cmbn_age_los_fctr_id in number,
101 p_pgm_id in number default null,
102 p_pl_id in number default null,
103 p_oipl_id in number default null,
104 p_comp_obj_mode in boolean default true,
105 p_per_in_ler_id in number,
106 p_effective_date in date,
107 p_lf_evt_ocrd_dt in date default null,
108 p_fonm_cvg_strt_dt in date default null,
109 p_fonm_rt_strt_dt in date default null,
110 p_business_group_id in number,
111 p_value out nocopy number);
112 --
113 procedure determine_hours_worked
114 (p_person_id in number,
115 p_assignment_id in number,
116 p_hrs_wkd_in_perd_fctr_id in number,
117 p_pgm_id in number default null,
118 p_pl_id in number default null,
119 p_oipl_id in number default null,
120 p_comp_obj_mode in boolean default true,
121 p_per_in_ler_id in number default null,
122 p_effective_date in date,
123 p_lf_evt_ocrd_dt in date,
124 p_fonm_cvg_strt_dt in date default null,
125 p_fonm_rt_strt_dt in date default null,
126 p_business_group_id in number,
127 p_value out nocopy number);
128 --
129 procedure determine_pct_fulltime
130 (p_person_id in number,
131 p_assignment_id in number,
132 p_pct_fl_tm_fctr_id in number,
133 p_effective_date in date,
134 p_lf_evt_ocrd_dt in date,
135 p_fonm_cvg_strt_dt in date default null,
136 p_fonm_rt_strt_dt in date default null,
137 p_comp_obj_mode in boolean default true,
138 p_business_group_id in number,
139 p_value out nocopy number);
140 --
141
142 end ben_derive_factors;