[Home] [Help]
8: 1 07/08/2004 Nagaraj.s for Bug# 3496408, Version:115.0
9: This Package is coded to handle all Accounting Entries for all the Receiving/Return Transactions and Cenvat Entries
10:
11: 2 16/09/2004 Sanjikum for bug # 3889243 File Version : 115.1
12: - Added 2 new variables - r_rcv_transactions, ln_accounting_line_type
13: - Added cursor - cur_trans_type, to get the transaction type
14: - Assigned the value to ln_accounting_line_type, on the basis of transaction type and
15: Debit_credit_flag
16: - While inserting into mtl_transaction_accounts, the value of column accounting_line_type
36:
37: 6 01/04/2005 Sanjikum for Bug#4257065, Version 115.5
38: Reason/problem
39: --------------
40: As ln_entered_cr and ln_entered_dr are rounded to the currency precision, before calling the procedure rcv_transactions_update.
41: So in the Procedure rcv_transactions_update, po_unit_price is rounded to the precision of the currency
42:
43: Fix
44: ---
37: 6 01/04/2005 Sanjikum for Bug#4257065, Version 115.5
38: Reason/problem
39: --------------
40: As ln_entered_cr and ln_entered_dr are rounded to the currency precision, before calling the procedure rcv_transactions_update.
41: So in the Procedure rcv_transactions_update, po_unit_price is rounded to the precision of the currency
42:
43: Fix
44: ---
45: In the Procedure Process_transaction, while calling procedure rcv_transactions_update, passed the value of parameter
41: So in the Procedure rcv_transactions_update, po_unit_price is rounded to the precision of the currency
42:
43: Fix
44: ---
45: In the Procedure Process_transaction, while calling procedure rcv_transactions_update, passed the value of parameter
46: p_costing_amount as ROUND(NVL(p_entered_cr, p_entered_dr),5), instead of NVL(ln_entered_cr, ln_entered_dr)
47:
48: 7 08-Jun-2005 File Version 116.2. Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
49: as required for CASE COMPLAINCE.
475: goto exit_from_procedure;
476: end if;
477: **//*8649408*/
478:
479: /* Fetch all the information from JAI_RCV_TRANSACTIONS */
480: open c_trx(p_transaction_id);
481: fetch c_trx into r_trx;
482: close c_trx;
483:
730: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); -- 20
731:
732: fnd_file.put_line(FND_FILE.LOG, '
733:
734: rcv_transactions_update
735: (
736: p_transaction_id => p_transaction_id,
737: p_costing_amount => ROUND(NVL(p_entered_cr, p_entered_dr),5), --added by Sanjikum for Bug #4257065
738: --p_costing_amount => NVL(ln_entered_cr, ln_entered_dr), --commented by Sanjikum for Bug #4257065
1102: FROM pjm_project_parameters
1103: WHERE project_id IN ( SELECT project_id
1104: FROM po_distributions_all
1105: WHERE po_distribution_id IN (SELECT po_distribution_id
1106: FROM rcv_transactions
1107: WHERE transaction_id = cp_transaction_id
1108: )
1109: )
1110: AND organization_id = cp_organization_id; --added for bug#8449597
1539: r_mmt_details c_fetch_mmt_details%rowtype;
1540:
1541: --Added the cursor by Sanjikum for Bug#3889243
1542: /*
1543: CURSOR cur_trans_type(cp_transaction_id rcv_transactions.transaction_id%type) IS
1544: SELECT *
1545: FROM rcv_transactions
1546: WHERE transaction_id = cp_transaction_id;
1547: r_rcv_transactions cur_trans_type%ROWTYPE;
1541: --Added the cursor by Sanjikum for Bug#3889243
1542: /*
1543: CURSOR cur_trans_type(cp_transaction_id rcv_transactions.transaction_id%type) IS
1544: SELECT *
1545: FROM rcv_transactions
1546: WHERE transaction_id = cp_transaction_id;
1547: r_rcv_transactions cur_trans_type%ROWTYPE;
1548: *//*commented by rchandan for bug#4473022 */
1549: r_trx c_trx%rowtype;-- rchandan for bug#4473022
1543: CURSOR cur_trans_type(cp_transaction_id rcv_transactions.transaction_id%type) IS
1544: SELECT *
1545: FROM rcv_transactions
1546: WHERE transaction_id = cp_transaction_id;
1547: r_rcv_transactions cur_trans_type%ROWTYPE;
1548: *//*commented by rchandan for bug#4473022 */
1549: r_trx c_trx%rowtype;-- rchandan for bug#4473022
1550:
1551: /* Bug 5243532. Added by Lakshmi Gopalsami
1653: RETURN;
1654: end mta_entry;
1655:
1656: /*------------------------------------------------------------------------------------------------*/
1657: PROCEDURE rcv_transactions_update
1658: (
1659: p_transaction_id in number,
1660: p_costing_amount in number,
1661: p_process_message OUT NOCOPY varchar2,
1664: ) IS
1665:
1666: BEGIN
1667:
1668: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_transactions_update', 'START'); /* 1 */
1669:
1670: UPDATE rcv_transactions
1671: SET po_unit_price = nvl(po_unit_price,0) + nvl(p_costing_amount,0)
1672: WHERE transaction_id = p_transaction_id;
1666: BEGIN
1667:
1668: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_transactions_update', 'START'); /* 1 */
1669:
1670: UPDATE rcv_transactions
1671: SET po_unit_price = nvl(po_unit_price,0) + nvl(p_costing_amount,0)
1672: WHERE transaction_id = p_transaction_id;
1673:
1674: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath, null, 'END'); /* 3 */
1675:
1676: EXCEPTION
1677: WHEN OTHERS then
1678: p_process_status := 'E';
1679: p_process_message := 'RECEIPT_ACCOUNTING_PKG.rcv_transactions_update:' || SQLERRM;
1680: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1681: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 4 */
1682: RETURN;
1683:
1680: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1681: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 4 */
1682: RETURN;
1683:
1684: end rcv_transactions_update;
1685:
1686: end jai_rcv_accounting_pkg;