DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 34: TYPE til_tbl_type IS TABLE OF OKL_TXL_AR_INV_LNS_B%ROWTYPE INDEX BY BINARY_INTEGER;

30: l_xsi_cnt NUMBER := 0;
31: l_xls_cnt NUMBER := 0;
32:
33: TYPE tai_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_B%ROWTYPE INDEX BY BINARY_INTEGER;
34: TYPE til_tbl_type IS TABLE OF OKL_TXL_AR_INV_LNS_B%ROWTYPE INDEX BY BINARY_INTEGER;
35: TYPE tld_tbl_type IS TABLE OF OKL_TXD_AR_LN_DTLS_B%ROWTYPE INDEX BY BINARY_INTEGER;
36: TYPE xsi_tbl_type IS TABLE OF OKL_EXT_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;
37: TYPE xls_tbl_type IS TABLE OF OKL_XTL_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;
38:

Line 679: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_b');

675: -- --------------------------------------
676: -- Transfer Til records to the Til table
677: -- --------------------------------------
678: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
679: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_b');
680:
681: END IF;
682: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL records to TIL table...');
683:

Line 688: INSERT INTO OKL_TXL_AR_INV_LNS_B

684: Fnd_File.PUT_LINE (Fnd_File.LOG, 'til_tbl.COUNT : ' || til_tbl.COUNT);
685:
686: IF til_tbl.COUNT > 0 THEN
687: FORALL indx IN til_tbl.first..til_tbl.LAST
688: INSERT INTO OKL_TXL_AR_INV_LNS_B
689: VALUES til_tbl(indx);
690: END IF;
691:
692: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

689: VALUES til_tbl(indx);
690: END IF;
691:
692: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
693: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_b');
694:
695: END IF;
696: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL records to TIL table...');
697: -- --------------------------------------