[Home] [Help]
395: ORDER BY tax_line_no;
396:
397: CURSOR c_manual_so_taxes_up(p_line_id IN NUMBER) IS
398: SELECT rowid, tax_line_no
399: FROM JAI_OM_OE_SO_TAXES
400: WHERE line_id = p_line_id
401: AND tax_category_id IS NULL
402: ORDER BY tax_line_no;
403:
3174: */
3175:
3176: -- The adhoc data is preserved to capture the tax_amount later.
3177: -- added by Harshita for Bug #3765133
3178: insert into JAI_OM_OE_SO_TAXES
3179: (line_id,tax_line_no,header_id,
3180: tax_id, tax_amount,
3181: creation_date,created_by,
3182: last_update_date, last_updated_by,last_update_login)
3185: A.tax_id, A.tax_amount,
3186: A.creation_date,A.created_by,
3187: A.last_update_date, A.last_updated_by,A.last_update_login
3188: FROM
3189: JAI_OM_OE_SO_TAXES A,
3190: JAI_CMN_TAXES_ALL B
3191: WHERE
3192: A.tax_id = B.tax_id AND
3193: line_id = so_rec.line_id AND
3194: NVL(adhoc_flag,'N') = 'Y';
3195: -- end, Harshita for Bug #3765133
3196:
3197: IF p_override_manual_taxes = 'Y' THEN
3198: DELETE FROM JAI_OM_OE_SO_TAXES
3199: WHERE line_id = so_rec.line_id;
3200:
3201: 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
3202: ELSE
3228: ||', tax_rec.p_10 -> '||tax_rec.p_10
3229: );
3230: END IF;
3231:
3232: INSERT INTO JAI_OM_OE_SO_TAXES(
3233: tax_line_no, line_id, header_id,
3234: precedence_1,
3235: precedence_2,
3236: precedence_3,
3260: /* Harshita - Update the tax_amount in the latest records
3261: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
3262:
3263: UPDATE
3264: JAI_OM_OE_SO_TAXES a
3265: SET
3266: tax_amount = (SELECT tax_amount
3267: FROM JAI_OM_OE_SO_TAXES
3268: where tax_id = a.tax_id
3263: UPDATE
3264: JAI_OM_OE_SO_TAXES a
3265: SET
3266: tax_amount = (SELECT tax_amount
3267: FROM JAI_OM_OE_SO_TAXES
3268: where tax_id = a.tax_id
3269: and line_id = -so_rec.line_id)
3270: WHERE
3271: line_id = so_rec.line_id
3283: IF p_override_manual_taxes <> 'Y' THEN
3284: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
3285: FOR tax_rec IN c_manual_so_taxes_up(so_rec.line_id) LOOP
3286: j := j + 1;
3287: UPDATE JAI_OM_OE_SO_TAXES SET tax_line_no = j
3288: WHERE rowid = tax_rec.rowid;
3289: END LOOP;
3290: END IF;
3291:
3442:
3443: END IF;
3444: -- added, Harshita for Bug #3765133
3445: /* Temporary data stored previously will be flushed using following DELETE */
3446: DELETE FROM JAI_OM_OE_SO_TAXES
3447: WHERE line_id = -so_rec.line_id;
3448: -- ended, Harshita for Bug #3765133
3449:
3450: ELSE
3653: nvl(precedence_9, -1) p_9,
3654: nvl(precedence_10, -1) p_10,
3655: tax_id,
3656: tax_category_id
3657: FROM JAI_OM_OE_SO_TAXES
3658: WHERE line_id = p_line_id;
3659:
3660: CURSOR c_req_line_taxes(p_requisition_line_id NUMBER) IS
3661: SELECT tax_line_no,
3896: DELETE FROM JAI_PO_TAXES
3897: WHERE line_focus_id = p_line_focus_id AND tax_category_id IS NOT NULL;
3898: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';
3899: ELSIF p_document_type = 'SO' THEN
3900: DELETE FROM JAI_OM_OE_SO_TAXES
3901: WHERE line_id = p_line_id AND tax_category_id IS NOT NULL;
3902: p_message := 'No Manual taxes are attached to the SO line, so no problem is deleting the line taxes';
3903: ELSIF p_document_type = 'REQUISITION' THEN
3904: DELETE FROM JAI_PO_REQ_LINE_TAXES
3920:
3921: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';
3922:
3923: ELSIF p_document_type = 'SO' THEN
3924: DELETE FROM JAI_OM_OE_SO_TAXES
3925: WHERE line_id = p_line_id
3926: AND tax_category_id IS NOT NULL;
3927:
3928: p_message := 'No Manual taxes are attached to the SO line, so no problem is deleting the line taxes';