1 PACKAGE xla_line_definitions_pvt AS
2 /* $Header: xlaamjld.pkh 120.7 2005/07/06 20:55:33 eklau ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_line_definitions_pvt |
10 | |
11 | DESCRIPTION |
12 | XLA Product Rules package |
13 | |
14 | HISTORY |
15 | 10-05-2004 W Chan Created |
16 | |
17 +======================================================================*/
18
19 --======================================================================
20 --
21 -- Name: copy_line_definition_details
22 -- Description: Copies the details of an existing line definition into the
23 -- new one
24 --
25 --======================================================================
26 PROCEDURE copy_line_definition_details
27 (p_application_id IN NUMBER
28 ,p_amb_context_code IN VARCHAR2
29 ,p_event_class_code IN VARCHAR2
30 ,p_event_type_code IN VARCHAR2
31 ,p_old_line_defn_owner_code IN VARCHAR2
32 ,p_old_line_defn_code IN VARCHAR2
33 ,p_new_line_defn_owner_code IN VARCHAR2
34 ,p_new_line_defn_code IN VARCHAR2
35 ,p_old_accounting_coa_id IN NUMBER
36 ,p_new_accounting_coa_id IN NUMBER);
37
38
39 --======================================================================
40 --
41 -- Name: line_definition_in_use
42 -- Description: Returns true if the line definition is in use by AAD
43 --
44 --======================================================================
45 FUNCTION line_definition_in_use
46 (p_application_id IN NUMBER
47 ,p_amb_context_code IN VARCHAR2
48 ,p_event_class_code IN VARCHAR2
49 ,p_event_type_code IN VARCHAR2
50 ,p_line_definition_owner_code IN VARCHAR2
51 ,p_line_definition_code IN VARCHAR2
52 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
53 ,x_product_rule_owner IN OUT NOCOPY VARCHAR2)
54 RETURN BOOLEAN;
55
56
57 --======================================================================
58 --
59 -- Name: line_definition_is_locked
60 -- Description: Returns true if the line definition is not used by any
61 -- AAD that is locked
62 --
63 --======================================================================
64 FUNCTION line_definition_is_locked
65 (p_application_id IN NUMBER
66 ,p_amb_context_code IN VARCHAR2
67 ,p_event_class_code IN VARCHAR2
68 ,p_event_type_code IN VARCHAR2
69 ,p_line_definition_owner_code IN VARCHAR2
70 ,p_line_definition_code IN VARCHAR2)
71 RETURN BOOLEAN;
72
73
74 FUNCTION line_definition_is_locked
75 (p_application_id IN NUMBER
76 ,p_amb_context_code IN VARCHAR2
77 ,p_event_class_code IN VARCHAR2
78 ,p_event_type_code IN VARCHAR2
79 ,p_line_definition_owner_code IN VARCHAR2
80 ,p_line_definition_code IN VARCHAR2
81 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
82 ,x_product_rule_owner IN OUT NOCOPY VARCHAR2
83 ,x_event_class_name IN OUT NOCOPY VARCHAR2
84 ,x_event_type_name IN OUT NOCOPY VARCHAR2
85 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
86 RETURN BOOLEAN;
87
88
89 --======================================================================
90 --
91 -- Name: delete_line_defn_details
92 -- Description: Deletes all details of the line definition
93 --
94 --======================================================================
95 PROCEDURE delete_line_defn_details
96 (p_application_id IN NUMBER
97 ,p_amb_context_code IN VARCHAR2
98 ,p_event_class_code IN VARCHAR2
99 ,p_event_type_code IN VARCHAR2
100 ,p_line_definition_owner_code IN VARCHAR2
101 ,p_line_definition_code IN VARCHAR2);
102
103
104 --======================================================================
105 --
106 -- Name: delete_line_defn_jlt_details
107 -- Description: Deletes all details of the line assignment
108 --
109 --======================================================================
110 PROCEDURE delete_line_defn_jlt_details
111 (p_application_id IN NUMBER
112 ,p_amb_context_code IN VARCHAR2
113 ,p_event_class_code IN VARCHAR2
114 ,p_event_type_code IN VARCHAR2
115 ,p_line_definition_owner_code IN VARCHAR2
116 ,p_line_definition_code IN VARCHAR2
117 ,p_accounting_line_type_code IN VARCHAR2
118 ,p_accounting_line_code IN VARCHAR2);
119
120
121 --======================================================================
122 --
123 -- Name: invalid_line_description
124 -- Description: Returns true if sources used in the description are invalid
125 -- Used in the lov for descriptions
126 --
127 --======================================================================
128 FUNCTION invalid_line_description
129 (p_application_id IN NUMBER
130 ,p_amb_context_code IN VARCHAR2
131 ,p_entity_code IN VARCHAR2
132 ,p_event_class_code IN VARCHAR2
133 ,p_description_type_code IN VARCHAR2
134 ,p_description_code IN VARCHAR2)
135 RETURN VARCHAR2;
136
137
138 --======================================================================
139 --
140 -- Name: invalid_seg_rule
141 -- Description: Returns true if sources used in the ADR are invalid
142 -- Used in the lov for descriptions
143 --
144 --======================================================================
145 FUNCTION invalid_segment_rule
146 (p_application_id IN NUMBER
147 ,p_amb_context_code IN VARCHAR2
148 ,p_entity_code IN VARCHAR2
149 ,p_event_class_code IN VARCHAR2
150 ,p_segment_rule_appl_id IN NUMBER DEFAULT NULL
151 ,p_segment_rule_type_code IN VARCHAR2
152 ,p_segment_rule_code IN VARCHAR2)
153 RETURN VARCHAR2;
154
155
156 --======================================================================
157 --
158 -- Name: uncompile_aads
159 -- Description: Returns true if all product rules that as referenced the
160 -- line definition gets uncompiled
161 --
162 --======================================================================
163 FUNCTION uncompile_aads
164 (p_amb_context_code IN VARCHAR2
165 ,p_application_id IN NUMBER
166 ,p_event_class_code IN VARCHAR2
167 ,p_event_type_code IN VARCHAR2
168 ,p_line_definition_owner_code IN VARCHAR2
169 ,p_line_definition_code IN VARCHAR2
170 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
171 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
172 ,x_event_class_name IN OUT NOCOPY VARCHAR2
173 ,x_event_type_name IN OUT NOCOPY VARCHAR2
174 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
175 RETURN BOOLEAN;
176
177
178 --======================================================================
179 --
180 -- Name: invalid_line_analytical
181 -- Description: Returns true if sources used in the AC are invalid
182 -- Used in the lov for analytical criteria
183 --
184 --======================================================================
185 FUNCTION invalid_line_analytical
186 (p_application_id IN NUMBER
187 ,p_amb_context_code IN VARCHAR2
188 ,p_entity_code IN VARCHAR2
189 ,p_event_class_code IN VARCHAR2
190 ,p_ac_type_code IN VARCHAR2
191 ,p_ac_code IN VARCHAR2)
192 RETURN VARCHAR2;
193
194
195 --======================================================================
196 --
197 -- Name: copy_line_assignment_details
198 -- Description: Copies the details of an existing line assignment into
199 -- a new one
200 --
201 --======================================================================
202 PROCEDURE copy_line_assignment_details
203 (p_application_id IN NUMBER
204 ,p_amb_context_code IN VARCHAR2
205 ,p_event_class_code IN VARCHAR2
206 ,p_event_type_code IN VARCHAR2
207 ,p_line_definition_owner_code IN VARCHAR2
208 ,p_line_definition_code IN VARCHAR2
209 ,p_old_accting_line_type_code IN VARCHAR2
210 ,p_old_accounting_line_code IN VARCHAR2
211 ,p_new_accting_line_type_code IN VARCHAR2
212 ,p_new_accounting_line_code IN VARCHAR2
213 ,p_include_ac_assignments IN VARCHAR2
214 ,p_include_adr_assignments IN VARCHAR2
215 ,p_mpa_option_code IN VARCHAR2);
216
217
218 --=============================================================================
219 --
220 -- Name: get_line_definition_info
221 -- Description: Validate the line definition
222 --
223 --=============================================================================
224 PROCEDURE get_line_definition_info
225 (p_application_id IN NUMBER
226 ,p_amb_context_code IN VARCHAR2
227 ,p_event_class_code IN VARCHAR2
228 ,p_event_type_code IN VARCHAR2
229 ,p_line_definition_owner_code IN VARCHAR2
230 ,p_line_definition_code IN VARCHAR2
231 ,x_line_definition_owner IN OUT NOCOPY VARCHAR2
232 ,x_line_definition_name IN OUT NOCOPY VARCHAR2);
233
234
235 --======================================================================
236 --
237 -- Name: validate_line_definition
238 -- Description: Validate the line definition. This API DOES NOT clear
239 -- the error stack and DOES NOT insert the error to the
240 -- error table
241 -- This API is used if multiple journal line definition is
242 -- validated
243 --
244 --======================================================================
245 FUNCTION validate_line_definition
246 (p_application_id IN NUMBER
247 ,p_amb_context_code IN VARCHAR2
248 ,p_event_class_code IN VARCHAR2
249 ,p_event_type_code IN VARCHAR2
250 ,p_line_definition_owner_code IN VARCHAR2
251 ,p_line_definition_code IN VARCHAR2)
252 RETURN BOOLEAN;
253
254 --=============================================================================
255 --
256 -- Name: validate_jld
257 -- Description: Validate the joural lines definition. This API reset the error
258 -- stack and insert the errors to the error table.
259 -- This API is used if only one journal line definition is
260 -- validated
261 --
262 --=============================================================================
263 FUNCTION validate_jld
264 (p_application_id IN NUMBER
265 ,p_amb_context_code IN VARCHAR2
266 ,p_event_class_code IN VARCHAR2
267 ,p_event_type_code IN VARCHAR2
268 ,p_line_definition_owner_code IN VARCHAR2
272 --======================================================================
269 ,p_line_definition_code IN VARCHAR2)
270 RETURN BOOLEAN;
271
273 --
274 -- Name: check_copy_line_definition
275 -- Description: Checks if the line definition can be copied into a new one
276 --
277 --======================================================================
278 FUNCTION check_copy_line_definition
279 (p_application_id IN NUMBER
280 ,p_amb_context_code IN VARCHAR2
281 ,p_event_class_code IN VARCHAR2
282 ,p_event_type_code IN VARCHAR2
283 ,p_old_line_defn_owner_code IN VARCHAR2
284 ,p_old_line_defn_code IN VARCHAR2
285 ,p_old_accounting_coa_id IN NUMBER
286 ,p_new_accounting_coa_id IN NUMBER
287 ,p_message IN OUT NOCOPY VARCHAR2
288 ,p_token_1 IN OUT NOCOPY VARCHAR2
289 ,p_value_1 IN OUT NOCOPY VARCHAR2)
290 RETURN BOOLEAN;
291
292 --======================================================================
293 --
294 -- Name: check_adr_has_loop
295 -- Description: Returns true if the ADR has an attached ADR which in
296 -- turn has another ADR attached
297 --
298 --======================================================================
299 FUNCTION check_adr_has_loop
300 (p_application_id IN NUMBER
301 ,p_amb_context_code IN VARCHAR2
302 ,p_event_class_code IN VARCHAR2
303 ,p_event_type_code IN VARCHAR2
304 ,p_line_definition_owner_code IN VARCHAR2
305 ,p_line_definition_code IN VARCHAR2)
306 RETURN BOOLEAN;
307
308 --======================================================================
309 --
310 -- Name: delete_mpa_jlt_details
311 -- Description: Deletes all details of the mpa line assignment.
312 --
313 -- Add for MPA project - 4262811
314 --
315 --======================================================================
316 PROCEDURE delete_mpa_jlt_details
317 (p_application_id IN NUMBER
318 ,p_amb_context_code IN VARCHAR2
319 ,p_event_class_code IN VARCHAR2
320 ,p_event_type_code IN VARCHAR2
321 ,p_line_definition_owner_code IN VARCHAR2
322 ,p_line_definition_code IN VARCHAR2
323 ,p_accounting_line_type_code IN VARCHAR2
324 ,p_accounting_line_code IN VARCHAR2
325 ,p_mpa_accounting_line_type_co IN VARCHAR2
326 ,p_mpa_accounting_line_code IN VARCHAR2);
327
328 END xla_line_definitions_pvt;