1 PACKAGE JMF_GTA_TRX_LINES_ALL_PKG AS
2 --$Header: JMFUGLAS.pls 120.0.12000000.2 2007/06/18 19:17:05 yawang ship $
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JMFUGLAS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package provides table handers for |
13 --| table JMF_GTA_TRX_LINES_ALL,these handlers |
14 --| will be called by 'Golden Tax Workbench' form and 'Golden Tax |
15 --| invoie import' program to operate data in table |
16 --| JMF_GTA_TRX_LINES_ALL |
17 --| |
18 --| HISTORY |
19 --| 05/17/05 Donghai Wang Created |
20 --| 06/18/07 Donghai Wang Update G_MODULE_PREFIX to follow |
21 --| FND log standard |
22 --+======================================================================*/
23
24 --Declare global variable for package name
25 G_MODULE_PREFIX VARCHAR2(50) :='jmf.plsql.JMF_GTA_TRX_LINES_ALL_PKG';
26
27 --==========================================================================
28 -- PROCEDURE NAME:
29 --
30 -- Insert_Row Public
31 --
32 -- DESCRIPTION:
33 --
34 -- This procedure is to insert data that are passed in by parameters into
35 -- table JMF_GTA_TRX_LINES_ALL to create a new record
36 --
37 -- PARAMETERS:
38 -- In: p_org_id Identifier of operating unit
39 -- p_gta_trx_header_id Identifier of GTA invoice header
40 -- p_gta_trx_line_id Identifier of GTA invoice line
41 -- p_matched_flag A flag to identify if a GT line
42 -- can match GTA line
43 -- p_line_number Line number
44 -- p_ar_trx_line_id Identifier of AR transaction lines
45 -- p_inventory_item_id Identifier of Item
46 -- p_item_number Item number
47 -- p_item_description Item description
48 -- p_item_model Item Model
49 -- p_item_tax_denomination Tax denomination for a item
50 -- p_tax_rate Tax rate
51 -- p_uom Unit of measure
52 -- p_uom_name Name for unit of measure
53 -- p_quantity Quantity
54 -- p_price_flag Flag to identify if unit procie with tax
55 -- p_unit_price Unit price without tax
56 -- p_unit_tax_price Unit price with tax
57 -- p_amount Amount without tax
58 -- p_original_currency_amount Amount without tax in original
59 -- curency code of invoice
60 -- p_tax_amount Amount with tax
61 -- p_discount_flag A flag to identify amount of
62 -- invoice line with discount or not
63 -- p_enabled_flag A flag to indicate if the line should
64 -- be imported to GT system
65 -- p_request_id Conc request id
66 -- p_program_application_id Program application id
67 -- p_program_id Program id
68 -- p_program_update_date Program update date
69 -- p_attribute_category Attribute category of
70 -- descriptive flexfield
71 -- p_attribute1 Attribute1
72 -- p_attribute2 Attribute2
73 -- p_attribute3 Attribute3
74 -- p_attribute4 Attribute4
75 -- p_attribute5 Attribute5
76 -- p_attribute6 Attribute6
77 -- p_attribute7 Attribute7
78 -- p_attribute8 Attribute8
79 -- p_attribute9 Attribute9
80 -- p_attribute10 Attribute10
81 -- p_attribute11 Attribute11
82 -- p_attribute12 Attribute12
83 -- p_attribute13 Attribute13
84 -- p_attribute14 Attribute14
85 -- p_attribute15 Attribute15
86 -- p_creation_date Creation date
87 -- p_created_by Identifier of user that creates
88 -- the record
89 -- p_last_update_date Last update date of the record
90 -- p_last_updated_by Last update by
91 -- p_last_update_login Last update login
92 --
93 -- In Out: p_row_id Row id of a table record
94 --
95 --
96 -- DESIGN REFERENCES:
97 -- GTA_Workbench_Form_TD.doc
98 --
99 -- CHANGE HISTORY:
100 --
101 -- 17-MAY-2005 Donghai Wang created
102 --
103 --===========================================================================
104 PROCEDURE Insert_Row
105 (p_rowid IN OUT NOCOPY VARCHAR2
106 ,p_org_id IN NUMBER
107 ,p_gta_trx_header_id IN NUMBER
108 ,p_gta_trx_line_id IN NUMBER
109 ,p_matched_flag IN VARCHAR2
110 ,p_line_number IN VARCHAR2
111 ,p_ar_trx_line_id IN NUMBER
112 ,p_inventory_item_id IN NUMBER
113 ,p_item_number IN VARCHAR2
114 ,p_item_description IN VARCHAR2
115 ,p_item_model IN VARCHAR2
116 ,p_item_tax_denomination IN VARCHAR2
117 ,p_tax_rate IN NUMBER
118 ,p_uom IN VARCHAR2
119 ,p_uom_name IN VARCHAR2
120 ,p_quantity IN NUMBER
121 ,p_price_flag IN VARCHAR2
122 ,p_unit_price IN NUMBER
123 ,p_unit_tax_price IN NUMBER
124 ,p_amount IN NUMBER
125 ,p_original_currency_amount IN NUMBER
126 ,p_tax_amount IN NUMBER
127 ,p_discount_flag IN VARCHAR2
128 ,p_enabled_flag IN VARCHAR2
129 ,p_request_id IN NUMBER
130 ,p_program_application_id IN NUMBER
131 ,p_program_id IN NUMBER
132 ,p_program_update_date IN DATE
133 ,p_attribute_category IN VARCHAR2
134 ,p_attribute1 IN VARCHAR2
135 ,p_attribute2 IN VARCHAR2
136 ,p_attribute3 IN VARCHAR2
137 ,p_attribute4 IN VARCHAR2
138 ,p_attribute5 IN VARCHAR2
139 ,p_attribute6 IN VARCHAR2
140 ,p_attribute7 IN VARCHAR2
141 ,p_attribute8 IN VARCHAR2
142 ,p_attribute9 IN VARCHAR2
143 ,p_attribute10 IN VARCHAR2
144 ,p_attribute11 IN VARCHAR2
145 ,p_attribute12 IN VARCHAR2
146 ,p_attribute13 IN VARCHAR2
147 ,p_attribute14 IN VARCHAR2
148 ,p_attribute15 IN VARCHAR2
149 ,p_creation_date IN DATE
150 ,p_created_by IN NUMBER
151 ,p_last_update_date IN DATE
152 ,p_last_updated_by IN NUMBER
153 ,p_last_update_login IN NUMBER
154 );
155
156 --==========================================================================
157 -- PROCEDURE NAME:
158 --
159 -- Update_Row Public
160 --
161 -- DESCRIPTION:
162 --
163 -- This procedure is used to update data in table JMF_GTA_TRX_LINES_ALL
164 -- according to parameters passed in
165 --
166 -- PARAMETERS:
167 -- In: p_org_id Identifier of operating unit
168 -- p_gta_trx_header_id Identifier of GTA invoice header
169 -- p_gta_trx_line_id Identifier of GTA invoice line
170 -- p_line_number Line number
171 -- p_item_number Item number
172 -- p_item_description Item description
173 -- p_item_model Item Model
174 -- p_item_tax_denomination Tax denomination for a item
175 -- p_tax_rate Tax rate
176 -- p_uom_name Name for unit of measure
177 -- p_quantity Quantity
178 -- p_unit_price Unit price without tax
179 -- p_amount Amount without tax
180 -- p_original_currency_amount Amount without tax in original
181 -- curency code of invoice
182 -- p_enabled_flag A flag to indicate if the line should
183 -- be imported to GT system
184 -- p_request_id Conc request id
185 -- p_program_application_id Program application id
186 -- p_program_id Program id
187 -- p_program_update_date Program update date
188 -- p_attribute_category Attribute category of
189 -- descriptive flexfield
190 -- p_attribute1 Attribute1
191 -- p_attribute2 Attribute2
192 -- p_attribute3 Attribute3
193 -- p_attribute4 Attribute4
194 -- p_attribute5 Attribute5
195 -- p_attribute6 Attribute6
196 -- p_attribute7 Attribute7
197 -- p_attribute8 Attribute8
198 -- p_attribute9 Attribute9
199 -- p_attribute10 Attribute10
200 -- p_attribute11 Attribute11
201 -- p_attribute12 Attribute12
202 -- p_attribute13 Attribute13
203 -- p_attribute14 Attribute14
204 -- p_attribute15 Attribute15
205 -- p_creation_date Creation date
206 -- p_created_by Identifier of user that creates
207 -- the record
208 -- p_last_update_date Last update date of the record
209 -- p_last_updated_by Last update by
210 -- p_last_update_login Last update login
211 --
212 -- In Out: p_row_id Row id of a table record
213 --
214 --
215 -- DESIGN REFERENCES:
216 -- GTA_Workbench_Form_TD.doc
217 --
218 -- CHANGE HISTORY:
219 --
220 -- 17-MAY-2005 Donghai Wang created
221 --
222 --===========================================================================
223 PROCEDURE Update_Row
224 (p_rowid IN OUT NOCOPY VARCHAR2
225 ,p_org_id IN NUMBER
226 ,p_gta_trx_header_id IN NUMBER
227 ,p_gta_trx_line_id IN NUMBER
228 ,p_line_number IN VARCHAR2
229 ,p_item_number IN VARCHAR2
230 ,p_item_description IN VARCHAR2
231 ,p_item_model IN VARCHAR2
235 ,p_quantity IN NUMBER
232 ,p_item_tax_denomination IN VARCHAR2
233 ,p_tax_rate IN NUMBER
234 ,p_uom_name IN VARCHAR2
236 ,p_unit_price IN NUMBER
237 ,p_amount IN NUMBER
238 ,p_original_currency_amount IN NUMBER
239 ,p_enabled_flag IN VARCHAR2
240 ,p_request_id IN NUMBER
241 ,p_program_application_id IN NUMBER
242 ,p_program_id IN NUMBER
243 ,p_program_update_date IN DATE
244 ,p_attribute_category IN VARCHAR2
245 ,p_attribute1 IN VARCHAR2
246 ,p_attribute2 IN VARCHAR2
247 ,p_attribute3 IN VARCHAR2
248 ,p_attribute4 IN VARCHAR2
249 ,p_attribute5 IN VARCHAR2
250 ,p_attribute6 IN VARCHAR2
251 ,p_attribute7 IN VARCHAR2
252 ,p_attribute8 IN VARCHAR2
253 ,p_attribute9 IN VARCHAR2
254 ,p_attribute10 IN VARCHAR2
255 ,p_attribute11 IN VARCHAR2
256 ,p_attribute12 IN VARCHAR2
257 ,p_attribute13 IN VARCHAR2
258 ,p_attribute14 IN VARCHAR2
259 ,p_attribute15 IN VARCHAR2
260 ,p_creation_date IN DATE
261 ,p_created_by IN NUMBER
262 ,p_last_update_date IN DATE
263 ,p_last_updated_by IN NUMBER
264 ,p_last_update_login IN NUMBER
265 );
266
267
268 --==========================================================================
269 -- PROCEDURE NAME:
270 --
271 -- Lock_Row Public
272 --
273 -- DESCRIPTION:
274 --
275 -- This procedure is used to update implement lock on row level on table
276 -- JMF_GTA_TRX_LINES_ALL
277 --
278 -- PARAMETERS:
279 -- In: p_org_id Identifier of operating unit
280 -- p_gta_trx_header_id Identifier of GTA invoice header
281 -- p_gta_trx_line_id Identifier of GTA invoice line
282 -- p_line_number Line number
283 -- p_item_number Item number
284 -- p_item_description Item description
285 -- p_item_model Item Model
286 -- p_item_tax_denomination Tax denomination for a item
287 -- p_tax_rate Tax rate
288 -- p_uom_name Name for unit of measure
289 -- p_quantity Quantity
290 -- p_unit_price Unit price without tax
291 -- p_amount Amount without tax
292 -- p_original_currency_amount Amount without tax in original
293 -- curency code of invoice
294 -- p_enabled_flag A flag to indicate if the line should
295 -- be imported to GT system
296 -- p_request_id Conc request id
297 -- p_program_application_id Program application id
298 -- p_program_id Program id
299 -- p_program_update_date Program update date
300 -- p_attribute_category Attribute category of
301 -- descriptive flexfield
302 -- p_attribute1 Attribute1
303 -- p_attribute2 Attribute2
304 -- p_attribute3 Attribute3
305 -- p_attribute4 Attribute4
306 -- p_attribute5 Attribute5
307 -- p_attribute6 Attribute6
308 -- p_attribute7 Attribute7
309 -- p_attribute8 Attribute8
310 -- p_attribute9 Attribute9
311 -- p_attribute10 Attribute10
312 -- p_attribute11 Attribute11
313 -- p_attribute12 Attribute12
314 -- p_attribute13 Attribute13
315 -- p_attribute14 Attribute14
316 -- p_attribute15 Attribute15
317 -- p_creation_date Creation date
318 -- p_created_by Identifier of user that creates
319 -- the record
320 -- p_last_update_date Last update date of the record
321 -- p_last_updated_by Last update by
322 -- p_last_update_login Last update login
323 --
324 -- In Out: p_row_id Row id of a table record
325 --
326 --
327 -- DESIGN REFERENCES:
328 -- GTA_Workbench_Form_TD.doc
329 --
330 -- CHANGE HISTORY:
331 --
332 -- 17-MAY-2005 Donghai Wang created
333 --
334 --=========================================================================
335 PROCEDURE Lock_Row
336 (p_rowid IN OUT NOCOPY VARCHAR2
337 ,p_org_id IN NUMBER
338 ,p_gta_trx_header_id IN NUMBER
339 ,p_gta_trx_line_id IN NUMBER
340 ,p_line_number IN VARCHAR2
341 ,p_item_number IN VARCHAR2
342 ,p_item_description IN VARCHAR2
343 ,p_item_model IN VARCHAR2
344 ,p_item_tax_denomination IN VARCHAR2
345 ,p_tax_rate IN NUMBER
346 ,p_uom_name IN VARCHAR2
347 ,p_quantity IN NUMBER
348 ,p_unit_price IN NUMBER
349 ,p_amount IN NUMBER
353 ,p_program_application_id IN NUMBER
350 ,p_original_currency_amount IN NUMBER
351 ,p_enabled_flag IN VARCHAR2
352 ,p_request_id IN NUMBER
354 ,p_program_id IN NUMBER
355 ,p_program_update_date IN DATE
356 ,p_attribute_category IN VARCHAR2
357 ,p_attribute1 IN VARCHAR2
358 ,p_attribute2 IN VARCHAR2
359 ,p_attribute3 IN VARCHAR2
360 ,p_attribute4 IN VARCHAR2
361 ,p_attribute5 IN VARCHAR2
362 ,p_attribute6 IN VARCHAR2
363 ,p_attribute7 IN VARCHAR2
364 ,p_attribute8 IN VARCHAR2
365 ,p_attribute9 IN VARCHAR2
366 ,p_attribute10 IN VARCHAR2
367 ,p_attribute11 IN VARCHAR2
368 ,p_attribute12 IN VARCHAR2
369 ,p_attribute13 IN VARCHAR2
370 ,p_attribute14 IN VARCHAR2
371 ,p_attribute15 IN VARCHAR2
372 ,p_creation_date IN DATE
373 ,p_created_by IN NUMBER
374 ,p_last_update_date IN DATE
375 ,p_last_updated_by IN NUMBER
376 ,p_last_update_login IN NUMBER
377 );
378
379 --==========================================================================
380 -- PROCEDURE NAME:
381 --
382 -- Delete_Row Public
383 --
384 -- DESCRIPTION:
385 --
386 -- This procedure is used to delete record from table
387 -- JMF_GTA_TRX_LINES_ALL
388 --
389 -- PARAMETERS:
390 --
391 -- In Out: p_row_id Row id of a table record
392 --
393 --
394 -- DESIGN REFERENCES:
395 -- GTA_Workbench_Form_TD.doc
396 --
397 -- CHANGE HISTORY:
398 --
399 -- 17-MAY-2005 Donghai Wang created
400 --
404 );
401 --===========================================================================
402 PROCEDURE Delete_Row
403 (p_rowid IN OUT NOCOPY VARCHAR2
405
406 END JMF_GTA_TRX_LINES_ALL_PKG;
407