1 package pqh_gsp_default AUTHID CURRENT_USER as
2 /* $Header: pqgspdef.pkh 115.3 2004/07/27 04:19 ggnanagu noship $ */
3
4 function get_asg_for_pil(p_per_in_ler_id in number,
5 p_effective_date in date) return number;
6
7 procedure get_electbl_chc(p_per_in_ler_id in number,
8 p_effective_date in date,
9 p_grade_id in number,
10 p_step_id in number,
11 p_electbl_chc_id out nocopy number);
12 procedure get_def_auto_code(p_per_in_ler_id in number,
13 p_effective_date in date,
14 p_return_code out nocopy varchar2,
15 p_electbl_chc_id out nocopy number);
16 function get_next_oipl(p_oipl_id in number,
17 p_effective_date in date) return number;
18 function get_next_step(p_grade_id in number default null,
19 p_step_id in number default null,
20 p_effective_date in date) return number;
21 function get_lowest_sal_incr_step(p_cur_sal in number,
22 p_grade_id in number,
23 p_effective_date in date,
24 P_Assignment_id in Number Default NULL) return number;
25 function get_sal_for_step(p_step_id in number,
26 p_effective_date in date) return number;
27 procedure get_default_progression(p_per_in_ler_id in number,
28 p_effective_date in date,
29 p_electbl_chc_id out nocopy number,
30 p_return_code out nocopy varchar2,
31 p_error_message out nocopy varchar2);
32 function get_default_gl(p_effective_date in date,
33 p_business_group_id in number) return number;
34 procedure get_gl_details(p_gl_id in number,
35 p_effective_date in date,
36 p_prog_style_cd out nocopy varchar2,
37 p_post_style_cd out nocopy varchar2,
38 p_gl_name out nocopy varchar2,
39 p_dflt_step_cd out nocopy varchar2,
40 p_dflt_step_rl out nocopy varchar2);
41 function get_next_grade(p_grade_id in number,
42 p_gl_id in number,
43 p_effective_date in date) return number;
44 function get_next_plan(p_pl_id in number,
45 p_gl_id in number,
46 p_effective_date in date) return number ;
47 function get_cur_sal(p_assignment_id in number,
48 p_effective_date in date) return number;
49 procedure get_emp_step_placement(p_assignment_id in number,
50 p_effective_date in date,
51 p_emp_step_id out nocopy number,
52 p_num_incr out nocopy number);
53 procedure step_progression(p_effective_date in date,
54 p_step_id in number,
55 p_num_incr in number,
56 p_ceiling_step_id in number,
57 p_future_step_id in number,
58 p_next_step_id out nocopy number);
59 procedure grd_step_progression_result(p_grade_id in number,
60 p_step_id in number,
61 p_gl_id in number,
62 p_assignment_id in number,
63 p_effective_date in date,
64 p_ceiling_step_id in number,
65 p_dflt_step_cd in varchar2,
66 p_num_incr in number,
67 p_future_step_id in number,
68 p_next_grade_id out nocopy number,
69 p_next_step_id out nocopy number);
70 procedure grade_progression(p_assignment_id in number,
71 p_effective_date in date,
72 p_grade_id in number,
73 p_gl_id in number,
74 p_next_grade_id out nocopy number);
75 function get_default_step(p_next_grade_id in number,
76 p_assignment_id in number,
77 p_dflt_step_cd in varchar2,
78 p_effective_date in date) return number;
79 procedure get_step_seq(p_step_id in number,
80 p_effective_date in date,
81 p_step_seq out nocopy number,
82 p_grade_spine_id out nocopy number);
83 function is_grade_in_gl(p_grade_id in number,
84 p_gl_id in number,
85 p_effective_date in date) return number;
86 procedure next_asg_grade_step(p_assignment_id in number,
87 p_cur_asg_eed in date,
88 p_future_grade_id out nocopy number,
89 p_future_step_id out nocopy number);
90 function get_annual_sal(p_assignment_id in number,
91 p_effective_date in date) return number;
92 end pqh_gsp_default;