APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 33: TYPE tai_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_B%ROWTYPE INDEX BY BINARY_INTEGER;

29: l_tld_cnt NUMBER := 0;
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;

Line 470: l_prev_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;

466: TYPE xtdtl_tbl_type IS TABLE OF OKL_XTD_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
467: xtd_tbl xtd_tbl_type;
468: xtdtl_tbl xtdtl_tbl_type;
469: l_xtd_id okl_xtd_sell_invs_v.id%TYPE;
470: l_prev_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;
471:
472: -------------------------------------
473: -- Variables for bulk updates
474: -------------------------------------

Line 502: l_err_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;

498: ------------------------------------------------------------
499:
500: l_error_status VARCHAR2(1);
501: l_error_message VARCHAR2(2000);
502: l_err_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;
503: l_rec_status VARCHAR2(10) := NULL;
504:
505: l_request_id NUMBER(15);
506: l_program_application_id NUMBER(15);

Line 600: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_b');

596: -- --------------------------------------
597: -- Transfer Tai records to the Tai table
598: -- --------------------------------------
599: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
600: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_b');
601:
602: END IF;
603: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');
604:

Line 609: INSERT INTO OKL_TRX_AR_INVOICES_B

605: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);
606:
607: IF tai_tbl.COUNT > 0 THEN
608: FORALL indx IN tai_tbl.first..tai_tbl.LAST
609: INSERT INTO OKL_TRX_AR_INVOICES_B
610: VALUES tai_tbl(indx);
611:
612: -- Start Bug 4520466
613: -- update okl_k_control table

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

645:
646: END IF; -- if tai_tbl.COUNT > 0
647:
648: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
649: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_b');
650:
651: END IF;
652: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI records to TAI table...');
653: -- --------------------------------------

Line 850: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';

846:
847:
848: l_next_til_counter := til_tbl.next(l_curr_til_counter);
849: if (l_next_til_counter is null) OR ((til_tbl(l_next_til_counter).tai_id <> l_curr_tai_id)) THEN
850: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
851: l_trx_header_id := l_curr_tai_id; --- need to be correct
852: --Call accounting with new signature
853: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
854: p_api_version => p_api_version,

Line 929: UPDATE okl_trx_ar_invoices_b

925: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tai_id_tbl.count : ' || tai_id_tbl.COUNT);
926: END IF;
927: IF tai_id_tbl.COUNT > 0 THEN
928: FORALL indx IN tai_id_tbl.FIRST..tai_id_tbl.LAST
929: UPDATE okl_trx_ar_invoices_b
930: SET trx_status_code = 'SUBMITTED' -- 'PROCESSED' -- rmunjulu R12 Fixes changed to submitted IS THIS CORRECT
931: WHERE id = tai_id_tbl(indx);
932: END IF;
933: -- ---------------------------------------------------