eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_LINE_TAXES

Line 416: FROM JAI_RCV_LINE_TAXES a,

412: ) tax_amount*/,
413: a.tax_type,
414: a.tax_id,
415: NVL(b.rounding_factor,0) rounding_factor
416: FROM JAI_RCV_LINE_TAXES a,
417: JAI_CMN_TAXES_ALL b
418: WHERE a.transaction_id = cp_transaction_id
419: AND a.tax_type IN ( select tax_type
420: from jai_regime_tax_types_v

Line 687: FROM JAI_RCV_LINE_TAXES rtl,

683: nvl(rtl.modvat_flag, 'N') modvat_flag,
684: nvl(rtl.currency, jai_constants.func_curr) currency,
685: nvl(jtc.rounding_factor, 0) rnd,
686: nvl(jtc.mod_cr_percentage, 0) modvat_percentage /*Added by Nitin for bug # 6681800*/
687: FROM JAI_RCV_LINE_TAXES rtl,
688: JAI_CMN_TAXES_ALL jtc
689: WHERE shipment_line_id = cp_shipment_line_id
690: AND jtc.tax_id = rtl.tax_id
691: AND rtl.modvat_flag = 'Y'

Line 739: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b

735:
736: CURSOR c_vat_exists(cp_shipment_line_id NUMBER )
737: IS
738: SELECT 1
739: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
740: WHERE shipment_line_id = cp_shipment_line_id AND
741: b.regime_code= jai_constants.vat_regime
742: and b.tax_type = a.tax_type ;
743:

Line 1135: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

1131: lv_process_message VARCHAR2(1000);
1132: ln_location_id NUMBER;
1133: ln_statement_id NUMBER;
1134:
1135: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1136: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1137: IS
1138: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1139: FROM JAI_RCV_LINE_TAXES

Line 1139: FROM JAI_RCV_LINE_TAXES

1135: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1136: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1137: IS
1138: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1139: FROM JAI_RCV_LINE_TAXES
1140: WHERE transaction_id = cp_transaction_id
1141: AND tax_type in (select tax_type
1142: from jai_regime_tax_types_v
1143: where regime_code = jai_constants.vat_regime)

Line 2313: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

2309: AND a.organization_id = b.organization_id
2310: AND a.location_id = b.location_id
2311: AND b.process_status_flag = 'Z'; /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
2312:
2313: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2314: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2315: IS
2316: SELECT jtl.tax_type,
2317: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount

Line 2319: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/

2315: IS
2316: SELECT jtl.tax_type,
2317: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount
2318: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2319: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2320: WHERE jtl.transaction_id = cp_transaction_id
2321: AND jtl.tax_type in (select tax_type
2322: from jai_regime_tax_types_v
2323: where regime_code = jai_constants.vat_regime)

Line 2328: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

2324: AND NVL(jtl.modvat_flag,'N') = 'Y'
2325: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2326: GROUP BY jtl.tax_type;
2327:
2328: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2329: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2330: IS
2331: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /*Added by Nitin for bug # 6681800*/a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount
2332: FROM JAI_RCV_LINE_TAXES a,

Line 2332: FROM JAI_RCV_LINE_TAXES a,

2328: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2329: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2330: IS
2331: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /*Added by Nitin for bug # 6681800*/a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount
2332: FROM JAI_RCV_LINE_TAXES a,
2333: JAI_CMN_TAXES_ALL b
2334: WHERE a.transaction_id = cp_transaction_id
2335: AND a.tax_type in (select tax_type
2336: from jai_regime_tax_types_v

Line 2639: UPDATE JAI_RCV_LINE_TAXES

2635: END IF;
2636:
2637: END LOOP;
2638:
2639: UPDATE JAI_RCV_LINE_TAXES
2640: SET modvat_flag = 'N',
2641: last_update_date = SYSDATE,
2642: last_updated_by = fnd_global.user_id,
2643: last_update_login = fnd_global.login_id

Line 3271: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

3267: p_process_status OUT NOCOPY VARCHAR2,
3268: p_process_message OUT NOCOPY VARCHAR2)
3269: IS
3270:
3271: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
3272: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3273: IS
3274: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3275: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount

Line 3276: FROM JAI_RCV_LINE_TAXES a,

3272: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3273: IS
3274: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3275: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount
3276: FROM JAI_RCV_LINE_TAXES a,
3277: JAI_CMN_TAXES_ALL b
3278: WHERE a.transaction_id = cp_transaction_id
3279: AND a.tax_type in (select tax_type
3280: from jai_regime_tax_types_v