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_RCV_RTV_PKG dependencies on JAI_CONSTANTS

Line 198: 18-FEB-2008: Changes done by nprashar for Bug #6807023. Changed the value of variable lv_organization_type to jai_constants.orgn_type_io;

194:
195: 03-dec-2007 Eric modified cursor c_ja_in_receipt_tax_lines and cursor
196: c_ja_in_tax_amt_by_account to pick up the exclusive taxes only
197:
198: 18-FEB-2008: Changes done by nprashar for Bug #6807023. Changed the value of variable lv_organization_type to jai_constants.orgn_type_io;
199:
200: 15-Apr-2008 rchandan for bug#6971526, File version 120.21
201: Issue : ST2-VAT CLAIM AMOUNT IS NOT RIGHT FOR PARTIALLY RECOVERABLE VAT TAX.
202: Fix : Changes made for bug#6681800 in version 120.16 were missed out when

Line 690: p_regime_code => jai_constants.service_regime,

686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
689: p_receipt_num => r_rcv_shipment_headers.receipt_num,
690: p_regime_code => jai_constants.service_regime,
691: ptr_jv => tr_jv,/*Bug 5632406*/
692: p_simulation => p_simulation,
693: p_process_flag => p_process_flag,
694: p_process_message => p_process_message,

Line 723: p_regime_code => jai_constants.vat_regime,

719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
722: p_receipt_num => r_rcv_shipment_headers.receipt_num,
723: p_regime_code => jai_constants.vat_regime,
724: ptr_jv => tr_jv,/*Bug 5632406*/
725: p_simulation => p_simulation,
726: p_process_flag => p_process_flag,
727: p_process_message => p_process_message,

Line 1226: and registration_type = jai_constants.regn_type_tax_types

1222: cursor c_is_tax_type_in_regime(cp_regime_id number, cp_tax_type varchar2) is
1223: select attribute_code regime_tax_type
1224: from JAI_RGM_REGISTRATIONS
1225: where regime_id = cp_regime_id
1226: and registration_type = jai_constants.regn_type_tax_types
1227: and attribute_code = cp_tax_type;
1228:
1229: /*
1230: r_jai_regimes_servce c_jai_regimes%rowtype;

Line 1272: open c_jai_regimes(jai_constants.service_regime);

1268: p_customs_sh_edu_cess := 0; /*Bug 5989740 bduvarag*/
1269:
1270:
1271: /*
1272: open c_jai_regimes(jai_constants.service_regime);
1273: fetch c_jai_regimes into r_jai_regimes_servce;
1274: close c_jai_regimes;
1275:
1276: open c_jai_regimes(jai_constants.vat_regime);

Line 1276: open c_jai_regimes(jai_constants.vat_regime);

1272: open c_jai_regimes(jai_constants.service_regime);
1273: fetch c_jai_regimes into r_jai_regimes_servce;
1274: close c_jai_regimes;
1275:
1276: open c_jai_regimes(jai_constants.vat_regime);
1277: fetch c_jai_regimes into r_jai_regimes_vat;
1278: close c_jai_regimes;
1279: */
1280:

Line 1305: if cur_rec.tax_type = jai_constants.tax_type_tds then /* TDS*/

1301: p_all_taxes := p_all_taxes + ln_tax_amount;
1302:
1303: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1304:
1305: if cur_rec.tax_type = jai_constants.tax_type_tds then /* TDS*/
1306:
1307: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
1308: p_tds_taxes := p_tds_taxes + ln_tax_amount;
1309:

Line 1311: elsif cur_rec.tax_type = jai_constants.tax_type_modvat_recovery then /* MODVAT RECOVERY*/

1307: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
1308: p_tds_taxes := p_tds_taxes + ln_tax_amount;
1309:
1310:
1311: elsif cur_rec.tax_type = jai_constants.tax_type_modvat_recovery then /* MODVAT RECOVERY*/
1312:
1313: p_codepath := jai_general_pkg.plot_codepath(7.2, p_codepath); /* 7.2 */
1314: p_modvat_recovery_taxes := p_modvat_recovery_taxes + ln_tax_amount;
1315:

Line 1316: elsif cur_rec.tax_type = jai_constants.tax_type_customs then /* CUSTOMS */

1312:
1313: p_codepath := jai_general_pkg.plot_codepath(7.2, p_codepath); /* 7.2 */
1314: p_modvat_recovery_taxes := p_modvat_recovery_taxes + ln_tax_amount;
1315:
1316: elsif cur_rec.tax_type = jai_constants.tax_type_customs then /* CUSTOMS */
1317:
1318: p_codepath := jai_general_pkg.plot_codepath(7.3, p_codepath); /* 7.3 */
1319: p_customs_taxes := p_customs_taxes + ln_tax_amount;
1320:

Line 1321: elsif cur_rec.tax_type = jai_constants.tax_type_cvd then /* CVD */

1317:
1318: p_codepath := jai_general_pkg.plot_codepath(7.3, p_codepath); /* 7.3 */
1319: p_customs_taxes := p_customs_taxes + ln_tax_amount;
1320:
1321: elsif cur_rec.tax_type = jai_constants.tax_type_cvd then /* CVD */
1322:
1323: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1324: p_cvd_taxes := p_cvd_taxes + ln_tax_amount;
1325:

Line 1326: elsif cur_rec.tax_type = jai_constants.tax_type_add_cvd then /* ADDITIONAL CVD - Enhancement 5228046 */

1322:
1323: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1324: p_cvd_taxes := p_cvd_taxes + ln_tax_amount;
1325:
1326: elsif cur_rec.tax_type = jai_constants.tax_type_add_cvd then /* ADDITIONAL CVD - Enhancement 5228046 */
1327:
1328: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1329: p_add_cvd_taxes := p_add_cvd_taxes + ln_tax_amount;
1330:

Line 1331: elsif cur_rec.tax_type = jai_constants.tax_type_exc_edu_cess then /* Educational Cess Excise */

1327:
1328: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1329: p_add_cvd_taxes := p_add_cvd_taxes + ln_tax_amount;
1330:
1331: elsif cur_rec.tax_type = jai_constants.tax_type_exc_edu_cess then /* Educational Cess Excise */
1332:
1333: p_codepath := jai_general_pkg.plot_codepath(7.5, p_codepath); /* 7.5 */
1334: p_excise_edu_cess := p_excise_edu_cess + ln_tax_amount;
1335: /*Bug 5989740 bduvarag start*/

Line 1336: elsif cur_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess then /* Higher Secondary Educational Cess Excise */

1332:
1333: p_codepath := jai_general_pkg.plot_codepath(7.5, p_codepath); /* 7.5 */
1334: p_excise_edu_cess := p_excise_edu_cess + ln_tax_amount;
1335: /*Bug 5989740 bduvarag start*/
1336: elsif cur_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess then /* Higher Secondary Educational Cess Excise */
1337:
1338: p_codepath := jai_general_pkg.plot_codepath(7.51, p_codepath); /* 7.51 */
1339: p_excise_sh_edu_cess := p_excise_sh_edu_cess + ln_tax_amount;
1340:

Line 1342: elsif cur_rec.tax_type = jai_constants.tax_type_cvd_edu_cess then /* Educational Cess CVD */

1338: p_codepath := jai_general_pkg.plot_codepath(7.51, p_codepath); /* 7.51 */
1339: p_excise_sh_edu_cess := p_excise_sh_edu_cess + ln_tax_amount;
1340:
1341: /*Bug 5989740 bduvarag end*/
1342: elsif cur_rec.tax_type = jai_constants.tax_type_cvd_edu_cess then /* Educational Cess CVD */
1343:
1344: p_codepath := jai_general_pkg.plot_codepath(7.6, p_codepath); /* 7.6 */
1345: p_cvd_edu_cess := p_cvd_edu_cess + ln_tax_amount;
1346: /*Bug 5989740 bduvarag start*/

Line 1347: elsif cur_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess then /* Higher Secondary Educational Cess CVD */

1343:
1344: p_codepath := jai_general_pkg.plot_codepath(7.6, p_codepath); /* 7.6 */
1345: p_cvd_edu_cess := p_cvd_edu_cess + ln_tax_amount;
1346: /*Bug 5989740 bduvarag start*/
1347: elsif cur_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess then /* Higher Secondary Educational Cess CVD */
1348:
1349: p_codepath := jai_general_pkg.plot_codepath(7.61, p_codepath); /* 7.61 */
1350: p_cvd_sh_edu_cess := p_cvd_sh_edu_cess + ln_tax_amount;
1351:

Line 1353: elsif cur_rec.tax_type = jai_constants.tax_type_customs_edu_cess then /* Educational Cess CVD */

1349: p_codepath := jai_general_pkg.plot_codepath(7.61, p_codepath); /* 7.61 */
1350: p_cvd_sh_edu_cess := p_cvd_sh_edu_cess + ln_tax_amount;
1351:
1352: /*Bug 5989740 bduvarag end*/
1353: elsif cur_rec.tax_type = jai_constants.tax_type_customs_edu_cess then /* Educational Cess CVD */
1354:
1355: p_codepath := jai_general_pkg.plot_codepath(7.7, p_codepath); /* 7.7 */
1356: p_customs_edu_cess := p_customs_edu_cess + ln_tax_amount;
1357: /*Bug 5989740 bduvarag start*/

Line 1358: elsif cur_rec.tax_type = jai_constants.tax_type_sh_customs_edu_cess then /* Higher Secondary Educational Cess CVD */

1354:
1355: p_codepath := jai_general_pkg.plot_codepath(7.7, p_codepath); /* 7.7 */
1356: p_customs_edu_cess := p_customs_edu_cess + ln_tax_amount;
1357: /*Bug 5989740 bduvarag start*/
1358: elsif cur_rec.tax_type = jai_constants.tax_type_sh_customs_edu_cess then /* Higher Secondary Educational Cess CVD */
1359:
1360: p_codepath := jai_general_pkg.plot_codepath(7.71, p_codepath); /* 7.71 */
1361: p_customs_sh_edu_cess := p_customs_sh_edu_cess + ln_tax_amount;
1362: /*Bug 5989740 bduvarag end*/

Line 1365: jai_constants.tax_type_excise , /* EXCISE */

1361: p_customs_sh_edu_cess := p_customs_sh_edu_cess + ln_tax_amount;
1362: /*Bug 5989740 bduvarag end*/
1363: elsif cur_rec.tax_type in
1364: (
1365: jai_constants.tax_type_excise , /* EXCISE */
1366: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */
1367: jai_constants.tax_type_exc_other /* EXCISE OTHERS */
1368: )
1369: then

Line 1366: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */

1362: /*Bug 5989740 bduvarag end*/
1363: elsif cur_rec.tax_type in
1364: (
1365: jai_constants.tax_type_excise , /* EXCISE */
1366: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */
1367: jai_constants.tax_type_exc_other /* EXCISE OTHERS */
1368: )
1369: then
1370:

Line 1367: jai_constants.tax_type_exc_other /* EXCISE OTHERS */

1363: elsif cur_rec.tax_type in
1364: (
1365: jai_constants.tax_type_excise , /* EXCISE */
1366: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */
1367: jai_constants.tax_type_exc_other /* EXCISE OTHERS */
1368: )
1369: then
1370:
1371: p_codepath := jai_general_pkg.plot_codepath(7.8, p_codepath); /* 7.8 */

Line 1390: if cur_rec.regime_code = jai_constants.service_regime then

1386:
1387: if r_is_tax_type_in_regime.regime_tax_type is not null then*/
1388:
1389: /* Service type of Tax */
1390: if cur_rec.regime_code = jai_constants.service_regime then
1391: p_codepath := jai_general_pkg.plot_codepath(7.11, p_codepath); /* 7.11 */
1392:
1393: if ( cur_rec.recoverable = 100 and cur_rec.modvatable = 'Y' ) then
1394: p_codepath := jai_general_pkg.plot_codepath(7.12, p_codepath); /* 7.12 */

Line 1420: if cur_rec.regime_code = jai_constants.vat_regime then

1416:
1417: if r_is_tax_type_in_regime.regime_tax_type is not null then */
1418:
1419: /* VAT type of Tax */
1420: if cur_rec.regime_code = jai_constants.vat_regime then
1421: p_codepath := jai_general_pkg.plot_codepath(7.15, p_codepath); /* 7.15 */
1422:
1423: if ( cur_rec.recoverable = 100 and cur_rec.modvatable = 'Y' ) then
1424: p_codepath := jai_general_pkg.plot_codepath(7.16, p_codepath); /* 7.16 */

Line 1450: cur_rec.tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery)

1446: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1447: if
1448: cur_rec.vendor_id <> p_po_vendor_id and
1449: cur_rec.vendor_id > 0 and
1450: cur_rec.tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery)
1451: then
1452: p_third_party_taxes := p_third_party_taxes + ln_tax_amount;
1453: end if;
1454:

Line 2956: and jrr.registration_type = jai_constants.regn_type_tax_types

2952: from JAI_RGM_DEFINITIONS jr,
2953: JAI_RGM_REGISTRATIONS jrr
2954: where jr.regime_id = jrr.regime_id
2955: and jr.regime_code = p_regime_code
2956: and jrr.registration_type = jai_constants.regn_type_tax_types
2957: )
2958: AND NVL(jtc.inclusive_tax_flag,'N')='N' --add by eric for inclusive tax,picking the exclusive tax only
2959: group by jai_cmn_rgm_recording_pkg.get_account
2960: (

Line 3033: if p_regime_code = jai_constants.service_regime then

3029: open c_jai_regimes(p_regime_code);
3030: fetch c_jai_regimes into r_jai_regimes;
3031: close c_jai_regimes;
3032:
3033: if p_regime_code = jai_constants.service_regime then
3034:
3035: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3036: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');
3037: lv_organization_type := jai_constants.orgn_type_io;

Line 3037: lv_organization_type := jai_constants.orgn_type_io;

3033: if p_regime_code = jai_constants.service_regime then
3034:
3035: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3036: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');
3037: lv_organization_type := jai_constants.orgn_type_io;
3038: ln_organization_id := p_organization_id;
3039: ln_location_id := p_location_id;
3040: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3041: -- added by nprashar for Bug 6807023

Line 3044: elsif p_regime_code = jai_constants.vat_regime then

3040: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3041: -- added by nprashar for Bug 6807023
3042: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime lv_organization_type =' ||lv_organization_type||' ln_organization_id='||p_organization_id||'ln_location_id='||p_location_id);
3043:
3044: elsif p_regime_code = jai_constants.vat_regime then
3045:
3046: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
3047: lv_organization_type := jai_constants.orgn_type_io;
3048: ln_organization_id := p_organization_id;

Line 3047: lv_organization_type := jai_constants.orgn_type_io;

3043:
3044: elsif p_regime_code = jai_constants.vat_regime then
3045:
3046: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
3047: lv_organization_type := jai_constants.orgn_type_io;
3048: ln_organization_id := p_organization_id;
3049: ln_location_id := p_location_id;
3050: l_jv_line_num_generator := 41;/*Bug 5527885*/
3051: end if;

Line 3064: jai_constants.recovery_interim,

3060: r_jai_regimes.regime_id,
3061: lv_organization_type,
3062: ln_organization_id,
3063: ln_location_id,
3064: jai_constants.recovery_interim,
3065: jai_rcv_trx_processing_pkg.gv_func_curr,
3066: ln_tax_apportion_factor,
3067: p_currency_conversion_rate
3068: )

Line 3158: if p_regime_code = jai_constants.service_regime then

3154: ptr_jv(l_jv_line_num_generator).reference_id := p_transaction_id;
3155: ptr_jv(l_jv_line_num_generator).non_rnd_entered_dr := ln_debit;
3156: ptr_jv(l_jv_line_num_generator).non_rnd_entered_cr := ln_credit;
3157: ptr_jv(l_jv_line_num_generator).summary_jv_flag := 'N';
3158: if p_regime_code = jai_constants.service_regime then
3159: ptr_jv(l_jv_line_num_generator).account_name := gv_service_interim;
3160: elsif p_regime_code = jai_constants.vat_regime then
3161: ptr_jv(l_jv_line_num_generator).account_name := gv_vat_interim;
3162: else

Line 3160: elsif p_regime_code = jai_constants.vat_regime then

3156: ptr_jv(l_jv_line_num_generator).non_rnd_entered_cr := ln_credit;
3157: ptr_jv(l_jv_line_num_generator).summary_jv_flag := 'N';
3158: if p_regime_code = jai_constants.service_regime then
3159: ptr_jv(l_jv_line_num_generator).account_name := gv_service_interim;
3160: elsif p_regime_code = jai_constants.vat_regime then
3161: ptr_jv(l_jv_line_num_generator).account_name := gv_vat_interim;
3162: else
3163: ptr_jv(l_jv_line_num_generator).account_name := gv_regime_interim;
3164: end if;