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 819: p_regime_code => jai_constants.service_regime,

815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
818: p_receipt_num => r_rcv_shipment_headers.receipt_num,
819: p_regime_code => jai_constants.service_regime,
820: ptr_jv => tr_jv,/*Bug 5632406*/
821: p_simulation => p_simulation,
822: p_process_flag => p_process_flag,
823: p_process_message => p_process_message,

Line 853: p_regime_code => jai_constants.vat_regime,

849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
852: p_receipt_num => r_rcv_shipment_headers.receipt_num,
853: p_regime_code => jai_constants.vat_regime,
854: ptr_jv => tr_jv,/*Bug 5632406*/
855: p_simulation => p_simulation,
856: p_process_flag => p_process_flag,
857: p_process_message => p_process_message,

Line 1380: jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,

1376: --added the or condition for POT 11936596
1377: OR
1378: (NVL(jtc.inclusive_tax_flag,'N')='Y'
1379: and jtc.tax_type in ('Service','SERVICE_EDUCATION_CESS','SERVICE_SH_EDU_CESS','VALUE ADDED TAX', /*Bug 14185068*/
1380: jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
1381: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_sh_exc_edu_cess))
1382: ); /*Added excise taxes by mmurtuza for bug 16101545. Also changed tax_types.tax_type to jtc.tax_type*/
1383:
1384: cursor c_jai_regimes(p_regime_code varchar2) is

Line 1381: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_sh_exc_edu_cess))

1377: OR
1378: (NVL(jtc.inclusive_tax_flag,'N')='Y'
1379: and jtc.tax_type in ('Service','SERVICE_EDUCATION_CESS','SERVICE_SH_EDU_CESS','VALUE ADDED TAX', /*Bug 14185068*/
1380: jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
1381: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_sh_exc_edu_cess))
1382: ); /*Added excise taxes by mmurtuza for bug 16101545. Also changed tax_types.tax_type to jtc.tax_type*/
1383:
1384: cursor c_jai_regimes(p_regime_code varchar2) is
1385: select regime_id

Line 1393: and registration_type = jai_constants.regn_type_tax_types

1389: cursor c_is_tax_type_in_regime(cp_regime_id number, cp_tax_type varchar2) is
1390: select attribute_code regime_tax_type
1391: from JAI_RGM_REGISTRATIONS
1392: where regime_id = cp_regime_id
1393: and registration_type = jai_constants.regn_type_tax_types
1394: and attribute_code = cp_tax_type;
1395:
1396: /*
1397: r_jai_regimes_servce c_jai_regimes%rowtype;

Line 1475: open c_jai_regimes(jai_constants.service_regime);

1471: p_boe_add_customs := 0;
1472: -------------------------------------------------
1473: --Added by zhiwei for BOE ER bug 11684111 end
1474: /*
1475: open c_jai_regimes(jai_constants.service_regime);
1476: fetch c_jai_regimes into r_jai_regimes_servce;
1477: close c_jai_regimes;
1478:
1479: open c_jai_regimes(jai_constants.vat_regime);

Line 1479: open c_jai_regimes(jai_constants.vat_regime);

1475: open c_jai_regimes(jai_constants.service_regime);
1476: fetch c_jai_regimes into r_jai_regimes_servce;
1477: close c_jai_regimes;
1478:
1479: open c_jai_regimes(jai_constants.vat_regime);
1480: fetch c_jai_regimes into r_jai_regimes_vat;
1481: close c_jai_regimes;
1482: */
1483:

Line 1491: jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,

1487:
1488: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
1489: --start additions for POT 11936596
1490: if cur_rec.inclusive_tax_flag='Y' and cur_rec.tax_type not in (
1491: jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
1492: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) /*Added not in condition by mmurtuza for bug 16101545*/
1493: then
1494: ln_tax_amount := 0;
1495: else

Line 1492: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) /Added not in condition by mmurtuza for bug 16101545/

1488: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
1489: --start additions for POT 11936596
1490: if cur_rec.inclusive_tax_flag='Y' and cur_rec.tax_type not in (
1491: jai_constants.tax_type_excise, jai_constants.tax_type_exc_additional, jai_constants.tax_type_exc_other,
1492: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) /*Added not in condition by mmurtuza for bug 16101545*/
1493: then
1494: ln_tax_amount := 0;
1495: else
1496: ln_tax_amount := cur_rec.tax_amount;

Line 1522: IF cur_rec.tax_type IN (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other,jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess)

1518: end if;
1519:
1520: /*bug 7640943 (FP for bug 7588482) - need to use rounded amounts for excise type of taxes while accounting
1521: *because amounts would be rounded for excise invoice (cenvat reversal)*/
1522: IF cur_rec.tax_type IN (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other,jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess)
1523: THEN
1524: ln_tax_amount := Round(ln_tax_amount,Nvl(cur_rec.rounding_factor,0));
1525: END IF;
1526: /*end bug 7640943*/

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

1532: p_all_taxes := p_all_taxes + ln_tax_amount;
1533:
1534: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1535:
1536: if cur_rec.tax_type = jai_constants.tax_type_tds then /* TDS*/
1537:
1538: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
1539: p_tds_taxes := p_tds_taxes + ln_tax_amount;
1540:

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

1538: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
1539: p_tds_taxes := p_tds_taxes + ln_tax_amount;
1540:
1541:
1542: elsif cur_rec.tax_type = jai_constants.tax_type_modvat_recovery then /* MODVAT RECOVERY*/
1543:
1544: p_codepath := jai_general_pkg.plot_codepath(7.2, p_codepath); /* 7.2 */
1545: p_modvat_recovery_taxes := p_modvat_recovery_taxes + ln_tax_amount;
1546:

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

1543:
1544: p_codepath := jai_general_pkg.plot_codepath(7.2, p_codepath); /* 7.2 */
1545: p_modvat_recovery_taxes := p_modvat_recovery_taxes + ln_tax_amount;
1546:
1547: elsif cur_rec.tax_type = jai_constants.tax_type_customs then /* CUSTOMS */
1548:
1549: p_codepath := jai_general_pkg.plot_codepath(7.3, p_codepath); /* 7.3 */
1550: p_customs_taxes := p_customs_taxes + ln_tax_amount;
1551:

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

1548:
1549: p_codepath := jai_general_pkg.plot_codepath(7.3, p_codepath); /* 7.3 */
1550: p_customs_taxes := p_customs_taxes + ln_tax_amount;
1551:
1552: elsif cur_rec.tax_type = jai_constants.tax_type_cvd then /* CVD */
1553:
1554: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1555: p_cvd_taxes := p_cvd_taxes + ln_tax_amount;
1556:

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

1553:
1554: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1555: p_cvd_taxes := p_cvd_taxes + ln_tax_amount;
1556:
1557: elsif cur_rec.tax_type = jai_constants.tax_type_add_cvd then /* ADDITIONAL CVD - Enhancement 5228046 */
1558:
1559: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1560: p_add_cvd_taxes := p_add_cvd_taxes + ln_tax_amount;
1561:

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

1558:
1559: p_codepath := jai_general_pkg.plot_codepath(7.4, p_codepath); /* 7.4 */
1560: p_add_cvd_taxes := p_add_cvd_taxes + ln_tax_amount;
1561:
1562: elsif cur_rec.tax_type = jai_constants.tax_type_exc_edu_cess then /* Educational Cess Excise */
1563:
1564: p_codepath := jai_general_pkg.plot_codepath(7.5, p_codepath); /* 7.5 */
1565: p_excise_edu_cess := p_excise_edu_cess + ln_tax_amount;
1566: /*Bug 5989740 bduvarag start*/

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

1563:
1564: p_codepath := jai_general_pkg.plot_codepath(7.5, p_codepath); /* 7.5 */
1565: p_excise_edu_cess := p_excise_edu_cess + ln_tax_amount;
1566: /*Bug 5989740 bduvarag start*/
1567: elsif cur_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess then /* Higher Secondary Educational Cess Excise */
1568:
1569: p_codepath := jai_general_pkg.plot_codepath(7.51, p_codepath); /* 7.51 */
1570: p_excise_sh_edu_cess := p_excise_sh_edu_cess + ln_tax_amount;
1571:

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

1569: p_codepath := jai_general_pkg.plot_codepath(7.51, p_codepath); /* 7.51 */
1570: p_excise_sh_edu_cess := p_excise_sh_edu_cess + ln_tax_amount;
1571:
1572: /*Bug 5989740 bduvarag end*/
1573: elsif cur_rec.tax_type = jai_constants.tax_type_cvd_edu_cess then /* Educational Cess CVD */
1574:
1575: p_codepath := jai_general_pkg.plot_codepath(7.6, p_codepath); /* 7.6 */
1576: p_cvd_edu_cess := p_cvd_edu_cess + ln_tax_amount;
1577: /*Bug 5989740 bduvarag start*/

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

1574:
1575: p_codepath := jai_general_pkg.plot_codepath(7.6, p_codepath); /* 7.6 */
1576: p_cvd_edu_cess := p_cvd_edu_cess + ln_tax_amount;
1577: /*Bug 5989740 bduvarag start*/
1578: elsif cur_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess then /* Higher Secondary Educational Cess CVD */
1579:
1580: p_codepath := jai_general_pkg.plot_codepath(7.61, p_codepath); /* 7.61 */
1581: p_cvd_sh_edu_cess := p_cvd_sh_edu_cess + ln_tax_amount;
1582:

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

1580: p_codepath := jai_general_pkg.plot_codepath(7.61, p_codepath); /* 7.61 */
1581: p_cvd_sh_edu_cess := p_cvd_sh_edu_cess + ln_tax_amount;
1582:
1583: /*Bug 5989740 bduvarag end*/
1584: elsif cur_rec.tax_type = jai_constants.tax_type_customs_edu_cess then /* Educational Cess CVD */
1585:
1586: p_codepath := jai_general_pkg.plot_codepath(7.7, p_codepath); /* 7.7 */
1587: p_customs_edu_cess := p_customs_edu_cess + ln_tax_amount;
1588: /*Bug 5989740 bduvarag start*/

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

1585:
1586: p_codepath := jai_general_pkg.plot_codepath(7.7, p_codepath); /* 7.7 */
1587: p_customs_edu_cess := p_customs_edu_cess + ln_tax_amount;
1588: /*Bug 5989740 bduvarag start*/
1589: elsif cur_rec.tax_type = jai_constants.tax_type_sh_customs_edu_cess then /* Higher Secondary Educational Cess CVD */
1590:
1591: p_codepath := jai_general_pkg.plot_codepath(7.71, p_codepath); /* 7.71 */
1592: p_customs_sh_edu_cess := p_customs_sh_edu_cess + ln_tax_amount;
1593: /*Bug 5989740 bduvarag end*/

Line 1599: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other1 then

1595:
1596: --Added by zhiwei for BOE ER bug 11684111 begin
1597: ---------------------------------------------------------------------------------
1598:
1599: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other1 then
1600:
1601: p_codepath := jai_general_pkg.plot_codepath(7.72, p_codepath); /* 7.72 */
1602: p_boe_other1 := p_boe_other1 + ln_tax_amount;
1603:

Line 1604: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other2 then

1600:
1601: p_codepath := jai_general_pkg.plot_codepath(7.72, p_codepath); /* 7.72 */
1602: p_boe_other1 := p_boe_other1 + ln_tax_amount;
1603:
1604: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other2 then
1605:
1606: p_codepath := jai_general_pkg.plot_codepath(7.73, p_codepath); /* 7.73 */
1607: p_boe_other2 := p_boe_other2 + ln_tax_amount;
1608:

Line 1609: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other3 then

1605:
1606: p_codepath := jai_general_pkg.plot_codepath(7.73, p_codepath); /* 7.73 */
1607: p_boe_other2 := p_boe_other2 + ln_tax_amount;
1608:
1609: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other3 then
1610:
1611: p_codepath := jai_general_pkg.plot_codepath(7.74, p_codepath); /* 7.74 */
1612: p_boe_other3 := p_boe_other3 + ln_tax_amount;
1613:

Line 1614: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other4 then

1610:
1611: p_codepath := jai_general_pkg.plot_codepath(7.74, p_codepath); /* 7.74 */
1612: p_boe_other3 := p_boe_other3 + ln_tax_amount;
1613:
1614: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other4 then
1615:
1616: p_codepath := jai_general_pkg.plot_codepath(7.75, p_codepath); /* 7.75 */
1617: p_boe_other4 := p_boe_other4 + ln_tax_amount;
1618:

Line 1619: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other5 then

1615:
1616: p_codepath := jai_general_pkg.plot_codepath(7.75, p_codepath); /* 7.75 */
1617: p_boe_other4 := p_boe_other4 + ln_tax_amount;
1618:
1619: elsif cur_rec.tax_type = jai_constants.tax_type_boe_other5 then
1620:
1621: p_codepath := jai_general_pkg.plot_codepath(7.76, p_codepath); /* 7.76 */
1622: p_boe_other5 := p_boe_other5 + ln_tax_amount;
1623:

Line 1624: elsif cur_rec.tax_type = jai_constants.tax_type_boe_surcharge_duty then

1620:
1621: p_codepath := jai_general_pkg.plot_codepath(7.76, p_codepath); /* 7.76 */
1622: p_boe_other5 := p_boe_other5 + ln_tax_amount;
1623:
1624: elsif cur_rec.tax_type = jai_constants.tax_type_boe_surcharge_duty then
1625:
1626: p_codepath := jai_general_pkg.plot_codepath(7.77, p_codepath); /* 7.77 */
1627: p_boe_surcharge_duty := p_boe_surcharge_duty + ln_tax_amount;
1628:

Line 1629: elsif cur_rec.tax_type = jai_constants.tax_type_boe_add_customs then

1625:
1626: p_codepath := jai_general_pkg.plot_codepath(7.77, p_codepath); /* 7.77 */
1627: p_boe_surcharge_duty := p_boe_surcharge_duty + ln_tax_amount;
1628:
1629: elsif cur_rec.tax_type = jai_constants.tax_type_boe_add_customs then
1630:
1631: p_codepath := jai_general_pkg.plot_codepath(7.78, p_codepath); /* 7.78 */
1632: p_boe_add_customs := p_boe_add_customs + ln_tax_amount;
1633: ---------------------------------------------------------------------------------

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

1634: --Added by zhiwei for BOE ER bug 11684111 end
1635:
1636: elsif cur_rec.tax_type in
1637: (
1638: jai_constants.tax_type_excise , /* EXCISE */
1639: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */
1640: jai_constants.tax_type_exc_other /* EXCISE OTHERS */
1641: )
1642: then

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

1635:
1636: elsif cur_rec.tax_type in
1637: (
1638: jai_constants.tax_type_excise , /* EXCISE */
1639: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */
1640: jai_constants.tax_type_exc_other /* EXCISE OTHERS */
1641: )
1642: then
1643:

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

1636: elsif cur_rec.tax_type in
1637: (
1638: jai_constants.tax_type_excise , /* EXCISE */
1639: jai_constants.tax_type_exc_additional , /* EXCISE ADDITIONAL */
1640: jai_constants.tax_type_exc_other /* EXCISE OTHERS */
1641: )
1642: then
1643:
1644: p_codepath := jai_general_pkg.plot_codepath(7.8, p_codepath); /* 7.8 */

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

1659:
1660: if r_is_tax_type_in_regime.regime_tax_type is not null then*/
1661:
1662: /* Service type of Tax */
1663: if cur_rec.regime_code = jai_constants.service_regime then
1664: p_codepath := jai_general_pkg.plot_codepath(7.11, p_codepath); /* 7.11 */
1665:
1666: /*bug 8488470 - modified the if block.
1667: Issue - Unbalanced entries in GL for correct / RTV transactions.

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

1703:
1704: if r_is_tax_type_in_regime.regime_tax_type is not null then */
1705:
1706: /* VAT type of Tax */
1707: if cur_rec.regime_code = jai_constants.vat_regime then
1708: p_codepath := jai_general_pkg.plot_codepath(7.15, p_codepath); /* 7.15 */
1709:
1710: /*bug 8488470 - modified the if block.
1711: Issue - Unbalanced entries in GL for correct / RTV transactions.

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

1744: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1745: if
1746: cur_rec.vendor_id <> p_po_vendor_id and
1747: cur_rec.vendor_id > 0 and
1748: cur_rec.tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery)
1749: then
1750: p_third_party_taxes := p_third_party_taxes + ln_tax_amount;
1751: end if;
1752:

Line 3075: pv_tax_type_code =>jai_constants.tax_type_cvd

3071: p_codepath := jai_general_pkg.plot_codepath(23.01, p_codepath); /* 23.01 */
3072: ln_debit := null;
3073: ln_credit := p_cvd_taxes;
3074: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3075: pv_tax_type_code =>jai_constants.tax_type_cvd
3076: ,pv_account_type =>'PAID_PAYABLES'
3077: ,pn_organization_id =>ln_organization_id
3078: ,pn_location_id =>ln_location_id
3079: );

Line 3112: pv_tax_type_code =>jai_constants.tax_type_add_cvd

3108: p_codepath := jai_general_pkg.plot_codepath(23.02, p_codepath); /* 23.02 */
3109: ln_debit := null;
3110: ln_credit := p_add_cvd_taxes;
3111: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3112: pv_tax_type_code =>jai_constants.tax_type_add_cvd
3113: ,pv_account_type =>'PAID_PAYABLES'
3114: ,pn_organization_id =>ln_organization_id
3115: ,pn_location_id =>ln_location_id
3116: );

Line 3148: pv_tax_type_code =>jai_constants.tax_type_customs

3144: p_codepath := jai_general_pkg.plot_codepath(23.03, p_codepath); /* 23.03 */
3145: ln_debit := null;
3146: ln_credit := p_customs_taxes;
3147: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3148: pv_tax_type_code =>jai_constants.tax_type_customs
3149: ,pv_account_type =>'PAID_PAYABLES'
3150: ,pn_organization_id =>ln_organization_id
3151: ,pn_location_id =>ln_location_id
3152: );

Line 3186: pv_tax_type_code =>jai_constants.tax_type_cvd_edu_cess

3182: p_codepath := jai_general_pkg.plot_codepath(23.04, p_codepath); /* 23.04 */
3183: ln_debit := null;
3184: ln_credit := p_cvd_edu_cess;
3185: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3186: pv_tax_type_code =>jai_constants.tax_type_cvd_edu_cess
3187: ,pv_account_type =>'PAID_PAYABLES'
3188: ,pn_organization_id =>ln_organization_id
3189: ,pn_location_id =>ln_location_id
3190: );

Line 3224: pv_tax_type_code =>jai_constants.tax_type_sh_cvd_edu_cess

3220: p_codepath := jai_general_pkg.plot_codepath(23.05, p_codepath); /* 23.05 */
3221: ln_debit := null;
3222: ln_credit := p_cvd_sh_edu_cess;
3223: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3224: pv_tax_type_code =>jai_constants.tax_type_sh_cvd_edu_cess
3225: ,pv_account_type =>'PAID_PAYABLES'
3226: ,pn_organization_id =>ln_organization_id
3227: ,pn_location_id =>ln_location_id
3228: );

Line 3263: pv_tax_type_code =>jai_constants.tax_type_customs_edu_cess

3259: p_codepath := jai_general_pkg.plot_codepath(23.06, p_codepath); /* 23.06 */
3260: ln_debit := null;
3261: ln_credit := p_customs_edu_cess;
3262: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3263: pv_tax_type_code =>jai_constants.tax_type_customs_edu_cess
3264: ,pv_account_type =>'PAID_PAYABLES'
3265: ,pn_organization_id =>ln_organization_id
3266: ,pn_location_id =>ln_location_id
3267: );

Line 3299: pv_tax_type_code =>jai_constants.tax_type_sh_customs_edu_Cess

3295: p_codepath := jai_general_pkg.plot_codepath(23.07, p_codepath); /* 23.07 */
3296: ln_debit := null;
3297: ln_credit := p_customs_sh_edu_cess;
3298: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3299: pv_tax_type_code =>jai_constants.tax_type_sh_customs_edu_Cess
3300: ,pv_account_type =>'PAID_PAYABLES'
3301: ,pn_organization_id =>ln_organization_id
3302: ,pn_location_id =>ln_location_id
3303: );

Line 3336: pv_tax_type_code =>jai_constants.tax_type_boe_other1

3332: p_codepath := jai_general_pkg.plot_codepath(23.08, p_codepath); /* 23.08 */
3333: ln_debit := null;
3334: ln_credit := p_boe_other1;
3335: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3336: pv_tax_type_code =>jai_constants.tax_type_boe_other1
3337: ,pv_account_type =>'PAID_PAYABLES'
3338: ,pn_organization_id =>ln_organization_id
3339: ,pn_location_id =>ln_location_id
3340: );

Line 3373: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(pv_tax_type_code =>jai_constants.tax_type_boe_other2

3369: if p_boe_other2 > 0 then
3370: p_codepath := jai_general_pkg.plot_codepath(23.09, p_codepath); /* 23.09 */
3371: ln_debit := null;
3372: ln_credit := p_boe_other2;
3373: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(pv_tax_type_code =>jai_constants.tax_type_boe_other2
3374: ,pv_account_type =>'PAID_PAYABLES'
3375: ,pn_organization_id =>ln_organization_id
3376: ,pn_location_id =>ln_location_id
3377: );

Line 3410: pv_tax_type_code =>jai_constants.tax_type_boe_other3

3406: p_codepath := jai_general_pkg.plot_codepath(23.10, p_codepath); /* 23.10 */
3407: ln_debit := null;
3408: ln_credit := p_boe_other3;
3409: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3410: pv_tax_type_code =>jai_constants.tax_type_boe_other3
3411: ,pv_account_type =>'PAID_PAYABLES'
3412: ,pn_organization_id =>ln_organization_id
3413: ,pn_location_id =>ln_location_id
3414: );

Line 3447: pv_tax_type_code =>jai_constants.tax_type_boe_other4

3443: p_codepath := jai_general_pkg.plot_codepath(23.11, p_codepath); /* 23.11 */
3444: ln_debit := null;
3445: ln_credit := p_boe_other4;
3446: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3447: pv_tax_type_code =>jai_constants.tax_type_boe_other4
3448: ,pv_account_type =>'PAID_PAYABLES'
3449: ,pn_organization_id =>ln_organization_id
3450: ,pn_location_id =>ln_location_id
3451: );

Line 3484: pv_tax_type_code =>jai_constants.tax_type_boe_other5

3480: p_codepath := jai_general_pkg.plot_codepath(23.12, p_codepath); /* 23.12 */
3481: ln_debit := null;
3482: ln_credit := p_boe_other5;
3483: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3484: pv_tax_type_code =>jai_constants.tax_type_boe_other5
3485: ,pv_account_type =>'PAID_PAYABLES'
3486: ,pn_organization_id =>ln_organization_id
3487: ,pn_location_id =>ln_location_id
3488: );

Line 3522: pv_tax_type_code =>jai_constants.tax_type_boe_surcharge_duty

3518: p_codepath := jai_general_pkg.plot_codepath(23.13, p_codepath); /* 23.13 */
3519: ln_debit := null;
3520: ln_credit := p_boe_surcharge_duty;
3521: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3522: pv_tax_type_code =>jai_constants.tax_type_boe_surcharge_duty
3523: ,pv_account_type =>'PAID_PAYABLES'
3524: ,pn_organization_id =>ln_organization_id
3525: ,pn_location_id =>ln_location_id
3526: );

Line 3560: pv_tax_type_code =>jai_constants.tax_type_boe_add_customs

3556: p_codepath := jai_general_pkg.plot_codepath(23.14, p_codepath); /* 23.14 */
3557: ln_debit := null;
3558: ln_credit := p_boe_add_customs;
3559: ln_boe_account_id := jai_boe_general_pkg.get_boe_accounting(
3560: pv_tax_type_code =>jai_constants.tax_type_boe_add_customs
3561: ,pv_account_type =>'PAID_PAYABLES'
3562: ,pn_organization_id =>ln_organization_id
3563: ,pn_location_id =>ln_location_id
3564: );

Line 3887: and jrr.registration_type = jai_constants.regn_type_tax_types

3883: from JAI_RGM_DEFINITIONS jr,
3884: JAI_RGM_REGISTRATIONS jrr
3885: where jr.regime_id = jrr.regime_id
3886: and jr.regime_code = p_regime_code
3887: and jrr.registration_type = jai_constants.regn_type_tax_types
3888: )
3889: AND (NVL(jtc.inclusive_tax_flag,'N')='N' --add by eric for inclusive tax,picking the exclusive tax only
3890: OR (NVL(jtc.inclusive_tax_flag,'N')='Y'
3891: AND

Line 3969: if p_regime_code = jai_constants.service_regime then

3965: open c_jai_regimes(p_regime_code);
3966: fetch c_jai_regimes into r_jai_regimes;
3967: close c_jai_regimes;
3968:
3969: if p_regime_code = jai_constants.service_regime then
3970:
3971: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3972: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');
3973: lv_organization_type := jai_constants.orgn_type_io;

Line 3973: lv_organization_type := jai_constants.orgn_type_io;

3969: if p_regime_code = jai_constants.service_regime then
3970:
3971: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3972: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');
3973: lv_organization_type := jai_constants.orgn_type_io;
3974: ln_organization_id := p_organization_id;
3975: ln_location_id := p_location_id;
3976: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3977: -- added by nprashar for Bug 6807023

Line 3980: elsif p_regime_code = jai_constants.vat_regime then

3976: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3977: -- added by nprashar for Bug 6807023
3978: 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);
3979:
3980: elsif p_regime_code = jai_constants.vat_regime then
3981:
3982: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
3983: lv_organization_type := jai_constants.orgn_type_io;
3984: ln_organization_id := p_organization_id;

Line 3983: lv_organization_type := jai_constants.orgn_type_io;

3979:
3980: elsif p_regime_code = jai_constants.vat_regime then
3981:
3982: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
3983: lv_organization_type := jai_constants.orgn_type_io;
3984: ln_organization_id := p_organization_id;
3985: ln_location_id := p_location_id;
3986: l_jv_line_num_generator := 41;/*Bug 5527885*/
3987: end if;

Line 4000: jai_constants.recovery_interim,

3996: r_jai_regimes.regime_id,
3997: lv_organization_type,
3998: ln_organization_id,
3999: ln_location_id,
4000: jai_constants.recovery_interim,
4001: jai_rcv_trx_processing_pkg.gv_func_curr,
4002: ln_tax_apportion_factor,
4003: p_currency_conversion_rate
4004: )

Line 4094: if p_regime_code = jai_constants.service_regime then

4090: ptr_jv(l_jv_line_num_generator).reference_id := p_transaction_id;
4091: ptr_jv(l_jv_line_num_generator).non_rnd_entered_dr := ln_debit;
4092: ptr_jv(l_jv_line_num_generator).non_rnd_entered_cr := ln_credit;
4093: ptr_jv(l_jv_line_num_generator).summary_jv_flag := 'N';
4094: if p_regime_code = jai_constants.service_regime then
4095: ptr_jv(l_jv_line_num_generator).account_name := gv_service_interim;
4096: elsif p_regime_code = jai_constants.vat_regime then
4097: ptr_jv(l_jv_line_num_generator).account_name := gv_vat_interim;
4098: else

Line 4096: elsif p_regime_code = jai_constants.vat_regime then

4092: ptr_jv(l_jv_line_num_generator).non_rnd_entered_cr := ln_credit;
4093: ptr_jv(l_jv_line_num_generator).summary_jv_flag := 'N';
4094: if p_regime_code = jai_constants.service_regime then
4095: ptr_jv(l_jv_line_num_generator).account_name := gv_service_interim;
4096: elsif p_regime_code = jai_constants.vat_regime then
4097: ptr_jv(l_jv_line_num_generator).account_name := gv_vat_interim;
4098: else
4099: ptr_jv(l_jv_line_num_generator).account_name := gv_regime_interim;
4100: end if;