[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:
469: /* Following Hierarchy is followed for Deciding on what has to happen
470: 1. Expense Routing
471: 2. OPM Costing
472: 3. Average Costing
473: 4. Standard Costing.
474: */
475:
476: if -- (r_trx.transaction_type ='CORRECT' AND r_trx.parent_transaction_type = 'DELIVER') or Vijay Shankar for Bug#4038034
477: r_trx.transaction_type = 'DELIVER'
617: elsif r_trx.costing_method = 1 then
618:
619: p_codepath := jai_general_pkg.plot_codepath(30, p_codepath); /* 30 */
620:
621: standard_costing
622: (
623: p_transaction_id => r_trx.transaction_id,
624: p_transaction_date => r_trx.transaction_date,
625: p_organization_id => r_trx.organization_id,
1123: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1124: ln_modvat_amount := ln_modvat_amount + ln_tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor; /* Replaced ln_tax_amount in place of tax_rec.tax_amount for bug #13494816 */
1125:
1126: -- Added by Jia Li for India tax inclusive 2007/11/28, Begin
1127: -- TD15-Changed Standard and Average Costing
1128: -- recoverable tax is inclusive, its costing effect needs to be negated
1129: -- Modified by Jia Li for Bug#6877290
1130: ----------------------------------------------------------------------
1131: IF ( tax_rec.inclusive_tax_flag = 'Y' )
1158: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1159: ln_other_modvat_amount := ln_other_modvat_amount + ln_tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor; /* Replaced ln_tax_amount in place of tax_rec.tax_amount for bug #13494816 */
1160:
1161: -- Added by Jia Li for India tax inclusive 2007/11/28, Begin
1162: -- TD15-Changed Standard and Average Costing
1163: -- recoverable tax is inclusive, its costing effect needs to be negated
1164: -- Modified by Jia Li for Bug#6877290
1165: ----------------------------------------------------------------------
1166: IF ( tax_rec.inclusive_tax_flag = 'Y' )
1178:
1179: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1180:
1181: -- Added by Jia Li for India tax inclusive 2007/11/28, Begin
1182: -- TD15-Changed Standard and Average Costing
1183: -- non-recoverable tax is inclusive, its costing should not be considered as it is already costed.
1184: -- Modified by Jia Li for Bug#6877290
1185: ----------------------------------------------------------------------
1186: IF ( tax_rec.inclusive_tax_flag = 'Y' )
1868: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 12 */
1869:
1870: END average_costing;
1871:
1872: /*----------------------------start of standard costing-------------------------------------------------------*/
1873:
1874: PROCEDURE standard_costing
1875: (
1876: p_transaction_id IN NUMBER,
1870: END average_costing;
1871:
1872: /*----------------------------start of standard costing-------------------------------------------------------*/
1873:
1874: PROCEDURE standard_costing
1875: (
1876: p_transaction_id IN NUMBER,
1877: p_transaction_date IN DATE,
1878: p_organization_id IN NUMBER,
1888: p_process_special_source IN VARCHAR2
1889: ) is
1890:
1891: /*
1892: This Procedure is meant for Costing Entries in case of a Standard costing Organization
1893:
1894:
1895: The Costing Amount is populated into MTA.
1896:
1921: ln_debit_amount NUMBER;
1922:
1923: lv_source VARCHAR2(30); --File.Sql.35 Cbabu := 'Inventory India';
1924: lv_category VARCHAR2(30); --File.Sql.35 Cbabu := 'MTL';
1925: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Standard Costing';
1926: --lv_debug varchar2(1) := 'Y';
1927:
1928: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1929: lv_reference_10_desc1 VARCHAR2(75);--rchandan for bug#4473022
1933: BEGIN
1934:
1935: lv_source := 'Inventory India';
1936: lv_category := 'MTL';
1937: lv_account_nature := 'Standard Costing';
1938: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1939: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
1940:
1941: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1937: lv_account_nature := 'Standard Costing';
1938: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1939: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
1940:
1941: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1942:
1943: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1944: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1945: lv_account_nature := 'Unclaim Standard Costing';
1941: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1942:
1943: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1944: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1945: lv_account_nature := 'Unclaim Standard Costing';
1946:
1947: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1948: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1949: lv_account_nature := 'VAT Unclaim Standard Costing';
1945: lv_account_nature := 'Unclaim Standard Costing';
1946:
1947: /* elsif added for vat_noclaim by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1948: ELSIF p_process_special_source = jai_constants.vat_noclaim THEN
1949: lv_account_nature := 'VAT Unclaim Standard Costing';
1950: END IF;
1951:
1952: ln_ppv_account_id := ppv_account
1953: (
1993: p_entered_cr => ln_credit_amount,
1994: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1995: p_accounting_date => p_transaction_date,
1996: p_reference_10 => NULL,
1997: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1998: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1999: p_reference_25 => NULL,
2000: p_reference_26 => to_char(p_transaction_id),
2001: p_destination => 'S', /*Indicates Standard Costing. */
1997: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1998: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1999: p_reference_25 => NULL,
2000: p_reference_26 => to_char(p_transaction_id),
2001: p_destination => 'S', /*Indicates Standard Costing. */
2002: p_simulate_flag => p_simulate,
2003: p_codepath => p_codepath,
2004: p_process_message => p_process_message,
2005: p_process_status => p_process_status
2041: p_entered_cr => ln_credit_amount,
2042: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
2043: p_accounting_date => p_transaction_date,
2044: p_reference_10 => NULL,
2045: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
2046: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
2047: p_reference_25 => NULL,
2048: p_reference_26 => to_char(p_transaction_id),
2049: p_destination => 'S', /*Indicates Standard Costing. */
2045: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
2046: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
2047: p_reference_25 => NULL,
2048: p_reference_26 => to_char(p_transaction_id),
2049: p_destination => 'S', /*Indicates Standard Costing. */
2050: p_simulate_flag => p_simulate,
2051: p_codepath => p_codepath,
2052: p_process_message => p_process_message,
2053: p_process_status => p_process_status
2064:
2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: p_process_status := 'E';
2068: p_process_message := 'DELIVER_RTR_PKG.standard_costing:' || sqlerrm ;
2069: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
2070: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
2071:
2072: END standard_costing;
2068: p_process_message := 'DELIVER_RTR_PKG.standard_costing:' || sqlerrm ;
2069: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
2070: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
2071:
2072: END standard_costing;
2073:
2074:
2075: /* ------------------------------------start of receiving_account-----------------------*/
2076: