1 PACKAGE xla_line_types_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlaamdlt.pkh 120.16 2006/02/15 19:51:32 dcshah 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_types_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Line Types package |
13 | |
14 | HISTORY |
15 | 01-May-01 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Procedure |
22 | |
23 | delete_line_type_details |
24 | |
25 | Deletes all details of the line type |
26 | |
27 +======================================================================*/
28
29 PROCEDURE delete_line_type_details
30 (p_application_id IN NUMBER
31 ,p_amb_context_code IN VARCHAR2
32 ,p_entity_code IN VARCHAR2
33 ,p_event_class_code IN VARCHAR2
34 ,p_accounting_line_type_code IN VARCHAR2
35 ,p_accounting_line_code IN VARCHAR2);
36
37 /*======================================================================+
38 | |
39 | Public Procedure |
40 | |
41 | copy_line_type_details |
42 | |
43 | Copies the details of the old line type into the new line type |
44 | |
45 +======================================================================*/
46
47 PROCEDURE copy_line_type_details
48 (p_application_id IN NUMBER
49 ,p_amb_context_code IN VARCHAR2
50 ,p_entity_code IN VARCHAR2
51 ,p_event_class_code IN VARCHAR2
52 ,p_old_accting_line_type_code IN VARCHAR2
53 ,p_old_accounting_line_code IN VARCHAR2
54 ,p_new_accting_line_type_code IN VARCHAR2
55 ,p_new_accounting_line_code IN VARCHAR2
56 ,p_old_transaction_coa_id IN NUMBER
57 ,p_new_transaction_coa_id IN NUMBER);
58
59 /*======================================================================+
60 | |
61 | Public Function |
62 | |
63 | line_type_in_use |
64 | |
65 | Returns true if the rule is in use by an accounting line type |
66 | |
67 +======================================================================*/
68
69 FUNCTION line_type_in_use
70 (p_event IN VARCHAR2
71 ,p_application_id IN NUMBER
72 ,p_amb_context_code IN VARCHAR2
73 ,p_event_class_code IN VARCHAR2
74 ,p_accounting_line_type_code IN VARCHAR2
75 ,p_accounting_line_code IN VARCHAR2
76 ,x_line_definition_name IN OUT NOCOPY VARCHAR2
77 ,x_line_definition_owner IN OUT NOCOPY VARCHAR2)
78 RETURN BOOLEAN;
79
80 /*======================================================================+
81 | |
82 | Public Function |
83 | |
84 | line_type_is_invalid |
85 | |
86 | Returns true if the line type is invalid |
87 | |
88 +======================================================================*/
89
90 FUNCTION line_type_is_invalid
91 (p_application_id IN NUMBER
92 ,p_amb_context_code IN VARCHAR2
93 ,p_entity_code IN VARCHAR2
94 ,p_event_class_code IN VARCHAR2
95 ,p_accounting_line_type_code IN VARCHAR2
96 ,p_accounting_line_code IN VARCHAR2
97 ,p_message_name IN OUT NOCOPY VARCHAR2
98 ,p_accounting_attribute_name IN OUT NOCOPY VARCHAR2)
99 RETURN BOOLEAN;
100
101 /*======================================================================+
102 | |
103 | Public Function |
104 | |
105 | line_type_is_locked |
106 | |
107 | Returns true if the line type is used by a locked product rule |
108 | |
109 +======================================================================*/
110
111 FUNCTION line_type_is_locked
112 (p_application_id IN NUMBER
113 ,p_amb_context_code IN VARCHAR2
114 ,p_entity_code IN VARCHAR2
115 ,p_event_class_code IN VARCHAR2
116 ,p_accounting_line_type_code IN VARCHAR2
117 ,p_accounting_line_code IN VARCHAR2)
118 RETURN BOOLEAN;
119
120 /*======================================================================+
121 | |
122 | Public Procedure |
123 | |
124 | create_accounting_attributes |
125 | |
126 | Returns true if accounting sources get created |
127 | |
128 +======================================================================*/
129
130 PROCEDURE create_accounting_attributes
131 (p_application_id IN NUMBER
132 ,p_amb_context_code IN VARCHAR2
133 ,p_event_class_code IN VARCHAR2
134 ,p_accounting_line_type_code IN VARCHAR2
135 ,p_accounting_line_code IN VARCHAR2
136 ,p_side_code IN VARCHAR2
137 ,p_business_method_code IN VARCHAR2
138 );
139
140 /*======================================================================+
141 | |
142 | Public Function |
143 | |
144 | uncompile_definitions |
145 | |
146 | Returns true if all the application accounting definitions and |
147 | journal line definitions using this journal line type are uncompiled |
148 | |
149 +======================================================================*/
150 FUNCTION uncompile_definitions
151 (p_application_id IN NUMBER
152 ,p_amb_context_code IN VARCHAR2
153 ,p_event_class_code IN VARCHAR2
154 ,p_accounting_line_type_code IN VARCHAR2
155 ,p_accounting_line_code IN VARCHAR2
156 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
157 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
158 ,x_event_class_name IN OUT NOCOPY VARCHAR2
159 ,x_event_type_name IN OUT NOCOPY VARCHAR2
160 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
161 RETURN BOOLEAN;
162
163 /*======================================================================+
164 | |
165 | Public Procedure |
166 | |
167 | get_default_attr_assignment |
168 | |
169 | Gets the default source assignments for the accounting attribute |
170 | |
171 +======================================================================*/
172
173 PROCEDURE get_default_attr_assignment
174 (p_application_id IN NUMBER
175 ,p_event_class_code IN VARCHAR2
176 ,p_accounting_attribute_code IN VARCHAR2
177 ,p_source_application_id IN OUT NOCOPY NUMBER
178 ,p_source_type_code IN OUT NOCOPY VARCHAR2
179 ,p_source_code IN OUT NOCOPY VARCHAR2
180 ,p_source_name IN OUT NOCOPY VARCHAR2
181 ,p_source_type_dsp IN OUT NOCOPY VARCHAR2);
182
183 /*======================================================================+
184 | |
185 | Public Function |
186 | |
187 | check_copy_line_type_details |
188 | |
189 | Checks if the line type can be copied |
190 | |
191 +======================================================================*/
192
193 FUNCTION check_copy_line_type_details
194 (p_application_id IN NUMBER
195 ,p_amb_context_code IN VARCHAR2
196 ,p_entity_code IN VARCHAR2
197 ,p_event_class_code IN VARCHAR2
198 ,p_old_accting_line_type_code IN VARCHAR2
199 ,p_old_accounting_line_code IN VARCHAR2
200 ,p_old_transaction_coa_id IN NUMBER
201 ,p_new_transaction_coa_id IN NUMBER
202 ,p_message IN OUT NOCOPY VARCHAR2
203 ,p_token_1 IN OUT NOCOPY VARCHAR2
204 ,p_value_1 IN OUT NOCOPY VARCHAR2)
205 RETURN BOOLEAN;
206
207
208 FUNCTION non_gain_acct_attrs_exists
209 (p_application_id IN NUMBER
210 ,p_amb_context_code IN VARCHAR2
211 ,p_event_class_code IN VARCHAR2
212 ,p_accounting_line_type_code IN VARCHAR2
213 ,p_accounting_line_code IN VARCHAR2)
214 return boolean;
215
216 PROCEDURE insert_non_gain_acct_attrs(
217 p_application_id IN NUMBER
218 ,p_amb_context_code IN VARCHAR2
219 ,p_event_class_code IN VARCHAR2
220 ,p_accounting_line_type_code IN VARCHAR2
221 ,p_accounting_line_code IN VARCHAR2);
222
223
224 PROCEDURE delete_non_gain_acct_attrs(
225 p_application_id IN NUMBER
226 ,p_amb_context_code IN VARCHAR2
227 ,p_event_class_code IN VARCHAR2
228 ,p_accounting_line_type_code IN VARCHAR2
229 ,p_accounting_line_code IN VARCHAR2);
230
231 PROCEDURE update_acct_attrs(
232 p_application_id IN NUMBER
233 ,p_amb_context_code IN VARCHAR2
234 ,p_event_class_code IN VARCHAR2
235 ,p_accounting_line_type_code IN VARCHAR2
236 ,p_accounting_line_code IN VARCHAR2
237 ,p_business_method_code IN VARCHAR2);
238
239 /*======================================================================+
240 | |
241 | Public Function |
242 | |
243 | mpa_line_type_in_use |
244 | |
245 | Returns true if the line is in used by a JLD |
246 | |
247 +======================================================================*/
248
249 FUNCTION mpa_line_type_in_use
250 (p_application_id IN NUMBER
251 ,p_amb_context_code IN VARCHAR2
252 ,p_event_class_code IN VARCHAR2
253 ,p_accounting_line_type_code IN VARCHAR2
254 ,p_accounting_line_code IN VARCHAR2
255 ,x_mpa_option_code IN OUT NOCOPY VARCHAR2
256 ,x_line_definition_name IN OUT NOCOPY VARCHAR2
257 ,x_line_definition_owner IN OUT NOCOPY VARCHAR2)
258 RETURN BOOLEAN;
259
260 END xla_line_types_pkg;