eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MISC_TRANS_PVT dependencies on OKL_TRX_CONTRACTS

Line 240: FROM OKL_TRX_CONTRACTS

236: -- Cursor to fetch trx amount
237:
238: CURSOR trx_amt_csr (l_trx_id NUMBER) IS
239: SELECT AMOUNT
240: FROM OKL_TRX_CONTRACTS
241: WHERE ID = l_trx_id;
242:
243: -- Cursor to fetch trx line amount
244: CURSOR txl_amt_in_csr (l_trx_id NUMBER) IS

Line 307: FROM OKL_TRX_CONTRACTS

303: IS
304:
305: CURSOR tcn_csr(v_tcn_id NUMBER) IS
306: SELECT tsu_code
307: FROM OKL_TRX_CONTRACTS
308: WHERE ID = v_tcn_id;
309:
310: CURSOR tcl_csr(v_tcl_id NUMBER) IS
311: SELECT avl_id,

Line 334: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;

330: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
331: l_old_avl_id NUMBER := NULL;
332: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
333: i NUMBER := 0;
334: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
335:
336: l_check_status NUMBER;
337: l_avl_id NUMBER;
338: l_sty_id NUMBER;

Line 408: -- Start of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

404:
405: END IF;
406:
407:
408: -- Start of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines
409: IF(L_DEBUG_ENABLED='Y') THEN
410: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
411: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
412: END IF;

Line 415: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines ');

411: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
412: END IF;
413: IF(IS_DEBUG_PROCEDURE_ON) THEN
414: BEGIN
415: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines ');
416: END;
417: END IF;
418: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines(p_api_version => l_api_version,
419: p_init_msg_list => l_init_msg_list,

Line 418: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines(p_api_version => l_api_version,

414: BEGIN
415: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines ');
416: END;
417: END IF;
418: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines(p_api_version => l_api_version,
419: p_init_msg_list => l_init_msg_list,
420: x_return_status => l_return_status,
421: x_msg_count => l_msg_count,
422: x_msg_data => l_msg_data,

Line 427: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines ');

423: p_tclv_rec => l_tclv_rec_in,
424: x_tclv_rec => l_tclv_rec_out);
425: IF(IS_DEBUG_PROCEDURE_ON) THEN
426: BEGIN
427: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines ');
428: END;
429: END IF;
430: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines
431:

Line 430: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

426: BEGIN
427: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines ');
428: END;
429: END IF;
430: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines
431:
432: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
433:
434: IF (l_tclv_rec_in.AVL_ID IS NOT NULL) AND

Line 483: -- Start of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines

479:
480:
481: -- Update has to be done anyway
482:
483: -- Start of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
484: IF(IS_DEBUG_PROCEDURE_ON) THEN
485: BEGIN
486: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
487: END;

Line 486: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');

482:
483: -- Start of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
484: IF(IS_DEBUG_PROCEDURE_ON) THEN
485: BEGIN
486: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
487: END;
488: END IF;
489: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,
490: p_init_msg_list => l_init_msg_list,

Line 489: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,

485: BEGIN
486: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
487: END;
488: END IF;
489: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,
490: p_init_msg_list => l_init_msg_list,
491: x_return_status => l_return_status,
492: x_msg_count => l_msg_count,
493: x_msg_data => l_msg_data,

Line 498: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');

494: p_tclv_rec => l_tclv_rec_in,
495: x_tclv_rec => l_tclv_rec_out);
496: IF(IS_DEBUG_PROCEDURE_ON) THEN
497: BEGIN
498: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
499: END;
500: END IF;
501: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
502:

Line 501: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines

497: BEGIN
498: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
499: END;
500: END IF;
501: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
502:
503: IF (nvl(l_tclv_rec_in.avl_id,OKL_API.G_MISS_NUM) <> nvl(l_avl_id,OKL_API.G_MISS_NUM)) OR
504: (nvl(l_tclv_rec_in.sty_id,OKL_API.G_MISS_NUM) <> nvl(l_sty_id,OKL_API.G_MISS_NUM)) OR
505: (nvl(l_tclv_rec_in.amount,OKL_API.G_MISS_NUM) <> nvl(l_amount,OKL_API.G_MISS_NUM)) THEN

Line 621: FROM OKL_TRX_CONTRACTS

617: currency_code,
618: currency_conversion_type,
619: currency_conversion_rate,
620: currency_conversion_date
621: FROM OKL_TRX_CONTRACTS
622: WHERE ID = v_tcn_id;
623:
624: CURSOR prod_csr(v_aes_id NUMBER) IS
625: SELECT ID

Line 706: l_currency_code okl_trx_contracts.currency_code%TYPE;

702: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
703: l_accounting_date DATE;
704:
705: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
706: l_currency_code okl_trx_contracts.currency_code%TYPE;
707: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
708: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
709: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
710:

Line 707: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;

703: l_accounting_date DATE;
704:
705: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
706: l_currency_code okl_trx_contracts.currency_code%TYPE;
707: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
708: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
709: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
710:
711: l_dist_api_version CONSTANT NUMBER := 1.0;

Line 708: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;

704:
705: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
706: l_currency_code okl_trx_contracts.currency_code%TYPE;
707: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
708: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
709: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
710:
711: l_dist_api_version CONSTANT NUMBER := 1.0;
712: l_aes_id NUMBER;

Line 709: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;

705: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
706: l_currency_code okl_trx_contracts.currency_code%TYPE;
707: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
708: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
709: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
710:
711: l_dist_api_version CONSTANT NUMBER := 1.0;
712: l_aes_id NUMBER;
713:

Line 886: x_tclv_rec OUT NOCOPY okl_trx_contracts_pvt.tclv_rec_type) IS

882: PROCEDURE populate_jrnl_lines(p_tcn_id IN NUMBER,
883: p_khr_id IN NUMBER,
884: p_currency_code IN VARCHAR2,
885: p_jrnl_line_rec IN jrnl_line_rec_type,
886: x_tclv_rec OUT NOCOPY okl_trx_contracts_pvt.tclv_rec_type) IS
887:
888: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
889: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||' populate_jrnl_lines ';
890: BEGIN

Line 888: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;

884: p_currency_code IN VARCHAR2,
885: p_jrnl_line_rec IN jrnl_line_rec_type,
886: x_tclv_rec OUT NOCOPY okl_trx_contracts_pvt.tclv_rec_type) IS
887:
888: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
889: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||' populate_jrnl_lines ';
890: BEGIN
891: IF(p_jrnl_line_rec.id IS NOT NULL) THEN
892: l_tclv_rec.id := p_jrnl_line_rec.id;

Line 927: l_transaction_date okl_trx_contracts.transaction_date%TYPE := okl_api.g_miss_date;

923:
924: l_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
925: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||' populate_jrnl_hdr ';
926:
927: l_transaction_date okl_trx_contracts.transaction_date%TYPE := okl_api.g_miss_date;
928:
929: CURSOR c_transaction_date(
930: cp_khr_id okl_trx_contracts.khr_id%TYPE,
931: cp_trx_number okl_trx_contracts.trx_number%TYPE

Line 930: cp_khr_id okl_trx_contracts.khr_id%TYPE,

926:
927: l_transaction_date okl_trx_contracts.transaction_date%TYPE := okl_api.g_miss_date;
928:
929: CURSOR c_transaction_date(
930: cp_khr_id okl_trx_contracts.khr_id%TYPE,
931: cp_trx_number okl_trx_contracts.trx_number%TYPE
932: ) IS
933: SELECT transaction_date
934: FROM okl_trx_contracts

Line 931: cp_trx_number okl_trx_contracts.trx_number%TYPE

927: l_transaction_date okl_trx_contracts.transaction_date%TYPE := okl_api.g_miss_date;
928:
929: CURSOR c_transaction_date(
930: cp_khr_id okl_trx_contracts.khr_id%TYPE,
931: cp_trx_number okl_trx_contracts.trx_number%TYPE
932: ) IS
933: SELECT transaction_date
934: FROM okl_trx_contracts
935: WHERE khr_id = cp_khr_id

Line 934: FROM okl_trx_contracts

930: cp_khr_id okl_trx_contracts.khr_id%TYPE,
931: cp_trx_number okl_trx_contracts.trx_number%TYPE
932: ) IS
933: SELECT transaction_date
934: FROM okl_trx_contracts
935: WHERE khr_id = cp_khr_id
936: AND trx_number = cp_trx_number;
937:
938: BEGIN

Line 988: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;

984:
985: l_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
986: lx_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
987:
988: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
989: lx_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
990:
991: lx_return_status VARCHAR2(1);
992:

Line 989: lx_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;

985: l_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
986: lx_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
987:
988: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
989: lx_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
990:
991: lx_return_status VARCHAR2(1);
992:
993: BEGIN

Line 1107: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;

1103:
1104: l_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
1105: lx_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
1106:
1107: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
1108: lx_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
1109:
1110: lx_return_status VARCHAR2(1);
1111:

Line 1108: lx_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;

1104: l_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
1105: lx_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
1106:
1107: l_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
1108: lx_tclv_rec okl_trx_contracts_pvt.tclv_rec_type;
1109:
1110: lx_return_status VARCHAR2(1);
1111:
1112: BEGIN