[Home] [Help]
1: PACKAGE BODY jai_om_tax_pkg AS
2: /* $Header: jai_om_tax.plb 120.14.12010000.2 2008/10/23 10:47:36 csahoo ship $ */
3:
4: /*------------------------------------------------------------------------------------------
5: FILENAME:
5: FILENAME:
6: 1 08-Aug-2005 Ramananda for Bug#4540783. File Version 120.2
7: In Procedure recalculate_excise_taxes:
8: Added a new parameter - p_vat_assess_value and value for the same as ln_vat_assessable_value
9: while calling procedure jai_om_tax_pkg.recalculate_oe_taxes
10:
11: 2.25-Aug-2006 Bug 5490479, Added by aiyer, File version 120.5
12: Issue:-
13: Org_id parameter in all MOAC related Concurrent programs is getting derived from the profile org_id
356: lv_excise_exemption_exists VARCHAR2(1);
357:
358: -- End of bug 3590208
359:
360: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_tax_pkg.calculate_ato_taxes';
361: BEGIN
362: /*------------------------------------------------------------------------------------------
363: FILENAME: calculate_ato_taxes_P.sql
364:
1682:
1683: lv_excise_exemption_exists VARCHAR2(1);
1684:
1685: -- End of bug 3565499
1686: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_tax_pkg.recalculate_oe_taxes';
1687: BEGIN
1688: /*-------------------------------------------------------------------------------------------------------------------------
1689: S.No Date(DD/MM/YY) Author and Details of Changes
1690: ---- -------------- -----------------------------
2496:
2497: v_check_line NUMBER;
2498:
2499: ln_vat_assessable_value NUMBER;
2500: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_tax_pkg.recalculate_excise_taxes';
2501:
2502: /* Bug 5243532. Added by Lakshmi Gopalsami
2503: * Defined variable for implementing caching logic.
2504: */
2524: Issue:-
2525: ja_in_assessible_price_change.sql was a pl-sql executable script, which needs to be
2526: a procedure inside a package
2527: Fix:-
2528: Script is migrated into a jai_om_tax_pkg as recalculate_excise_tax procedure
2529: with following input parameters.
2530: errbuf, retcode, pn_org_id, pn_start_order
2531: , pn_end_order, pn_order_type_id, pn_ship_from_org_id
2532: In JAINREPC Concurrent Definition execution mentod modified from
2533: SQL*Plus to PL-SQL Stored Procedure
2534:
2535: 4 26/05/2005 Ramananda for Bug#4540783. File Version 120.2
2536: While running the concurrent - INDIA - EXCISE DUTY RECALCULATION, system is giving error -
2537: "wrong number or types of arguments in call to 'jai_om_tax_pkg.recalculate_oe_taxes'"
2538: Added a new parameter - p_vat_assess_value and value for the same as NULL,
2539: while calling procedure jai_om_tax_pkg.recalculate_oe_taxes
2540:
2541: --------------------------------------------------------------------------------------------------------------------*/
2535: 4 26/05/2005 Ramananda for Bug#4540783. File Version 120.2
2536: While running the concurrent - INDIA - EXCISE DUTY RECALCULATION, system is giving error -
2537: "wrong number or types of arguments in call to 'jai_om_tax_pkg.recalculate_oe_taxes'"
2538: Added a new parameter - p_vat_assess_value and value for the same as NULL,
2539: while calling procedure jai_om_tax_pkg.recalculate_oe_taxes
2540:
2541: --------------------------------------------------------------------------------------------------------------------*/
2542: v_assessable_value_date := sysdate;
2543: ii := 1;
2774:
2775: ln_vat_assessable_value := nvl(ln_vat_assessable_value,0) * v_line_quantity;
2776: /* End OF Bug# 4400993 */
2777:
2778: jai_om_tax_pkg.recalculate_oe_taxes
2779: (
2780: v_header_id,
2781: v_line_id,
2782: v_assessable_amount,
2865: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2866: app_exception.raise_exception;
2867: END recalculate_excise_taxes;
2868:
2869: END jai_om_tax_pkg;