[Home] [Help]
442: a.qty_rate,
443: a.tax_rate, a.tax_amount, a.uom, b.end_date valid_date,
444: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
445: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd
446: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
447: WHERE a.link_to_cust_trx_line_id = p_line_id
448: AND a.tax_id = b.tax_id
449: ORDER BY a.tax_line_no;
450:
1079: -- CLOSE Fetch_Matched_Qty_AR_Cur;
1080:
1081: IF p_line_quantity <> 0 THEN
1082: FOR Rec IN Fetch_Total_AR_Cur( i ) LOOP
1083: UPDATE JAI_AR_TRX_TAX_LINES
1084: SET Tax_Amount = rec.tax_amount,
1085: Base_Tax_Amount = rec.base_tax_amount,
1086: Func_Tax_Amount = rec.func_tax_amount
1087: WHERE link_to_cust_trx_line_id = p_ref_line_id
1087: WHERE link_to_cust_trx_line_id = p_ref_line_id
1088: AND Tax_Line_No = i;
1089: END LOOP;
1090: ELSE
1091: UPDATE JAI_AR_TRX_TAX_LINES
1092: SET Tax_Amount = tax_amt_tab(i),
1093: Base_Tax_Amount = tax_target_tab(i),
1094: Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )
1095: WHERE link_to_cust_trx_line_id = p_ref_line_id
1129: WHERE Customer_Trx_Line_Id = p_ref_line_id;
1130:
1131: CURSOR Chk_New_Added_Tax_Cur IS
1132: SELECT NVL( MAX( Tax_Line_No ), 0 )
1133: FROM JAI_AR_TRX_TAX_LINES
1134: WHERE Link_To_Cust_Trx_Line_Id = p_link_to_cust_trx_line_id;
1135:
1136: CURSOR Chk_Tax_Count_Cur IS
1137: SELECT NVL( MAX( Tax_Line_No ), 0 )
1139: WHERE Ref_Line_Id = p_ref_line_id;
1140:
1141: CURSOR Fetch_New_Taxes_Cur IS
1142: SELECT *
1143: FROM JAI_AR_TRX_TAX_LINES
1144: WHERE Link_To_Cust_Trx_Line_Id = p_link_to_cust_trx_line_id
1145: AND Tax_Line_No > nvl(v_tax_line_no,0)
1146: ORDER BY Tax_Line_No;
1147:
1541: lv_sh_cvd_cess_code,4,
1542: 0) tax_type_val,
1543: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd, b.adhoc_flag /* Added for bug 5091874*/
1544: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1545: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
1546: WHERE a.link_to_cust_trx_line_id = p_line_id
1547: AND a.tax_id = b.tax_id
1548: ORDER BY a.tax_line_no;
1549:
1679: AND b.tax_type = p_Cess_type_code;/*Bug 5989740 bduvarag*/
1680:
1681: CURSOR c_ar_excise_cess_cnt(cp_customer_trx_line_id IN NUMBER) IS
1682: SELECT count(1)
1683: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
1684: WHERE a.link_to_cust_trx_line_id = cp_customer_trx_line_id
1685: AND a.tax_id = b.tax_id
1686: AND b.tax_type = p_Cess_type_code ;/*Bug 5989740 bduvarag*/
1687:
1765: is that , manual rg23d receipts and receipts created by iso transactions are not
1766: picked by this cursor.
1767:
1768: Hence, the cursor which was used earlier has been retained , which picks the taxes
1769: from JAI_AR_TRX_TAX_LINES table and then calculate the excise tax bases on
1770: the excise duty per unit and the same is updated back to the
1771: localization AR table.
1772:
1773: 3. 05/05/2004 Aiyer - Bug # 3611625, FileVersion 619.1
3648: END IF;
3649:
3650: IF p_line_quantity <> 0 THEN
3651: FOR Rec IN Fetch_Total_AR_Cur( i ) LOOP
3652: UPDATE JAI_AR_TRX_TAX_LINES
3653: SET Tax_Amount = rec.tax_amount,
3654: Base_Tax_Amount = rec.base_tax_amount,
3655: Func_Tax_Amount = rec.func_tax_amount
3656: WHERE link_to_cust_trx_line_id = p_ref_line_id
3656: WHERE link_to_cust_trx_line_id = p_ref_line_id
3657: AND Tax_Line_No = i;
3658: END LOOP;
3659: ELSE
3660: UPDATE JAI_AR_TRX_TAX_LINES
3661: SET Tax_Amount = tax_amt_tab(i),
3662: Base_Tax_Amount = tax_target_tab(i),
3663: Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )
3664: WHERE link_to_cust_trx_line_id = p_ref_line_id