[Home] [Help]
28: RETURNs true if ISO Entries needs to be passed for transaction, else returns false. This is basically an applicability func.
29: - GET_ANCESTOR_ID
30: RETURNs the transaction_id of PARANT transaction type required for the current transaction
31: - GET_APPORTION_FACTOR
32: RETURNs the factor that should be used for multiplication with transaction Quantity and JAI_RCV_LINE_TAXES.tax amount to
33: get the transaction tax amount
34: - GET_TRXN_CENVAT_AMOUNT
35: RETURNs the transaction EXCISE Amount
36: - GET_TRXN_TAX_AMOUNT
624: -- added, Ramananda for bug # 4519719
625: CURSOR c_vat_exists(cp_shipment_line_id NUMBER )
626: IS
627: SELECT 1
628: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
629: WHERE shipment_line_id = cp_shipment_line_id AND
630: b.regime_code= jai_constants.vat_regime
631: and b.tax_type = a.tax_type ;
632:
1473: WHERE invoice_id = ln_invoice_id
1474: AND invoice_distribution_id /*distribution_line_number*/ IN /*Replaced distribution_line_number by invoice_distribution_id for bug # 11659328*/
1475: (SELECT invoice_distribution_id /*distribution_line_number*/
1476: FROM jai_ap_match_inv_taxes jatd,
1477: jai_rcv_line_taxes jrtl
1478: WHERE jatd.invoice_id=ln_invoice_id
1479: AND jrtl.transaction_id=r_trx.tax_transaction_id
1480: AND jrtl.modvat_flag = 'Y'
1481: AND jrtl.shipment_line_id = temp_rec.shipment_line_id
1492: END LOOP;
1493: /*Bug 8648138*/
1494:
1495: -- By doing this future transactions will be taken care not to see Excise taxes as Recoverable
1496: UPDATE JAI_RCV_LINE_TAXES
1497: SET modvat_flag ='N',
1498: last_update_date = sysdate,
1499: last_updated_by = fnd_global.user_id,
1500: last_update_login = fnd_global.login_id
3621: lv_third_party_flag VARCHAR2(1);
3622:
3623: CURSOR c_non_po_vendor_cnt(cp_shipment_header_id IN NUMBER, cp_shipment_line_id IN NUMBER) IS /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3624: SELECT nvl(count(distinct vendor_id), 0)
3625: from JAI_RCV_LINE_TAXES
3626: where shipment_line_id = cp_shipment_line_id
3627: AND vendor_id <> (SELECT vendor_id
3628: FROM rcv_shipment_headers
3629: WHERE shipment_header_id = cp_shipment_header_id
4086: jai_constants.tax_type_exc_edu_cess,1,
4087: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
4088: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4089: ) excise_cnt
4090: FROM JAI_RCV_LINE_TAXES
4091: WHERE shipment_line_id = cp_shipment_line_id
4092: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery); --('TDS', 'MODVAT RECOVERY')
4093:
4094: CURSOR c_excise_tax_count(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is
4092: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery); --('TDS', 'MODVAT RECOVERY')
4093:
4094: CURSOR c_excise_tax_count(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is
4095: SELECT count(1)
4096: FROM JAI_RCV_LINE_TAXES
4097: WHERE shipment_line_id = cp_shipment_line_id
4098: -- AND tax_type NOT IN ('TDS','Modvat Recovery')
4099: AND modvat_flag = jai_constants.yes
4100: AND upper(tax_type) IN ( 'EXCISE',
4112:
4113: ln_recoverable_vat_tax_cnt NUMBER;
4114: CURSOR c_recoverable_vat_tax_cnt(cp_shipment_line_id number, cp_regime_code varchar2) is
4115: SELECT count(1)
4116: FROM JAI_RCV_LINE_TAXES
4117: WHERE shipment_line_id = cp_shipment_line_id
4118: AND modvat_flag = jai_constants.yes
4119: AND tax_type IN
4120: ( select tax_type from jai_regime_tax_types_v /*modified this to use View as part of OPM changes */
4174: or less than 100*/
4175: Cursor c_check_non_recover_taxes (p_shipment_line_id number) is /*Added by nprashar for bug # 9767315*/
4176: select 1 from dual
4177: Where Exists (
4178: select 1 from jai_rcv_line_taxes jrlt, jai_cmn_taxes_all jcta
4179: where jrlt.tax_id = jcta.tax_id
4180: and jrlt.shipment_line_id = p_shipment_line_id
4181: and (jrlt.modvat_flag = 'N' or (jrlt.modvat_flag='Y' and nvl(jcta.mod_cr_percentage,0)<100)));
4182:
4224:
4225:
4226: CURSOR ship_cur (c_shipment_line_id NUMBER) IS
4227: SELECT tax_amount,currency
4228: FROM jai_Rcv_line_taxes
4229: WHERE shipment_line_id = c_shipment_line_id
4230: AND upper(tax_type) IN (jai_constants.tax_type_cvd, jai_constants.tax_type_add_cvd, UPPER(jai_constants.tax_type_customs),
4231: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess,
4232: jai_constants.tax_type_sh_customs_edu_Cess);
5142: WHERE shipment_line_id = cp_shipment_line_id;
5143:
5144: CURSOR c_excise_tax_cnt(cp_shipment_line_id number) is
5145: SELECT count(1)
5146: FROM JAI_RCV_LINE_TAXES
5147: WHERE shipment_line_id = cp_shipment_line_id
5148: -- CVD is Not Considered, because in ISO scenario CVD is not supported.
5149: AND upper(tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess); --Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
5150:
5295: ) non_inr_tax_amount,
5296: sum(
5297: nvl(tax_amount, 0) * decode(currency, jai_general_pkg.INDIAN_CURRENCY, 1, cp_curr_conv_rate)
5298: ) inr_tax_amount
5299: FROM JAI_RCV_LINE_TAXES
5300: WHERE shipment_line_id = cp_shipment_line_id
5301: AND tax_type NOT IN ('TDS', 'Modvat Recovery');
5302:
5303: ln_tax_amount NUMBER;
5343: ) manufacturing_cenvat,
5344: sum(
5345: nvl(a.tax_amount, 0) * decode(a.currency, jai_general_pkg.INDIAN_CURRENCY, 1, cp_curr_conv_rate)
5346: ) trading_cenvat
5347: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
5348: WHERE shipment_line_id = cp_shipment_line_id
5349: AND a.tax_id = b.tax_id
5350: AND upper(a.tax_type) IN ( 'EXCISE',
5351: 'ADDL. EXCISE',