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 1560: -- insert records into okl_property_tax_b

1556: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1557: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate property tax parameters record, stm rec and sel rec.');
1558: END IF;
1559:
1560: -- insert records into okl_property_tax_b
1561: if ptc_tbl.count > 0 then
1562: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_b rec.');
1564: END IF;

Line 1566: insert into okl_property_tax_b

1562: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_b rec.');
1564: END IF;
1565: forall i in ptc_tbl.first..ptc_tbl.last
1566: insert into okl_property_tax_b
1567: values ptc_tbl(i);
1568: COMMIT;
1569: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1570: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ptc_b rec.');

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

1665: -- delete orphan record in PTC for
1666: -- referential integrity
1667: -- ------------------------------
1668: delete from OKL_PROPERTY_TAX_tl where id = ptc_tbl(indx).id;
1669: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;
1670: delete from okl_strm_elements where id = upd_sel_tbl(indx);
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');
1673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');

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

1668: delete from OKL_PROPERTY_TAX_tl where id = ptc_tbl(indx).id;
1669: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;
1670: delete from okl_strm_elements where id = upd_sel_tbl(indx);
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');
1673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');
1674: END IF;
1675: END IF;
1676: