[Home] [Help]
815: ooha.transactional_curr_code currency_code, ooha.conversion_type_code, ooha.conversion_rate,
816: ooha.conversion_rate_date conversion_date,
817: ooha.ordered_date date_ordered, ooha.creation_date,
818: ooha.order_type_id, ooha.order_number document_no, oola.line_number
819: FROM oe_order_headers_all ooha, oe_order_lines_all oola, JAI_OM_OE_SO_LINES jisl
820: WHERE ooha.header_id = oola.header_id
821: AND oola.line_id = jisl.line_id
822: AND oola.open_flag = 'Y'
823: AND ((p_document_no is null) OR (p_document_no is not null and ooha.order_number = p_document_no ))
1221: FIX: modified the code in the do_tax_redefaultation. Commented the check
1222: for the value of release no.
1223: 12. 12-May-2009 JMEENA for bug#6335001
1224: Issue: VAT ASSESSABLE PRICE IN SO CHANGES AFTER RUNNING INDIA MASS TAX CALCULATION
1225: Fix: Modified code to update the correct VAT Assessable Value in the table JAI_OM_OE_SO_LINES.
1226:
1227: 13. 28-Jul-2009 Xiao Lv for IL Advanced Pricing.
1228: Add if condition control for specific release version, code as:
1229: IF lv_release_name NOT LIKE '12.0%' THEN
3988: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3989: END IF;
3990:
3991:
3992: UPDATE JAI_OM_OE_SO_LINES
3993: SET assessable_value = v_assessable_value,
3994: vat_assessable_value = ln_vat_assess_amount, --Replaced ln_vat_assess_value with ln_vat_assess_amount by JMEENA for bug#6335001
3995: -- gst_assessable_value = ln_gst_assess_amount, --Added by zhiwei for bug10043656 GST enhancement 2010/09/14
3996: tax_amount = nvl(v_line_tax_amount,0),
4758: (
4759: p_document_type IN VARCHAR2, -- eg. PO, SO, REQUISITION
4760: p_line_focus_id IN NUMBER, -- IF 'PO' this should contain JAI_PO_LINE_LOCATIONS.line_focus_id and
4761: p_line_location_id IN NUMBER,
4762: p_line_id IN NUMBER, -- if 'SO' then this should contain JAI_OM_OE_SO_LINES.line_id
4763: p_success OUT NOCOPY NUMBER,
4764: p_message OUT NOCOPY VARCHAR2
4765: ) IS
4766:
4947:
4948: END LOOP;
4949:
4950: ELSIF p_document_type IN ( 'SO' ) THEN
4951: FOR processing_rec IN c_so_line_taxes(p_line_id) LOOP -- p_line_focus_id should contain JAI_OM_OE_SO_LINES.line_id
4952: j := j + 1;
4953:
4954: -- we have to identify the defaulted taxes that are not dependant on any other taxes and any
4955: -- manually added tax is not dependant on the defaulted taxes and then populate plsql table so that
4994: ELSIF p_document_type IN ( 'BOE' ) THEN
4995:
4996:
4997:
4998: FOR processing_rec IN c_boe_line_taxes(p_line_id) LOOP -- p_line_focus_id should contain JAI_OM_OE_SO_LINES.line_id
4999: j := j + 1;
5000:
5001: -- we have to identify the defaulted taxes that are not dependant on any other taxes and any
5002: -- manually added tax is not dependant on the defaulted taxes and then populate plsql table so that