[Home] [Help]
PACKAGE: APPS.RG_REPORTS_PKG
Source
1 PACKAGE RG_REPORTS_PKG AS
2 /* $Header: rgirepts.pls 120.5 2003/04/29 00:47:49 djogg ship $ */
3
4 --
5 -- NAME
6 -- get_adhoc_prefix
7 --
8 -- DESCRIPTION
9 -- Get the ah hoc report name prefix from rg_lookups
10 --
11 -- PARAMETERS
12 -- Listed Below
13
14 PROCEDURE get_adhoc_prefix(X_adhoc_prefix IN OUT NOCOPY VARCHAR2);
15
16 --
17 -- NAME
18 -- Insert_Row
19 --
20 -- DESCRIPTION
21 -- Insert a row into rg_reports
22 --
23 -- PARAMETERS
24 -- Listed Below
25 --
26 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
27 X_Application_Id NUMBER,
28 X_Report_Id IN OUT NOCOPY NUMBER,
29 X_Last_Update_Date DATE,
30 X_Last_Updated_By NUMBER,
31 X_Last_Update_Login NUMBER,
32 X_Creation_Date DATE,
33 X_Created_By NUMBER,
34 X_Name IN OUT NOCOPY VARCHAR2,
35 X_Report_Title VARCHAR2,
36 X_Security_Flag VARCHAR2,
37 X_Column_Set_Id NUMBER,
38 X_Row_Set_Id NUMBER,
39 X_Rounding_Option VARCHAR2,
40 X_Output_Option VARCHAR2,
41 X_Report_Display_Set_Id NUMBER,
42 X_Content_Set_Id NUMBER,
43 X_Row_Order_Id NUMBER,
44 X_Parameter_Set_Id NUMBER,
45 X_Unit_Of_Measure_Id VARCHAR2,
46 X_Id_Flex_Code VARCHAR2,
47 X_Structure_Id NUMBER,
48 X_Segment_Override VARCHAR2,
49 X_Override_Alc_Ledger_Currency VARCHAR2,
50 X_Period_Set_Name VARCHAR2,
51 X_Minimum_Display_Level NUMBER,
52 X_Description VARCHAR2,
53 X_Context VARCHAR2,
54 X_Attribute1 VARCHAR2,
55 X_Attribute2 VARCHAR2,
56 X_Attribute3 VARCHAR2,
57 X_Attribute4 VARCHAR2,
58 X_Attribute5 VARCHAR2,
59 X_Attribute6 VARCHAR2,
60 X_Attribute7 VARCHAR2,
61 X_Attribute8 VARCHAR2,
62 X_Attribute9 VARCHAR2,
63 X_Attribute10 VARCHAR2,
64 X_Attribute11 VARCHAR2,
65 X_Attribute12 VARCHAR2,
66 X_Attribute13 VARCHAR2,
67 X_Attribute14 VARCHAR2,
68 X_Attribute15 VARCHAR2
69 );
70
71 --
72 -- NAME
73 -- Lock_Row
74 --
75 -- DESCRIPTION
76 -- Lock a row in rg_reports
77 --
78 -- PARAMETERS
79 -- Listed Below
80 --
81 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
82 X_Application_Id NUMBER,
83 X_Report_Id NUMBER,
84 X_Name VARCHAR2,
85 X_Report_Title VARCHAR2,
86 X_Security_Flag VARCHAR2,
87 X_Column_Set_Id NUMBER,
88 X_Row_Set_Id NUMBER,
89 X_Rounding_Option VARCHAR2,
90 X_Output_Option VARCHAR2,
91 X_Report_Display_Set_Id NUMBER,
92 X_Content_Set_Id NUMBER,
93 X_Row_Order_Id NUMBER,
94 X_Parameter_Set_Id NUMBER,
95 X_Unit_Of_Measure_Id VARCHAR2,
96 X_Id_Flex_Code VARCHAR2,
97 X_Structure_Id NUMBER,
98 X_Segment_Override VARCHAR2,
99 X_Override_Alc_Ledger_Currency VARCHAR2,
100 X_Period_Set_Name VARCHAR2,
101 X_Minimum_Display_Level NUMBER,
102 X_Description VARCHAR2,
103 X_Context VARCHAR2,
104 X_Attribute1 VARCHAR2,
105 X_Attribute2 VARCHAR2,
106 X_Attribute3 VARCHAR2,
107 X_Attribute4 VARCHAR2,
108 X_Attribute5 VARCHAR2,
109 X_Attribute6 VARCHAR2,
110 X_Attribute7 VARCHAR2,
111 X_Attribute8 VARCHAR2,
112 X_Attribute9 VARCHAR2,
113 X_Attribute10 VARCHAR2,
114 X_Attribute11 VARCHAR2,
115 X_Attribute12 VARCHAR2,
116 X_Attribute13 VARCHAR2,
117 X_Attribute14 VARCHAR2,
118 X_Attribute15 VARCHAR2
119 );
120
121 --
122 -- NAME
123 -- Update_Row
124 --
125 -- DESCRIPTION
126 -- Update a row in rg_reports
127 --
128 -- PARAMETERS
129 -- Listed Below
130 --
131 PROCEDURE Update_Row(X_Rowid VARCHAR2,
132 X_Application_Id NUMBER,
133 X_Report_Id NUMBER,
134 X_Last_Update_Date DATE,
135 X_Last_Updated_By NUMBER,
136 X_Last_Update_Login NUMBER,
137 X_Name VARCHAR2,
138 X_Report_Title VARCHAR2,
139 X_Security_Flag VARCHAR2,
140 X_Column_Set_Id NUMBER,
141 X_Row_Set_Id NUMBER,
142 X_Rounding_Option VARCHAR2,
143 X_Output_Option VARCHAR2,
144 X_Report_Display_Set_Id NUMBER,
145 X_Content_Set_Id NUMBER,
146 X_Row_Order_Id NUMBER,
147 X_Parameter_Set_Id NUMBER,
148 X_Unit_Of_Measure_Id VARCHAR2,
149 X_Id_Flex_Code VARCHAR2,
150 X_Structure_Id NUMBER,
151 X_Segment_Override VARCHAR2,
152 X_Override_Alc_Ledger_Currency VARCHAR2,
153 X_Period_Set_Name VARCHAR2,
154 X_Minimum_Display_Level NUMBER,
155 X_Description VARCHAR2,
156 X_Context VARCHAR2,
157 X_Attribute1 VARCHAR2,
158 X_Attribute2 VARCHAR2,
159 X_Attribute3 VARCHAR2,
160 X_Attribute4 VARCHAR2,
161 X_Attribute5 VARCHAR2,
162 X_Attribute6 VARCHAR2,
163 X_Attribute7 VARCHAR2,
164 X_Attribute8 VARCHAR2,
165 X_Attribute9 VARCHAR2,
166 X_Attribute10 VARCHAR2,
167 X_Attribute11 VARCHAR2,
168 X_Attribute12 VARCHAR2,
169 X_Attribute13 VARCHAR2,
170 X_Attribute14 VARCHAR2,
171 X_Attribute15 VARCHAR2
172 );
173
174 --
175 -- NAME
176 -- Delete_Row
177 --
178 -- DESCRIPTION
179 -- Delete a row in rg_reports
180 --
181 -- PARAMETERS
182 -- Listed Below
183 --
184 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
185
186 --
187 -- NAME
188 -- select_columns
189 -- DESCRIPTION
190 -- find report name corresponded to a report_id (no one is using this)
191 -- PARAMETERS
192 -- 1. Report ID
193 -- 2. Report name
194 --
195 PROCEDURE select_columns(report_id IN NUMBER,
196 name IN OUT NOCOPY VARCHAR2);
197
198 --
199 -- NAME
200 -- get_report_id
201 --
202 -- DESCRIPTION
203 -- Get the next sequence number from rg_report_id_s.
204 --
205 -- PARAMETERS
206 -- None
207 --
208 FUNCTION get_report_id RETURN NUMBER;
209
210 --
211 -- NAME
212 -- report_is_used
213 --
214 -- DESCRIPTION
215 -- Check whether the report is used by a report request.
216 --
217 -- PARAMETERS
218 -- 1. Report ID
219 --
220 FUNCTION report_is_used(cur_report_id IN NUMBER)
221 RETURN BOOLEAN;
222
223
224 --
225 -- NAME
226 -- report_belongs_set
227 --
228 -- DESCRIPTION
229 -- Check whether the report is used by a report set.
230 --
231 -- PARAMETERS
232 -- 1. Report ID
233 --
234 FUNCTION report_belongs_set(cur_report_id IN NUMBER)
235 RETURN BOOLEAN;
236
237
238 --
239 -- NAME
240 -- check_dup_report_name
241 -- DESCRIPTION
242 -- Check whether new_name already used by another report
243 -- in the currenct application.
244 -- PARAMETERS
245 -- 1. Current Application ID
246 -- 2. Current Report Set ID
247 -- 3. New report name
248 --
249 FUNCTION check_dup_report_name( cur_application_id IN NUMBER,
250 cur_report_id IN NUMBER,
251 new_name IN VARCHAR2)
252 RETURN BOOLEAN;
253
254 --
255 -- Name
256 -- get_overrides
257 -- Description
258 -- This procedure sets the passed override variables for the
259 -- row set and column set. Override variables are set to TRUE
260 -- the override is present; otherwise, they are set to FALSE.
261 -- Parameters
262 -- 1. row set id
263 -- 2. column set id
264 -- 3. budget_override
265 -- 4. encumbrance_override
266 -- 5. currency_override
267 --
268 PROCEDURE get_overrides(
269 row_set_id IN NUMBER,
270 column_set_id IN NUMBER,
271 budget_override IN OUT NOCOPY BOOLEAN,
272 encumbrance_override IN OUT NOCOPY BOOLEAN,
273 currency_override IN OUT NOCOPY BOOLEAN);
274
275 --
276 -- NAME
277 -- find_report_segment_override
278 -- DESCRIPTION
279 -- This is for processing the ledger segment of the Run FSG program
280 -- SRS segment override parameter.
281 -- PARAMETERS
282 -- x_report_id
283 --
284 FUNCTION find_report_segment_override(x_report_id IN NUMBER)
285 RETURN VARCHAR2;
286
287 END RG_REPORTS_PKG;