eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 416: added the column error_flag to the table 'JAI_AR_TRX_INS_LINES_T'

412: 2. 2001/06/22 Anuradha Parthasarathy
413: Commented and Added code for better performance.
414:
415: 3. 2002/03/22 RPK
416: added the column error_flag to the table 'JAI_AR_TRX_INS_LINES_T'
417: added the cursor trx_num to get the invoice num.
418:
419: 4 2002/04/22 RPK
420: BUG#2334972.

Line 422: the table JAI_AR_TRX_INS_LINES_T.When an order line is having 2 tax amounts

418:
419: 4 2002/04/22 RPK
420: BUG#2334972.
421: Code modified to allow the taxes to be inserted into
422: the table JAI_AR_TRX_INS_LINES_T.When an order line is having 2 tax amounts
423: one with a positive value and the other with a negative value(eg:100 and -100)
424: then these lines were not getting transferred to AR Tables and the same is
425: required to be transferred to have the proper accounting of the GL/AR.For this,
426: the when_clause of this trigger is commented to facilitate the execution of this

Line 437: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be

433: 6. 2002/05/06 Added the Source Column in the insert statement of Ja-In_temp_lines_insert
434: table.
435:
436: 8. 2003/04/07 SSUMAITH.Bug # 2779967
437: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
438: inserted in the table , because when processing the records using the 'India Local Concurrent'
439: only records that belong to the orgid of the current responsiblity needs to be picked up.
440:
441: 9. 2003/04/10 SSUMAITH - Bug # 2769439

Line 442: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.

438: inserted in the table , because when processing the records using the 'India Local Concurrent'
439: only records that belong to the orgid of the current responsiblity needs to be picked up.
440:
441: 9. 2003/04/10 SSUMAITH - Bug # 2769439
442: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.
443: This is necessary for creating links between OM and AR.
444:
445: 10. 2003/11/20 SSUMAITH - Bug # 3266982 File Version 617.1
446: The cursor which fetches order number was still pointing to So_headers_all table.

Line 520: when the insert id done in the JAI_AR_TRX_INS_LINES_T.

516: 19 14-FEB-2007 CSahoo - bug# 5364120 - file version 120.4
517: Forward Porting Of 11i BUG 5346489.
518:
519: The transaction amounts are rounded based on the currency precision of the invoice currency code
520: when the insert id done in the JAI_AR_TRX_INS_LINES_T.
521: Added the cursor c_inv_curr_precision.
522:
523: Dependency due to this bug :- None
524:

Line 591: Description: Data was inserted into JAI_AR_TRX_INS_LINES_T via tax_type_cur only if

587: Fix: Service Tax Libility Account will be hit directly instead of Interim Liablity as there
588: will be no set off during Receipt/CM Application.
589:
590: 30 12-Apr-2011 Bug 11936630
591: Description: Data was inserted into JAI_AR_TRX_INS_LINES_T via tax_type_cur only if
592: there was an Exclusive Tax Line. Hence for Order Imported AR Invoice with only
593: Inclusive Taxes accounting was not happening.
594: Fix: Data to be inserted into JAI_AR_TRX_INS_LINES_T irrespective of Tax Types.
595:

Line 594: Fix: Data to be inserted into JAI_AR_TRX_INS_LINES_T irrespective of Tax Types.

590: 30 12-Apr-2011 Bug 11936630
591: Description: Data was inserted into JAI_AR_TRX_INS_LINES_T via tax_type_cur only if
592: there was an Exclusive Tax Line. Hence for Order Imported AR Invoice with only
593: Inclusive Taxes accounting was not happening.
594: Fix: Data to be inserted into JAI_AR_TRX_INS_LINES_T irrespective of Tax Types.
595:
596: 31 18-May-2011 Xiao for POT changes, reg bug#12533434.
597: Issue: Compare transaction date with POT date.
598: fixed: Compare Accounting Date with POT date. Cursor c_get_trx_date is modified. --Added by Chong.Lei for POT code port

Line 1203: INSERT INTO JAI_AR_TRX_INS_LINES_T ( -- paddr,

1199: TAX_TYPE_REC.tax_amt := 0;
1200: END IF;
1201: END IF;--Added by zhiwei for GST get ccid by regime setup BUG#10233402 20101027
1202:
1203: INSERT INTO JAI_AR_TRX_INS_LINES_T ( -- paddr,
1204: -- 6842749
1205: extended_amount,
1206: customer_trx_line_id,
1207: customer_trx_id,

Line 1562: FROM JAI_AR_TRX_INS_LINES_T

1558: WHERE customer_trx_id = v_customer_trx_id;
1559:
1560: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
1561: SELECT INSERT_UPDATE_FLAG
1562: FROM JAI_AR_TRX_INS_LINES_T
1563: WHERE customer_trx_id = V_CUSTOMER_TRX_ID AND
1564: Customer_trx_line_id = p_customer_trx_line_id
1565: ORDER BY CUSTOMER_TRX_LINE_ID;
1566:

Line 1658: This Column was added in the JAI_AR_TRX_INS_LINES_T table because the

1654: Code commented because if the updated tax amount is zero the tax lines
1655: need to be corrected in the Base Tables as well.
1656: 5. 2002/05/09 Sriram
1657: Added the Source Column in the Column list in the insert statement
1658: This Column was added in the JAI_AR_TRX_INS_LINES_T table because the
1659: AR Tax and Freight Defaultation Concurrent - was split into 2 concurrents
1660: doing the same functionality - one being called from the AR side for manual invoice
1661: from this trigger and another from OM side which is scheduled to run on a periodid basis
1662: 6. 2002/05/09 Sriram

Line 1671: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be

1667: Which was causing a mutating error and causing the transaction to error out
1668: with unhandled exception.This has been changed to point to JAI_AR_TRXS
1669: table instead which takes care of the issue.
1670: 8. 2003/04/07 SSUMAITH.Bug # 2779967
1671: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
1672: inserted in the table , because when processing the records using the 'India Local Concurrent'
1673: only records that belong to the orgid of the current responsiblity needs to be picked up.
1674: 9. 2003/04/10 SSUMAITH - Bug # 2769439
1675: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.

Line 1675: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.

1671: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
1672: inserted in the table , because when processing the records using the 'India Local Concurrent'
1673: only records that belong to the orgid of the current responsiblity needs to be picked up.
1674: 9. 2003/04/10 SSUMAITH - Bug # 2769439
1675: Also inserting the tax line number in the JAI_AR_TRX_INS_LINES_T table.
1676: This is necessary for creating links between OM and AR.
1677:
1678:
1679: 10. 2005/27/01 aiyer - Bug # 4089440 File Version 115.1

Line 1731: when the insert is done in the JAI_AR_TRX_INS_LINES_T.

1727:
1728: 15. 14-Feb-2007 CSahoo BUG#5364120, File Version - 120.4
1729: Forward Porting of 11i BUG#5346489
1730: The transaction amounts are rounded based on the currency precision of the invoice currency code
1731: when the insert is done in the JAI_AR_TRX_INS_LINES_T.
1732: Added the cursor c_inv_curr_precision.
1733:
1734: Dependency due to this bug :- None
1735:

Line 1797: tax amount has been populated as "0" in jai_ar_trx_ins_lines_t.

1793: END IF;
1794: END IF;
1795:
1796: Eventhough the order_price_excise_inclusive functionality was obsoleted the
1797: tax amount has been populated as "0" in jai_ar_trx_ins_lines_t.
1798:
1799: Hence the issue
1800:
1801: Fix:

Line 1817: Description: Data was inserted into JAI_AR_TRX_INS_LINES_T via tax_type_cur only if

1813: JAI_JAR_TL_TRIGGER_PKG.ARU_T1 will not be invoked, and the same logic is implemented
1814: in Open Interface Procedure.
1815:
1816: 29 12-Apr-2011 Bug 11936630
1817: Description: Data was inserted into JAI_AR_TRX_INS_LINES_T via tax_type_cur only if
1818: there was an Exclusive Tax Line. Hence for Order Imported AR Invoice with only
1819: Inclusive Taxes accounting was not happening.
1820: Fix: Data to be inserted into JAI_AR_TRX_INS_LINES_T irrespective of Tax Types.
1821:

Line 1820: Fix: Data to be inserted into JAI_AR_TRX_INS_LINES_T irrespective of Tax Types.

1816: 29 12-Apr-2011 Bug 11936630
1817: Description: Data was inserted into JAI_AR_TRX_INS_LINES_T via tax_type_cur only if
1818: there was an Exclusive Tax Line. Hence for Order Imported AR Invoice with only
1819: Inclusive Taxes accounting was not happening.
1820: Fix: Data to be inserted into JAI_AR_TRX_INS_LINES_T irrespective of Tax Types.
1821:
1822: 29 18-May-2011 Xiao for POT changes, reg bug#12533434.
1823: Issue: Compare transaction date with POT date.
1824: fixed: Compare Accounting Date with POT date. Cursor c_get_trx_date is modified. --Added by Chong.Lei for POT code port

Line 2006: FROM JAI_AR_TRX_INS_LINES_T b

2002:
2003: FOR TAX_TYPE_REC IN TAX_TYPE_CUR
2004: LOOP
2005: SELECT COUNT(*) INTO v_counter
2006: FROM JAI_AR_TRX_INS_LINES_T b
2007: WHERE b.LINK_TO_CUST_TRX_LINE_ID = pr_new.Customer_Trx_Line_Id
2008: AND b.customer_trx_line_id = Tax_Type_Rec.LINE_ID;
2009:
2010: --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

Line 2371: INSERT INTO JAI_AR_TRX_INS_LINES_T (

2367: CLOSE TAX_CCID_CUR;
2368: END IF;
2369: END IF ;---- Added by zhiwei for GST get ccid by regime setup BUG#10233402 20101027
2370: IF NVL(v_counter,0) = 0 THEN
2371: INSERT INTO JAI_AR_TRX_INS_LINES_T (
2372: -- paddr,
2373: -- 6842749
2374: extended_amount,
2375: customer_trx_line_id,

Line 2422: UPDATE JAI_AR_TRX_INS_LINES_T

2418: v_Created_from, -- v_created_from column added by Sriram - 09-MAY-2002
2419: v_org_id , -- added by sriram bug # 2779967
2420: tax_type_rec.tax_line_no) ; -- added by sriram - bug # 2769439
2421: ELSE
2422: UPDATE JAI_AR_TRX_INS_LINES_T
2423: SET extended_amount = TAX_TYPE_REC.tax_amt,
2424: set_of_books_id = v_books_id,
2425: line_type = v_line_type,
2426: uom_code = TAX_TYPE_REC.uom,