[Home] [Help]
PACKAGE: APPS.RG_REPORT_REQUESTS_PKG
Source
1 PACKAGE RG_REPORT_REQUESTS_PKG as
2 /* $Header: rgirreqs.pls 120.4 2003/04/29 00:47:55 djogg ship $ */
3
4 /* Name: init
5 * Desc: Initialize some variables.
6 *
7 * History:
8 * 11/27/95 S Rahman Created
9 */
10
11 PROCEDURE init(
12 ProductVersion IN OUT NOCOPY VARCHAR2,
13 ABFlag IN OUT NOCOPY VARCHAR2,
14 LedgerId NUMBER,
15 PeriodName VARCHAR2,
16 PeriodStartDate IN OUT NOCOPY DATE,
17 PeriodEndDate IN OUT NOCOPY DATE
18 );
19
20
21 /* Name: date_to_period
22 * Desc: Return the period for the passed date.
23 *
24 * History:
25 * 11/28/95 S Rahman Created
26 */
27
28 PROCEDURE date_to_period(
29 PeriodSetName VARCHAR2,
30 PeriodType VARCHAR2,
31 AccountingDate DATE,
32 PeriodName IN OUT NOCOPY VARCHAR2
33 );
34
35
36 /* Name: closest_date_for_period
37 * Desc: Return the date in the specified period that is closest to sysdate.
38 *
39 * History:
40 * 07/22/97 S Rahman Created
41 */
42 PROCEDURE closest_date_for_period(
43 LedgerId NUMBER,
44 PeriodName VARCHAR2,
45 AccountingDate IN OUT NOCOPY DATE
46 );
47
48
49 --
50 -- NAME
51 -- new_report_request_id
52 --
53 -- DESCRIPTION
54 -- get a new report_request_id from rg_report_requests_s
55 --
56 -- PARAMETERS
57 -- *None*
58 --
59
60 FUNCTION new_report_request_id
61 RETURN NUMBER;
62
63 --
64 --
65 -- NAME
66 -- check_dup_sequence
67 --
68 -- DESCRIPTION
69 -- Check whether a particular sequence already existed in
70 -- in current report set
71 --
72 -- PARAMETERS
73 -- 1. Current Report Set ID
74 -- 2. Current Report Request ID
75 -- 2. New sequence number
76 --
77 -- EXAMPLE
78 -- IF you want to check whether 15 is already a sequence number
79 -- in a differrent requests in current report set with
80 -- report_set_id = 100. Assume the current request is 2000
81 -- rg_report_requests_pkg.check_dup_sequence(100,2000,15);
82 -- Return TURE is it is exist, Otherwise FALSE.
83 --
84
85 FUNCTION check_dup_sequence(cur_report_set_id IN NUMBER,
86 cur_report_request_id IN NUMBER,
87 new_sequence IN NUMBER)
88 RETURN BOOLEAN;
89
90
91 --
92 -- NAME
93 -- Insert_Row
94 --
95 -- DESCRIPTION
96 -- Insert row into rg_report_requests
97 --
98 -- PARAMETERS
99 -- Listed Below
100 --
101
102 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
103 X_Application_Id NUMBER,
104 X_Report_Request_Id NUMBER,
105 X_Last_Update_Date DATE,
106 X_Last_Updated_By NUMBER,
107 X_Last_Update_Login NUMBER,
108 X_Creation_Date DATE,
109 X_Created_By NUMBER,
110 X_Report_Id NUMBER,
111 X_Sequence NUMBER,
112 X_Form_Submission_Flag VARCHAR2,
113 X_Concurrent_Request_Id NUMBER,
114 X_Report_Set_Id NUMBER,
115 X_Content_Set_Id NUMBER,
116 X_Row_Order_Id NUMBER,
117 X_Exceptions_Flag VARCHAR2,
118 X_Rounding_Option VARCHAR2,
119 X_Output_Option VARCHAR2,
120 X_Ledger_Id NUMBER,
121 X_Alc_Ledger_Currency VARCHAR2,
122 X_Report_Display_Set_Id NUMBER,
123 X_Id_Flex_Code VARCHAR2,
124 X_Structure_Id NUMBER,
125 X_Segment_Override VARCHAR2,
126 X_Override_Alc_Ledger_Currency VARCHAR2,
127 X_Period_Name VARCHAR2,
128 X_Accounting_Date DATE,
129 X_Unit_Of_Measure_Id VARCHAR2,
130 X_Context VARCHAR2,
131 X_Attribute1 VARCHAR2,
132 X_Attribute2 VARCHAR2,
133 X_Attribute3 VARCHAR2,
134 X_Attribute4 VARCHAR2,
135 X_Attribute5 VARCHAR2,
136 X_Attribute6 VARCHAR2,
137 X_Attribute7 VARCHAR2,
138 X_Attribute8 VARCHAR2,
139 X_Attribute9 VARCHAR2,
140 X_Attribute10 VARCHAR2,
141 X_Attribute11 VARCHAR2,
142 X_Attribute12 VARCHAR2,
143 X_Attribute13 VARCHAR2,
144 X_Attribute14 VARCHAR2,
145 X_Attribute15 VARCHAR2,
146 X_Runtime_Option_Context VARCHAR2
147 );
148
149 --
150 -- NAME
151 -- Lock_Row
152 --
153 -- DESCRIPTION
154 -- Lock a row in rg_report_requests
155 --
156 -- PARAMETERS
157 -- Listed Below
158 --
159
160 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
161 X_Application_Id NUMBER,
162 X_Report_Request_Id NUMBER,
163 X_Report_Id NUMBER,
164 X_Sequence NUMBER,
165 X_Form_Submission_Flag VARCHAR2,
166 X_Concurrent_Request_Id NUMBER,
167 X_Report_Set_Id NUMBER,
168 X_Content_Set_Id NUMBER,
169 X_Row_Order_Id NUMBER,
170 X_Exceptions_Flag VARCHAR2,
171 X_Rounding_Option VARCHAR2,
172 X_Output_Option VARCHAR2,
173 X_Ledger_Id NUMBER,
174 X_Alc_Ledger_Currency VARCHAR2,
175 X_Report_Display_Set_Id NUMBER,
176 X_Id_Flex_Code VARCHAR2,
177 X_Structure_Id NUMBER,
178 X_Segment_Override VARCHAR2,
179 X_Override_Alc_Ledger_Currency VARCHAR2,
180 X_Period_Name VARCHAR2,
181 X_Accounting_Date DATE,
182 X_Unit_Of_Measure_Id VARCHAR2,
183 X_Context VARCHAR2,
184 X_Attribute1 VARCHAR2,
185 X_Attribute2 VARCHAR2,
186 X_Attribute3 VARCHAR2,
187 X_Attribute4 VARCHAR2,
188 X_Attribute5 VARCHAR2,
189 X_Attribute6 VARCHAR2,
190 X_Attribute7 VARCHAR2,
191 X_Attribute8 VARCHAR2,
192 X_Attribute9 VARCHAR2,
193 X_Attribute10 VARCHAR2,
194 X_Attribute11 VARCHAR2,
195 X_Attribute12 VARCHAR2,
196 X_Attribute13 VARCHAR2,
197 X_Attribute14 VARCHAR2,
198 X_Attribute15 VARCHAR2,
199 X_Runtime_Option_Context VARCHAR2
200 );
201
202 --
203 -- NAME
204 -- Update_Row
205 --
206 -- DESCRIPTION
207 -- Update a row in rg_report_requests
208 --
209 -- PARAMETERS
210 -- Listed Below
211 --
212
213 PROCEDURE Update_Row(X_Rowid VARCHAR2,
214 X_Application_Id NUMBER,
215 X_Report_Request_Id NUMBER,
216 X_Last_Update_Date DATE,
217 X_Last_Updated_By NUMBER,
218 X_Last_Update_Login NUMBER,
219 X_Report_Id NUMBER,
220 X_Sequence NUMBER,
221 X_Form_Submission_Flag VARCHAR2,
222 X_Concurrent_Request_Id NUMBER,
223 X_Report_Set_Id NUMBER,
224 X_Content_Set_Id NUMBER,
225 X_Row_Order_Id NUMBER,
226 X_Exceptions_Flag VARCHAR2,
227 X_Rounding_Option VARCHAR2,
228 X_Output_Option VARCHAR2,
229 X_Ledger_Id NUMBER,
230 X_Alc_Ledger_Currency VARCHAR2,
231 X_Report_Display_Set_Id NUMBER,
232 X_Id_Flex_Code VARCHAR2,
233 X_Structure_Id NUMBER,
234 X_Segment_Override VARCHAR2,
235 X_Override_Alc_Ledger_Currency VARCHAR2,
236 X_Period_Name VARCHAR2,
237 X_Accounting_Date DATE,
238 X_Unit_Of_Measure_Id VARCHAR2,
239 X_Context VARCHAR2,
240 X_Attribute1 VARCHAR2,
241 X_Attribute2 VARCHAR2,
242 X_Attribute3 VARCHAR2,
243 X_Attribute4 VARCHAR2,
244 X_Attribute5 VARCHAR2,
245 X_Attribute6 VARCHAR2,
246 X_Attribute7 VARCHAR2,
247 X_Attribute8 VARCHAR2,
248 X_Attribute9 VARCHAR2,
249 X_Attribute10 VARCHAR2,
250 X_Attribute11 VARCHAR2,
251 X_Attribute12 VARCHAR2,
252 X_Attribute13 VARCHAR2,
253 X_Attribute14 VARCHAR2,
254 X_Attribute15 VARCHAR2,
255 X_Runtime_Option_Context VARCHAR2
256 );
257
258 --
259 -- NAME
260 -- Delete_Row
261 --
262 -- DESCRIPTION
263 -- Delete a row in rg_report_requests
264 --
265 -- PARAMETERS
266 -- Listed Below
267 --
268
269 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
270
271 END RG_REPORT_REQUESTS_PKG;