1 PACKAGE PSB_POSITION_PAY_DISTR_PVT AS
2 /* $Header: PSBVPYDS.pls 120.3 2005/10/14 16:33:17 matthoma ship $ */
3
4 PROCEDURE INSERT_ROW
5 ( p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7 p_commit IN VARCHAR2 := fnd_api.g_false,
8 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
9 p_return_status OUT NOCOPY VARCHAR2,
10 p_msg_count OUT NOCOPY NUMBER,
11 p_msg_data OUT NOCOPY VARCHAR2,
12 p_rowid IN OUT NOCOPY VARCHAR2,
13 p_distribution_id IN NUMBER,
14 p_position_id IN NUMBER,
15 p_data_extract_id IN NUMBER,
16 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
17 p_effective_start_date IN DATE,
18 p_effective_end_date IN DATE,
19 p_chart_of_accounts_id IN NUMBER,
20 p_code_combination_id IN NUMBER,
21 p_distribution_percent IN NUMBER,
22 p_global_default_flag IN VARCHAR2,
23 p_distribution_default_rule_id IN NUMBER,
24 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
25 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
29 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
30 p_mode in varchar2 default 'R'
31 );
32 --
33 --
34 --
35
36 PROCEDURE LOCK_ROW (
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39 p_commit IN VARCHAR2 := fnd_api.g_false,
40 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41 p_return_status OUT NOCOPY VARCHAR2,
42 p_msg_count OUT NOCOPY NUMBER,
43 p_msg_data OUT NOCOPY VARCHAR2,
44 p_row_locked OUT NOCOPY VARCHAR2,
45 p_distribution_id IN NUMBER,
46 p_position_id IN NUMBER,
47 p_data_extract_id IN NUMBER,
48 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
49 p_effective_start_date IN DATE,
50 p_effective_end_date IN DATE,
51 p_chart_of_accounts_id IN NUMBER,
52 p_code_combination_id IN NUMBER,
53 p_distribution_percent IN NUMBER,
54 p_global_default_flag IN VARCHAR2,
55 p_distribution_default_rule_id IN NUMBER,
56 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
57 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
61 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR
62 );
63
64 --
65 --
66 --
67 PROCEDURE UPDATE_ROW (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
70 p_commit IN VARCHAR2 := fnd_api.g_false,
71 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
72 p_return_status OUT NOCOPY VARCHAR2,
73 p_msg_count OUT NOCOPY NUMBER,
74 p_msg_data OUT NOCOPY VARCHAR2,
75 p_distribution_id IN NUMBER,
76 p_code_combination_id IN NUMBER,
77 p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
78 p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
79 p_distribution_percent IN NUMBER,
80 p_global_default_flag IN VARCHAR2,
81 p_distribution_default_rule_id IN NUMBER,
82 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
83 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
87 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
88 p_mode in varchar2 default 'R'
89 );
90 --
91 --
92 --
93 PROCEDURE ADD_ROW (
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
96 p_commit IN VARCHAR2 := fnd_api.g_false,
97 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98 p_return_status OUT NOCOPY VARCHAR2,
99 p_msg_count OUT NOCOPY NUMBER,
100 p_msg_data OUT NOCOPY VARCHAR2,
101 p_rowid IN OUT NOCOPY VARCHAR2,
102 p_distribution_id IN NUMBER,
103 p_position_id IN NUMBER,
104 p_data_extract_id IN NUMBER,
105 p_worksheet_id IN NUMBER,
106 p_effective_start_date IN DATE,
107 p_effective_end_date IN DATE,
108 p_chart_of_accounts_id IN NUMBER,
109 p_code_combination_id IN NUMBER,
110 p_distribution_percent IN NUMBER,
111 p_global_default_flag IN VARCHAR2,
112 p_distribution_default_rule_id IN NUMBER,
113 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
114 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
118 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
119 p_mode in varchar2 default 'R'
120
121 );
122 --
123 --
124 --
125 PROCEDURE DELETE_ROW (
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
128 p_commit IN VARCHAR2 := fnd_api.g_false,
129 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
130 p_return_status OUT NOCOPY VARCHAR2,
131 p_msg_count OUT NOCOPY NUMBER,
132 p_msg_data OUT NOCOPY VARCHAR2,
133 p_distribution_id IN NUMBER
134 );
135 --
136
137 PROCEDURE Delete_Distributions
138 ( p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140 p_commit IN VARCHAR2 := FND_API.G_FALSE,
141 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142 p_return_status OUT NOCOPY VARCHAR2,
143 p_msg_count OUT NOCOPY NUMBER,
144 p_msg_data OUT NOCOPY VARCHAR2,
145 p_data_extract_id IN NUMBER
146 );
147
148 PROCEDURE Delete_Distributions_Position
149 ( p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151 p_commit IN VARCHAR2 := FND_API.G_FALSE,
152 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153 p_return_status OUT NOCOPY VARCHAR2,
154 p_msg_count OUT NOCOPY NUMBER,
155 p_msg_data OUT NOCOPY VARCHAR2,
156 p_position_id IN NUMBER,
157 p_worksheet_id IN NUMBER DEFAULT NULL -- bug 4545909
158 );
159
160 --
161
162 PROCEDURE Modify_Distribution_WS
163 ( p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 p_return_status OUT NOCOPY VARCHAR2,
168 p_msg_count OUT NOCOPY NUMBER,
169 p_msg_data OUT NOCOPY VARCHAR2,
170 p_distribution_id IN OUT NOCOPY NUMBER,
171 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
172 p_position_id IN NUMBER,
173 p_data_extract_id IN NUMBER,
174 p_effective_start_date IN DATE,
175 p_effective_end_date IN DATE,
176 p_modify_flag IN VARCHAR2 := 'N',
177 p_chart_of_accounts_id IN NUMBER,
178 p_code_combination_id IN NUMBER,
179 p_distribution_percent IN NUMBER,
180 p_global_default_flag IN VARCHAR2,
181 p_distribution_default_rule_id IN NUMBER,
182 p_rowid IN OUT NOCOPY VARCHAR2,
183 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
184 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
189 p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
190 p_mode IN VARCHAR2 default 'R',
191 p_ruleset_id IN NUMBER := NULL
192 );
193
194 PROCEDURE Modify_Distribution
195 ( p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197 p_commit IN VARCHAR2 := FND_API.G_FALSE,
198 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199 p_return_status OUT NOCOPY VARCHAR2,
200 p_msg_count OUT NOCOPY NUMBER,
201 p_msg_data OUT NOCOPY VARCHAR2,
202 p_distribution_id IN OUT NOCOPY NUMBER,
203 p_position_id IN NUMBER,
204 p_data_extract_id IN NUMBER,
205 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
206 p_effective_start_date IN DATE,
207 p_effective_end_date IN DATE,
208 p_chart_of_accounts_id IN NUMBER,
209 p_code_combination_id IN NUMBER,
210 p_distribution_percent IN NUMBER,
211 p_global_default_flag IN VARCHAR2,
212 p_distribution_default_rule_id IN NUMBER,
213 p_rowid IN OUT NOCOPY VARCHAR2,
214 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
215 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
219 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
220 p_mode IN VARCHAR2 default 'R'
221 );
222
223 PROCEDURE Modify_Extract_Distribution
224 ( p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226 p_commit IN VARCHAR2 := FND_API.G_FALSE,
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 p_return_status OUT NOCOPY VARCHAR2,
229 p_msg_count OUT NOCOPY NUMBER,
230 p_msg_data OUT NOCOPY VARCHAR2,
231 p_position_id IN NUMBER,
232 p_data_extract_id IN NUMBER,
233 p_chart_of_accounts_id IN NUMBER,
234 p_distribution IN OUT NOCOPY PSB_HR_POPULATE_DATA_PVT.gl_distribution_tbl_type
235 );
236
237
238 /* Bug 1308558 Start */
239 -- This api is used for applying distribution default rules.
240
241 PROCEDURE Apply_Position_Pay_Distr
242 ( p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244 p_commit IN VARCHAR2 := FND_API.G_FALSE,
245 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_distribution_id IN OUT NOCOPY NUMBER,
250 p_position_id IN NUMBER,
251 p_data_extract_id IN NUMBER,
252 p_worksheet_id IN NUMBER,
253 p_effective_start_date IN DATE,
254 p_effective_end_date IN DATE,
255 p_modify_flag IN VARCHAR2,
256 p_chart_of_accounts_id IN NUMBER,
257 p_code_combination_id IN NUMBER,
258 p_distribution_percent IN NUMBER,
259 p_global_default_flag IN VARCHAR2,
260 p_distribution_default_rule_id IN NUMBER,
261 p_rowid IN OUT NOCOPY VARCHAR2,
262 p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
263 p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264 p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265 p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266 p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
267 p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
268 p_mode IN VARCHAR2 := 'R');
269
270 /* Bug 1308558 End */
271
272 --
273 --
274 FUNCTION get_debug RETURN VARCHAR2;
275 --
276 END PSB_POSITION_PAY_DISTR_PVT ;