DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TXD_AR_LN_DTLS_TL

Line 53: TYPE tldtl_tbl_type IS TABLE OF OKL_TXD_AR_LN_DTLS_TL%ROWTYPE INDEX BY BINARY_INTEGER;

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:
57: taitl_tbl taitl_tbl_type;

Line 745: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_tl');

741: -- --------------------------------------
742: -- Transfer TldTl records to the TldTl table
743: -- --------------------------------------
744: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
745: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_tl');
746:
747: END IF;
748: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD_TL records to TLD_TL table...');
749:

Line 754: INSERT INTO OKL_TXD_AR_LN_DTLS_TL

750: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tldtl_tbl.COUNT : ' || tldtl_tbl.COUNT);
751:
752: IF tldtl_tbl.COUNT > 0 THEN
753: FORALL indx IN tldtl_tbl.first..tldtl_tbl.LAST
754: INSERT INTO OKL_TXD_AR_LN_DTLS_TL
755: VALUES tldtl_tbl(indx);
756: END IF;
757:
758: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

755: VALUES tldtl_tbl(indx);
756: END IF;
757:
758: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
759: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_tl');
760:
761: END IF;
762: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD_TL records to TLD_TL table...');
763: -- --------------------------------------