[Home] [Help]
118: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8,a.precedence_9 p_9, a.precedence_10 p_10,
119: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type,
120: a.vendor_id, a.modvat_flag,
121: tax_category_id -- cbabu for EnhancementBug# 2427465
122: FROM JAI_PO_TAXES a
123: WHERE a.line_location_id = p_line_location_id
124: ORDER BY a.tax_line_no;
125:
126: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
130: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8, a.precedence_9 p_9, a.precedence_10 p_10,
131: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type,
132: a.vendor_id, a.modvat_flag,
133: tax_category_id -- cbabu for EnhancementBug# 2427465
134: FROM JAI_PO_TAXES a
135: WHERE a.po_line_id = v_po_line_id
136: AND Line_Location_Id IS NULL
137: ORDER BY a.tax_line_no;*/
138: --pramasub commented for FP end
158: a.tax_type ,
159: a.vendor_id ,
160: a.modvat_flag ,
161: tax_category_id -- cbabu for EnhancementBug# 2427465
162: FROM JAI_PO_TAXES a --Ja_In_Po_Line_Location_Taxes a
163: WHERE po_line_id = p_po_line_id
164: AND nvl(line_location_id,-999) = p_line_location_id
165: ORDER BY a.tax_line_no; --new cursor added by pramasub for FP
166:
979: ln_vat_assess_value NUMBER; -- added rallamse bug#4250072 VAT
980: -- ln_gst_assessable_value NUMBER; -- Added by Jia for GST Bug#10091373 on 2010/09/10
981: v_loc_count NUMBER;--File.Sql.35 Cbabu := 0; --new variable for loc chk on 17-aug-00
982:
983: v_tax_category_id JAI_PO_TAXES.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
984: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
985: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
986:
987: ------------------------------>
1079:
1080:
1081: CURSOR Tot_Amt_Cur IS
1082: SELECT SUM( NVL( Tax_Amount, 0 ) )
1083: FROM JAI_PO_TAXES
1084: WHERE line_location_id = v_line_loc_id
1085: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS'; Ramananda for removal of SQL LITERALs */
1086:
1087: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00
1143: AND Line_Location_Id = line_loc_id;
1144:
1145: Cursor fetch_Tax_cnt( cp_line_loc_id in number ) is
1146: select count(1)
1147: from JAI_PO_TAXES
1148: where line_location_id = cp_line_loc_id;
1149:
1150: /* Bug 5243532. Added by Lakshmi Gopalsami
1151: * Removed cursors Fetch_Book_Id and used po_requisition_headers_v
1523:
1524:
1525: IF NVL(lv_tax_modified_flag,'N') = 'N' THEN --added, Bgowrava for Bug#6084636
1526:
1527: DELETE FROM JAI_PO_TAXES
1528: WHERE line_location_id = pr_new.line_location_id;
1529:
1530: IF v_debug THEN -- bug 7218695. Added by Lakshmi Gopalsami
1531:
1705: END IF;
1706: END IF;
1707:
1708: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
1709: INSERT INTO JAI_PO_TAXES(
1710: line_focus_id, line_location_id, tax_line_no, po_line_id, po_header_id,
1711: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
1712: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
1713: tax_id, currency, tax_rate, qty_rate, uom,
1995: a.vendor_id ,
1996: a.modvat_flag ,
1997: tax_category_id
1998: --FROM Ja_In_Po_Line_Location_Taxes a
1999: FROM JAI_PO_TAXES a
2000: WHERE po_line_id = p_po_line_id
2001: AND nvl(line_location_id,-999) = p_line_location_id
2002: ORDER BY a.tax_line_no;
2003: