DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TRX_AR_INVOICES_TL

Line 51: TYPE taitl_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_TL%ROWTYPE INDEX BY BINARY_INTEGER;

47: l_tldtl_cnt NUMBER := 0;
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;

Line 716: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_tl');

712: -- --------------------------------------
713: -- Transfer TaiTl records to the TaiTl table
714: -- --------------------------------------
715: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
716: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_tl');
717:
718: END IF;
719: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI_TL records to TAI_TL table...');
720:

Line 725: INSERT INTO OKL_TRX_AR_INVOICES_TL

721: Fnd_File.PUT_LINE (Fnd_File.LOG, 'taitl_tbl.COUNT : ' || taitl_tbl.COUNT);
722:
723: IF taitl_tbl.COUNT > 0 THEN
724: FORALL indx IN taitl_tbl.first..taitl_tbl.LAST
725: INSERT INTO OKL_TRX_AR_INVOICES_TL
726: VALUES taitl_tbl(indx);
727: END IF;
728:
729: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

726: VALUES taitl_tbl(indx);
727: END IF;
728:
729: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
730: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_tl');
731:
732: END IF;
733: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI_TL records to TAI_TL table...');
734: -- --------------------------------------