1 package ben_cwb_data_model_upgrade AUTHID CURRENT_USER as
2 /* $Header: bencwbmu.pkh 120.1 2006/01/09 15:49:36 maagrawa noship $ */
3 /* ===========================================================================+
4 * Name
5 * Compensation Workbench Data Model Upgrade Package
6 * Purpose
7 * This package is used to migrate data of old customers to
8 * new CWB Data model.
9 *
10 * Version Date Author Comment
11 * -------+-----------+---------+----------------------------------------------
12 * 115.0 14-Jan-2004 maagrawa created
13 * 115.1 15-Jan-2004 maagrawa Added out parameters to main;used by CM.
14 * 115.2 10-Feb-2004 skota Added get_ functions
15 * 115.3 03-Jan-2006 maagrawa Made commit_and_log public.
16 * ==========================================================================+
17 */
18
19 procedure main(errbuf out nocopy varchar2
20 ,retcode out nocopy number);
21
22 procedure is_cwb_used(p_result out nocopy varchar2);
23
24
25 -- The following are the functions called from refresh_person_info_group_pl
26 function get_years_in_job(p_assignment_id in number
27 ,p_job_id in number
28 ,p_effective_date in date
29 ,p_asg_effective_start_date in date)
30 return number;
31
32 function get_years_in_position(p_assignment_id in number
33 ,p_position_id in number
34 ,p_effective_date in date
35 ,p_asg_effective_start_date in date)
36 return number;
37
41 ,p_asg_effective_start_date in date)
38 function get_years_in_grade(p_assignment_id in number
39 ,p_grade_id in number
40 ,p_effective_date in date
42 return number;
43
44 function get_grd_min_val(p_grade_id in number
45 ,p_rate_id in number
46 ,p_effective_date in date)
47 return number;
48
49 function get_grd_max_val(p_grade_id in number
50 ,p_rate_id in number
51 ,p_effective_date in date)
52 return number;
53
54 function get_grd_mid_point(p_grade_id in number
55 ,p_rate_id in number
56 ,p_effective_date in date)
57 return number;
58
59 procedure commit_and_log(p_text in varchar2);
60
61 end ben_cwb_data_model_upgrade;