1 package PSB_PARAMETER_FORMULAS_PVT as
2 /* $Header: PSBVPFPS.pls 120.2 2005/07/13 11:28:27 shtripat ship $ */
3 procedure INSERT_ROW (
4 p_api_version IN NUMBER,
5 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6 p_commit IN VARCHAR2 := FND_API.G_FALSE,
7 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8 p_return_status OUT NOCOPY VARCHAR2,
9 p_msg_count OUT NOCOPY NUMBER,
10 p_msg_data OUT NOCOPY VARCHAR2,
11 --
12 P_ROWID in OUT NOCOPY VARCHAR2,
13 P_PARAMETER_FORMULA_ID in NUMBER,
14 P_PARAMETER_ID in NUMBER,
15 P_STEP_NUMBER in NUMBER,
16 P_BUDGET_YEAR_TYPE_ID in NUMBER,
17 P_BALANCE_TYPE in VARCHAR2,
18 P_TEMPLATE_ID in NUMBER,
19 P_CONCATENATED_SEGMENTS IN VARCHAR2,
20 P_SEGMENT1 in VARCHAR2,
21 P_SEGMENT2 in VARCHAR2,
22 P_SEGMENT3 in VARCHAR2,
23 P_SEGMENT4 in VARCHAR2,
24 P_SEGMENT5 in VARCHAR2,
25 P_SEGMENT6 in VARCHAR2,
26 P_SEGMENT7 in VARCHAR2,
27 P_SEGMENT8 in VARCHAR2,
28 P_SEGMENT9 in VARCHAR2,
29 P_SEGMENT10 in VARCHAR2,
30 P_SEGMENT11 in VARCHAR2,
31 P_SEGMENT12 in VARCHAR2,
32 P_SEGMENT13 in VARCHAR2,
33 P_SEGMENT14 in VARCHAR2,
34 P_SEGMENT15 in VARCHAR2,
35 P_SEGMENT16 in VARCHAR2,
36 P_SEGMENT17 in VARCHAR2,
37 P_SEGMENT18 in VARCHAR2,
38 P_SEGMENT19 in VARCHAR2,
39 P_SEGMENT20 in VARCHAR2,
40 P_SEGMENT21 in VARCHAR2,
41 P_SEGMENT22 in VARCHAR2,
42 P_SEGMENT23 in VARCHAR2,
43 P_SEGMENT24 in VARCHAR2,
44 P_SEGMENT25 in VARCHAR2,
45 P_SEGMENT26 in VARCHAR2,
46 P_SEGMENT27 in VARCHAR2,
47 P_SEGMENT28 in VARCHAR2,
48 P_SEGMENT29 in VARCHAR2,
49 P_SEGMENT30 in VARCHAR2,
50 P_CURRENCY_CODE in VARCHAR2,
51 P_AMOUNT in NUMBER,
52 P_PREFIX_OPERATOR in VARCHAR2,
53 P_POSTFIX_OPERATOR in VARCHAR2,
54 P_HIREDATE_BETWEEN_FROM in NUMBER,
55 P_HIREDATE_BETWEEN_TO in NUMBER,
56 P_ADJDATE_BETWEEN_FROM in NUMBER,
57 P_ADJDATE_BETWEEN_TO in NUMBER,
58 P_INCREMENT_BY in NUMBER,
59 P_INCREMENT_TYPE in VARCHAR2,
60 P_ASSIGNMENT_TYPE IN VARCHAR2,
61 P_ATTRIBUTE_ID IN NUMBER,
62 P_ATTRIBUTE_VALUE IN VARCHAR2,
63 P_PAY_ELEMENT_ID in NUMBER,
64 P_PAY_ELEMENT_OPTION_ID IN NUMBER,
65 P_GRADE_STEP IN NUMBER,
66 P_ELEMENT_VALUE in NUMBER,
67 P_ELEMENT_VALUE_TYPE in VARCHAR2,
68 P_EFFECTIVE_START_DATE in DATE,
69 P_EFFECTIVE_END_DATE in DATE,
70 P_ATTRIBUTE1 in VARCHAR2,
71 P_ATTRIBUTE2 in VARCHAR2,
72 P_ATTRIBUTE3 in VARCHAR2,
73 P_ATTRIBUTE4 in VARCHAR2,
74 P_ATTRIBUTE5 in VARCHAR2,
75 P_ATTRIBUTE6 in VARCHAR2,
76 P_ATTRIBUTE7 in VARCHAR2,
77 P_ATTRIBUTE8 in VARCHAR2,
78 P_ATTRIBUTE9 in VARCHAR2,
79 P_ATTRIBUTE10 in VARCHAR2,
80 P_CONTEXT in VARCHAR2,
81 p_Last_Update_Date DATE,
82 p_Last_Updated_By NUMBER,
83 p_Last_Update_Login NUMBER,
84 p_Created_By NUMBER,
85 p_Creation_Date DATE
86 );
87
88
89 procedure LOCK_ROW (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 p_return_status OUT NOCOPY VARCHAR2,
95 p_msg_count OUT NOCOPY NUMBER,
96 p_msg_data OUT NOCOPY VARCHAR2,
97 p_lock_row OUT NOCOPY VARCHAR2,
98 --
99 P_ROWID IN VARCHAR2,
100 P_PARAMETER_FORMULA_ID in NUMBER,
101 P_PARAMETER_ID in NUMBER,
102 P_STEP_NUMBER in NUMBER,
103 P_BUDGET_YEAR_TYPE_ID in NUMBER,
104 P_BALANCE_TYPE in VARCHAR2,
105 P_TEMPLATE_ID in NUMBER,
106 P_CONCATENATED_SEGMENTS IN VARCHAR2,
107 P_SEGMENT1 in VARCHAR2,
108 P_SEGMENT2 in VARCHAR2,
109 P_SEGMENT3 in VARCHAR2,
110 P_SEGMENT4 in VARCHAR2,
111 P_SEGMENT5 in VARCHAR2,
112 P_SEGMENT6 in VARCHAR2,
113 P_SEGMENT7 in VARCHAR2,
114 P_SEGMENT8 in VARCHAR2,
115 P_SEGMENT9 in VARCHAR2,
116 P_SEGMENT10 in VARCHAR2,
117 P_SEGMENT11 in VARCHAR2,
118 P_SEGMENT12 in VARCHAR2,
119 P_SEGMENT13 in VARCHAR2,
120 P_SEGMENT14 in VARCHAR2,
121 P_SEGMENT15 in VARCHAR2,
122 P_SEGMENT16 in VARCHAR2,
123 P_SEGMENT17 in VARCHAR2,
124 P_SEGMENT18 in VARCHAR2,
125 P_SEGMENT19 in VARCHAR2,
126 P_SEGMENT20 in VARCHAR2,
127 P_SEGMENT21 in VARCHAR2,
128 P_SEGMENT22 in VARCHAR2,
129 P_SEGMENT23 in VARCHAR2,
130 P_SEGMENT24 in VARCHAR2,
131 P_SEGMENT25 in VARCHAR2,
132 P_SEGMENT26 in VARCHAR2,
133 P_SEGMENT27 in VARCHAR2,
134 P_SEGMENT28 in VARCHAR2,
135 P_SEGMENT29 in VARCHAR2,
136 P_SEGMENT30 in VARCHAR2,
137 P_CURRENCY_CODE in VARCHAR2,
138 P_AMOUNT in NUMBER,
139 P_PREFIX_OPERATOR in VARCHAR2,
140 P_POSTFIX_OPERATOR in VARCHAR2,
141 P_HIREDATE_BETWEEN_FROM in NUMBER,
142 P_HIREDATE_BETWEEN_TO in NUMBER,
143 P_ADJDATE_BETWEEN_FROM in NUMBER,
144 P_ADJDATE_BETWEEN_TO in NUMBER,
145 P_INCREMENT_BY in NUMBER,
146 P_INCREMENT_TYPE in VARCHAR2,
147 P_ASSIGNMENT_TYPE IN VARCHAR2,
148 P_ATTRIBUTE_ID IN NUMBER,
149 P_ATTRIBUTE_VALUE IN VARCHAR2,
150 P_PAY_ELEMENT_ID in NUMBER,
151 P_PAY_ELEMENT_OPTION_ID IN NUMBER,
152 P_GRADE_STEP IN NUMBER,
153 P_ELEMENT_VALUE in NUMBER,
154 P_ELEMENT_VALUE_TYPE in VARCHAR2,
155 P_EFFECTIVE_START_DATE in DATE,
156 P_EFFECTIVE_END_DATE in DATE,
157 P_ATTRIBUTE1 in VARCHAR2,
158 P_ATTRIBUTE2 in VARCHAR2,
159 P_ATTRIBUTE3 in VARCHAR2,
160 P_ATTRIBUTE4 in VARCHAR2,
161 P_ATTRIBUTE5 in VARCHAR2,
162 P_ATTRIBUTE6 in VARCHAR2,
163 P_ATTRIBUTE7 in VARCHAR2,
164 P_ATTRIBUTE8 in VARCHAR2,
165 P_ATTRIBUTE9 in VARCHAR2,
166 P_ATTRIBUTE10 in VARCHAR2,
167 P_CONTEXT in VARCHAR2
168 );
169
170 procedure UPDATE_ROW (
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173 p_commit IN VARCHAR2 := FND_API.G_FALSE,
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 p_return_status OUT NOCOPY VARCHAR2,
176 p_msg_count OUT NOCOPY NUMBER,
177 p_msg_data OUT NOCOPY VARCHAR2,
178 --
179 P_ROWID IN VARCHAR2,
180 P_PARAMETER_FORMULA_ID in NUMBER,
181 P_PARAMETER_ID in NUMBER,
182 P_STEP_NUMBER in NUMBER,
183 P_BUDGET_YEAR_TYPE_ID in NUMBER,
184 P_BALANCE_TYPE in VARCHAR2,
185 P_TEMPLATE_ID in NUMBER,
186 P_CONCATENATED_SEGMENTS IN VARCHAR2,
187 P_SEGMENT1 in VARCHAR2,
188 P_SEGMENT2 in VARCHAR2,
189 P_SEGMENT3 in VARCHAR2,
190 P_SEGMENT4 in VARCHAR2,
191 P_SEGMENT5 in VARCHAR2,
192 P_SEGMENT6 in VARCHAR2,
193 P_SEGMENT7 in VARCHAR2,
194 P_SEGMENT8 in VARCHAR2,
195 P_SEGMENT9 in VARCHAR2,
196 P_SEGMENT10 in VARCHAR2,
197 P_SEGMENT11 in VARCHAR2,
198 P_SEGMENT12 in VARCHAR2,
199 P_SEGMENT13 in VARCHAR2,
200 P_SEGMENT14 in VARCHAR2,
201 P_SEGMENT15 in VARCHAR2,
202 P_SEGMENT16 in VARCHAR2,
203 P_SEGMENT17 in VARCHAR2,
204 P_SEGMENT18 in VARCHAR2,
205 P_SEGMENT19 in VARCHAR2,
206 P_SEGMENT20 in VARCHAR2,
207 P_SEGMENT21 in VARCHAR2,
208 P_SEGMENT22 in VARCHAR2,
209 P_SEGMENT23 in VARCHAR2,
210 P_SEGMENT24 in VARCHAR2,
211 P_SEGMENT25 in VARCHAR2,
212 P_SEGMENT26 in VARCHAR2,
213 P_SEGMENT27 in VARCHAR2,
214 P_SEGMENT28 in VARCHAR2,
215 P_SEGMENT29 in VARCHAR2,
216 P_SEGMENT30 in VARCHAR2,
217 P_CURRENCY_CODE in VARCHAR2,
218 P_AMOUNT in NUMBER,
219 P_PREFIX_OPERATOR in VARCHAR2,
220 P_POSTFIX_OPERATOR in VARCHAR2,
221 P_HIREDATE_BETWEEN_FROM in NUMBER,
222 P_HIREDATE_BETWEEN_TO in NUMBER,
223 P_ADJDATE_BETWEEN_FROM in NUMBER,
224 P_ADJDATE_BETWEEN_TO in NUMBER,
225 P_INCREMENT_BY in NUMBER,
226 P_INCREMENT_TYPE in VARCHAR2,
227 P_ASSIGNMENT_TYPE IN VARCHAR2,
228 P_ATTRIBUTE_ID IN NUMBER,
229 P_ATTRIBUTE_VALUE IN VARCHAR2,
230 P_PAY_ELEMENT_ID in NUMBER,
231 P_PAY_ELEMENT_OPTION_ID IN NUMBER,
232 P_GRADE_STEP IN NUMBER,
233 P_ELEMENT_VALUE in NUMBER,
234 P_ELEMENT_VALUE_TYPE in VARCHAR2,
235 P_EFFECTIVE_START_DATE in DATE,
236 P_EFFECTIVE_END_DATE in DATE,
237 P_ATTRIBUTE1 in VARCHAR2,
238 P_ATTRIBUTE2 in VARCHAR2,
239 P_ATTRIBUTE3 in VARCHAR2,
240 P_ATTRIBUTE4 in VARCHAR2,
241 P_ATTRIBUTE5 in VARCHAR2,
242 P_ATTRIBUTE6 in VARCHAR2,
243 P_ATTRIBUTE7 in VARCHAR2,
244 P_ATTRIBUTE8 in VARCHAR2,
245 P_ATTRIBUTE9 in VARCHAR2,
246 P_ATTRIBUTE10 in VARCHAR2,
247 P_CONTEXT in VARCHAR2,
248 p_Last_Update_Date DATE,
249 p_Last_Updated_By NUMBER,
250 p_Last_Update_Login NUMBER
251 );
252
253 procedure DELETE_ROW (
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256 p_commit IN VARCHAR2 := FND_API.G_FALSE,
257 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258 p_return_status OUT NOCOPY VARCHAR2,
259 p_msg_count OUT NOCOPY NUMBER,
260 p_msg_data OUT NOCOPY VARCHAR2,
261 --
262 P_PARAMETER_FORMULA_ID in NUMBER
263 );
264
265 end PSB_PARAMETER_FORMULAS_PVT;