[Home] [Help]
501: a.qty_rate,
502: a.tax_rate, a.tax_amount, a.uom, b.end_date valid_date,
503: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
504: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd
505: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
506: WHERE a.link_to_cust_trx_line_id = p_line_id
507: AND a.tax_id = b.tax_id
508: ORDER BY a.tax_line_no;
509:
1138: -- CLOSE Fetch_Matched_Qty_AR_Cur;
1139:
1140: IF p_line_quantity <> 0 THEN
1141: FOR Rec IN Fetch_Total_AR_Cur( i ) LOOP
1142: UPDATE JAI_AR_TRX_TAX_LINES
1143: SET Tax_Amount = rec.tax_amount,
1144: Base_Tax_Amount = rec.base_tax_amount,
1145: Func_Tax_Amount = rec.func_tax_amount
1146: WHERE link_to_cust_trx_line_id = p_ref_line_id
1146: WHERE link_to_cust_trx_line_id = p_ref_line_id
1147: AND Tax_Line_No = i;
1148: END LOOP;
1149: ELSE
1150: UPDATE JAI_AR_TRX_TAX_LINES
1151: SET Tax_Amount = tax_amt_tab(i),
1152: Base_Tax_Amount = tax_target_tab(i),
1153: Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )
1154: WHERE link_to_cust_trx_line_id = p_ref_line_id
1188: WHERE Customer_Trx_Line_Id = p_ref_line_id;
1189:
1190: CURSOR Chk_New_Added_Tax_Cur IS
1191: SELECT NVL( MAX( Tax_Line_No ), 0 )
1192: FROM JAI_AR_TRX_TAX_LINES
1193: WHERE Link_To_Cust_Trx_Line_Id = p_link_to_cust_trx_line_id;
1194:
1195: CURSOR Chk_Tax_Count_Cur IS
1196: SELECT NVL( MAX( Tax_Line_No ), 0 )
1198: WHERE Ref_Line_Id = p_ref_line_id;
1199:
1200: CURSOR Fetch_New_Taxes_Cur IS
1201: SELECT *
1202: FROM JAI_AR_TRX_TAX_LINES
1203: WHERE Link_To_Cust_Trx_Line_Id = p_link_to_cust_trx_line_id
1204: AND Tax_Line_No > nvl(v_tax_line_no,0)
1205: ORDER BY Tax_Line_No;
1206:
1625: AND jrttv.regime_code = jai_constants.vat_regime), 5,
1626: 'VAT REVERSAL', 6, 0)) tax_type_val,
1627: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd, b.adhoc_flag /* Added for bug 5091874*/
1628: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1629: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b,
1630: jai_regime_tax_types_v aa -- Add by Xiao for GST refer to bug#10043656.
1631: WHERE a.link_to_cust_trx_line_id = p_line_id
1632: AND a.tax_id = b.tax_id
1633: AND aa.tax_type(+) = b.tax_type -- Add by Xiao for GST refer to bug#10043656.
1774: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1775:
1776: CURSOR c_ar_excise_cess_cnt(cp_customer_trx_line_id IN NUMBER) IS
1777: SELECT count(1)
1778: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
1779: WHERE a.link_to_cust_trx_line_id = cp_customer_trx_line_id
1780: AND a.tax_id = b.tax_id
1781: AND b.tax_type = p_Cess_type_code ;/*Bug 5989740 bduvarag*/
1782:
1860: is that , manual rg23d receipts and receipts created by iso transactions are not
1861: picked by this cursor.
1862:
1863: Hence, the cursor which was used earlier has been retained , which picks the taxes
1864: from JAI_AR_TRX_TAX_LINES table and then calculate the excise tax bases on
1865: the excise duty per unit and the same is updated back to the
1866: localization AR table.
1867:
1868: 3. 05/05/2004 Aiyer - Bug # 3611625, FileVersion 619.1
4506: END IF;
4507:
4508: IF p_line_quantity <> 0 THEN
4509: FOR Rec IN Fetch_Total_AR_Cur( i ) LOOP
4510: UPDATE JAI_AR_TRX_TAX_LINES
4511: SET Tax_Amount = rec.tax_amount,
4512: Base_Tax_Amount = rec.base_tax_amount,
4513: Func_Tax_Amount = rec.func_tax_amount
4514: WHERE link_to_cust_trx_line_id = p_ref_line_id
4514: WHERE link_to_cust_trx_line_id = p_ref_line_id
4515: AND Tax_Line_No = i;
4516: END LOOP;
4517: ELSE
4518: UPDATE JAI_AR_TRX_TAX_LINES
4519: SET Tax_Amount = tax_amt_tab(i),
4520: -- Base_Tax_Amount = tax_target_tab(i),
4521: Base_Tax_Amount = lt_base_tax_amt_tab(i) --bug#9794853
4522: ,Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )