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 529: l_prev_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;

525: TYPE xtdtl_tbl_type IS TABLE OF OKL_XTD_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
526: xtd_tbl xtd_tbl_type;
527: xtdtl_tbl xtdtl_tbl_type;
528: l_xtd_id okl_xtd_sell_invs_v.id%TYPE;
529: l_prev_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;
530:
531: -------------------------------------
532: -- Variables for bulk updates
533: -------------------------------------

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

557: ------------------------------------------------------------
558:
559: l_error_status VARCHAR2(1);
560: l_error_message VARCHAR2(2000);
561: l_err_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE := NULL;
562: l_rec_status VARCHAR2(10) := NULL;
563:
564: l_request_id NUMBER(15);
565: l_program_application_id NUMBER(15);

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

655: -- --------------------------------------
656: -- Transfer Tai records to the Tai table
657: -- --------------------------------------
658: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
659: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_b');
660:
661: END IF;
662: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');
663:

Line 668: INSERT INTO OKL_TRX_AR_INVOICES_B

664: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);
665:
666: IF tai_tbl.COUNT > 0 THEN
667: FORALL indx IN tai_tbl.first..tai_tbl.LAST
668: INSERT INTO OKL_TRX_AR_INVOICES_B
669: VALUES tai_tbl(indx);
670:
671: -- Start Bug 4520466
672: -- update okl_k_control table

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

704:
705: END IF; -- if tai_tbl.COUNT > 0
706:
707: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
708: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_b');
709:
710: END IF;
711: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI records to TAI table...');
712: -- --------------------------------------

Line 909: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';

905:
906:
907: l_next_til_counter := til_tbl.next(l_curr_til_counter);
908: if (l_next_til_counter is null) OR ((til_tbl(l_next_til_counter).tai_id <> l_curr_tai_id)) THEN
909: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
910: l_trx_header_id := l_curr_tai_id; --- need to be correct
911: --Call accounting with new signature
912: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
913: p_api_version => p_api_version,

Line 988: UPDATE okl_trx_ar_invoices_b

984: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tai_id_tbl.count : ' || tai_id_tbl.COUNT);
985: END IF;
986: IF tai_id_tbl.COUNT > 0 THEN
987: FORALL indx IN tai_id_tbl.FIRST..tai_id_tbl.LAST
988: UPDATE okl_trx_ar_invoices_b
989: SET trx_status_code = 'SUBMITTED' -- 'PROCESSED' -- rmunjulu R12 Fixes changed to submitted IS THIS CORRECT
990: WHERE id = tai_id_tbl(indx);
991: END IF;
992: -- ---------------------------------------------------