[Home] [Help]
34: - Uncommented the call to OPM_COSTING to support OPM Receipts Functionality also
35: - INCLUDE_CENVAT_IN_COSTING is modified to include some more checks to return a value to caller
36: - Modfied the Main Cursor in DELIVER_RTR_RECO_NONEXCISE procedure not to pass INDIVIDUAL accounting for taxes
37: related to 'Service Tax India' and 'SERVICE_EDUCATION_CESS' tax types
38: - Modified the procedures expense_accounting, average_costing, standard_costing, opm_costing to include parameters
39: p_process_special_Reason in the signature. this is used to pass a different value for JAI_RCV_JOURNAL_ENTRIES.acct_nature,
40: for accounting_entries identification
41:
42:
392: /* Following Hierarchy is followed for Deciding on what has to happen
393: 1. Expense Routing
394: 2. OPM Costing
395: 3. Average Costing
396: 4. Standard Costing.
397: */
398:
399: if -- (r_trx.transaction_type ='CORRECT' AND r_trx.parent_transaction_type = 'DELIVER') or Vijay Shankar for Bug#4038034
400: r_trx.transaction_type = 'DELIVER'
540: elsif r_trx.costing_method = 1 then
541:
542: p_codepath := jai_general_pkg.plot_codepath(30, p_codepath); /* 30 */
543:
544: standard_costing
545: (
546: p_transaction_id => r_trx.transaction_id,
547: p_transaction_date => r_trx.transaction_date,
548: p_organization_id => r_trx.organization_id,
983: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
984: ln_modvat_amount := ln_modvat_amount + tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor;
985:
986: -- Added by Jia Li for India tax inclusive 2007/11/28, Begin
987: -- TD15-Changed Standard and Average Costing
988: -- recoverable tax is inclusive, its costing effect needs to be negated
989: -- Modified by Jia Li for Bug#6877290
990: ----------------------------------------------------------------------
991: IF ( tax_rec.inclusive_tax_flag = 'Y' )
1009: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1010: ln_other_modvat_amount := ln_other_modvat_amount + tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor;
1011:
1012: -- Added by Jia Li for India tax inclusive 2007/11/28, Begin
1013: -- TD15-Changed Standard and Average Costing
1014: -- recoverable tax is inclusive, its costing effect needs to be negated
1015: -- Modified by Jia Li for Bug#6877290
1016: ----------------------------------------------------------------------
1017: IF ( tax_rec.inclusive_tax_flag = 'Y' )
1028:
1029: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1030:
1031: -- Added by Jia Li for India tax inclusive 2007/11/28, Begin
1032: -- TD15-Changed Standard and Average Costing
1033: -- non-recoverable tax is inclusive, its costing should not be considered as it is already costed.
1034: -- Modified by Jia Li for Bug#6877290
1035: ----------------------------------------------------------------------
1036: IF ( tax_rec.inclusive_tax_flag = 'Y' )
1704: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 12 */
1705:
1706: END average_costing;
1707:
1708: /*----------------------------start of standard costing-------------------------------------------------------*/
1709:
1710: PROCEDURE standard_costing
1711: (
1712: p_transaction_id IN NUMBER,
1706: END average_costing;
1707:
1708: /*----------------------------start of standard costing-------------------------------------------------------*/
1709:
1710: PROCEDURE standard_costing
1711: (
1712: p_transaction_id IN NUMBER,
1713: p_transaction_date IN DATE,
1714: p_organization_id IN NUMBER,
1724: p_process_special_source IN VARCHAR2
1725: ) is
1726:
1727: /*
1728: This Procedure is meant for Costing Entries in case of a Standard costing Organization
1729:
1730:
1731: The Costing Amount is populated into MTA.
1732:
1757: ln_debit_amount NUMBER;
1758:
1759: lv_source VARCHAR2(30); --File.Sql.35 Cbabu := 'Inventory India';
1760: lv_category VARCHAR2(30); --File.Sql.35 Cbabu := 'MTL';
1761: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Standard Costing';
1762: --lv_debug varchar2(1) := 'Y';
1763:
1764: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1765: lv_reference_10_desc1 VARCHAR2(75);--rchandan for bug#4473022
1769: BEGIN
1770:
1771: lv_source := 'Inventory India';
1772: lv_category := 'MTL';
1773: lv_account_nature := 'Standard Costing';
1774: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1775: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
1776:
1777: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1773: lv_account_nature := 'Standard Costing';
1774: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1775: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
1776:
1777: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1778:
1779: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1780: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1781: lv_account_nature := 'Unclaim Standard Costing';
1777: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1778:
1779: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1780: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1781: lv_account_nature := 'Unclaim Standard Costing';
1782:
1783: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1784: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1785: lv_account_nature := 'VAT Unclaim Standard Costing';
1781: lv_account_nature := 'Unclaim Standard Costing';
1782:
1783: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1784: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1785: lv_account_nature := 'VAT Unclaim Standard Costing';
1786: END IF;
1787:
1788: ln_ppv_account_id := ppv_account
1789: (
1829: p_entered_cr => ln_credit_amount,
1830: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1831: p_accounting_date => p_transaction_date,
1832: p_reference_10 => NULL,
1833: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1834: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1835: p_reference_25 => NULL,
1836: p_reference_26 => to_char(p_transaction_id),
1837: p_destination => 'S', /*Indicates Standard Costing. */
1833: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1834: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1835: p_reference_25 => NULL,
1836: p_reference_26 => to_char(p_transaction_id),
1837: p_destination => 'S', /*Indicates Standard Costing. */
1838: p_simulate_flag => p_simulate,
1839: p_codepath => p_codepath,
1840: p_process_message => p_process_message,
1841: p_process_status => p_process_status
1877: p_entered_cr => ln_credit_amount,
1878: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1879: p_accounting_date => p_transaction_date,
1880: p_reference_10 => NULL,
1881: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1882: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1883: p_reference_25 => NULL,
1884: p_reference_26 => to_char(p_transaction_id),
1885: p_destination => 'S', /*Indicates Standard Costing. */
1881: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1882: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1883: p_reference_25 => NULL,
1884: p_reference_26 => to_char(p_transaction_id),
1885: p_destination => 'S', /*Indicates Standard Costing. */
1886: p_simulate_flag => p_simulate,
1887: p_codepath => p_codepath,
1888: p_process_message => p_process_message,
1889: p_process_status => p_process_status
1900:
1901: EXCEPTION
1902: WHEN OTHERS THEN
1903: p_process_status := 'E';
1904: p_process_message := 'DELIVER_RTR_PKG.standard_costing:' || sqlerrm ;
1905: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1906: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1907:
1908: END standard_costing;
1904: p_process_message := 'DELIVER_RTR_PKG.standard_costing:' || sqlerrm ;
1905: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1906: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1907:
1908: END standard_costing;
1909:
1910:
1911: /* ------------------------------------start of receiving_account-----------------------*/
1912: