[Home] [Help]
606: , jpt.tax_line_no -- added by kunkumar for bug 5593895
607: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
608: FROM
609: JAI_PO_TAXES jpt
610: , JAI_CMN_TAXES_ALL jcta --Added by Eric for Inclusive Tax
611: -- WHERE line_focus_id = focus_id
612: WHERE line_location_id = p_line_location_id -- 3096578
613: AND NVL(UPPER(jpt.tax_type), 'A')
614: NOT IN( 'TDS'
638: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
639: FROM
640: jai_retro_tax_changes jrl
641: , jai_retro_line_changes jrlc
642: , jai_cmn_taxes_all jcta
643: WHERE jrlc.line_location_id = p_line_location_id
644: AND jrlc.line_change_id = jrl.line_change_id
645: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
646: FROM jai_retro_line_changes
671: mod_cr_percentage, -- bug 3051828
672: adhoc_flag, -- added by aparajita on 23/01/2003 for bug # 2694011
673: nvl(tax_rate,-1) tax_rate, --Modified by kunkumar for bug 5593895
674: tax_type
675: FROM JAI_CMN_TAXES_ALL
676: WHERE tax_id = t_id;
677:
678: CURSOR c_inv(inv_id NUMBER) IS
679: SELECT batch_id,source
766: FROM
767: JAI_RCV_LINE_TAXES jrl
768: , RCV_SHIPMENT_LINES RSL
769: , RCV_TRANSACTIONS RT
770: , jai_cmn_taxes_all jcta
771: WHERE jrl.shipment_line_id = rsl.shipment_line_id
772: AND rt.shipment_line_id = rsl.shipment_line_id
773: AND rt.transaction_id = tran_id
774: AND jrl.vendor_id = ven_id
805: FROM
806: jai_rcv_line_taxes jrl
807: , rcv_shipment_lines rsl
808: , rcv_transactions rt
809: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
810: WHERE jrl.shipment_line_id = rsl.shipment_line_id
811: AND rt.shipment_line_id = rsl.shipment_line_id
812: AND rt.transaction_id = tran_id
813: AND jrl.vendor_id = ven_id
836: jai_retro_tax_changes jrl
837: , rcv_shipment_lines rsl
838: , rcv_transactions rt
839: , jai_retro_line_changes jrlc
840: , jai_cmn_taxes_all jcta
841: WHERE jrlc.doc_line_id = rsl.shipment_line_id
842: AND jrlc.line_change_id = jrl.line_change_id
843: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
844: FROM jai_retro_line_changes
878: where currency_code = cp_currency_code;
879:
880: -- ends here additions by ssumaith -bug# 3127834
881: --Added by kunkumar for porting 4454499
882: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
883: select NVL(rounding_factor,-1)
884: from jai_cmn_taxes_all
885: where tax_id = cp_tax_id ;
886:
880: -- ends here additions by ssumaith -bug# 3127834
881: --Added by kunkumar for porting 4454499
882: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
883: select NVL(rounding_factor,-1)
884: from jai_cmn_taxes_all
885: where tax_id = cp_tax_id ;
886:
887: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
888: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
1319: 2. 29-mar-01 Subramanyam S.K added modifications for STForm
1320: Tracking at AP level. Insert statments for JA_in_po_st_forms_hdr
1321: and ja_in_po_st_forms_dtl after validating whether
1322: the tax line is Sales Tax or CST and for these taxes
1323: stform_type(JAI_CMN_TAXES_ALL) is not null.
1324:
1325: 3. 20-apr-01 Modifications done by Ajay Sharma for correct calculation
1326: of taxes and invoice amount at the time of RCV_MATCHING
1327:
5772:
5773: CURSOR c_tax(t_id NUMBER) IS
5774: SELECT tax_name, tax_account_id, mod_cr_percentage, tax_type
5775: -- bug 3051832, mod_cr_percentage added by aparajita on 10/10/2002 for bug # 2616100
5776: FROM JAI_CMN_TAXES_ALL
5777: WHERE tax_id = t_id;
5778:
5779: CURSOR c_inv(inv_id NUMBER) IS
5780: SELECT batch_id,source
5838: FROM
5839: JAI_RCV_LINE_TAXES jrl
5840: , rcv_shipment_lines rsl
5841: , rcv_transactions rt
5842: , jai_cmn_taxes_all jcta
5843: WHERE jrl.shipment_line_id = rsl.shipment_line_id
5844: AND rt.shipment_line_id = rsl.shipment_line_id
5845: AND rt.transaction_id = tran_id
5846: AND jrl.vendor_id = ven_id
5876: , jpt.tax_line_no --Added by kunkumar for bug#5593895
5877: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
5878: FROM
5879: jai_po_taxes jpt
5880: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
5881: -- WHERE line_focus_id = focus_id
5882: WHERE jpt.line_location_id = p_line_location_id -- 3096578
5883: AND jcta.tax_id = jpt.tax_id --Added by Eric for Inclusive Tax
5884: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
5904: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
5905: FROM
5906: jai_cmn_lines lines
5907: , jai_cmn_document_Taxes taxes
5908: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
5909: WHERE lines.cmn_line_id = taxes.source_doc_line_id
5910: AND taxes.source_doc_type = 'ASBN'
5911: AND lines.po_line_location_id = p_line_location_id
5912: AND lines.shipment_number = cp_shipment_num
6058: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
6059: and attribute_code = cp_tax_type;
6060:
6061: /*Added by kunkumar for bug#5593895*/
6062: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
6063: select NVL(rounding_factor,-1)
6064: from jai_cmn_taxes_all
6065: where tax_id = cp_tax_id ;
6066: /*End, Added by kunkumar for bug#5593895*/
6060:
6061: /*Added by kunkumar for bug#5593895*/
6062: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
6063: select NVL(rounding_factor,-1)
6064: from jai_cmn_taxes_all
6065: where tax_id = cp_tax_id ;
6066: /*End, Added by kunkumar for bug#5593895*/
6067:
6068: r_rcv_transactions c_rcv_transactions%rowtype;
6080: r_vat_regimes c_jai_regimes%rowtype;
6081: r_vat_regime_tax_type c_regime_tax_type%rowtype;
6082:
6083: ln_base_amount number ; --Added by kunkumar for bug#5593895
6084: ln_tax_precision JAI_CMN_TAXES_ALL.rounding_factor%type;--Added by kunkumar for bug#5593895
6085:
6086: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
6087:
6088: v_total_tax_in_payment number;