1 PACKAGE xla_sources_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlaamdss.pkh 120.15 2006/01/09 14:24:17 vkasina ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_sources_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Sources Package |
13 | |
14 | HISTORY |
15 | 01-May-01 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Function |
22 | |
23 | source_in_use |
24 | |
25 | Returns true if the source is being used |
26 | |
27 +======================================================================*/
28 FUNCTION source_in_use
29 (p_event IN VARCHAR2
30 ,p_application_id IN NUMBER
31 ,p_source_code IN VARCHAR2
32 ,p_source_type_code IN VARCHAR2
33 ,p_source_msg OUT NOCOPY VARCHAR2)
34 RETURN BOOLEAN;
35
36 /*======================================================================+
37 | |
38 | Public Function |
39 | |
40 | source_is_locked |
41 | |
42 | Returns true if the source is being used by a locked product rule |
43 | |
44 +======================================================================*/
45 FUNCTION source_is_locked
46 (p_application_id IN NUMBER
47 ,p_source_code IN VARCHAR2
48 ,p_source_type_code IN VARCHAR2)
49 RETURN BOOLEAN;
50
51 /*======================================================================+
52 | |
53 | Public Function |
54 | |
55 | uncompile_prod_rule |
56 | |
57 | Wrapper for uncompile_definitions |
58 | Provided for backward-compatibility, to be obsoleted |
59 | |
60 +======================================================================*/
61 FUNCTION uncompile_prod_rule
62 (p_application_id IN NUMBER
63 ,p_source_code IN VARCHAR2
64 ,p_source_type_code IN VARCHAR2
65 ,p_product_rule_name IN OUT NOCOPY VARCHAR2
66 ,p_product_rule_type IN OUT NOCOPY VARCHAR2)
67 RETURN BOOLEAN;
68
69 /*======================================================================+
70 | |
71 | Public Procedure |
72 | |
73 | uncompile_definitions |
74 | |
75 | Sets status of assigned application accounting definitions and |
76 | journal lines definitions to uncompiled |
77 | |
78 +======================================================================*/
79 FUNCTION uncompile_definitions
80 (p_application_id IN NUMBER
81 ,p_source_code IN VARCHAR2
82 ,p_source_type_code IN VARCHAR2
83 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
84 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
85 ,x_event_class_name IN OUT NOCOPY VARCHAR2
86 ,x_event_type_name IN OUT NOCOPY VARCHAR2
87 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
88 RETURN BOOLEAN;
89
90 /*======================================================================+
91 | |
92 | Public Procedure |
93 | |
94 | delete_derived_source_details |
95 | |
96 | Deletes details of the derived source when derived source is deleted |
97 | |
98 +======================================================================*/
99 PROCEDURE delete_derived_source_details
100 (p_application_id IN NUMBER
101 ,p_source_code IN VARCHAR2
102 ,p_source_type_code IN VARCHAR2);
103
104 /*======================================================================+
105 | |
106 | Public Function |
107 | |
108 | derived_source_is_invalid |
109 | |
110 | Returns true if the derived source has seeded sources not belonging |
111 | to the event class or entity |
112 | |
113 +======================================================================*/
114 FUNCTION derived_source_is_invalid
115 (p_application_id IN NUMBER
116 ,p_derived_source_code IN VARCHAR2
117 ,p_derived_source_type_code IN VARCHAR2
118 ,p_entity_code IN VARCHAR2
119 ,p_event_class_code IN VARCHAR2
120 ,p_level IN VARCHAR2)
121 RETURN VARCHAR2;
122
123 FUNCTION derived_source_is_invalid
124 (p_application_id IN NUMBER
125 ,p_derived_source_code IN VARCHAR2
126 ,p_derived_source_type_code IN VARCHAR2
127 ,p_event_class_code IN VARCHAR2
128 ,p_level IN VARCHAR2)
129 RETURN VARCHAR2;
130
131 /*======================================================================+
132 | |
133 | Public Function |
134 | |
135 | source_in_use_by_tab |
136 | |
137 | Returns true if the source is being used by transaction account type |
138 | |
139 +======================================================================*/
140 FUNCTION source_in_use_by_tab
141 (p_event IN VARCHAR2
142 ,p_application_id IN NUMBER
143 ,p_source_code IN VARCHAR2
144 ,p_source_type_code IN VARCHAR2)
145 RETURN BOOLEAN;
146
147 /*======================================================================+
148 | |
149 | Public Function |
150 | |
151 | source_is_locked_by_tab |
152 | |
153 | Returns true if the source is being used by a locked product rule |
154 | |
155 +======================================================================*/
156 FUNCTION source_is_locked_by_tab
157 (p_application_id IN NUMBER
158 ,p_source_code IN VARCHAR2
159 ,p_source_type_code IN VARCHAR2)
160 RETURN BOOLEAN;
161
162 /*======================================================================+
163 | |
164 | Public Function |
165 | |
166 | uncompile_tran_acct_def |
167 | |
168 | Sets status of the assigned transaction account definition |
169 | to uncompiled |
170 | |
171 +======================================================================*/
172 FUNCTION uncompile_tran_acct_def
173 (p_application_id IN NUMBER
174 ,p_source_code IN VARCHAR2
175 ,p_source_type_code IN VARCHAR2
176 ,p_trx_acct_def IN OUT NOCOPY VARCHAR2
177 ,p_trx_acct_def_type IN OUT NOCOPY VARCHAR2)
178 RETURN BOOLEAN;
179
180 /*======================================================================+
181 | |
182 | Public Function |
183 | |
184 | source_in_use_by_tad |
185 | |
186 | Returns true if the source is being used by a transaction account |
187 | definition |
188 | |
189 +======================================================================*/
190 FUNCTION source_in_use_by_tad
191 (p_application_id IN NUMBER
192 ,p_source_code IN VARCHAR2
193 ,p_source_type_code IN VARCHAR2
194 ,p_account_type_code IN VARCHAR2)
195 RETURN VARCHAR2;
196
197 /*======================================================================+
198 | |
199 | Public Function |
200 | |
201 | get_derived_source_level |
202 | |
203 | Gets the level of derived source if the source belongs to the event |
204 | class |
205 | |
206 +======================================================================*/
207 FUNCTION get_derived_source_level
208 (p_application_id IN NUMBER
209 ,p_derived_source_type_code IN VARCHAR2
210 ,p_derived_source_code IN VARCHAR2
211 ,p_event_class_code IN VARCHAR2)
212 RETURN VARCHAR2;
213
214 END xla_sources_pkg;