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