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 429: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,

425: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
426: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
427: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
428: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
429: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
430: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
431: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
432: --p_simulate_flag IN VARCHAR2 DEFAULT 'N', --Added for Bug 4950914
433: p_process_status OUT NOCOPY VARCHAR2,

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

426: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
427: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
428: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
429: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
430: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
431: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
432: --p_simulate_flag IN VARCHAR2 DEFAULT 'N', --Added for Bug 4950914
433: p_process_status OUT NOCOPY VARCHAR2,
434: p_process_message OUT NOCOPY VARCHAR2,

Line 484: JAI_CMN_TAXES_ALL b

480: a.tax_type,
481: a.tax_id,
482: NVL(b.rounding_factor,0) rounding_factor
483: FROM JAI_RCV_LINE_TAXES a,
484: JAI_CMN_TAXES_ALL b
485: WHERE a.transaction_id = cp_transaction_id
486: AND a.tax_type IN ( select tax_type
487: from jai_regime_tax_types_v
488: where regime_code = jai_constants.vat_regime

Line 758: JAI_CMN_TAXES_ALL jtc

754: nvl(rtl.currency, jai_constants.func_curr) currency,
755: nvl(jtc.rounding_factor, 0) rnd,
756: nvl(jtc.mod_cr_percentage, 0) modvat_percentage /*Added by Nitin for bug # 6681800*/
757: FROM JAI_RCV_LINE_TAXES rtl,
758: JAI_CMN_TAXES_ALL jtc
759: WHERE shipment_line_id = cp_shipment_line_id
760: AND jtc.tax_id = rtl.tax_id
761: AND rtl.modvat_flag = 'Y'
762: AND jtc.tax_type IN (select tax_type

Line 1883: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE,

1879: AND regime_code = NVL(cp_regime_code, regime_code);
1880:
1881: CURSOR c_claim_schedule( cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1882: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
1883: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE,
1884: cp_installment_no IN jai_rcv_rgm_claims.installment_no%TYPE)
1885: IS
1886: SELECT MIN(claim_schedule_id) claim_schedule_id
1887: FROM jai_rcv_rgm_claims

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

2395: IS
2396: SELECT jtl.tax_type,
2397: /*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
2398: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2399: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2400: WHERE jtl.transaction_id = cp_transaction_id
2401: AND jtl.tax_type in (select tax_type
2402: from jai_regime_tax_types_v
2403: where regime_code = jai_constants.vat_regime)

Line 2413: JAI_CMN_TAXES_ALL b

2409: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2410: IS
2411: 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
2412: FROM JAI_RCV_LINE_TAXES a,
2413: JAI_CMN_TAXES_ALL b
2414: WHERE a.transaction_id = cp_transaction_id
2415: AND a.tax_type in (select tax_type
2416: from jai_regime_tax_types_v
2417: where regime_code = jai_constants.vat_regime)

Line 3067: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)

3063:
3064: CURSOR c_claim_schedule(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
3065: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
3066: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
3067: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)
3068: IS
3069: SELECT MIN(claim_schedule_id) claim_schedule_id
3070: FROM jai_rcv_rgm_claims
3071: WHERE shipment_header_id = cp_shipment_header_id

Line 3524: JAI_CMN_TAXES_ALL b

3520: IS
3521: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3522: 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
3523: FROM JAI_RCV_LINE_TAXES a,
3524: JAI_CMN_TAXES_ALL b
3525: WHERE a.transaction_id = cp_transaction_id
3526: AND a.tax_type in (select tax_type
3527: from jai_regime_tax_types_v
3528: where regime_code = jai_constants.vat_regime)