[Home] [Help]
1: PACKAGE BODY jai_om_tax_pkg AS
2: /* $Header: jai_om_tax.plb 120.26.12020000.6 2013/02/28 09:40:05 mmurtuza 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
394: lv_excise_exemption_exists VARCHAR2(1);
395:
396: -- End of bug 3590208
397:
398: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_tax_pkg.calculate_ato_taxes';
399:
400: /* Start Additions by mmurtuza for bug 14031594*/
401: CURSOR get_adhoc_flag(pn_tax_id NUMBER) IS
402: SELECT adhoc_flag
2389:
2390: lv_excise_exemption_exists VARCHAR2(1);
2391:
2392: -- End of bug 3565499
2393: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_tax_pkg.recalculate_oe_taxes';
2394: BEGIN
2395: /*-------------------------------------------------------------------------------------------------------------------------
2396: S.No Date(DD/MM/YY) Author and Details of Changes
2397: ---- -------------- -----------------------------
3550:
3551: ln_vat_assessable_value NUMBER;
3552: --ln_gst_assessable_value NUMBER; --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
3553:
3554: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_tax_pkg.recalculate_excise_taxes';
3555:
3556: /* Bug 5243532. Added by Lakshmi Gopalsami
3557: * Defined variable for implementing caching logic.
3558: */
3578: Issue:-
3579: ja_in_assessible_price_change.sql was a pl-sql executable script, which needs to be
3580: a procedure inside a package
3581: Fix:-
3582: Script is migrated into a jai_om_tax_pkg as recalculate_excise_tax procedure
3583: with following input parameters.
3584: errbuf, retcode, pn_org_id, pn_start_order
3585: , pn_end_order, pn_order_type_id, pn_ship_from_org_id
3586: In JAINREPC Concurrent Definition execution mentod modified from
3587: SQL*Plus to PL-SQL Stored Procedure
3588:
3589: 4 26/05/2005 Ramananda for Bug#4540783. File Version 120.2
3590: While running the concurrent - INDIA - EXCISE DUTY RECALCULATION, system is giving error -
3591: "wrong number or types of arguments in call to 'jai_om_tax_pkg.recalculate_oe_taxes'"
3592: Added a new parameter - p_vat_assess_value and value for the same as NULL,
3593: while calling procedure jai_om_tax_pkg.recalculate_oe_taxes
3594:
3595: --------------------------------------------------------------------------------------------------------------------*/
3589: 4 26/05/2005 Ramananda for Bug#4540783. File Version 120.2
3590: While running the concurrent - INDIA - EXCISE DUTY RECALCULATION, system is giving error -
3591: "wrong number or types of arguments in call to 'jai_om_tax_pkg.recalculate_oe_taxes'"
3592: Added a new parameter - p_vat_assess_value and value for the same as NULL,
3593: while calling procedure jai_om_tax_pkg.recalculate_oe_taxes
3594:
3595: --------------------------------------------------------------------------------------------------------------------*/
3596: v_assessable_value_date := sysdate;
3597: ii := 1;
3848: /*End Commenting by mmurtuza for removing GST Changes*/
3849: ---------------------------------------------------
3850: --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 end
3851:
3852: jai_om_tax_pkg.recalculate_oe_taxes
3853: (
3854: v_header_id,
3855: v_line_id,
3856: v_assessable_amount,
3940: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3941: app_exception.raise_exception;
3942: END recalculate_excise_taxes;
3943:
3944: END jai_om_tax_pkg;