[Home] [Help]
215: 2. 2001/06/22 Anuradha Parthasarathy
216: Commented and Added code for better performance.
217:
218: 3. 2002/03/22 RPK
219: added the column error_flag to the table 'JAI_AR_TRX_INS_LINES_T'
220: added the cursor trx_num to get the invoice num.
221:
222: 4 2002/04/22 RPK
223: BUG#2334972.
221:
222: 4 2002/04/22 RPK
223: BUG#2334972.
224: Code modified to allow the taxes to be inserted into
225: the table JAI_AR_TRX_INS_LINES_T.When an order line is having 2 tax amounts
226: one with a positive value and the other with a negative value(eg:100 and -100)
227: then these lines were not getting transferred to AR Tables and the same is
228: required to be transferred to have the proper accounting of the GL/AR.For this,
229: the when_clause of this trigger is commented to facilitate the execution of this
236: 6. 2002/05/06 Added the Source Column in the insert statement of Ja-In_temp_lines_insert
237: table.
238:
239: 8. 2003/04/07 SSUMAITH.Bug # 2779967
240: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
241: inserted in the table , because when processing the records using the 'India Local Concurrent'
242: only records that belong to the orgid of the current responsiblity needs to be picked up.
243:
244: 9. 2003/04/10 SSUMAITH - Bug # 2769439
241: inserted in the table , because when processing the records using the 'India Local Concurrent'
242: only records that belong to the orgid of the current responsiblity needs to be picked up.
243:
244: 9. 2003/04/10 SSUMAITH - Bug # 2769439
245: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.
246: This is necessary for creating links between OM and AR.
247:
248: 10. 2003/11/20 SSUMAITH - Bug # 3266982 File Version 617.1
249: The cursor which fetches order number was still pointing to So_headers_all table.
319: 19 14-FEB-2007 CSahoo - bug# 5364120 - file version 120.4
320: Forward Porting Of 11i BUG 5346489.
321:
322: The transaction amounts are rounded based on the currency precision of the invoice currency code
323: when the insert id done in the JAI_AR_TRX_INS_LINES_T.
324: Added the cursor c_inv_curr_precision.
325:
326: Dependency due to this bug :- None
327:
743: IF TAX_TYPE_REC.t_type = 'TDS' THEN
744: TAX_TYPE_REC.tax_amt := 0;
745: END IF;
746:
747: INSERT INTO JAI_AR_TRX_INS_LINES_T ( -- paddr,
-- 6842749
748: extended_amount,
749: customer_trx_line_id,
750: customer_trx_id,
751: set_of_books_id,
961: WHERE customer_trx_id = v_customer_trx_id;
962:
963: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
964: SELECT INSERT_UPDATE_FLAG
965: FROM JAI_AR_TRX_INS_LINES_T
966: WHERE customer_trx_id = V_CUSTOMER_TRX_ID AND
967: Customer_trx_line_id = p_customer_trx_line_id
968: ORDER BY CUSTOMER_TRX_LINE_ID;
969:
1033: Code commented because if the updated tax amount is zero the tax lines
1034: need to be corrected in the Base Tables as well.
1035: 5. 2002/05/09 Sriram
1036: Added the Source Column in the Column list in the insert statement
1037: This Column was added in the JAI_AR_TRX_INS_LINES_T table because the
1038: AR Tax and Freight Defaultation Concurrent - was split into 2 concurrents
1039: doing the same functionality - one being called from the AR side for manual invoice
1040: from this trigger and another from OM side which is scheduled to run on a periodid basis
1041: 6. 2002/05/09 Sriram
1046: Which was causing a mutating error and causing the transaction to error out
1047: with unhandled exception.This has been changed to point to JAI_AR_TRXS
1048: table instead which takes care of the issue.
1049: 8. 2003/04/07 SSUMAITH.Bug # 2779967
1050: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
1051: inserted in the table , because when processing the records using the 'India Local Concurrent'
1052: only records that belong to the orgid of the current responsiblity needs to be picked up.
1053: 9. 2003/04/10 SSUMAITH - Bug # 2769439
1054: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.
1050: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
1051: inserted in the table , because when processing the records using the 'India Local Concurrent'
1052: only records that belong to the orgid of the current responsiblity needs to be picked up.
1053: 9. 2003/04/10 SSUMAITH - Bug # 2769439
1054: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.
1055: This is necessary for creating links between OM and AR.
1056:
1057:
1058: 10. 2005/27/01 aiyer - Bug # 4089440 File Version 115.1
1106:
1107: 15. 14-Feb-2007 CSahoo BUG#5364120, File Version - 120.4
1108: Forward Porting of 11i BUG#5346489
1109: The transaction amounts are rounded based on the currency precision of the invoice currency code
1110: when the insert is done in the JAI_AR_TRX_INS_LINES_T.
1111: Added the cursor c_inv_curr_precision.
1112:
1113: Dependency due to this bug :- None
1114:
1290:
1291: FOR TAX_TYPE_REC IN TAX_TYPE_CUR
1292: LOOP
1293: SELECT COUNT(*) INTO v_counter
1294: FROM JAI_AR_TRX_INS_LINES_T b
1295: WHERE b.LINK_TO_CUST_TRX_LINE_ID = pr_new.Customer_Trx_Line_Id
1296: AND b.customer_trx_line_id = Tax_Type_Rec.LINE_ID;
1297:
1298: --IF nvl(v_ORDER_PRICE_EXCISE_INCLUSIVE,'N') = 'Y' then -- date 15/06/2007 sacsethi for bug 6131957 -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22, TD18
1561: CLOSE TAX_CCID_CUR;
1562: END IF;
1563:
1564: IF NVL(v_counter,0) = 0 THEN
1565: INSERT INTO JAI_AR_TRX_INS_LINES_T (
1566: -- paddr,
-- 6842749
1567: extended_amount,
1568: customer_trx_line_id,
1569: customer_trx_id,
1610: v_Created_from, -- v_created_from column added by Sriram - 09-MAY-2002
1611: v_org_id , -- added by sriram bug # 2779967
1612: tax_type_rec.tax_line_no) ; -- added by sriram - bug # 2769439
1613: ELSE
1614: UPDATE JAI_AR_TRX_INS_LINES_T
1615: SET extended_amount = TAX_TYPE_REC.tax_amt,
1616: set_of_books_id = v_books_id,
1617: line_type = v_line_type,
1618: uom_code = TAX_TYPE_REC.uom,