1 PACKAGE xla_seg_rules_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlaamadr.pkh 120.14 2006/01/19 21:09:58 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_seg_rules_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Segment Rules package |
13 | |
14 | HISTORY |
15 | 01-May-01 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Procedure |
22 | |
23 | delete_seg_rule_details |
24 | |
25 | Deletes all details of the segment rule |
26 | |
27 +======================================================================*/
28
29 PROCEDURE delete_seg_rule_details
30 (p_application_id IN NUMBER
31 ,p_amb_context_code IN VARCHAR2
32 ,p_segment_rule_type_code IN VARCHAR2
33 ,p_segment_rule_code IN VARCHAR2);
34
35 /*======================================================================+
36 | |
37 | Public Procedure |
38 | |
39 | copy_seg_rule_details |
40 | |
41 | Copies the details of the old segment rule into the new segment rule |
42 | |
43 +======================================================================*/
44
45 PROCEDURE copy_seg_rule_details
46 (p_application_id IN NUMBER
47 ,p_amb_context_code IN VARCHAR2
48 ,p_old_segment_rule_type_code IN VARCHAR2
49 ,p_old_segment_rule_code IN VARCHAR2
50 ,p_new_segment_rule_type_code IN VARCHAR2
51 ,p_new_segment_rule_code IN VARCHAR2
52 ,p_old_transaction_coa_id IN NUMBER
53 ,p_new_transaction_coa_id IN NUMBER);
54
55 /*======================================================================+
56 | |
57 | Public Function |
58 | |
59 | rule_in_use |
60 | |
61 | Returns true if the rule is in use by an accounting line type |
62 | |
63 +======================================================================*/
64
65 FUNCTION rule_in_use
66 (p_event IN VARCHAR2
67 ,p_application_id IN NUMBER
68 ,p_amb_context_code IN VARCHAR2
69 ,p_segment_rule_type_code IN VARCHAR2
70 ,p_segment_rule_code IN VARCHAR2
71 ,x_line_definition_name IN OUT NOCOPY VARCHAR2
72 ,x_line_definition_owner IN OUT NOCOPY VARCHAR2)
73 RETURN BOOLEAN;
74
75 /*======================================================================+
76 | |
77 | Public Function |
78 | |
79 | rule_is_invalid |
80 | |
81 | Returns true if the rule is invalid |
82 | |
83 +======================================================================*/
84
85 FUNCTION rule_is_invalid
86 (p_application_id IN NUMBER
87 ,p_amb_context_code IN VARCHAR2
88 ,p_segment_rule_type_code IN VARCHAR2
89 ,p_segment_rule_code IN VARCHAR2
90 ,p_message_name OUT NOCOPY VARCHAR2)
91 RETURN BOOLEAN;
92
93 /*======================================================================+
94 | |
95 | Public Function |
96 | |
97 | seg_rule_is_locked |
98 | |
99 | Returns true if the seg rule is being used by a locked journal line |
100 | definitions |
101 | |
102 +======================================================================*/
103
104 FUNCTION seg_rule_is_locked
105 (p_application_id IN NUMBER
106 ,p_amb_context_code IN VARCHAR2
107 ,p_segment_rule_type_code IN VARCHAR2
108 ,p_segment_rule_code IN VARCHAR2)
109 RETURN BOOLEAN;
110
111 /*======================================================================+
112 | |
113 | Public Function |
114 | |
115 | uncompile_definitions |
116 | |
117 | Returns true if all the application accounting definitions and |
118 | journal line definitions using this segment rule are uncompiled |
119 | |
120 +======================================================================*/
121
122 FUNCTION uncompile_definitions
123 (p_application_id IN NUMBER
124 ,p_amb_context_code IN VARCHAR2
125 ,p_segment_rule_type_code IN VARCHAR2
126 ,p_segment_rule_code IN VARCHAR2
127 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
128 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
129 ,x_event_class_name IN OUT NOCOPY VARCHAR2
130 ,x_event_type_name IN OUT NOCOPY VARCHAR2
131 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
132 RETURN BOOLEAN;
133
134 /*======================================================================+
135 | |
136 | Public Function |
137 | |
138 | rule_in_use_by_tab |
139 | |
140 | Returns true if the rule is in use by a transaction account definition|
141 | |
142 +======================================================================*/
143
144 FUNCTION rule_in_use_by_tab
145 (p_event IN VARCHAR2
146 ,p_application_id IN NUMBER
147 ,p_amb_context_code IN VARCHAR2
148 ,p_segment_rule_type_code IN VARCHAR2
149 ,p_segment_rule_code IN VARCHAR2
150 ,p_trx_acct_def IN OUT NOCOPY VARCHAR2
151 ,p_trx_acct_def_type IN OUT NOCOPY VARCHAR2
152 ,p_trx_acct_type IN OUT NOCOPY VARCHAR2)
153 RETURN BOOLEAN;
154
155 /*======================================================================+
156 | |
157 | Public Function |
158 | |
159 | uncompile_tran_acct_def |
160 | |
161 | Returns true if all the transaction account definitions using |
162 | the segment rule are uncompiled |
163 | |
164 +======================================================================*/
165
166 FUNCTION uncompile_tran_acct_def
167 (p_application_id IN NUMBER
168 ,p_amb_context_code IN VARCHAR2
169 ,p_segment_rule_type_code IN VARCHAR2
170 ,p_segment_rule_code IN VARCHAR2
171 ,p_application_name IN OUT NOCOPY VARCHAR2
172 ,p_trx_acct_def IN OUT NOCOPY VARCHAR2
173 ,p_trx_acct_def_type IN OUT NOCOPY VARCHAR2)
174 RETURN BOOLEAN;
175
176 /*======================================================================+
177 | |
178 | Public Function |
179 | |
180 | check_copy_seg_rule_details |
181 | |
182 | Checks if the segment rule details can be copied into the new one |
183 | |
184 +======================================================================*/
185
186 FUNCTION check_copy_seg_rule_details
187 (p_application_id IN NUMBER
188 ,p_amb_context_code IN VARCHAR2
189 ,p_old_segment_rule_type_code IN VARCHAR2
190 ,p_old_segment_rule_code IN VARCHAR2
191 ,p_old_transaction_coa_id IN NUMBER
192 ,p_new_transaction_coa_id IN NUMBER
193 ,p_old_flex_value_set_id IN NUMBER
194 ,p_new_flex_value_set_id IN NUMBER
195 ,p_message IN OUT NOCOPY VARCHAR2
196 ,p_token_1 IN OUT NOCOPY VARCHAR2
197 ,p_value_1 IN OUT NOCOPY VARCHAR2)
198 RETURN BOOLEAN;
199
200 /*======================================================================+
201 | |
202 | Public Function |
203 | |
204 | rule_in_use_by_adr |
208 +======================================================================*/
205 | |
206 | Checks if the segment rule is used by another ADR |
207 | |
209 FUNCTION rule_in_use_by_adr
210 (p_event IN VARCHAR2
211 ,p_application_id IN NUMBER
212 ,p_amb_context_code IN VARCHAR2
213 ,p_segment_rule_type_code IN VARCHAR2
214 ,p_segment_rule_code IN VARCHAR2
215 ,p_parent_seg_rule_appl_name IN OUT NOCOPY VARCHAR2
216 ,p_parent_segment_rule_type IN OUT NOCOPY VARCHAR2
217 ,p_parent_segment_rule_name IN OUT NOCOPY VARCHAR2)
218 RETURN BOOLEAN;
219
220 /*======================================================================+
221 | |
222 | Public Function |
223 | |
224 | parent_seg_rule_is_locked |
225 | |
226 | Checks if the segment rule is used by a locked ADR |
227 | |
228 +======================================================================*/
229 FUNCTION parent_seg_rule_is_locked
230 (p_application_id IN NUMBER
231 ,p_amb_context_code IN VARCHAR2
232 ,p_segment_rule_type_code IN VARCHAR2
233 ,p_segment_rule_code IN VARCHAR2)
234 RETURN BOOLEAN;
235
236 END xla_seg_rules_pkg;
[Home] [Help]