[Home] [Help]
484: ORDER BY tax_line_no;
485:
486: CURSOR c_manual_so_taxes_up(p_line_id IN NUMBER) IS
487: SELECT rowid, tax_line_no
488: FROM JAI_OM_OE_SO_TAXES
489: WHERE line_id = p_line_id
490: AND tax_category_id IS NULL
491: ORDER BY tax_line_no;
492:
3661: */
3662:
3663: -- The adhoc data is preserved to capture the tax_amount later.
3664: -- added by Harshita for Bug #3765133
3665: insert into JAI_OM_OE_SO_TAXES
3666: (line_id,tax_line_no,header_id,
3667: tax_id, tax_amount,
3668: creation_date,created_by,
3669: last_update_date, last_updated_by,last_update_login)
3672: A.tax_id, A.tax_amount,
3673: A.creation_date,A.created_by,
3674: A.last_update_date, A.last_updated_by,A.last_update_login
3675: FROM
3676: JAI_OM_OE_SO_TAXES A,
3677: JAI_CMN_TAXES_ALL B
3678: WHERE
3679: A.tax_id = B.tax_id AND
3680: line_id = so_rec.line_id AND
3681: NVL(adhoc_flag,'N') = 'Y';
3682: -- end, Harshita for Bug #3765133
3683:
3684: IF p_override_manual_taxes = 'Y' THEN
3685: DELETE FROM JAI_OM_OE_SO_TAXES
3686: WHERE line_id = so_rec.line_id;
3687:
3688: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
3689: ELSE
3715: ||', tax_rec.p_10 -> '||tax_rec.p_10
3716: );
3717: END IF;
3718:
3719: INSERT INTO JAI_OM_OE_SO_TAXES(
3720: tax_line_no, line_id, header_id,
3721: precedence_1,
3722: precedence_2,
3723: precedence_3,
3747: /* Harshita - Update the tax_amount in the latest records
3748: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
3749:
3750: UPDATE
3751: JAI_OM_OE_SO_TAXES a
3752: SET
3753: tax_amount = (SELECT tax_amount
3754: FROM JAI_OM_OE_SO_TAXES
3755: where tax_id = a.tax_id
3750: UPDATE
3751: JAI_OM_OE_SO_TAXES a
3752: SET
3753: tax_amount = (SELECT tax_amount
3754: FROM JAI_OM_OE_SO_TAXES
3755: where tax_id = a.tax_id
3756: and line_id = -so_rec.line_id)
3757: WHERE
3758: line_id = so_rec.line_id
3770: IF p_override_manual_taxes <> 'Y' THEN
3771: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
3772: FOR tax_rec IN c_manual_so_taxes_up(so_rec.line_id) LOOP
3773: j := j + 1;
3774: UPDATE JAI_OM_OE_SO_TAXES SET tax_line_no = j
3775: WHERE rowid = tax_rec.rowid;
3776: END LOOP;
3777: END IF;
3778:
4031:
4032: END IF;
4033: -- added, Harshita for Bug #3765133
4034: /* Temporary data stored previously will be flushed using following DELETE */
4035: DELETE FROM JAI_OM_OE_SO_TAXES
4036: WHERE line_id = -so_rec.line_id;
4037: -- ended, Harshita for Bug #3765133
4038:
4039: ELSE
4800: nvl(precedence_9, -1) p_9,
4801: nvl(precedence_10, -1) p_10,
4802: tax_id,
4803: tax_category_id
4804: FROM JAI_OM_OE_SO_TAXES
4805: WHERE line_id = p_line_id;
4806: --Added by zhiwei for BOE ER bug 11684111 begin
4807: ---------------------------------------------
4808: CURSOR c_boe_line_taxes(p_line_id NUMBER) IS
5111: DELETE FROM JAI_PO_TAXES
5112: WHERE line_focus_id = p_line_focus_id AND tax_category_id IS NOT NULL;
5113: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';
5114: ELSIF p_document_type = 'SO' THEN
5115: DELETE FROM JAI_OM_OE_SO_TAXES
5116: WHERE line_id = p_line_id AND tax_category_id IS NOT NULL;
5117: p_message := 'No Manual taxes are attached to the SO line, so no problem is deleting the line taxes';
5118: --Added by zhiwei for BOE ER bug 11684111 begin
5119: -------------------------------------------------
5146:
5147: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';
5148:
5149: ELSIF p_document_type = 'SO' THEN
5150: DELETE FROM JAI_OM_OE_SO_TAXES
5151: WHERE line_id = p_line_id
5152: AND tax_category_id IS NOT NULL;
5153:
5154: p_message := 'No Manual taxes are attached to the SO line, so no problem is deleting the line taxes';