1 PACKAGE xla_descriptions_pkg AS
2 /* $Header: xlaamdad.pkh 120.9 2005/02/26 01:53:45 weshen ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_descriptions_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Descriptions package |
13 | |
14 | HISTORY |
15 | 01-May-01 Dimple Shah Created |
16 | |
17 +======================================================================*/
18
19 /*======================================================================+
20 | |
21 | Public Procedure |
22 | |
23 | delete_description_details |
24 | |
25 | Deletes all details of the description |
26 | |
27 +======================================================================*/
28
29 PROCEDURE delete_description_details
30 (p_application_id IN NUMBER
31 ,p_amb_context_code IN VARCHAR2
32 ,p_description_type_code IN VARCHAR2
33 ,p_description_code IN VARCHAR2);
34
35 /*======================================================================+
36 | |
37 | Public Procedure |
38 | |
39 | copy_description_details |
40 | |
41 | Copies the details of the old description into the new description |
42 | |
43 +======================================================================*/
44
45 PROCEDURE copy_description_details
46 (p_application_id IN NUMBER
47 ,p_amb_context_code IN VARCHAR2
48 ,p_old_description_type_code IN VARCHAR2
49 ,p_old_description_code IN VARCHAR2
50 ,p_new_description_type_code IN VARCHAR2
51 ,p_new_description_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_description_type_code IN VARCHAR2
70 ,p_description_code IN VARCHAR2
71 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
72 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
73 ,x_event_class_name IN OUT NOCOPY VARCHAR2
74 ,x_line_definition_name IN OUT NOCOPY VARCHAR2
75 ,x_line_definition_owner IN OUT NOCOPY VARCHAR2)
76 RETURN BOOLEAN;
77
78 /*======================================================================+
79 | |
80 | Public Function |
81 | |
82 | rule_is_invalid |
83 | |
84 | Returns true if the rule is invalid |
85 | |
86 +======================================================================*/
87
88 FUNCTION rule_is_invalid
89 (p_application_id IN NUMBER
90 ,p_amb_context_code IN VARCHAR2
91 ,p_description_type_code IN VARCHAR2
92 ,p_description_code IN VARCHAR2
93 ,p_message_name OUT NOCOPY VARCHAR2)
94 RETURN BOOLEAN;
95
96 /*======================================================================+
97 | |
98 | Public Function |
99 | |
100 | description_is_locked |
101 | |
102 | Returns true if the description is being used by a locked product rule|
103 | |
104 +======================================================================*/
105
106 FUNCTION description_is_locked
107 (p_application_id IN NUMBER
108 ,p_amb_context_code IN VARCHAR2
109 ,p_description_type_code IN VARCHAR2
110 ,p_description_code IN VARCHAR2)
111 RETURN BOOLEAN;
112
113 /*======================================================================+
114 | |
115 | Public Function |
116 | |
117 | uncompile_definitions |
118 | |
119 | Returns true if the application accounting definitions and journal |
120 | line definitions using the description get uncompiled |
121 | |
122 +======================================================================*/
123
124 FUNCTION uncompile_definitions
125 (p_application_id IN NUMBER
126 ,p_amb_context_code IN VARCHAR2
127 ,p_description_type_code IN VARCHAR2
128 ,p_description_code IN VARCHAR2
129 ,x_product_rule_name IN OUT NOCOPY VARCHAR2
130 ,x_product_rule_type IN OUT NOCOPY VARCHAR2
131 ,x_event_class_name IN OUT NOCOPY VARCHAR2
132 ,x_event_type_name IN OUT NOCOPY VARCHAR2
133 ,x_locking_status_flag IN OUT NOCOPY VARCHAR2)
134 RETURN BOOLEAN;
135
136 /*======================================================================+
137 | |
138 | Public Function |
139 | |
140 | check_copy_description_details |
141 | |
142 | Checks if description can be copied |
143 | |
144 +======================================================================*/
145
146 FUNCTION check_copy_description_details
147 (p_application_id IN NUMBER
148 ,p_amb_context_code IN VARCHAR2
149 ,p_old_description_type_code IN VARCHAR2
150 ,p_old_description_code IN VARCHAR2
151 ,p_old_transaction_coa_id IN NUMBER
152 ,p_new_transaction_coa_id IN NUMBER
153 ,p_message IN OUT NOCOPY VARCHAR2
154 ,p_token_1 IN OUT NOCOPY VARCHAR2
155 ,p_value_1 IN OUT NOCOPY VARCHAR2)
156 RETURN BOOLEAN;
157
158 END xla_descriptions_pkg;