APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 35: TYPE tld_tbl_type IS TABLE OF OKL_TXD_AR_LN_DTLS_B%ROWTYPE INDEX BY BINARY_INTEGER;

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:
39: tai_tbl tai_tbl_type;

Line 449: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS

445:
446:
447: -- Start : Bug#5964007 : PRASJAIN
448: -- Cursor to check if 3 level credit memo is on-account
449: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS
450: SELECT 'X' FROM
451: OKL_TXD_AR_LN_DTLS_B
452: WHERE ID = p_tld_id
453: AND TLD_ID_REVERSES IS NULL;

Line 451: OKL_TXD_AR_LN_DTLS_B

447: -- Start : Bug#5964007 : PRASJAIN
448: -- Cursor to check if 3 level credit memo is on-account
449: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS
450: SELECT 'X' FROM
451: OKL_TXD_AR_LN_DTLS_B
452: WHERE ID = p_tld_id
453: AND TLD_ID_REVERSES IS NULL;
454:
455: l_on_acc_cm BOOLEAN;

Line 723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_b');

719: -- --------------------------------------
720: -- Transfer Tld records to the Tld table
721: -- --------------------------------------
722: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_b');
724:
725: END IF;
726: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');
727:

Line 732: INSERT INTO OKL_TXD_AR_LN_DTLS_B

728: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);
729:
730: IF tld_tbl.COUNT > 0 THEN
731: FORALL indx IN tld_tbl.first..tld_tbl.LAST
732: INSERT INTO OKL_TXD_AR_LN_DTLS_B
733: VALUES tld_tbl(indx);
734: END IF;
735:
736: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

733: VALUES tld_tbl(indx);
734: END IF;
735:
736: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
737: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_b');
738:
739: END IF;
740: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD records to TLD table...');
741: -- --------------------------------------

Line 788: p_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

784: ---- End Added by Vpanwar --- Code for new accounting API uptake
785: l_acc_dist_status := 'S';
786: l_error_message := NULL;
787: p_bpd_acc_rec.id := tld_tbl(i).id; --xls_tbl(i).tld_id; -- rmunjulu R12 Fixes changed to tld
788: p_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';
789:
790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Transaction Line Id '||p_bpd_acc_rec.id);
792: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Transaction Source Table '||p_bpd_acc_rec.source_table);

Line 1128: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL

1124: IS
1125:
1126: --cklee: start 3/16/07
1127: cursor c_seq is
1128: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL
1129: FROM dual;
1130: l_seq number;
1131: --cklee: start 3/16/07
1132: