[Home] [Help]
44: 12/10/2007 Kevin Cheng Update the logic for inclusive tax calculation
45:
46: 05-Mar-08 Jia Li Added clause logic for bug# 6846048
47: Issue: When unit selling price is changed because of discounts,
48: inclusive taxes are getting added to the tax amount in the JAI_OM_OE_SO_LINES table.
49: So at ship confirm time, comparing the tax amount in the lines table with the sum of exclusive taxes
50: in the taxes table was not matching and hence the trigger was returning an error.
51: Fix: Ensuring that only exclusive taxes are added to the tax amount in the jai_om_oe_so_lines table.
52:
47: Issue: When unit selling price is changed because of discounts,
48: inclusive taxes are getting added to the tax amount in the JAI_OM_OE_SO_LINES table.
49: So at ship confirm time, comparing the tax amount in the lines table with the sum of exclusive taxes
50: in the taxes table was not matching and hence the trigger was returning an error.
51: Fix: Ensuring that only exclusive taxes are added to the tax amount in the jai_om_oe_so_lines table.
52:
53: 22-Oct-2008 CSahoo - bug#4918667, File Version 120.14.12010000.2
54: Issue :- In case of retrobilling functionality, there was a divide by zero error which is caused.
55: The parameter p_line_quantity is being used as a denominator, and in case it is zero
385: IS
386: SELECT
387: '1'
388: FROM
389: JAI_OM_OE_SO_LINES jsl
390: WHERE
391: jsl.excise_exempt_type IS NOT NULL AND
392: jsl.line_id = p_line_id ;
393:
408:
409: /*Start additions by mmurtuza for bug 14559561*/
410:
411: CURSOR c_get_vat_exempt_flag(cp_line_id number) IS
412: select vat_exemption_flag from jai_om_oe_so_lines
413: where line_id = cp_line_id;
414: lv_vat_exemption_flag char(1) := 'N';
415:
416: cursor c_get_base_line_id(cp_line_id oe_order_lines_all.line_id%type)
420: and joorl.rma_line_id = cp_line_id;
421: lv_reference_Line_id oe_order_lines_all.Reference_Line_id%type;
422:
423: cursor c_excise_exemption_rma(cp_line_id number) IS
424: select excise_exempt_type from jai_om_oe_so_lines
425: where excise_exempt_type IS NOT NULL AND
426: line_id = cp_line_id;
427:
428: /*End additions by mmurtuza for bug 14559561*/
515: 10. 10-Dec-007 Kevin Cheng Update the logic for inclusive tax calculation
516:
517: 11. 05-Mar-08 Jia Li Added clause logic for bug# 6846048
518: Issue: When unit selling price is changed because of discounts,
519: inclusive taxes are getting added to the tax amount in the JAI_OM_OE_SO_LINES table.
520: So at ship confirm time, comparing the tax amount in the lines table with the sum of exclusive taxes
521: in the taxes table was not matching and hence the trigger was returning an error.
522: Fix: Ensuring that only exclusive taxes are added to the tax amount in the jai_om_oe_so_lines table.
523:
518: Issue: When unit selling price is changed because of discounts,
519: inclusive taxes are getting added to the tax amount in the JAI_OM_OE_SO_LINES table.
520: So at ship confirm time, comparing the tax amount in the lines table with the sum of exclusive taxes
521: in the taxes table was not matching and hence the trigger was returning an error.
522: Fix: Ensuring that only exclusive taxes are added to the tax amount in the jai_om_oe_so_lines table.
523:
524: 12 22-sep-2010 vkaranam for bug#10114559
525: Issue:
526: TAXES ARE NOT CALCULATED AUTOMATICALLY ON A SPLIT ORDER
2207: --,pn_gst_assess_value IN NUMBER --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
2208: ) IS
2209:
2210: -- P_TAX_AMOUNT input parameter will contain the line_tax_amount after successful completion of the procedure which
2211: -- can be used to update the line amount in JAI_OM_OE_SO_LINES
2212:
2213: TYPE num_tab IS TABLE OF NUMBER(20,3) INDEX BY BINARY_INTEGER;
2214: TYPE tax_amt_num_tab IS TABLE OF NUMBER(20,3) INDEX BY BINARY_INTEGER;
2215:
2381: IS
2382: SELECT
2383: '1'
2384: FROM
2385: JAI_OM_OE_SO_LINES jsl
2386: WHERE
2387: jsl.excise_exempt_type IS NOT NULL AND
2388: jsl.line_id = p_line_id ;
2389:
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
3427: v_operating_id oe_order_lines_all.org_id%TYPE;
3428: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
3429: v_line_amount NUMBER := 0;
3430:
3431: v_original_system_reference VARCHAR2(50);
3432: v_customer_id Number;
3516: base.SOURCE_DOCUMENT_TYPE_ID, ja.assessable_value,
3517: NVL(head.org_id,0) org_id1, head.SOLD_TO_ORG_ID, head.SOURCE_DOCUMENT_ID hsdi, head.order_number,
3518: head.price_list_id, head.ORDER_CATEGORY_CODE, head.ORIG_SYS_DOCUMENT_REF, head.TRANSACTIONAL_CURR_CODE,
3519: head.conversion_type_code, head.conversion_rate, head.CONVERSION_RATE_DATE, nvl(head.ORDERED_DATE, head.creation_date) ordered_date
3520: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja
3521: WHERE head.header_id = base.header_id
3522: and base.line_id = ja.line_id
3523: and base.OPEN_FLAG = 'Y'
3524: and base.line_category_code = 'ORDER'
3866: --,ln_gst_assessable_value --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
3867: );
3868: -- added by cbabu for Bug#2496481, end
3869:
3870: UPDATE JAI_OM_OE_SO_LINES
3871: SET assessable_value = v_assessable_value,
3872: tax_amount = nvl(v_line_tax_amount,0),
3873: line_amount = v_line_amount,
3874: line_tot_amount = v_line_amount + nvl(v_line_tax_amount,0),