APPS.JAI_CMN_MTAX_PKG dependencies on JAI_OM_OE_SO_LINES

Line 682: FROM oe_order_headers_all ooha, oe_order_lines_all oola, JAI_OM_OE_SO_LINES jisl

678: ooha.transactional_curr_code currency_code, ooha.conversion_type_code, ooha.conversion_rate,
679: ooha.conversion_rate_date conversion_date,
680: ooha.ordered_date date_ordered, ooha.creation_date,
681: ooha.order_type_id, ooha.order_number document_no, oola.line_number
682: FROM oe_order_headers_all ooha, oe_order_lines_all oola, JAI_OM_OE_SO_LINES jisl
683: WHERE ooha.header_id = oola.header_id
684: AND oola.line_id = jisl.line_id
685: AND oola.open_flag = 'Y'
686: AND ((p_document_no is null) OR (p_document_no is not null and ooha.order_number = p_document_no ))

Line 3404: UPDATE JAI_OM_OE_SO_LINES

3400: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3401: END IF;
3402:
3403:
3404: UPDATE JAI_OM_OE_SO_LINES
3405: SET assessable_value = v_assessable_value,
3406: vat_assessable_value = ln_vat_assess_value, -- added, Harshita for bug #4245062
3407: tax_amount = nvl(v_line_tax_amount,0),
3408: line_amount = v_line_amount,

Line 3615: p_line_id IN NUMBER, -- if 'SO' then this should contain JAI_OM_OE_SO_LINES.line_id

3611: (
3612: p_document_type IN VARCHAR2, -- eg. PO, SO, REQUISITION
3613: p_line_focus_id IN NUMBER, -- IF 'PO' this should contain JAI_PO_LINE_LOCATIONS.line_focus_id and
3614: p_line_location_id IN NUMBER,
3615: p_line_id IN NUMBER, -- if 'SO' then this should contain JAI_OM_OE_SO_LINES.line_id
3616: p_success OUT NOCOPY NUMBER,
3617: p_message OUT NOCOPY VARCHAR2
3618: ) IS
3619:

Line 3784: 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

3780:
3781: END LOOP;
3782:
3783: ELSIF p_document_type IN ( 'SO' ) THEN
3784: 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
3785: j := j + 1;
3786:
3787: -- we have to identify the defaulted taxes that are not dependant on any other taxes and any
3788: -- manually added tax is not dependant on the defaulted taxes and then populate plsql table so that