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 508: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS

504:
505:
506: -- Start : Bug#5964007 : PRASJAIN
507: -- Cursor to check if 3 level credit memo is on-account
508: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS
509: SELECT 'X' FROM
510: OKL_TXD_AR_LN_DTLS_B
511: WHERE ID = p_tld_id
512: AND TLD_ID_REVERSES IS NULL;

Line 510: OKL_TXD_AR_LN_DTLS_B

506: -- Start : Bug#5964007 : PRASJAIN
507: -- Cursor to check if 3 level credit memo is on-account
508: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS
509: SELECT 'X' FROM
510: OKL_TXD_AR_LN_DTLS_B
511: WHERE ID = p_tld_id
512: AND TLD_ID_REVERSES IS NULL;
513:
514: l_on_acc_cm BOOLEAN;

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

778: -- --------------------------------------
779: -- Transfer Tld records to the Tld table
780: -- --------------------------------------
781: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
782: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_b');
783:
784: END IF;
785: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');
786:

Line 791: INSERT INTO OKL_TXD_AR_LN_DTLS_B

787: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);
788:
789: IF tld_tbl.COUNT > 0 THEN
790: FORALL indx IN tld_tbl.first..tld_tbl.LAST
791: INSERT INTO OKL_TXD_AR_LN_DTLS_B
792: VALUES tld_tbl(indx);
793: END IF;
794:
795: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

792: VALUES tld_tbl(indx);
793: END IF;
794:
795: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_b');
797:
798: END IF;
799: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD records to TLD table...');
800: -- --------------------------------------

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

843: ---- End Added by Vpanwar --- Code for new accounting API uptake
844: l_acc_dist_status := 'S';
845: l_error_message := NULL;
846: p_bpd_acc_rec.id := tld_tbl(i).id; --xls_tbl(i).tld_id; -- rmunjulu R12 Fixes changed to tld
847: p_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';
848:
849: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
850: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Transaction Line Id '||p_bpd_acc_rec.id);
851: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Transaction Source Table '||p_bpd_acc_rec.source_table);

Line 1190: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL

1186: IS
1187:
1188: --cklee: start 3/16/07
1189: cursor c_seq is
1190: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL
1191: FROM dual;
1192: l_seq number;
1193: --cklee: start 3/16/07
1194: