1 PACKAGE FA_RX_SHARED_PKG as
2 /* $Header: farxs.pls 120.7.12010000.2 2008/07/31 07:22:06 sbhaskar 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 errbuf out nocopy varchar2,
53 retcode out nocopy number);
54
55
56 procedure concat_general (
57 table_id in number,
58 table_name in varchar2,
59 ccid_col_name in varchar2,
60 struct_id in number,
61 flex_code in varchar2,
62 ccid in number,
63 appl_id in number,
64 appl_short_name in varchar2,
65 concat_string in out nocopy varchar2,
66 segarray in out nocopy Seg_Array);
67
68
69
70 procedure concat_category (
71 struct_id in number,
72 ccid in number,
73 concat_string in out nocopy varchar2,
74 segarray in out nocopy Seg_Array);
75
76
77 procedure concat_location (
78 struct_id in number,
79 ccid in number,
80 concat_string in out nocopy varchar2,
81 segarray in out nocopy Seg_Array);
82
83
84 procedure concat_asset_key (
85 struct_id in number,
86 ccid in number,
87 concat_string in out nocopy varchar2,
88 segarray in out nocopy Seg_Array);
89
90
91 procedure concat_acct (
92 struct_id in number,
93 ccid in number,
94 concat_string in out nocopy varchar2,
95 segarray in out nocopy Seg_Array);
96
97
98
99 procedure get_request_info (
100 userid in number,
101 prog_name_template in varchar2,
102 max_requests in number,
103 dateform in varchar2,
104 applid in number,
105 user_conc_prog_names out nocopy largevarchar2table,
106 conc_prog_names out nocopy varchar2table,
107 arg_texts out nocopy largevarchar2table,
108 request_ids out nocopy numbertable,
109 phases out nocopy varchar2table,
110 statuses out nocopy varchar2table,
111 dev_phases out nocopy smallvarchar2table,
112 dev_statuses out nocopy smallvarchar2table,
113 timestamps out nocopy varchar2table,
114 num_requests out nocopy number);
115
116 procedure get_arguments (
117 req_id in number,
118 arg1 out nocopy varchar2,
119 arg2 out nocopy varchar2,
120 arg3 out nocopy varchar2,
121 arg4 out nocopy varchar2,
122 arg5 out nocopy varchar2,
123 arg6 out nocopy varchar2,
124 arg7 out nocopy varchar2,
125 arg8 out nocopy varchar2,
126 arg9 out nocopy varchar2,
127 arg10 out nocopy varchar2,
128 arg11 out nocopy varchar2,
129 arg12 out nocopy varchar2,
130 arg13 out nocopy varchar2,
131 arg14 out nocopy varchar2,
132 arg15 out nocopy varchar2,
133 arg16 out nocopy varchar2,
134 arg17 out nocopy varchar2,
135 arg18 out nocopy varchar2,
136 arg19 out nocopy varchar2,
137 arg20 out nocopy varchar2,
138 arg21 out nocopy varchar2,
139 arg22 out nocopy varchar2,
140 arg23 out nocopy varchar2,
141 arg24 out nocopy varchar2,
142 arg25 out nocopy varchar2);
143
144
145 procedure add_dynamic_column (
146 X_request_id in number,
147 X_attribute_name in varchar2,
148 X_column_name in varchar2,
149 X_ordering in varchar2,
150 X_BREAK in VARCHAR2,
151 X_DISPLAY_LENGTH in NUMBER,
152 X_DISPLAY_FORMAT in VARCHAR2,
153 X_DISPLAY_STATUS in VARCHAR2,
154 calling_fn in varchar2);
155
156 /* StatReq - The following two function specs have been added for statutory reporting requirements */
157
158 FUNCTION get_flex_val_meaning (
159 v_flex_value_set_id IN NUMBER,
160 v_flex_value_set_name IN VARCHAR2,
161 v_flex_value IN VARCHAR2)
162 return VARCHAR2;
163
164 --* bug#2991482, rravunny
165 --* parent value feature added.
166 --* overridden function
167 --*
168 FUNCTION get_flex_val_meaning (
169 v_flex_value_set_id IN NUMBER,
170 v_flex_value_set_name IN VARCHAR2,
171 v_flex_value IN VARCHAR2,
172 v_parent_flex_val IN VARCHAR2) --* new parameter added.
173 return VARCHAR2;
174
175 FUNCTION get_asset_info (
176 v_info_type IN VARCHAR2,
177 v_asset_id IN NUMBER,
178 v_from_date IN DATE,
179 v_to_date IN DATE,
180 v_book_type_code IN VARCHAR2,
181 v_balancing_segment IN VARCHAR2)
182 return VARCHAR2;
183
184
185
186 PROCEDURE clear_flex_val_cache;
187
188 /* StatReq - Global Variables */
189
190 --* bug#2991482, rravunny
191 --* parent value feature added.
192 --*
193 TYPE g_value_rec_type is RECORD (
194 parent_flex_value_low fnd_flex_values.parent_flex_value_low%TYPE default null,
195 value VARCHAR2(150),
196 meaning VARCHAR2(240));
197
198 --* TYPE g_value_rec_type is RECORD (
199 --* value VARCHAR2(150),
200 --* meaning VARCHAR2(240));
201
202 TYPE g_value_tab_type is TABLE of g_value_rec_type
203 index by BINARY_INTEGER;
204
205 TYPE g_value_set_rec_type is RECORD (
206 value_set_name VARCHAR2(150),
207 from_counter NUMBER,
208 to_counter NUMBER);
209
210 TYPE g_value_set_tab_type is TABLE of g_value_set_rec_type
211 index by BINARY_INTEGER;
212
213 g_values_tab g_value_tab_type;
214
215 g_value_set_tab g_value_set_tab_type;
216
217 g_value_set_counter NUMBER := 0;
218 g_value_counter NUMBER := 0;
219
220 g_loc_flex_struct NUMBER;
221
222
223
224 TYPE g_seg_data is RECORD (
225 tabname VARCHAR2(30),
226 table_id NUMBER(15),
227 colname VARCHAR2(30),
228 segment_num NUMBER(3),
229 delimiter VARCHAR2(1) );
230
231 -- Needed for multirow selects.
232 TYPE g_seg_data_tbl is TABLE of g_seg_data
233 INDEX BY BINARY_INTEGER;
234
235 g_seg_struct g_seg_data;
236 g_seg_table g_seg_data_tbl;
237 g_seg_count NUMBER := 0;
238
239
240
241 END FA_RX_SHARED_PKG;