1 PACKAGE FA_RX_SHARED_PKG AUTHID CURRENT_USER as
2 /* $Header: farxs.pls 120.12 2009/10/30 11:33:14 pmadas ship $ */
3
4
5 TYPE Seg_Array IS TABLE OF VARCHAR2(30)
6 INDEX BY BINARY_INTEGER;
7
8 type varchar2table is table of varchar2(50)
9 index by binary_integer;
10 type smallvarchar2table is table of varchar2(1)
11 index by binary_integer;
12 type largevarchar2table is table of varchar2(250)
13 index by binary_integer;
14 type numbertable is table of number
15 index by binary_integer;
16
17
18
19
20 PROCEDURE GET_ACCT_SEGMENT_NUMBERS (
21 BOOK IN VARCHAR2,
22 BALANCING_SEGNUM OUT NOCOPY NUMBER,
23 ACCOUNT_SEGNUM OUT NOCOPY NUMBER,
24 CC_SEGNUM OUT NOCOPY NUMBER,
25 CALLING_FN IN VARCHAR2);
26
27 PROCEDURE GET_ACCT_SEGMENT_INDEX ( /* StatReq */
28 BOOK IN VARCHAR2,
29 BALANCING_SEGNUM OUT NOCOPY NUMBER,
30 ACCOUNT_SEGNUM OUT NOCOPY NUMBER,
31 CC_SEGNUM OUT NOCOPY NUMBER,
32 CALLING_FN IN VARCHAR2);
33
34 PROCEDURE GET_ACCT_SEGMENTS (
35 combination_id IN NUMBER,
36 n_segments IN OUT NOCOPY NUMBER,
37 segments IN OUT NOCOPY Seg_Array,
38 CALLING_FN IN VARCHAR2);
39
40 procedure fadolif (
41 life in number default null,
42 adj_rate in number default null,
43 bonus_rate in number default null,
44 prod in number default null,
45 retval out nocopy varchar2);
46
47
48 procedure fa_rsvldg (
49 book in varchar2,
50 period in varchar2,
51 report_style in varchar2 default 'S',
52 sob_id in number default NULL, -- MRC: Set of books id
53 errbuf out nocopy varchar2,
54 retcode out nocopy number);
55
56
57 procedure concat_general (
58 table_id in number,
59 table_name in varchar2,
60 ccid_col_name in varchar2,
61 struct_id in number,
62 flex_code in varchar2,
63 ccid in number,
64 appl_id in number,
65 appl_short_name in varchar2,
66 concat_string in out nocopy varchar2,
67 segarray in out nocopy Seg_Array);
68
69
70
71 procedure concat_category (
72 struct_id in number,
73 ccid in number,
74 concat_string in out nocopy varchar2,
75 segarray in out nocopy Seg_Array);
76
77
78 procedure concat_location (
79 struct_id in number,
80 ccid in number,
81 concat_string in out nocopy varchar2,
82 segarray in out nocopy Seg_Array);
83
84
85 procedure concat_asset_key (
86 struct_id in number,
87 ccid in number,
88 concat_string in out nocopy varchar2,
89 segarray in out nocopy Seg_Array);
90
91
92 procedure concat_acct (
93 struct_id in number,
94 ccid in number,
95 concat_string in out nocopy varchar2,
96 segarray in out nocopy Seg_Array);
97
98
99
100 procedure get_request_info (
101 userid in number,
102 prog_name_template in varchar2,
103 max_requests in number,
104 dateform in varchar2,
105 applid in number,
106 user_conc_prog_names out nocopy largevarchar2table,
107 conc_prog_names out nocopy varchar2table,
108 arg_texts out nocopy largevarchar2table,
109 request_ids out nocopy numbertable,
110 phases out nocopy varchar2table,
111 statuses out nocopy varchar2table,
112 dev_phases out nocopy smallvarchar2table,
113 dev_statuses out nocopy smallvarchar2table,
114 timestamps out nocopy varchar2table,
115 num_requests out nocopy number);
116
117 procedure get_arguments (
118 req_id in number,
119 arg1 out nocopy varchar2,
120 arg2 out nocopy varchar2,
121 arg3 out nocopy varchar2,
122 arg4 out nocopy varchar2,
123 arg5 out nocopy varchar2,
124 arg6 out nocopy varchar2,
125 arg7 out nocopy varchar2,
126 arg8 out nocopy varchar2,
127 arg9 out nocopy varchar2,
128 arg10 out nocopy varchar2,
129 arg11 out nocopy varchar2,
130 arg12 out nocopy varchar2,
131 arg13 out nocopy varchar2,
132 arg14 out nocopy varchar2,
133 arg15 out nocopy varchar2,
134 arg16 out nocopy varchar2,
135 arg17 out nocopy varchar2,
136 arg18 out nocopy varchar2,
137 arg19 out nocopy varchar2,
138 arg20 out nocopy varchar2,
139 arg21 out nocopy varchar2,
140 arg22 out nocopy varchar2,
141 arg23 out nocopy varchar2,
142 arg24 out nocopy varchar2,
143 arg25 out nocopy varchar2);
144
145
146 procedure add_dynamic_column (
147 X_request_id in number,
148 X_attribute_name in varchar2,
149 X_column_name in varchar2,
150 X_ordering in varchar2,
151 X_BREAK in VARCHAR2,
152 X_DISPLAY_LENGTH in NUMBER,
153 X_DISPLAY_FORMAT in VARCHAR2,
154 X_DISPLAY_STATUS in VARCHAR2,
155 calling_fn in varchar2);
156
157 /* StatReq - The following two function specs have been added for statutory reporting requirements */
158
159 FUNCTION get_flex_val_meaning (
160 v_flex_value_set_id IN NUMBER,
161 v_flex_value_set_name IN VARCHAR2,
162 v_flex_value IN VARCHAR2)
163 return VARCHAR2;
164
165 --* bug#2991482, rravunny
166 --* parent value feature added.
167 --* overridden function
168 --*
169 FUNCTION get_flex_val_meaning (
170 v_flex_value_set_id IN NUMBER,
171 v_flex_value_set_name IN VARCHAR2,
172 v_flex_value IN VARCHAR2,
173 v_parent_flex_val IN VARCHAR2) --* new parameter added.
174 return VARCHAR2;
175
176 FUNCTION get_asset_info (
177 v_info_type IN VARCHAR2,
178 v_asset_id IN NUMBER,
179 v_from_date IN DATE,
180 v_to_date IN DATE,
181 v_book_type_code IN VARCHAR2,
182 v_balancing_segment IN VARCHAR2)
183 return VARCHAR2;
184
185
186
187 PROCEDURE clear_flex_val_cache;
188
189 /* StatReq - Global Variables */
190
191 --* bug#2991482, rravunny
192 --* parent value feature added.
193 --*
194 TYPE g_value_rec_type is RECORD (
195 parent_flex_value_low fnd_flex_values.parent_flex_value_low%TYPE default null,
196 value VARCHAR2(150),
197 meaning VARCHAR2(240));
198
199 --* TYPE g_value_rec_type is RECORD (
200 --* value VARCHAR2(150),
201 --* meaning VARCHAR2(240));
202
203 TYPE g_value_tab_type is TABLE of g_value_rec_type
204 index by BINARY_INTEGER;
205
206 TYPE g_value_set_rec_type is RECORD (
207 value_set_name VARCHAR2(150),
208 from_counter NUMBER,
209 to_counter NUMBER);
210
211 TYPE g_value_set_tab_type is TABLE of g_value_set_rec_type
212 index by BINARY_INTEGER;
213
214 g_values_tab g_value_tab_type;
215
216 g_value_set_tab g_value_set_tab_type;
217
218 g_value_set_counter NUMBER := 0;
219 g_value_counter NUMBER := 0;
220
221 g_loc_flex_struct NUMBER;
222
223
224
225 TYPE g_seg_data is RECORD (
226 tabname VARCHAR2(30),
227 table_id NUMBER(15),
228 colname VARCHAR2(30),
229 segment_num NUMBER(3),
230 delimiter VARCHAR2(1) );
231
232 -- Needed for multirow selects.
233 TYPE g_seg_data_tbl is TABLE of g_seg_data
234 INDEX BY BINARY_INTEGER;
235
236 g_seg_struct g_seg_data;
237 g_seg_table g_seg_data_tbl;
238 g_seg_count NUMBER := 0;
239
240
241
242 END FA_RX_SHARED_PKG;