[Home] [Help]
PACKAGE: APPS.RG_REPORT_AXIS_SETS_PKG
Source
1 PACKAGE RG_REPORT_AXIS_SETS_PKG AS
2 /* $Header: rgiraxss.pls 120.7 2004/07/16 18:30:06 ticheng ship $ */
3 --
4 -- Name
5 -- rg_report_axis_sets_pkg
6 -- Purpose
7 -- to include all server side procedures and packages for table
8 -- rg_report_axis_sets
9 -- Notes
10 --
11 -- History
12 -- 11/01/93 A Chen Created
13 --
14 --
15 -- Procedures
16
17 -- Name
18 -- update_structure_info
19 -- Purpose
20 -- update id_flex_code and structure_id for a axis set
21 -- Arguments
22 -- X_axis_set_id axis set id
23 -- X_id_flex_code id flex code
24 -- X_structure_id structure_id or chart of accounts id
25 --
26 PROCEDURE update_structure_info(X_axis_set_id NUMBER,
27 X_id_flex_code VARCHAR2,
28 X_structure_id NUMBER);
29
30 -- Name
31 -- check_unique
32 -- Purpose
33 -- unique check for name
34 -- Arguments
35 -- X_rowid rowid
36 -- X_name row set name or column set name
37 -- X_axis_set_type 'R' or 'C'
38 -- X_application_id application_id
39 --
40 -- Returns
41 -- TRUE if unique
42 -- FALSE if not unique
43 --
44 FUNCTION check_unique(X_rowid VARCHAR2,
45 X_name VARCHAR2,
46 X_axis_set_type VARCHAR2,
47 X_application_id NUMBER) RETURN BOOLEAN;
48
49 -- Name
50 -- check_references
51 -- Purpose
52 -- Referential integrity check on rg_report_axis_sets
53 -- Arguments
54 -- X_axis_set_id
55 -- X_axis_set_type 'R' or 'C'
56 --
57 PROCEDURE check_references(X_axis_set_id NUMBER,
58 X_axis_set_type VARCHAR2);
59
60 -- Name
61 -- get_nextval
62 -- Purpose
63 -- Retrieves next value for axis_set_id from
64 -- rg_report_axis_sets_s
65 -- Arguments
66 -- None.
67 --
68 FUNCTION get_nextval RETURN NUMBER;
69
70 -- *********************************************************************
71 -- The following procedures are necessary to handle the base view form.
72
73 PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2,
74 X_application_id NUMBER,
75 X_axis_set_id IN OUT NOCOPY NUMBER,
76 X_name VARCHAR2,
77 X_axis_set_type VARCHAR2,
78 X_security_flag VARCHAR2,
79 X_display_in_list_flag VARCHAR2,
80 X_period_set_name VARCHAR2,
81 X_description VARCHAR2,
82 X_column_set_header VARCHAR2,
83 X_segment_name VARCHAR2,
84 X_id_flex_code VARCHAR2,
85 X_structure_id NUMBER,
86 X_creation_date DATE,
87 X_created_by NUMBER,
88 X_last_update_date DATE,
89 X_last_updated_by NUMBER,
90 X_last_update_login NUMBER,
91 X_context VARCHAR2,
92 X_attribute1 VARCHAR2,
93 X_attribute2 VARCHAR2,
94 X_attribute3 VARCHAR2,
95 X_attribute4 VARCHAR2,
96 X_attribute5 VARCHAR2,
97 X_attribute6 VARCHAR2,
98 X_attribute7 VARCHAR2,
99 X_attribute8 VARCHAR2,
100 X_attribute9 VARCHAR2,
101 X_attribute10 VARCHAR2,
102 X_attribute11 VARCHAR2,
103 X_attribute12 VARCHAR2,
104 X_attribute13 VARCHAR2,
105 X_attribute14 VARCHAR2,
106 X_attribute15 VARCHAR2,
107 X_taxonomy_id NUMBER
108 );
109
110 PROCEDURE lock_row(X_rowid VARCHAR2,
111 X_application_id NUMBER,
112 X_axis_set_id NUMBER,
113 X_name VARCHAR2,
114 X_axis_set_type VARCHAR2,
115 X_security_flag VARCHAR2,
116 X_display_in_list_flag VARCHAR2,
117 X_period_set_name VARCHAR2,
118 X_description VARCHAR2,
119 X_column_set_header VARCHAR2,
120 X_segment_name VARCHAR2,
121 X_id_flex_code VARCHAR2,
122 X_structure_id NUMBER,
123 X_context VARCHAR2,
124 X_attribute1 VARCHAR2,
125 X_attribute2 VARCHAR2,
126 X_attribute3 VARCHAR2,
127 X_attribute4 VARCHAR2,
128 X_attribute5 VARCHAR2,
129 X_attribute6 VARCHAR2,
130 X_attribute7 VARCHAR2,
131 X_attribute8 VARCHAR2,
132 X_attribute9 VARCHAR2,
133 X_attribute10 VARCHAR2,
134 X_attribute11 VARCHAR2,
135 X_attribute12 VARCHAR2,
136 X_attribute13 VARCHAR2,
137 X_attribute14 VARCHAR2,
138 X_attribute15 VARCHAR2,
139 X_taxonomy_id NUMBER
140 );
141
142 PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2,
143 X_application_id NUMBER,
144 X_axis_set_id NUMBER,
145 X_name VARCHAR2,
146 X_axis_set_type VARCHAR2,
147 X_security_flag VARCHAR2,
148 X_display_in_list_flag VARCHAR2,
149 X_period_set_name VARCHAR2,
150 X_description VARCHAR2,
151 X_column_set_header VARCHAR2,
152 X_segment_name VARCHAR2,
153 X_id_flex_code VARCHAR2,
154 X_structure_id NUMBER,
155 X_last_update_date DATE,
156 X_last_updated_by NUMBER,
157 X_last_update_login NUMBER,
158 X_context VARCHAR2,
159 X_attribute1 VARCHAR2,
160 X_attribute2 VARCHAR2,
161 X_attribute3 VARCHAR2,
162 X_attribute4 VARCHAR2,
163 X_attribute5 VARCHAR2,
164 X_attribute6 VARCHAR2,
165 X_attribute7 VARCHAR2,
166 X_attribute8 VARCHAR2,
167 X_attribute9 VARCHAR2,
168 X_attribute10 VARCHAR2,
169 X_attribute11 VARCHAR2,
170 X_attribute12 VARCHAR2,
171 X_attribute13 VARCHAR2,
172 X_attribute14 VARCHAR2,
173 X_attribute15 VARCHAR2,
174 X_taxonomy_id NUMBER
175 );
176
177 PROCEDURE delete_row(X_rowid VARCHAR2,
178 X_axis_set_id NUMBER);
179
180 PROCEDURE Load_Row (
181 X_Application_Id NUMBER,
182 X_Seeded_Name VARCHAR2,
183 X_Name VARCHAR2,
184 X_Axis_Set_Type VARCHAR2,
185 X_Display_In_List_Flag VARCHAR2,
186 X_Description VARCHAR2,
187 X_Column_Set_Header VARCHAR2,
188 X_Segment_Name VARCHAR2,
189 X_Id_Flex_Code VARCHAR2,
190 X_Structure_Id NUMBER,
191 X_Context VARCHAR2,
192 X_Attribute1 VARCHAR2,
193 X_Attribute2 VARCHAR2,
194 X_Attribute3 VARCHAR2,
195 X_Attribute4 VARCHAR2,
196 X_Attribute5 VARCHAR2,
197 X_Attribute6 VARCHAR2,
198 X_Attribute7 VARCHAR2,
199 X_Attribute8 VARCHAR2,
200 X_Attribute9 VARCHAR2,
201 X_Attribute10 VARCHAR2,
202 X_Attribute11 VARCHAR2,
203 X_Attribute12 VARCHAR2,
204 X_Attribute13 VARCHAR2,
205 X_Attribute14 VARCHAR2,
206 X_Attribute15 VARCHAR2,
207 X_Owner VARCHAR2,
208 X_Force_Edits VARCHAR2
209 );
210
211 PROCEDURE Translate_Row (
212 X_Name VARCHAR2,
213 X_Description VARCHAR2,
214 X_Seeded_Name VARCHAR2,
215 X_Owner VARCHAR2,
216 X_Force_Edits VARCHAR2
217 );
218
219 END RG_REPORT_AXIS_SETS_PKG;