1 package pqh_gsp_rates AUTHID CURRENT_USER as
2 /* $Header: pqgsprat.pkh 120.2.12010000.1 2008/07/28 12:57:54 appldev ship $ */
3 type t_grd_steps is record (
4 grade_cer_id number,
5 plip_cer_id number,
6 num_steps number,
7 range number,
8 crset_id number,
9 point1_cer_id number,
10 point2_cer_id number,
11 point3_cer_id number,
12 point4_cer_id number,
13 point5_cer_id number);
14
15 type t_gs_matx is table of t_grd_steps
16 index by binary_integer ;
17
18 type t_gs_rate is record (
19 grade_cer_id number,
20 plip_cer_id number,
21 esd date,
22 eed date,
23 num_steps number,
24 range number,
25 crset_id number,
26 point1_cer_id number,
27 point2_cer_id number,
28 point3_cer_id number,
29 point4_cer_id number,
30 point5_cer_id number,
31 point1_value number,
32 point2_value number,
33 point3_value number,
34 point4_value number,
35 point5_value number);
36
37 type t_gs_rate_matx is table of t_gs_rate
38 index by binary_integer ;
39
40 type t_pt_matx is table of date
41 index by binary_integer ;
42
43 procedure build_gs_matrix(p_copy_entity_txn_id in number,
44 p_effective_date in date,
45 p_business_group_id in number) ;
46 procedure update_gsrate(p_copy_entity_txn_id in number,
47 p_gsr_cer_id in number,
48 p_effective_date in date,
49 p_business_group_id in number,
50 p_value1 in number,
51 p_value2 in number,
52 p_value3 in number,
53 p_value4 in number,
54 p_value5 in number,
55 p_datetrack_mode in varchar2);
56 procedure build_gr_matrix(p_copy_entity_txn_id in number,
57 p_effective_date in date,
58 p_crset_id in number,
59 p_business_group_id in number);
60 procedure update_grrate(p_copy_entity_txn_id in number,
61 p_grr_cer_id in number,
62 p_effective_date in date,
63 p_business_group_id in number,
64 p_value1 in number,
65 p_value2 in number,
66 p_value3 in number,
67 p_value4 in number,
68 p_value5 in number,
69 p_datetrack_mode in varchar2);
70 procedure update_crrate(p_crset_id in number,
71 p_effective_date in date,
72 p_copy_entity_txn_id in number,
73 p_datetrack_mode in varchar2,
74 p_grade_cer_id in number default null,
75 p_point_cer_id in number default null,
76 p_new_value in number);
77 procedure update_hrrate(p_old_hrrate_cer_id in number,
78 p_effective_date in date,
79 p_value in number,
80 p_datetrack_mode in varchar2,
81 p_grd_min_value in number default null,
82 p_grd_mid_value in number default null,
83 p_grd_max_value in number default null,
84 p_new_hrrate_cer_id out nocopy number);
85 procedure update_point_hrrate(p_copy_entity_txn_id in number,
86 p_rt_effective_date in date,
87 p_gl_effective_date in date,
88 p_business_group_id in number,
89 p_hrrate_cer_id in out nocopy number,
90 p_point_cer_id in number,
91 p_point_value in number,
92 p_datetrack_mode in varchar2);
93 procedure update_grade_hrrate(p_copy_entity_txn_id in number,
94 p_rt_effective_date in date,
95 p_gl_effective_date in date,
96 p_business_group_id in number,
97 p_hrrate_cer_id in out nocopy number,
98 p_grade_cer_id in number,
99 p_grd_value in number,
100 p_grd_min_value in number,
101 p_grd_mid_value in number,
102 p_grd_max_value in number,
103 p_datetrack_mode in varchar2);
104 procedure create_grade_hrrate(p_copy_entity_txn_id in number,
105 p_effective_date in date,
106 p_abr_id in number,
107 p_abr_cer_id in number,
108 p_pay_rule_id in number,
109 p_grade_id in number);
110 procedure create_point_hrrate(p_copy_entity_txn_id in number,
111 p_effective_date in date,
112 p_abr_id in number,
113 p_abr_cer_id in number,
114 p_pay_rule_id in number,
115 p_point_id in number);
116 procedure sync_grrate(p_crset_id in number,
117 p_copy_entity_txn_id in number);
118 procedure populate_old_values(p_copy_entity_txn_id in number);
119 end pqh_gsp_rates;