1 PACKAGE xla_product_rules_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlaampad.pkh 120.19 2006/02/22 22:35:17 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_product_rules_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Product Rules package |
13 | |
14 | HISTORY |
15 | 01-Sep-01 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Procedure |
22 | |
23 | delete_product_rule_details |
24 | |
25 | Deletes all details of the Product Rule |
26 | |
27 +======================================================================*/
28
29 PROCEDURE delete_product_rule_details
30 (p_application_id IN NUMBER
31 ,p_amb_context_code IN VARCHAR2
32 ,p_product_rule_type_code IN VARCHAR2
33 ,p_product_rule_code IN VARCHAR2);
34
35 /*======================================================================+
36 | |
37 | Public Procedure |
38 | |
39 | delete_prod_header_details |
40 | |
41 | Deletes all details of the event class and event type assignment |
42 | |
43 +======================================================================*/
44
45 PROCEDURE delete_prod_header_details
46 (p_application_id IN NUMBER
47 ,p_amb_context_code IN VARCHAR2
48 ,p_product_rule_type_code IN VARCHAR2
49 ,p_product_rule_code IN VARCHAR2
50 ,p_event_class_code IN VARCHAR2
51 ,p_event_type_code IN VARCHAR2);
52
53 /*======================================================================+
54 | |
55 | Public Procedure |
56 | |
57 | copy_product_rule_details |
58 | |
59 | Copies the details of the old product rule into the new product rule |
60 | |
61 +======================================================================*/
62
63 PROCEDURE copy_product_rule_details
64 (p_application_id IN NUMBER
65 ,p_amb_context_code IN VARCHAR2
66 ,p_old_product_rule_type_code IN VARCHAR2
67 ,p_old_product_rule_code IN VARCHAR2
68 ,p_new_product_rule_type_code IN VARCHAR2
69 ,p_new_product_rule_code IN VARCHAR2
70 ,p_include_header_assignments IN VARCHAR2
71 ,p_include_line_assignments IN VARCHAR2);
72
73 /*======================================================================+
74 | |
75 | Public Function |
76 | |
77 | product_rule_in_use |
78 | |
79 | Returns true if the rule is in use by accounting method |
80 | |
81 +======================================================================*/
82
83 FUNCTION product_rule_in_use
84 (p_event IN VARCHAR2
85 ,p_application_id IN NUMBER
86 ,p_amb_context_code IN VARCHAR2
87 ,p_product_rule_type_code IN VARCHAR2
88 ,p_product_rule_code IN VARCHAR2
89 ,p_accounting_method_name IN OUT NOCOPY VARCHAR2
90 ,p_accounting_method_type IN OUT NOCOPY VARCHAR2)
91 RETURN BOOLEAN;
92
93 /*======================================================================+
94 | |
95 | Public Function |
96 | |
97 | invalid_header_description |
98 | |
99 | Returns true if sources used in the description are invalid. |
100 | Used in the lov for descriptions |
101 | |
102 +======================================================================*/
103
104 FUNCTION invalid_header_description
105 (p_application_id IN NUMBER
106 ,p_amb_context_code IN VARCHAR2
107 ,p_entity_code IN VARCHAR2
108 ,p_event_class_code IN VARCHAR2
109 ,p_description_type_code IN VARCHAR2
110 ,p_description_code IN VARCHAR2)
111 RETURN VARCHAR2;
112
113 /*======================================================================+
114 | |
115 | Public Function |
116 | |
117 | uncompile_product_rule |
118 | |
119 | Returns true if product rule gets uncompiled |
120 | |
121 +======================================================================*/
122
123 FUNCTION uncompile_product_rule
124 (p_application_id IN NUMBER
125 ,p_amb_context_code IN VARCHAR2
126 ,p_product_rule_type_code IN VARCHAR2
127 ,p_product_rule_code IN VARCHAR2)
128 RETURN BOOLEAN;
129
130 /*======================================================================+
131 | |
132 | Public Function |
133 | |
134 | set_compile_status |
135 | |
136 | Returns true if the compile status is changed as desired |
137 | |
138 +======================================================================*/
139
140 FUNCTION set_compile_status
141 (p_application_id IN NUMBER
142 ,p_amb_context_code IN VARCHAR2
143 ,p_product_rule_type_code IN VARCHAR2
144 ,p_product_rule_code IN VARCHAR2
145 ,p_status IN VARCHAR2)
146 RETURN BOOLEAN;
147
148 /*======================================================================+
149 | |
150 | Public Function |
151 | |
152 | invalid_hdr_analytical |
153 | |
154 | Returns true if sources used in the analytical criteria are invalid |
155 | Used in the lov for analytical criteria |
156 | |
157 +======================================================================*/
158
159 FUNCTION invalid_hdr_analytical
160 (p_application_id IN NUMBER
161 ,p_amb_context_code IN VARCHAR2
162 ,p_event_class_code IN VARCHAR2
163 ,p_anal_criterion_type_code IN VARCHAR2
164 ,p_analytical_criterion_code IN VARCHAR2)
165 RETURN VARCHAR2;
166
167 /*======================================================================+
168 | |
169 | Public Procedure |
170 | |
171 | create_accounting_attributes |
172 | |
173 | Returns true if accounting sources get created |
174 | |
175 +======================================================================*/
176
177 PROCEDURE create_accounting_attributes
178 (p_application_id IN NUMBER
179 ,p_amb_context_code IN VARCHAR2
180 ,p_product_rule_type_code IN VARCHAR2
181 ,p_product_rule_code IN VARCHAR2
182 ,p_event_class_code IN VARCHAR2
183 ,p_event_type_code IN VARCHAR2
184 );
185
186 /*======================================================================+
187 | |
188 | Public Procedure |
189 | |
190 | get_default_attr_assignment |
191 | |
192 | Gets the default source assignments for the accounting attribute |
193 | |
194 +======================================================================*/
195
196 PROCEDURE get_default_attr_assignment
197 (p_application_id IN NUMBER
198 ,p_event_class_code IN VARCHAR2
199 ,p_accounting_attribute_code IN VARCHAR2
200 ,p_source_application_id IN OUT NOCOPY NUMBER
201 ,p_source_type_code IN OUT NOCOPY VARCHAR2
202 ,p_source_code IN OUT NOCOPY VARCHAR2
203 ,p_source_name IN OUT NOCOPY VARCHAR2
204 ,p_source_type_dsp IN OUT NOCOPY VARCHAR2);
205
206 /*======================================================================+
207 | |
208 | Public Function |
209 | |
210 | uncompile_definitions |
211 | |
212 | Uncompiles all AADs for an application |
213 | |
214 +======================================================================*/
215
216 FUNCTION uncompile_definitions
217 (p_application_id IN NUMBER
218 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
219 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
220 ,x_event_class_name IN OUT NOCOPY VARCHAR2
221 ,x_event_type_name IN OUT NOCOPY VARCHAR2
222 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
223 RETURN BOOLEAN;
224
225 END xla_product_rules_pkg;