DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on DUAL

Line 458: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;

454: /*Bug 5527885 End*/
455: begin
456:
457: -- this is to identify the path in SQL TRACE file if any problem occured
458: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
459:
460: if p_debug = 'Y' then
461: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
462: end if;

Line 1668: Cause - In case of recoverable VAT, the individual tax line is rounded, and the credit / debit

1664: p_codepath := jai_general_pkg.plot_codepath(7.11, p_codepath); /* 7.11 */
1665:
1666: /*bug 8488470 - modified the if block.
1667: Issue - Unbalanced entries in GL for correct / RTV transactions.
1668: Cause - In case of recoverable VAT, the individual tax line is rounded, and the credit / debit
1669: is done with the rounded amount for interim accounting. But the accrual accounting is
1670: using the unrounded amount. This is because the tax amount is rounded only in case of
1671: partially recoverable taxes here. Rounding should be applied for fully recoverable taxes
1672: also. Moreover, the rounded amount should be considered for the total amount being stored

Line 1712: Cause - In case of recoverable VAT, the individual tax line is rounded, and the credit / debit

1708: p_codepath := jai_general_pkg.plot_codepath(7.15, p_codepath); /* 7.15 */
1709:
1710: /*bug 8488470 - modified the if block.
1711: Issue - Unbalanced entries in GL for correct / RTV transactions.
1712: Cause - In case of recoverable VAT, the individual tax line is rounded, and the credit / debit
1713: is done with the rounded amount for interim accounting. But the accrual accounting is
1714: using the unrounded amount. This is because the tax amount is rounded only in case of
1715: partially recoverable taxes here. Rounding should be applied for fully recoverable taxes
1716: also. Moreover, the rounded amount should be considered for the total amount being stored