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_CMN_TAXES_ALL

Line 360: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,

356: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
357: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
358: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
359: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
360: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
361: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
362: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
363: --p_simulate_flag IN VARCHAR2 DEFAULT 'N', --Added for Bug 4950914
364: p_process_status OUT NOCOPY VARCHAR2,

Line 361: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,

357: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
358: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
359: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
360: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
361: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
362: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
363: --p_simulate_flag IN VARCHAR2 DEFAULT 'N', --Added for Bug 4950914
364: p_process_status OUT NOCOPY VARCHAR2,
365: p_process_message OUT NOCOPY VARCHAR2,

Line 417: JAI_CMN_TAXES_ALL b

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
421: where regime_code = jai_constants.vat_regime

Line 688: JAI_CMN_TAXES_ALL jtc

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'
692: AND jtc.tax_type IN (select tax_type

Line 1812: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE,

1808: AND regime_code = NVL(cp_regime_code, regime_code);
1809:
1810: CURSOR c_claim_schedule( cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1811: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
1812: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE,
1813: cp_installment_no IN jai_rcv_rgm_claims.installment_no%TYPE)
1814: IS
1815: SELECT MIN(claim_schedule_id) claim_schedule_id
1816: FROM jai_rcv_rgm_claims

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 2333: JAI_CMN_TAXES_ALL b

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
2337: where regime_code = jai_constants.vat_regime)

Line 2854: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)

2850:
2851: CURSOR c_claim_schedule(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2852: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2853: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
2854: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)
2855: IS
2856: SELECT MIN(claim_schedule_id) claim_schedule_id
2857: FROM jai_rcv_rgm_claims
2858: WHERE shipment_header_id = cp_shipment_header_id

Line 3277: JAI_CMN_TAXES_ALL b

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
3281: where regime_code = jai_constants.vat_regime)