[Home] [Help]
PACKAGE: APPS.GL_STORAGE_PARAMETERS_PKG
Source
1 PACKAGE gl_storage_parameters_pkg AS
2 /* $Header: glistpas.pls 120.6 2005/05/05 01:23:57 kvora ship $ */
3 --
4 -- Package
5 -- gl_storage_parameters_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_storage_parameters_pkg
8 -- History
9 -- 07-19-94 Kai Pigg Created
10
11 --
12 -- Procedure
13 -- check_unique
14 -- Purpose
15 -- Checks to make sure that the storage parameter
16 -- is unique.
17 -- History
18 -- 07-19-94 Kai Pigg Created
19 -- Arguments
20 -- rid The current rowid
21 -- Example
22 -- storage.check_unique();
23 -- Notes
24 --
25 PROCEDURE check_unique(X_object_name VARCHAR2,
26 X_row_id VARCHAR2);
27
28 --
29 -- Procedure
30 -- Insert_Row
31 -- Purpose
32 -- Inserts a row into gl_storage_parameters
33 -- History
34 -- 07-19-94 Kai Pigg Created
35 -- Arguments
36 -- all the columns of the table GL_STORAGE_PARAMETERS
37 -- Example
38 -- gl_storage_parameters_pkg.Insert_Row(....;
39 -- Notes
40 --
41 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
42 X_object_name VARCHAR2,
43 X_last_update_date DATE,
44 X_last_updated_by NUMBER,
45 X_creation_date DATE,
46 X_created_by NUMBER,
47 X_last_update_login NUMBER,
48 X_object_type VARCHAR2,
49 X_tablespace_name VARCHAR2,
50 X_initial_extent_size_kb NUMBER,
51 X_next_extent_size_kb NUMBER,
52 X_max_extents NUMBER,
53 X_pct_increase NUMBER,
54 X_pct_free NUMBER,
55 X_description VARCHAR2);
56
57 --
58 -- Procedure
59 -- Update_Row
60 -- Purpose
61 -- Updates a row into gl_storage_parameters
62 -- History
63 -- 07-19-94 Kai Pigg Created
64 -- Arguments
65 -- all the columns of the table GL_STORAGE_PARAMETERS
66 -- Example
67 -- gl_storage_parameters_pkg.Update_Row(....;
68 -- Notes
69 --
70 PROCEDURE Update_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
71 X_object_name VARCHAR2,
72 X_last_update_date DATE,
73 X_last_updated_by NUMBER,
74 X_creation_date DATE,
75 X_created_by NUMBER,
76 X_last_update_login NUMBER,
77 X_object_type VARCHAR2,
78 X_tablespace_name VARCHAR2,
79 X_initial_extent_size_kb NUMBER,
80 X_next_extent_size_kb NUMBER,
81 X_max_extents NUMBER,
82 X_pct_increase NUMBER,
83 X_pct_free NUMBER,
84 X_description VARCHAR2);
85
86 --
87 -- Procedure
88 -- Lock_Row
89 -- Purpose
90 -- Locks a row into gl_storage_parameters
91 -- History
92 -- 07-19-94 Kai Pigg Created
93 -- Arguments
94 -- all (-who) the columns of the table GL_STORAGE_PARAMETERS
95 -- Example
96 -- gl_storage_parameters_pkg.Lock_Row(....;
97 -- Notes
98 --
99 PROCEDURE Lock_Row ( X_Rowid IN OUT NOCOPY VARCHAR2,
100 X_object_name VARCHAR2,
101 X_object_type VARCHAR2,
102 X_tablespace_name VARCHAR2,
103 X_initial_extent_size_kb NUMBER,
104 X_next_extent_size_kb NUMBER,
105 X_max_extents NUMBER,
106 X_pct_increase NUMBER,
107 X_pct_free NUMBER,
108 X_description VARCHAR2);
109
110 --
111 -- Procedure
112 -- Delete_Row
113 -- Purpose
114 -- Deletes a row from gl_storage_parameters
115 -- History
116 -- 07-19-94 Kai Pigg Created
117 -- Arguments
118 -- x_rowid Rowid of a row
119 -- Example
120 -- gl_storage_parameters.delete_row('001.0000.0000');
121 -- Notes
122 --
123 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
124
125
126 --
127 -- Procedure
128 -- load_row
129 -- Purpose
130 -- called from loader
131 -- update existing data, insert new data
132 -- History
133 -- 07-19-99 A Lal Created
134 -- Arguments
135 -- all the columns of the table GL_STORAGE_PARAMETERS
136 -- Example
137 -- gl_storage_parameters_pkg.load_row(....;
138
139 Procedure load_row(
140 x_object_name in out NOCOPY varchar2,
141 x_object_type in varchar2,
142 x_tablespace_name in varchar2,
143 x_initial_extent_size_kb in number,
144 x_next_extent_size_kb in number,
145 x_max_extents in number,
146 x_pct_increase in number,
147 x_description in varchar2,
148 x_pct_free in number,
149 x_owner in varchar2,
150 x_force_edits in varchar2
151 );
152
153
154 --
155 -- Procedure
156 -- translate_row
157 -- Purpose
158 -- called from loader
159 -- Update translation only.
160 -- History
161 -- 07-19-99 A Lal Created
162 -- Arguments
163 -- object name, description, owner and force_edits
164
165 Procedure translate_row (
166 x_object_name in varchar2,
167 x_description in varchar2,
168 x_owner in varchar2,
169 x_force_edits in varchar2
170 );
171
172 END gl_storage_parameters_pkg;