1 PACKAGE gl_period_types_pkg AS
2 /* $Header: gliprpts.pls 120.6 2005/05/05 01:18:19 kvora ship $ */
3 --
4 -- Package
5 -- gl_period_types_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_period_types
8 -- History
9 -- 11-02-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- select_columns
14 -- Purpose
15 -- Used to select the user_period_type, year_type_in_name, and
16 -- number_per_fiscal_year for a given period type.
17 -- History
18 -- 11-02-93 D. J. Ogg Created
19 -- Arguments
20 -- x_period_type Period Type to be used
21 -- x_user_period_type User name for the period type
22 -- x_year_type_in_name Calendar or Fiscal period
23 -- x_number_per_fiscal_year Number of periods of the given
24 -- type in a fiscal year
25 -- Example
26 -- gl_period_types_pkg.select_columns('Month', user_name, year_type,
27 -- num_per_year)
28 -- Notes
29 --
30 PROCEDURE select_columns(
31 x_period_type IN OUT NOCOPY VARCHAR2,
32 x_user_period_type IN OUT NOCOPY VARCHAR2,
33 x_year_type_in_name IN OUT NOCOPY VARCHAR2,
34 x_number_per_fiscal_year IN OUT NOCOPY NUMBER);
35
36 --
37 -- Procedure
38 -- Check_Unique_User_Type
39 -- Purpose
40 -- Verify user defined period types are unique
41 -- History
42 -- 19-AUG-94 E Wilson
43 -- Arguments
44 -- x_user_period_type User name for the period type
45 -- x_row_id Row id
46 -- Example
47 -- gl_period_types_pkg.check_unique_user_type('Month', <rowid>)
48 -- Notes
49 --
50 PROCEDURE check_unique_user_type(x_user_period_type VARCHAR2,
51 x_rowid VARCHAR2);
52
53 --
54 -- Procedure
55 -- Check_Unique_Type
56 -- Purpose
57 -- Check that sequence value GL_PERIOD_TYPES_S is unique for each new
58 -- period type
59 -- History
60 -- 19-AUG-94 E Wilson Created
61 -- Arguments
62 -- x_period_type System generated Period Type
63 -- x_rowid Rowid
64 -- Example
65 -- gl_period_types_pkg.check_unique_type('Month', <rowid>)
66 -- Notes
67 --
68 PROCEDURE check_unique_type(x_period_type VARCHAR2,
69 x_rowid VARCHAR2);
70
71 --
72 -- Procedure
73 -- get_new_id
74 -- Purpose
75 -- Get unique system value for newly defined period type from seqence
76 -- GL_PERIOD_TYPES_S
77 -- History
78 -- 19-AUG-94 E Wilson Created
79 -- Arguments
80 -- x_period_type System generated Period Type
81 -- x_rowid Rowid
82 -- Example
83 -- gl_period_types_pkg.get_new_id(:PERIOD_TYPES.period_type);
84 -- Notes
85 --
86 PROCEDURE Get_New_Id(x_period_type IN OUT NOCOPY VARCHAR2);
87
88
89
90 --
91 -- Procedure
92 -- translate_row
93 -- Purpose
94 -- called from loader
95 -- Update translation only.
96 -- History
97 -- 07-19-99 A Lal Created
98 -- Arguments
99 -- period_type,user_period_type, description, owner and force_edits
100
101 PROCEDURE TRANSLATE_ROW(
102 x_period_type in varchar2,
103 x_user_period_type in varchar2,
104 x_description in varchar2,
105 x_owner in varchar2,
106 x_force_edits in varchar2 );
107
108 --
109 -- Procedure
110 -- load_row
111 -- Purpose
112 -- called from loader
113 -- update existing data, insert new data
114 -- History
115 -- 07-19-99 A Lal Created
116 -- Arguments
117 -- all the columns of the table GL_PERIOD_TYPES
118 -- Example
119 -- gl_period_types_pkg.load_row(....;
120
121 PROCEDURE LOAD_ROW(
122 x_period_type in varchar2,
123 x_number_per_fiscal_year in number,
124 x_year_type_in_name in varchar2,
125 x_user_period_type in varchar2,
126 x_description in varchar2,
127 x_attribute1 in varchar2,
128 x_attribute2 in varchar2,
129 x_attribute3 in varchar2,
130 x_attribute4 in varchar2,
131 x_attribute5 in varchar2,
132 x_context in varchar2,
133 x_owner in varchar2,
134 x_force_edits in varchar2 default 'N'
135 );
136 --
137 -- Procedure
138 -- update_row
139 -- Purpose
140 -- called from loader
141 -- update existing data
142 -- History
143 -- 07-19-99 A Lal Created
144 -- Arguments
145 -- all the columns of the table GL_PERIOD_TYPES
146 -- Example
147 -- gl_period_types_pkg.update_row(....;
148
149 PROCEDURE UPDATE_ROW(
150 x_row_id in varchar2,
151 x_period_type in varchar2,
152 x_number_per_fiscal_year in number,
153 x_year_type_in_name in varchar2,
154 x_user_period_type in varchar2,
155 x_description in varchar2,
156 x_attribute1 in varchar2,
157 x_attribute2 in varchar2,
158 x_attribute3 in varchar2,
159 x_attribute4 in varchar2,
160 x_attribute5 in varchar2,
161 x_context in varchar2,
162 x_last_update_date in date,
163 x_last_updated_by in number,
164 x_last_update_login in number ,
165 x_creation_date in date
166 );
167
168 --
169 -- Procedure
170 -- insert_row
171 -- Purpose
172 -- called from loader
173 -- History
174 -- 07-19-99 A Lal Created
175 -- Arguments
176 -- all the columns of the table GL_PERIOD_TYPES
177 -- Example
178 -- gl_period_types_pkg.insert_row(....;
179
180 PROCEDURE INSERT_ROW(
181 x_row_id in out NOCOPY varchar2,
182 x_period_type in varchar2,
183 x_number_per_fiscal_year in number,
184 x_year_type_in_name in varchar2,
185 x_user_period_type in varchar2,
186 x_description in varchar2,
187 x_attribute1 in varchar2,
188 x_attribute2 in varchar2,
189 x_attribute3 in varchar2,
190 x_attribute4 in varchar2,
191 x_attribute5 in varchar2,
192 x_context in varchar2,
193 x_last_update_date in date,
194 x_last_updated_by in number,
195 x_last_update_login in number ,
196 x_creation_date in date,
197 x_created_by in number
198 );
199
200 --
201 -- Procedure
202 -- checkUpdate
203 -- Purpose
204 -- called from iSpeed calendar api
205 -- History
206 -- 11-01-00 A Lal Created
207 -- Arguments
208 -- all the columns of the table GL_PERIOD_TYPES
209 -- Example
210 -- gl_period_types_pkg.checkUpdate(....;
211
212 procedure checkUpdate(
213 mReturnValue OUT NOCOPY VARCHAR2
214 ,mPeriodType IN VARCHAR2
215 ,mNumberPerFiscalYear IN VARCHAR2
216 ,mYearTypeInName IN VARCHAR2
217 ) ;
218
219
220 END gl_period_types_pkg;