1 PACKAGE PAY_GRADE_RULES_PKG AUTHID CURRENT_USER AS
2 /* $Header: pygrr01t.pkh 115.12 2003/06/01 12:14:18 kjagadee ship $ */
3
4
5 PROCEDURE CHECK_UNIQUENESS(P_GRADE_RULE_ID_2 IN OUT NOCOPY NUMBER,
6 P_GRADE_OR_SPINAL_POINT_ID NUMBER,
7 P_RATE_TYPE VARCHAR2,
8 P_RATE_ID NUMBER,
9 P_BUSINESS_GROUP_ID NUMBER,
10 P_MODE VARCHAR2);
11
12 procedure pop_flds(p_name IN OUT NOCOPY VARCHAR2,
13 p_rt_id IN NUMBER,
14 p_mean IN OUT NOCOPY VARCHAR2,
15 p_bgroup_id IN NUMBER);
16
17 -- ----------------------------------------------------------------------------
18 -- |-------------------< INSERT_ROW >----------------------|
19 -- ----------------------------------------------------------------------------
20 -- {Start Of Comments}
21 --
22 -- Description:
23 -- This procedure will insert the grade rule details
24 --
25 -- Prerequisites:
26 -- A valid grade must be existing .
27 --
28 -- In Parameters:
29 -- Name Reqd Type Description
30 -- P_GRADE_RULE_ID yes number System assigned id for
31 -- the grade rule
32 -- P_EFFECTIVE_START_DATE yes date Start date of this
33 -- grade rule
34 -- P_EFFECTIVE_END_DATE yes date End date of this grade
35 -- rule(maximum date or
36 -- the end date of
37 -- attached grade,
38 -- whichever is earlier)
39 -- P_GRADE_OR_SPINAL_POINT_ID yes date Grade id which is
40 -- attached to this grade
41 -- rule
42 -- Post Success:
43 -- Rowid of the new record will be rturned.
44 --
45 -- Post Failure:
46 -- None.
47 --
48 -- Access Status:
49 -- Internal developement use.
50 --
51 -- {End Of Comments}
52 -- ----------------------------------------------------------------------------
53 PROCEDURE INSERT_ROW(P_ROWID IN OUT NOCOPY VARCHAR2,
54 P_GRADE_RULE_ID NUMBER,
55 P_EFFECTIVE_START_DATE DATE,
56 P_EFFECTIVE_END_DATE DATE,
57 P_BUSINESS_GROUP_ID NUMBER,
58 P_RATE_TYPE VARCHAR2,
59 P_GRADE_OR_SPINAL_POINT_ID NUMBER,
60 P_RATE_ID NUMBER,
61 P_MAXIMUM VARCHAR2,
62 P_MID_VALUE VARCHAR2,
63 P_MINIMUM VARCHAR2,
64 P_SEQUENCE NUMBER,
65 P_VALUE VARCHAR2,
66 P_REQUEST_ID NUMBER,
67 P_PROGRAM_APPLICATION_ID NUMBER,
68 P_PROGRAM_ID NUMBER,
69 P_PROGRAM_UPDATE_DATE DATE,
70 P_CURRENCY_CODE VARCHAR2);
71
72 PROCEDURE UPDATE_ROW(P_ROWID VARCHAR2,
73 P_GRADE_RULE_ID NUMBER,
74 P_EFFECTIVE_START_DATE DATE,
75 P_EFFECTIVE_END_DATE DATE,
76 P_BUSINESS_GROUP_ID NUMBER,
77 P_RATE_TYPE VARCHAR2,
78 P_GRADE_OR_SPINAL_POINT_ID NUMBER,
79 P_RATE_ID NUMBER,
80 P_MAXIMUM VARCHAR2,
81 P_MID_VALUE VARCHAR2,
82 P_MINIMUM VARCHAR2,
83 P_SEQUENCE NUMBER,
84 P_VALUE VARCHAR2,
85 P_REQUEST_ID NUMBER,
86 P_PROGRAM_APPLICATION_ID NUMBER,
87 P_PROGRAM_ID NUMBER,
88 P_PROGRAM_UPDATE_DATE DATE,
89 P_CURRENCY_CODE VARCHAR2);
90
91 PROCEDURE DELETE_ROW(P_ROWID VARCHAR2);
92 --
93 PROCEDURE LOCK_ROW( P_ROWID VARCHAR2,
94 P_GRADE_RULE_ID NUMBER,
95 P_EFFECTIVE_START_DATE DATE,
96 P_EFFECTIVE_END_DATE DATE,
97 P_BUSINESS_GROUP_ID NUMBER,
98 P_RATE_TYPE VARCHAR2,
99 P_GRADE_OR_SPINAL_POINT_ID NUMBER,
100 P_RATE_ID NUMBER,
101 P_MAXIMUM VARCHAR2,
102 P_MID_VALUE VARCHAR2,
103 P_MINIMUM VARCHAR2,
104 P_SEQUENCE NUMBER,
105 P_VALUE VARCHAR2,
106 P_REQUEST_ID NUMBER,
107 P_PROGRAM_APPLICATION_ID NUMBER,
108 P_PROGRAM_ID NUMBER,
109 P_PROGRAM_UPDATE_DATE DATE,
110 P_CURRENCY_CODE VARCHAR2);
111
112 FUNCTION POPULATE_RATE(p_spinal_point_id IN NUMBER, p_effective_date IN DATE)
113
114 RETURN VARCHAR;
115
116 FUNCTION POPULATE_VALUE(p_spinal_point_id IN NUMBER, p_effective_date IN DATE)
117
118 RETURN VARCHAR;
119
120 FUNCTION POPULATE_UNITS (p_spinal_point_id IN NUMBER, p_effective_date IN DATE)
121
122 RETURN VARCHAR;
123
124 -- Bug fix 2651173
125 -- ----------------------------------------------------------------------------
126 -- |-------------------< chk_emp_asgmnt_bef_del >----------------------|
127 -- ----------------------------------------------------------------------------
128 -- {Start Of Comments}
129 --
130 -- Description:
131 -- This procedure will check that, for the given spinal point id and
132 -- and parent spine id, point value is used in employee assignments
133 -- based on the effective date and irrespective of the efective date
134 --
135 -- Prerequisites:
136 -- A valid grade point value should be existing
137 --
138 -- In Parameters:
139 -- Name Reqd Type Description
140 -- p_spinal_point_id yes number System assigned id for
141 -- grade point or spinal
142 -- point
143 -- p_parent_spine_id yes number Pay Scale id for the
144 -- grade points
145 -- p_effective_date yes date Effective date of the
146 -- user environment
147 -- Post Success:
148 -- p_point_used varchar2 Flag used to identify
149 -- whether the point value
150 -- is associated with
151 -- any assignment/s
152 -- irrespective of the
153 -- effective date
154 -- User will be stopped from deleting the point value which is
155 -- associated with an employee assignment
156 --
157 -- Post Failure:
158 -- None.
159 --
160 -- Access Status:
161 -- Internal developement use.
162 --
163 -- {End Of Comments}
164 -- ----------------------------------------------------------------------------
165 procedure chk_emp_asgmnt_bef_del(p_spinal_point_id in number,
166 p_parent_spine_id in number,
167 p_effective_date in date,
168 p_point_used out nocopy varchar2);
169 --
170
171 END PAY_GRADE_RULES_PKG;