[Home] [Help]
PACKAGE: APPS.GL_DAILY_CONV_TYPES_PKG
Source
1 PACKAGE GL_DAILY_CONV_TYPES_PKG AS
2 /* $Header: glirtcts.pls 120.4 2005/05/05 01:20:59 kvora ship $ */
3 --
4 -- Package
5 -- gl_daily_conversion_types
6 -- Purpose
7 -- Package of procedures for Define Daily Conversion Rate Types form
8 -- History
9 -- 10/27/93 E Wilson Created
10 -- 07/16/99 S Kung Added Insert_Row, Update_Row,
11 -- Load_Row and Translate_Row
12 --
13
14 --
15 -- Procedure
16 -- select_columns
17 -- Purpose
18 -- Used to select the user name for a given conversion type
19 -- History
20 -- 12-21-93 D. J. Ogg Created
21 -- Arguments
22 -- x_conversion_type The conversion type to use
23 -- x_user_conversion_type The user name for the conversion type
24 -- Example
25 -- gl_daily_conv_types_pkg.select_columns('User', user_name);
26 -- Notes
27 --
28 PROCEDURE select_columns(
29 x_conversion_type VARCHAR2,
30 x_user_conversion_type IN OUT NOCOPY VARCHAR2);
31
32 --
33 -- Procedure
34 -- check_unique_type
35 -- Purpose
36 -- Check for uniqueness of conversion type
37 -- Arguments
38 -- conversion_type Conversion type
39 -- x_rowid row id
40 -- Example
41 -- daily_rate_type.check_unique_type(
42 -- :DAILY_RATE_TYPE.conversion_type,
43 -- :DAILY_RATE_TYPE.rowid);
44 -- Notes
45 -- Conversion type is determined by a sequence (see Get_New_Id)
46 PROCEDURE check_unique_type(conversion_type VARCHAR2,
47 x_rowid VARCHAR2);
48
49 --
50 -- Function
51 -- check_unique_user_type
52 -- Purpose
53 -- Check for uniqueness of user entered conversion type
54 -- Arguments
55 -- user_conversion_type User entered conversion type
56 -- x_rowid row id
57 -- Example
58 -- daily_rate_type.check_unique_user_type(
59 -- :DAILY_RATE_TYPE.user_conversion_type,
60 -- :DAILY_RATE_TYPE.rowid);
61 -- Notes
62 --
63 PROCEDURE check_unique_user_type(user_conversion_type VARCHAR2,
64 x_rowid VARCHAR2);
65
66 --
67 -- Procedure
68 -- Get_New_Id
69 -- Purpose
70 -- Get next value from GL_DAILY_CONVERSION_TYPES_S
71 -- Arguments
72 -- next_val Return next value in sequence
73 -- Example
74 -- GL_DAILY_CONVERSION_TYPES_PKG.(:DAILY_RATE_TYPES.conversion_type)
75 -- Notes
76 --
77 PROCEDURE Get_New_Id(next_val IN OUT NOCOPY VARCHAR2);
78
79
80 --
81 -- Procedure
82 -- Insert_Row
83 -- Purpose
84 -- Inserts a row into gl_daily_conversion_types
85 -- History
86 -- 07/16/99 S Kung Created
87 -- 07/15/2003 P Sahay Added X_Security_Flag
88 -- Arguments
89 -- all the columns of the table GL_DAILY_CONVERSION_TYPES
90 -- Example
91 -- gl_daily_conv_types_pkg.Insert_Row(....;
92 -- Notes
93 --
94 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
95 X_Conversion_Type VARCHAR2,
96 X_User_Conversion_Type VARCHAR2,
97 X_Last_Update_Date DATE,
98 X_Last_Updated_By NUMBER,
99 X_Creation_Date DATE,
100 X_Created_By NUMBER,
101 X_Last_Update_Login NUMBER,
102 X_Description VARCHAR2,
103 X_Attribute1 VARCHAR2,
104 X_Attribute2 VARCHAR2,
105 X_Attribute3 VARCHAR2,
106 X_Attribute4 VARCHAR2,
107 X_Attribute5 VARCHAR2,
108 X_Attribute6 VARCHAR2,
109 X_Attribute7 VARCHAR2,
110 X_Attribute8 VARCHAR2,
111 X_Attribute9 VARCHAR2,
112 X_Attribute10 VARCHAR2,
113 X_Attribute11 VARCHAR2,
114 X_Attribute12 VARCHAR2,
115 X_Attribute13 VARCHAR2,
116 X_Attribute14 VARCHAR2,
117 X_Attribute15 VARCHAR2,
118 X_Context VARCHAR2,
119 X_Security_Flag VARCHAR2);
120
121 --
122 -- Procedure
123 -- Lock_Row
124 -- Purpose
125 -- Locks a row of gl_daily_conversion_types
126 -- History
127 -- 07/15/2003 P Sahay Created
128 -- Arguments
129 -- all the columns of the table GL_DAILY_CONVERSION_TYPES (except WHO columns)
130 -- Example
131 -- gl_daily_conv_types_pkg.Lock_Row(....;
132 -- Notes
133 --
134 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
135 X_Conversion_Type VARCHAR2,
136 X_User_Conversion_Type VARCHAR2,
137 X_Description VARCHAR2,
138 X_Attribute1 VARCHAR2,
139 X_Attribute2 VARCHAR2,
140 X_Attribute3 VARCHAR2,
141 X_Attribute4 VARCHAR2,
142 X_Attribute5 VARCHAR2,
143 X_Attribute6 VARCHAR2,
144 X_Attribute7 VARCHAR2,
145 X_Attribute8 VARCHAR2,
146 X_Attribute9 VARCHAR2,
147 X_Attribute10 VARCHAR2,
148 X_Attribute11 VARCHAR2,
149 X_Attribute12 VARCHAR2,
150 X_Attribute13 VARCHAR2,
151 X_Attribute14 VARCHAR2,
152 X_Attribute15 VARCHAR2,
153 X_Context VARCHAR2,
154 X_Security_Flag VARCHAR2);
155
156 --
157 -- Procedure
158 -- Update_Row
159 -- Purpose
160 -- Updates a row in gl_daily_conversion_types
161 -- History
162 -- 07/16/99 S Kung Created
163 -- 07/15/2003 P Sahay Added X_Security_Flag
164 -- Arguments
165 -- all the columns of the table GL_DAILY_CONVERSION_TYPES
166 -- Example
167 -- gl_daily_conv_types_pkg.Update_Row(....;
168 -- Notes
169 --
170 PROCEDURE Update_Row(X_Conversion_Type VARCHAR2,
171 X_User_Conversion_Type VARCHAR2,
172 X_Last_Update_Date DATE,
173 X_Last_Updated_By NUMBER,
174 X_Last_Update_Login NUMBER,
175 X_Description VARCHAR2,
176 X_Attribute1 VARCHAR2,
177 X_Attribute2 VARCHAR2,
178 X_Attribute3 VARCHAR2,
179 X_Attribute4 VARCHAR2,
180 X_Attribute5 VARCHAR2,
181 X_Attribute6 VARCHAR2,
182 X_Attribute7 VARCHAR2,
183 X_Attribute8 VARCHAR2,
184 X_Attribute9 VARCHAR2,
185 X_Attribute10 VARCHAR2,
186 X_Attribute11 VARCHAR2,
187 X_Attribute12 VARCHAR2,
188 X_Attribute13 VARCHAR2,
189 X_Attribute14 VARCHAR2,
190 X_Attribute15 VARCHAR2,
191 X_Context VARCHAR2,
192 X_Security_Flag VARCHAR2);
193
194 --
195 -- Procedure
196 -- Load_Row
197 -- Purpose
198 -- Called from loader config file to upload a multi-lingual entity
199 -- History
200 -- 07/19/99 S Kung Created
201 -- Arguments
202 -- all the columns of the table GL_DAILY_CONVERSION_TYPES
203 -- Example
204 -- gl_daily_conv_types_pkg.Load_Row(....;
205 -- Notes
206 --
207 PROCEDURE Load_Row(
208 V_Conversion_Type VARCHAR2,
209 V_User_Conversion_Type VARCHAR2,
210 V_Description VARCHAR2,
211 V_Attribute1 VARCHAR2,
212 V_Attribute2 VARCHAR2,
213 V_Attribute3 VARCHAR2,
214 V_Attribute4 VARCHAR2,
215 V_Attribute5 VARCHAR2,
216 V_Attribute6 VARCHAR2,
217 V_Attribute7 VARCHAR2,
218 V_Attribute8 VARCHAR2,
219 V_Attribute9 VARCHAR2,
220 V_Attribute10 VARCHAR2,
221 V_Attribute11 VARCHAR2,
222 V_Attribute12 VARCHAR2,
223 V_Attribute13 VARCHAR2,
224 V_Attribute14 VARCHAR2,
225 V_Attribute15 VARCHAR2,
226 V_Context VARCHAR2,
227 V_Owner VARCHAR2,
228 V_Force_Edits VARCHAR2);
229
230 --
231 -- Procedure
232 -- Translate_Row
233 -- Purpose
234 -- Called from loader config to upload translation
235 -- History
236 -- 07/19/99 S Kung Created
237 -- Arguments
238 -- V_Conversion_Type Conversion Type name
239 -- V_User_Conversion_Type Conversion Type user name
240 -- V_Description Conversion Type description
241 -- V_Owner Can be 'SEED' or other values
242 -- V_Force_Edits Force update to be performed
243 -- Example
244 -- gl_daily_conv_types_pkg.Translate_Row(....;
245 -- Notes
246 --
247 PROCEDURE Translate_Row(
248 V_Conversion_Type VARCHAR2,
249 V_User_Conversion_Type VARCHAR2,
250 V_Description VARCHAR2,
251 V_Owner VARCHAR2,
252 V_Force_Edits VARCHAR2);
253
254
255 end GL_DAILY_CONV_TYPES_PKG;