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.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKL_PROPERTY_TAX_B

Line 372: TYPE ptc_tbl_type IS TABLE OF OKL_PROPERTY_TAX_B%ROWTYPE INDEX BY BINARY_INTEGER;

368:
369: -- Base tables for insert
370: TYPE tai_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_B%ROWTYPE INDEX BY BINARY_INTEGER;
371: TYPE til_tbl_type IS TABLE OF OKL_TXL_AR_INV_LNS_B%ROWTYPE INDEX BY BINARY_INTEGER;
372: TYPE ptc_tbl_type IS TABLE OF OKL_PROPERTY_TAX_B%ROWTYPE INDEX BY BINARY_INTEGER;
373: TYPE stm_tbl_type IS TABLE OF OKL_STREAMS%ROWTYPE INDEX BY BINARY_INTEGER;
374: TYPE sel_tbl_type IS TABLE OF OKL_STRM_ELEMENTS%ROWTYPE INDEX BY BINARY_INTEGER;
375:
376: -- TL tables for insert

Line 1632: -- insert records into okl_property_tax_b

1628: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate property tax parameters record, stm rec and sel rec.');
1630: END IF;
1631:
1632: -- insert records into okl_property_tax_b
1633: if ptc_tbl.count > 0 then
1634: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1635: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_b rec.');
1636: END IF;

Line 1638: insert into okl_property_tax_b

1634: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1635: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_b rec.');
1636: END IF;
1637: forall i in ptc_tbl.first..ptc_tbl.last
1638: insert into okl_property_tax_b
1639: values ptc_tbl(i);
1640: COMMIT;
1641: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ptc_b rec.');

Line 1741: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;

1737: -- delete orphan record in PTC for
1738: -- referential integrity
1739: -- ------------------------------
1740: delete from OKL_PROPERTY_TAX_tl where id = ptc_tbl(indx).id;
1741: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;
1742: delete from okl_strm_elements where id = upd_sel_tbl(indx);
1743: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');
1745: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');

Line 1744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');

1740: delete from OKL_PROPERTY_TAX_tl where id = ptc_tbl(indx).id;
1741: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;
1742: delete from okl_strm_elements where id = upd_sel_tbl(indx);
1743: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');
1745: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');
1746: END IF;
1747: END IF;
1748: