1 PACKAGE xla_validations_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacmval.pkh 120.11 2005/07/05 03:32:10 masada ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_validations_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Common Validations Package |
13 | |
14 | HISTORY |
15 | 22-May-02 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Function |
22 | |
23 | object_name_is_valid |
24 | |
25 | Checks whether an object name has valid alphanumeric characters |
26 | |
27 +======================================================================*/
28 FUNCTION object_name_is_valid
29 (p_object_name IN VARCHAR2)
30 RETURN BOOLEAN;
31
32 /*======================================================================+
33 | |
34 | Public Procedure |
35 | |
36 | get_product_rule_info |
37 | |
38 | Get name and owner for the product rule |
39 | |
40 +======================================================================*/
41 PROCEDURE get_product_rule_info
42 (p_application_id IN NUMBER
43 ,p_amb_context_code IN VARCHAR2
44 ,p_product_rule_type_code IN VARCHAR2
45 ,p_product_rule_code IN VARCHAR2
46 ,p_application_name IN OUT NOCOPY VARCHAR2
47 ,p_product_rule_name IN OUT NOCOPY VARCHAR2
48 ,p_product_rule_type IN OUT NOCOPY VARCHAR2);
49
50 /*======================================================================+
51 | |
52 | Public Procedure |
53 | |
54 | get_description_info |
55 | |
56 | Get name and owner for the description rule |
57 | |
58 +======================================================================*/
59 PROCEDURE get_description_info
60 (p_application_id IN NUMBER
61 ,p_amb_context_code IN VARCHAR2
62 ,p_description_type_code IN VARCHAR2
63 ,p_description_code IN VARCHAR2
64 ,p_application_name IN OUT NOCOPY VARCHAR2
65 ,p_description_name IN OUT NOCOPY VARCHAR2
66 ,p_description_type IN OUT NOCOPY VARCHAR2);
67
68 /*======================================================================+
69 | |
70 | Public Procedure |
71 | |
72 | get_segment_rule_info |
73 | |
74 | Get name and owner for the segment rule |
75 | |
76 +======================================================================*/
77 PROCEDURE get_segment_rule_info
78 (p_application_id IN NUMBER
79 ,p_amb_context_code IN VARCHAR2
80 ,p_segment_rule_type_code IN VARCHAR2
81 ,p_segment_rule_code IN VARCHAR2
82 ,p_application_name IN OUT NOCOPY VARCHAR2
83 ,p_segment_rule_name IN OUT NOCOPY VARCHAR2
84 ,p_segment_rule_type IN OUT NOCOPY VARCHAR2);
85
86
87 /*======================================================================+
88 | |
89 | Public Procedure |
90 | |
91 | get_line_type_info |
92 | |
93 | Get name and owner for the line type |
94 | |
95 +======================================================================*/
96 PROCEDURE get_line_type_info
97 (p_application_id IN NUMBER
98 ,p_amb_context_code IN VARCHAR2
99 ,p_entity_code IN VARCHAR2
100 ,p_event_class_code IN VARCHAR2
101 ,p_accounting_line_type_code IN VARCHAR2
102 ,p_accounting_line_code IN VARCHAR2
103 ,p_application_name IN OUT NOCOPY VARCHAR2
104 ,p_accounting_line_type_name IN OUT NOCOPY VARCHAR2
105 ,p_accounting_line_type IN OUT NOCOPY VARCHAR2);
106
107 /*======================================================================+
108 | |
109 | Public Procedure |
110 | |
111 | get_event_class_info |
112 | |
113 | Get name for the event class |
114 | |
115 +======================================================================*/
116 PROCEDURE get_event_class_info
117 (p_application_id IN NUMBER
118 ,p_entity_code IN VARCHAR2
119 ,p_event_class_code IN VARCHAR2
120 ,p_event_class_name IN OUT NOCOPY VARCHAR2);
121
122 /*======================================================================+
123 | |
124 | Public Procedure |
125 | |
126 | get_event_type_info |
127 | |
128 | Get name for the event type |
129 | |
130 +======================================================================*/
131 PROCEDURE get_event_type_info
132 (p_application_id IN NUMBER
133 ,p_entity_code IN VARCHAR2
134 ,p_event_class_code IN VARCHAR2
135 ,p_event_type_code IN VARCHAR2
136 ,p_event_type_name IN OUT NOCOPY VARCHAR2);
137
138 /*======================================================================+
139 | |
140 | Public Procedure |
141 | |
142 | get_source_info |
143 | |
144 | Get name for the source |
145 | |
146 +======================================================================*/
147 PROCEDURE get_source_info
148 (p_application_id IN NUMBER
149 ,p_source_type_code IN VARCHAR2
150 ,p_source_code IN VARCHAR2
151 ,p_source_name IN OUT NOCOPY VARCHAR2
152 ,p_source_type IN OUT NOCOPY VARCHAR2);
153
154 /*======================================================================+
155 | |
156 | Public Procedure |
157 | |
158 | get_analytical_criteria_info |
159 | |
160 | Get name for the analytical criteria |
161 | |
162 +======================================================================*/
163 PROCEDURE get_analytical_criteria_info
164 (p_amb_context_code IN VARCHAR2
165 ,p_anal_criterion_type_code IN VARCHAR2
166 ,p_analytical_criterion_code IN VARCHAR2
167 ,p_analytical_criteria_name IN OUT NOCOPY VARCHAR2
168 ,p_analytical_criteria_type IN OUT NOCOPY VARCHAR2);
169
170 /*======================================================================+
171 | |
172 | Public Procedure |
173 | |
174 | get_accounting_method_info |
175 | |
176 | Get name and owner for the accounting method |
177 | |
178 +======================================================================*/
179 PROCEDURE get_accounting_method_info
180 (p_accounting_method_type_code IN VARCHAR2
181 ,p_accounting_method_code IN VARCHAR2
182 ,p_accounting_method_name IN OUT NOCOPY VARCHAR2
183 ,p_accounting_method_type IN OUT NOCOPY VARCHAR2);
184
185 /*======================================================================+
186 | |
187 | Public Procedure |
188 | |
189 | get_application_name |
190 | |
191 | Get name of the application |
192 | |
193 +======================================================================*/
194 PROCEDURE get_application_name
195 (p_application_id IN NUMBER
196 ,p_application_name IN OUT NOCOPY VARCHAR2);
197
198 /*======================================================================+
199 | |
200 | Public Procedure |
201 | |
202 | get_ledger_name |
203 | |
204 | Get name of the ledger |
205 | |
206 +======================================================================*/
207 PROCEDURE get_ledger_name
208 (p_ledger_id IN NUMBER
209 ,p_ledger_name IN OUT NOCOPY VARCHAR2);
210
211 /*======================================================================+
212 | |
213 | Public Procedure |
214 | |
215 | get_trx_acct_def_info |
216 | |
217 | Get name and owner for the transaction account definition |
218 | |
219 +======================================================================*/
220 PROCEDURE get_trx_acct_def_info
221 (p_application_id IN NUMBER
222 ,p_amb_context_code IN VARCHAR2
223 ,p_account_definition_type_code IN VARCHAR2
224 ,p_account_definition_code IN VARCHAR2
225 ,p_application_name IN OUT NOCOPY VARCHAR2
226 ,p_trx_acct_def IN OUT NOCOPY VARCHAR2
227 ,p_trx_acct_def_type IN OUT NOCOPY VARCHAR2);
228
229 /*======================================================================+
230 | |
231 | Public Procedure |
232 | |
233 | get_trx_acct_type_info |
234 | |
235 | Get name for the transaction account type |
236 | |
237 +======================================================================*/
238 PROCEDURE get_trx_acct_type_info
239 (p_application_id IN NUMBER
240 ,p_account_type_code IN VARCHAR2
241 ,p_trx_acct_type IN OUT NOCOPY VARCHAR2);
242
243 /*======================================================================+
244 | |
245 | Public Function |
246 | |
247 | table_name_is_valid |
248 | |
249 | Checks whether an object exists in the database |
250 | |
251 +======================================================================*/
252 FUNCTION table_name_is_valid
253 (p_table_name IN VARCHAR2)
254 RETURN BOOLEAN;
255
256 /*======================================================================+
257 | |
258 | Public Procedure |
259 | |
260 | reference_is_valid |
261 | |
262 | Check if reference object is not used by other transaction |
263 | objects within the same event class. |
264 +======================================================================*/
265 FUNCTION reference_is_valid
266 (p_table_name IN VARCHAR2
267 ,p_event_class_code IN VARCHAR2)
268 RETURN BOOLEAN;
269
270 /*======================================================================+
271 | |
272 | Public Procedure |
273 | |
274 | join_condition_is_valid |
276 | Check if join condition is valid |
277 | |
278 +======================================================================*/
279 FUNCTION join_condition_is_valid
280 (p_trx_object_name IN VARCHAR2
281 ,p_ref_object_name IN VARCHAR2
282 ,p_join_condition IN VARCHAR2
283 ,p_error_message OUT NOCOPY VARCHAR2)
284 RETURN BOOLEAN;
285
286 END xla_validations_pkg;275 | |