[Home] [Help]
PACKAGE: APPS.RG_REPORT_DISPLAY_SETS_PKG
Source
1 PACKAGE RG_REPORT_DISPLAY_SETS_PKG AS
2 /* $Header: rgirdpss.pls 120.2 2002/11/14 03:01:15 djogg ship $ */
3 --
4 -- Package
5 -- RG_REPORT_DISPLAY_SETS_PKG
6 -- Purpose
7 -- To create RG_REPORT_DISPLAY_SETS_PKG package.
8 -- History
9 -- 01.12.94 A. Chen Created
10 --
11
12 --
13 -- Procedure
14 -- check_unique
15 -- Purpose
16 -- Ensure new display sets name is unique.
17 -- History
18 -- 01.12.94 A. Chen Created
19 -- Arguments
20 -- X_rowid The ID of the row to be checked
21 -- X_name The display sets name to be checked
22 -- Example
23 -- RG_REPORT_DISPLAY_SETS_PKG.check_unique( '12345', 'Display Set 1' );
24 -- Notes
25 --
26 PROCEDURE check_unique( X_rowid VARCHAR2,
27 X_name VARCHAR2 );
28
29 --
30 -- Procedure
31 -- check_references
32 -- Purpose
33 -- Ensure the object is not used reports
34 -- History
35 -- 01.12.94 A. Chen Created
36 -- Arguments
37 -- X_display_set_id The display set id to be checked
38 -- Example
39 -- RG_REPORT_DISPLAY_SETS_PKG.check_references( '12345' );
40 -- Notes
41 --
42 PROCEDURE check_references(X_report_display_set_id NUMBER);
43
44 --
45 -- Procedure
46 -- check_display_exists
47 -- Purpose
48 -- Check whether a display set has display options.
49 -- History
50 -- 01.12.94 A. Chen Created
51 -- Arguments
52 -- X_display_set_id The display set id to be checked
53 -- Example
54 -- RG_REPORT_DISPLAY_SETS_PKG.check_display_exists( '12345' );
55 -- Notes
56 --
57 FUNCTION check_display_exists(X_report_display_set_id NUMBER)
58 RETURN BOOLEAN;
59
60 --
61 -- Procedure
62 -- check_displays_row_set
63 -- Purpose
64 -- To check whether updating the row set in a display set
65 -- is allowed.
66 -- History
67 -- 01.12.94 A. Chen Created
68 -- Arguments
69 -- X_rowid The rowid of the display set
70 -- X_display_set_id The display set id to be checked
71 -- X_row_set_id_saved The original row set id
72 -- Example
73 -- RG_REPORT_DISPLAY_SETS_PKG.check_displays_row_set(:display_sets.row_id,
74 -- :display_sets.report_display_set_id,
75 -- :display_sets.row_set_id_saved)
76 -- Notes
77 --
78 FUNCTION check_displays_row_set(X_rowid VARCHAR2,
79 X_report_display_set_id NUMBER,
80 X_row_set_id_saved NUMBER)
81 RETURN BOOLEAN;
82
83 --
84 -- PROCEDURE
85 -- check_reports_row_set
86 -- Purpose
87 -- To check whether updating the row set in a display set
88 -- is allowed.
89 -- History
90 -- 01.12.94 A. Chen Created
91 -- Arguments
92 -- X_rowid The rowid of the display set
93 -- X_display_set_id The display set id to be checked
94 -- X_row_set_id The new row set id to be checked
95 -- X_row_set_id_saved The original row set id
96 -- Example
97 -- RG_REPORT_DISPLAY_SETS_PKG.check_reports_row_set(:display_sets.row_id,
98 -- :display_sets.report_display_set_id,
99 -- :display_sets.row_set_id,
100 -- :display_sets.row_set_id_saved)
101 -- Notes
102 --
103 FUNCTION check_reports_row_set(X_rowid VARCHAR2,
104 X_report_display_set_id NUMBER,
105 X_row_set_id NUMBER,
106 X_row_set_id_saved NUMBER)
107 RETURN BOOLEAN;
108
109 --
110 -- Procedure
111 -- check_displays_column_set
112 -- Purpose
113 -- To check whether updating the column set in a display set
114 -- is allowed.
115 -- History
116 -- 01.12.94 A. Chen Created
117 -- Arguments
118 -- X_rowid The rowid of the display set
119 -- X_display_set_id The display set id to be checked
120 -- X_column_set_id_saved The original column set id
121 -- Example
122 -- RG_REPORT_DISPLAY_SETS_PKG.check_displays_column_set(:display_sets.row_id,
123 -- :display_sets.report_display_set_id,
124 -- :display_sets.column_set_id_save)
125 -- Notes
126 --
127 FUNCTION check_displays_column_set(X_rowid VARCHAR2,
128 X_report_display_set_id NUMBER,
129 X_column_set_id_saved NUMBER)
130 RETURN BOOLEAN;
131
132 --
133 -- Procedure
134 -- check_reports_column_set
135 -- Purpose
136 -- To check whether updating the column set in a display set
137 -- is allowed.
138 -- History
139 -- 01.12.94 A. Chen Created
140 -- Arguments
141 -- X_rowid The rowid of the display set
142 -- X_display_set_id The display set id to be checked
143 -- X_column_set_id The new column set id to be checked
144 -- X_column_set_id_saved The original column set id
145 -- Example
146 -- RG_REPORT_DISPLAY_SETS_PKG.check_reports_column_set(:display_sets.row_id,
147 -- :display_sets.report_display_set_id,
148 -- :display_sets.column_set_id,
149 -- :display_sets.column_set_id_save)
150 -- Notes
151 --
152 FUNCTION check_reports_column_set(X_rowid VARCHAR2,
153 X_report_display_set_id NUMBER,
154 X_column_set_id NUMBER,
155 X_column_set_id_saved NUMBER)
156 RETURN BOOLEAN;
157
158 --
159 -- Procedure
160 -- get_unique_id
161 -- Purpose
162 -- Gets a new sequence unique id for a new display sets.
163 -- History
164 -- 01.12.94 A. Chen Created
165 -- Arguments
166 -- none
167 -- Example
168 -- :display_sets.report_display_set_id := RG_REPORT_DISPLAY_SETS_PKG.get_unique_id;
169 -- Notes
170 --
171 FUNCTION get_unique_id RETURN NUMBER;
172
173 -- *********************************************************************
174
175 -- The following procedures are necessary to handle the base view form.
176
177 PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2,
178 X_report_display_set_id NUMBER,
179 X_name VARCHAR2,
180 X_description VARCHAR2,
181 X_row_set_id NUMBER,
182 X_column_set_id NUMBER,
183 X_creation_date DATE,
184 X_created_by NUMBER,
185 X_last_update_date DATE,
186 X_last_updated_by NUMBER,
187 X_last_update_login NUMBER,
188 X_context VARCHAR2,
189 X_attribute1 VARCHAR2,
190 X_attribute2 VARCHAR2,
191 X_attribute3 VARCHAR2,
192 X_attribute4 VARCHAR2,
193 X_attribute5 VARCHAR2,
194 X_attribute6 VARCHAR2,
195 X_attribute7 VARCHAR2,
196 X_attribute8 VARCHAR2,
197 X_attribute9 VARCHAR2,
198 X_attribute10 VARCHAR2,
199 X_attribute11 VARCHAR2,
200 X_attribute12 VARCHAR2,
201 X_attribute13 VARCHAR2,
202 X_attribute14 VARCHAR2,
203 X_attribute15 VARCHAR2
204 );
205
206 PROCEDURE lock_row(X_rowid IN OUT NOCOPY VARCHAR2,
207 X_report_display_set_id NUMBER,
208 X_name VARCHAR2,
209 X_description VARCHAR2,
210 X_row_set_id NUMBER,
211 X_column_set_id NUMBER,
212 X_context VARCHAR2,
213 X_attribute1 VARCHAR2,
214 X_attribute2 VARCHAR2,
215 X_attribute3 VARCHAR2,
216 X_attribute4 VARCHAR2,
217 X_attribute5 VARCHAR2,
218 X_attribute6 VARCHAR2,
219 X_attribute7 VARCHAR2,
220 X_attribute8 VARCHAR2,
221 X_attribute9 VARCHAR2,
222 X_attribute10 VARCHAR2,
223 X_attribute11 VARCHAR2,
224 X_attribute12 VARCHAR2,
225 X_attribute13 VARCHAR2,
226 X_attribute14 VARCHAR2,
227 X_attribute15 VARCHAR2
228 );
229
230 PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2,
231 X_report_display_set_id NUMBER,
232 X_name VARCHAR2,
233 X_description VARCHAR2,
234 X_row_set_id NUMBER,
235 X_column_set_id NUMBER,
236 X_last_update_date DATE,
237 X_last_updated_by NUMBER,
238 X_last_update_login NUMBER,
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 );
256
257 PROCEDURE delete_row(X_rowid VARCHAR2);
258
259 END RG_REPORT_DISPLAY_SETS_PKG;