1 PACKAGE XLA_ANALYTICAL_CRITERIA_PKG AUTHID CURRENT_USER AS
2 /* $Header: xlabaacr.pkh 120.8 2007/05/03 23:03:02 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_analytical_criteria_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Analytical Criteria Package |
13 | |
14 | HISTORY |
15 | 27-AUG-02 A.Quaglia Created |
16 | 02-APR-03 A.Quaglia Major revisions |
17 | 10-APR-03 A.Quaglia Final adjustments |
18 | 08-SEP-03 A. Quaglia Included the following functions/procs: |
19 | compile_criterion |
20 | build_criteria_view |
21 +======================================================================*/
22
23 TYPE t_list_of_detail_chars IS TABLE OF VARCHAR2(240);
24 TYPE t_list_of_detail_dates IS TABLE OF DATE;
25 TYPE t_list_of_detail_numbers IS TABLE OF NUMBER;
26
27 TYPE t_analytical_criterion IS RECORD
28 ( anacri_code VARCHAR2(30)
29 ,anacri_type_code VARCHAR2(1)
30 ,amb_context_code VARCHAR2(30)
31 ,list_of_detail_chars t_list_of_detail_chars
32 ,list_of_detail_dates t_list_of_detail_dates
33 ,list_of_detail_numbers t_list_of_detail_numbers
34 );
35
36 TYPE t_list_of_criteria IS TABLE OF t_analytical_criterion;
37
38 --Public constants
39 --Success
40 C_SUCCESS CONSTANT INTEGER := 0;
41 --Could not lock row in xla_analytical_hdrs_b
42 C_CANNOT_LOCK_DETAIL_ROW CONSTANT INTEGER := -1;
43 --One or more details could not be mapped to a column of
44 --the view xla_analytical_criteria_v
45 C_NO_AVAILABLE_VIEW_COLUMN CONSTANT INTEGER := -2;
46
47 FUNCTION update_detail_value
48 ( p_application_id IN INTEGER
49 ,p_ae_header_id IN INTEGER
50 ,p_ae_line_num IN INTEGER
51 ,p_list_of_criteria IN OUT NOCOPY t_list_of_criteria
52 ,p_update_mode IN VARCHAR2
53 )
54 RETURN BOOLEAN;
55
56
57 FUNCTION single_update_detail_value
58 ( p_application_id IN INTEGER
59 ,p_ae_header_id IN INTEGER
60 ,p_ae_line_num IN INTEGER
61 ,p_analytical_detail_value_id IN INTEGER
62 ,p_anacri_code IN VARCHAR2
63 ,p_anacri_type_code IN VARCHAR2
64 ,p_amb_context_code IN VARCHAR2
65 ,p_update_mode IN VARCHAR2
66 ,p_detail_char_1 IN VARCHAR2 DEFAULT NULL
67 ,p_detail_date_1 IN DATE DEFAULT NULL
68 ,p_detail_number_1 IN NUMBER DEFAULT NULL
69 ,p_detail_char_2 IN VARCHAR2 DEFAULT NULL
70 ,p_detail_date_2 IN DATE DEFAULT NULL
71 ,p_detail_number_2 IN NUMBER DEFAULT NULL
72 ,p_detail_char_3 IN VARCHAR2 DEFAULT NULL
73 ,p_detail_date_3 IN DATE DEFAULT NULL
74 ,p_detail_number_3 IN NUMBER DEFAULT NULL
75 ,p_detail_char_4 IN VARCHAR2 DEFAULT NULL
76 ,p_detail_date_4 IN DATE DEFAULT NULL
77 ,p_detail_number_4 IN NUMBER DEFAULT NULL
78 ,p_detail_char_5 IN VARCHAR2 DEFAULT NULL
79 ,p_detail_date_5 IN DATE DEFAULT NULL
80 ,p_detail_number_5 IN NUMBER DEFAULT NULL
81 )
82 RETURN BOOLEAN;
83
84
85
86 FUNCTION get_detail_value_id
87 ( p_anacri_code IN VARCHAR2
88 ,p_anacri_type_code IN VARCHAR2
89 ,p_amb_context_code IN VARCHAR2
90 ,p_detail_char_1 IN VARCHAR2 DEFAULT NULL
91 ,p_detail_date_1 IN DATE DEFAULT NULL
92 ,p_detail_number_1 IN NUMBER DEFAULT NULL
93 ,p_detail_char_2 IN VARCHAR2 DEFAULT NULL
94 ,p_detail_date_2 IN DATE DEFAULT NULL
95 ,p_detail_number_2 IN NUMBER DEFAULT NULL
96 ,p_detail_char_3 IN VARCHAR2 DEFAULT NULL
97 ,p_detail_date_3 IN DATE DEFAULT NULL
98 ,p_detail_number_3 IN NUMBER DEFAULT NULL
99 ,p_detail_char_4 IN VARCHAR2 DEFAULT NULL
100 ,p_detail_date_4 IN DATE DEFAULT NULL
101 ,p_detail_number_4 IN NUMBER DEFAULT NULL
102 ,p_detail_char_5 IN VARCHAR2 DEFAULT NULL
103 ,p_detail_date_5 IN DATE DEFAULT NULL
104 ,p_detail_number_5 IN NUMBER DEFAULT NULL
105 )
106 RETURN INTEGER;
107
108 FUNCTION single_update_detail_value
109 ( p_application_id IN INTEGER
110 ,p_ae_header_id IN INTEGER
111 ,p_ae_line_num IN INTEGER
112 ,p_anacri_code IN VARCHAR2
113 ,p_anacri_type_code IN VARCHAR2
114 ,p_amb_context_code IN VARCHAR2
115 ,p_update_mode IN VARCHAR2
116 ,p_ac1 IN VARCHAR2 DEFAULT NULL
117 ,p_ac2 IN VARCHAR2 DEFAULT NULL
118 ,p_ac3 IN VARCHAR2 DEFAULT NULL
119 ,p_ac4 IN VARCHAR2 DEFAULT NULL
120 ,p_ac5 IN VARCHAR2 DEFAULT NULL
121 )
122 RETURN BOOLEAN;
123
124 FUNCTION compile_criterion ( p_anacri_code IN VARCHAR2
125 ,p_anacri_type_code IN VARCHAR2
126 ,p_amb_context_code IN VARCHAR2
127 )
128
129 RETURN INTEGER;
130
131 FUNCTION concat_detail_values
132 ( p_anacri_code IN VARCHAR2
133 ,p_anacri_type_code IN VARCHAR2
134 ,p_amb_context_code IN VARCHAR2
135 ,p_detail_char_1 IN VARCHAR2 DEFAULT NULL
136 ,p_detail_date_1 IN DATE DEFAULT NULL
137 ,p_detail_number_1 IN NUMBER DEFAULT NULL
138 ,p_detail_char_2 IN VARCHAR2 DEFAULT NULL
139 ,p_detail_date_2 IN DATE DEFAULT NULL
140 ,p_detail_number_2 IN NUMBER DEFAULT NULL
141 ,p_detail_char_3 IN VARCHAR2 DEFAULT NULL
142 ,p_detail_date_3 IN DATE DEFAULT NULL
143 ,p_detail_number_3 IN NUMBER DEFAULT NULL
144 ,p_detail_char_4 IN VARCHAR2 DEFAULT NULL
145 ,p_detail_date_4 IN DATE DEFAULT NULL
146 ,p_detail_number_4 IN NUMBER DEFAULT NULL
147 ,p_detail_char_5 IN VARCHAR2 DEFAULT NULL
148 ,p_detail_date_5 IN DATE DEFAULT NULL
149 ,p_detail_number_5 IN NUMBER DEFAULT NULL
150 )
151 RETURN VARCHAR2;
152
153 FUNCTION build_criteria_view
154 RETURN INTEGER;
155
156 FUNCTION get_hdr_ac_count
157 RETURN INTEGER;
158
159 FUNCTION get_line_ac_count
160 RETURN INTEGER;
161
162 END xla_analytical_criteria_pkg;