DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TXL_AR_INV_LNS_TL

Line 52: TYPE tiltl_tbl_type IS TABLE OF OKL_TXL_AR_INV_LNS_TL%ROWTYPE INDEX BY BINARY_INTEGER;

48: l_xsitl_cnt NUMBER := 0;
49: l_xlstl_cnt NUMBER := 0;
50:
51: TYPE taitl_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_TL%ROWTYPE INDEX BY BINARY_INTEGER;
52: TYPE tiltl_tbl_type IS TABLE OF OKL_TXL_AR_INV_LNS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
53: TYPE tldtl_tbl_type IS TABLE OF OKL_TXD_AR_LN_DTLS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
54: TYPE xsitl_tbl_type IS TABLE OF OKL_EXT_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
55: TYPE xlstl_tbl_type IS TABLE OF OKL_XTL_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
56:

Line 760: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_tl');

756: -- --------------------------------------
757: -- Transfer TilTl records to the TilTl table
758: -- --------------------------------------
759: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
760: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_tl');
761:
762: END IF;
763: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL_TL records to TIL_TL table...');
764:

Line 769: INSERT INTO OKL_TXL_AR_INV_LNS_TL

765: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tiltl_tbl.COUNT : ' || tiltl_tbl.COUNT);
766:
767: IF tiltl_tbl.COUNT > 0 THEN
768: FORALL indx IN tiltl_tbl.first..tiltl_tbl.LAST
769: INSERT INTO OKL_TXL_AR_INV_LNS_TL
770: VALUES tiltl_tbl(indx);
771: END IF;
772:
773: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 774: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_tl');

770: VALUES tiltl_tbl(indx);
771: END IF;
772:
773: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
774: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_tl');
775:
776: END IF;
777: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL_TL records to TIL_TL table...');
778: -- --------------------------------------