1 Package hr_grade_bk2 as
2 /* $Header: pegrdapi.pkh 120.1.12010000.3 2008/12/05 08:02:39 sidsaxen ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------------< update_grade_b >--------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_grade_b
9 (P_GRADE_ID IN NUMBER
10 ,P_SEQUENCE IN NUMBER
11 ,P_DATE_FROM IN DATE
12 ,P_DATE_TO IN DATE
13 ,p_effective_date in date
14 ,P_REQUEST_ID IN NUMBER
15 ,P_PROGRAM_APPLICATION_ID IN NUMBER
16 ,P_PROGRAM_ID IN NUMBER
17 ,P_PROGRAM_UPDATE_DATE IN DATE
18 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2
19 ,P_ATTRIBUTE1 IN VARCHAR2
20 ,P_ATTRIBUTE2 IN VARCHAR2
21 ,P_ATTRIBUTE3 IN VARCHAR2
22 ,P_ATTRIBUTE4 IN VARCHAR2
23 ,P_ATTRIBUTE5 IN VARCHAR2
24 ,P_ATTRIBUTE6 IN VARCHAR2
25 ,P_ATTRIBUTE7 IN VARCHAR2
26 ,P_ATTRIBUTE8 IN VARCHAR2
27 ,P_ATTRIBUTE9 IN VARCHAR2
28 ,P_ATTRIBUTE10 IN VARCHAR2
29 ,P_ATTRIBUTE11 IN VARCHAR2
30 ,P_ATTRIBUTE12 IN VARCHAR2
31 ,P_ATTRIBUTE13 IN VARCHAR2
32 ,P_ATTRIBUTE14 IN VARCHAR2
33 ,P_ATTRIBUTE15 IN VARCHAR2
34 ,P_ATTRIBUTE16 IN VARCHAR2
35 ,P_ATTRIBUTE17 IN VARCHAR2
36 ,P_ATTRIBUTE18 IN VARCHAR2
37 ,P_ATTRIBUTE19 IN VARCHAR2
38 ,P_ATTRIBUTE20 IN VARCHAR2
39 ,P_INFORMATION_CATEGORY IN VARCHAR2
40 ,P_INFORMATION1 IN VARCHAR2
41 ,P_INFORMATION2 IN VARCHAR2
42 ,P_INFORMATION3 IN VARCHAR2
43 ,P_INFORMATION4 IN VARCHAR2
44 ,P_INFORMATION5 IN VARCHAR2
45 ,P_INFORMATION6 IN VARCHAR2
46 ,P_INFORMATION7 IN VARCHAR2
47 ,P_INFORMATION8 IN VARCHAR2
48 ,P_INFORMATION9 IN VARCHAR2
49 ,P_INFORMATION10 IN VARCHAR2
50 ,P_INFORMATION11 IN VARCHAR2
51 ,P_INFORMATION12 IN VARCHAR2
52 ,P_INFORMATION13 IN VARCHAR2
53 ,P_INFORMATION14 IN VARCHAR2
54 ,P_INFORMATION15 IN VARCHAR2
55 ,P_INFORMATION16 IN VARCHAR2
56 ,P_INFORMATION17 IN VARCHAR2
57 ,P_INFORMATION18 IN VARCHAR2
58 ,P_INFORMATION19 IN VARCHAR2
59 ,P_INFORMATION20 IN VARCHAR2
60 ,P_LAST_UPDATE_DATE IN DATE
61 ,P_LAST_UPDATED_BY IN NUMBER
62 ,P_LAST_UPDATE_LOGIN IN NUMBER
63 ,P_CREATED_BY IN NUMBER
64 ,P_CREATION_DATE IN DATE
65 ,P_SEGMENT1 IN VARCHAR2
66 ,P_SEGMENT2 IN VARCHAR2
67 ,P_SEGMENT3 IN VARCHAR2
68 ,P_SEGMENT4 IN VARCHAR2
69 ,P_SEGMENT5 IN VARCHAR2
70 ,P_SEGMENT6 IN VARCHAR2
71 ,P_SEGMENT7 IN VARCHAR2
72 ,P_SEGMENT8 IN VARCHAR2
73 ,P_SEGMENT9 IN VARCHAR2
74 ,P_SEGMENT10 IN VARCHAR2
75 ,P_SEGMENT11 IN VARCHAR2
76 ,P_SEGMENT12 IN VARCHAR2
77 ,P_SEGMENT13 IN VARCHAR2
78 ,P_SEGMENT14 IN VARCHAR2
79 ,P_SEGMENT15 IN VARCHAR2
80 ,P_SEGMENT16 IN VARCHAR2
81 ,P_SEGMENT17 IN VARCHAR2
82 ,P_SEGMENT18 IN VARCHAR2
83 ,P_SEGMENT19 IN VARCHAR2
84 ,P_SEGMENT20 IN VARCHAR2
85 ,P_SEGMENT21 IN VARCHAR2
86 ,P_SEGMENT22 IN VARCHAR2
87 ,P_SEGMENT23 IN VARCHAR2
88 ,P_SEGMENT24 IN VARCHAR2
89 ,P_SEGMENT25 IN VARCHAR2
90 ,P_SEGMENT26 IN VARCHAR2
91 ,P_SEGMENT27 IN VARCHAR2
92 ,P_SEGMENT28 IN VARCHAR2
93 ,P_SEGMENT29 IN VARCHAR2
94 ,P_SEGMENT30 IN VARCHAR2
95 ,P_CONCAT_SEGMENTS IN VARCHAR2
96 ,P_LANGUAGE_CODE IN VARCHAR2
97 ,P_NAME IN VARCHAR2
98 ,P_OBJECT_VERSION_NUMBER IN NUMBER
99 ,P_GRADE_DEFINITION_ID IN NUMBER
100 ,P_SHORT_NAME IN VARCHAR2
101 );
102 --
103 -- ----------------------------------------------------------------------------
104 -- |------------------------------< update_grade_a >--------------------------|
105 -- ----------------------------------------------------------------------------
106 --
107 procedure update_grade_a
108 (P_GRADE_ID IN NUMBER
109 ,P_SEQUENCE IN NUMBER
110 ,P_DATE_FROM IN DATE
111 ,P_DATE_TO IN DATE
112 ,p_effective_date in date
113 ,P_REQUEST_ID IN NUMBER
114 ,P_PROGRAM_APPLICATION_ID IN NUMBER
115 ,P_PROGRAM_ID IN NUMBER
116 ,P_PROGRAM_UPDATE_DATE IN DATE
117 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2
118 ,P_ATTRIBUTE1 IN VARCHAR2
119 ,P_ATTRIBUTE2 IN VARCHAR2
120 ,P_ATTRIBUTE3 IN VARCHAR2
121 ,P_ATTRIBUTE4 IN VARCHAR2
122 ,P_ATTRIBUTE5 IN VARCHAR2
123 ,P_ATTRIBUTE6 IN VARCHAR2
124 ,P_ATTRIBUTE7 IN VARCHAR2
125 ,P_ATTRIBUTE8 IN VARCHAR2
126 ,P_ATTRIBUTE9 IN VARCHAR2
127 ,P_ATTRIBUTE10 IN VARCHAR2
128 ,P_ATTRIBUTE11 IN VARCHAR2
129 ,P_ATTRIBUTE12 IN VARCHAR2
130 ,P_ATTRIBUTE13 IN VARCHAR2
131 ,P_ATTRIBUTE14 IN VARCHAR2
132 ,P_ATTRIBUTE15 IN VARCHAR2
133 ,P_ATTRIBUTE16 IN VARCHAR2
134 ,P_ATTRIBUTE17 IN VARCHAR2
135 ,P_ATTRIBUTE18 IN VARCHAR2
136 ,P_ATTRIBUTE19 IN VARCHAR2
137 ,P_ATTRIBUTE20 IN VARCHAR2
138 ,P_INFORMATION_CATEGORY IN VARCHAR2
139 ,P_INFORMATION1 IN VARCHAR2
140 ,P_INFORMATION2 IN VARCHAR2
141 ,P_INFORMATION3 IN VARCHAR2
142 ,P_INFORMATION4 IN VARCHAR2
143 ,P_INFORMATION5 IN VARCHAR2
144 ,P_INFORMATION6 IN VARCHAR2
145 ,P_INFORMATION7 IN VARCHAR2
146 ,P_INFORMATION8 IN VARCHAR2
147 ,P_INFORMATION9 IN VARCHAR2
148 ,P_INFORMATION10 IN VARCHAR2
149 ,P_INFORMATION11 IN VARCHAR2
150 ,P_INFORMATION12 IN VARCHAR2
151 ,P_INFORMATION13 IN VARCHAR2
152 ,P_INFORMATION14 IN VARCHAR2
153 ,P_INFORMATION15 IN VARCHAR2
154 ,P_INFORMATION16 IN VARCHAR2
155 ,P_INFORMATION17 IN VARCHAR2
156 ,P_INFORMATION18 IN VARCHAR2
157 ,P_INFORMATION19 IN VARCHAR2
158 ,P_INFORMATION20 IN VARCHAR2
159 ,P_LAST_UPDATE_DATE IN DATE
160 ,P_LAST_UPDATED_BY IN NUMBER
161 ,P_LAST_UPDATE_LOGIN IN NUMBER
162 ,P_CREATED_BY IN NUMBER
163 ,P_CREATION_DATE IN DATE
164 ,P_SEGMENT1 IN VARCHAR2
165 ,P_SEGMENT2 IN VARCHAR2
166 ,P_SEGMENT3 IN VARCHAR2
167 ,P_SEGMENT4 IN VARCHAR2
168 ,P_SEGMENT5 IN VARCHAR2
169 ,P_SEGMENT6 IN VARCHAR2
170 ,P_SEGMENT7 IN VARCHAR2
171 ,P_SEGMENT8 IN VARCHAR2
172 ,P_SEGMENT9 IN VARCHAR2
173 ,P_SEGMENT10 IN VARCHAR2
174 ,P_SEGMENT11 IN VARCHAR2
175 ,P_SEGMENT12 IN VARCHAR2
176 ,P_SEGMENT13 IN VARCHAR2
177 ,P_SEGMENT14 IN VARCHAR2
178 ,P_SEGMENT15 IN VARCHAR2
179 ,P_SEGMENT16 IN VARCHAR2
180 ,P_SEGMENT17 IN VARCHAR2
181 ,P_SEGMENT18 IN VARCHAR2
182 ,P_SEGMENT19 IN VARCHAR2
183 ,P_SEGMENT20 IN VARCHAR2
184 ,P_SEGMENT21 IN VARCHAR2
185 ,P_SEGMENT22 IN VARCHAR2
186 ,P_SEGMENT23 IN VARCHAR2
187 ,P_SEGMENT24 IN VARCHAR2
188 ,P_SEGMENT25 IN VARCHAR2
189 ,P_SEGMENT26 IN VARCHAR2
190 ,P_SEGMENT27 IN VARCHAR2
191 ,P_SEGMENT28 IN VARCHAR2
192 ,P_SEGMENT29 IN VARCHAR2
193 ,P_SEGMENT30 IN VARCHAR2
194 ,P_LANGUAGE_CODE IN VARCHAR2
195 ,P_CONCAT_SEGMENTS IN VARCHAR2
196 ,P_NAME IN VARCHAR2
197 ,P_OBJECT_VERSION_NUMBER IN NUMBER
198 ,P_GRADE_DEFINITION_ID IN NUMBER
199 ,P_SHORT_NAME IN VARCHAR2
200 );
201 --
202 end hr_grade_bk2;
[Home] [Help]