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_ACTIVATE_CONTRACT_PUB dependencies on OKL_TRX_CONTRACTS

Line 768: l_tcnv_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

764: l_api_version CONSTANT NUMBER := 1.0;
765:
766: l_cimv_tbl_fa Okl_Activate_Asset_Pub.cimv_tbl_type;
767: l_cimv_tbl_ib Okl_Activate_Ib_Pub.cimv_tbl_type;
768: l_tcnv_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
769: l_service_chr_id Number;
770:
771: l_commit VARCHAR2(1) := Okl_Api.G_FALSE;
772: l_transaction_type VARCHAR2(256) default 'Booking';

Line 780: okl_trx_contracts ktrx

776: --cursor to check if the contract is rebooked contract
777: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
778: SELECT '!',chr.orig_system_id1, ktrx.date_transaction_occurred,ktrx.id
779: FROM okc_k_headers_b CHR,
780: okl_trx_contracts ktrx
781: WHERE ktrx.khr_id_new = chr.id
782: AND ktrx.tsu_code = 'ENTERED'
783: AND ktrx.rbr_code is NOT NULL
784: AND ktrx.tcn_type = 'TRBK'

Line 791: l_rebook_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

787: AND ktrx.representation_type = 'PRIMARY'; -- MGAAP 7263041
788:
789: l_rbk_khr VARCHAR2(1) DEFAULT '?';
790: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;
791: l_rebook_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
792: l_transaction_id okl_trx_contracts.id%TYPE;
793: --4542290 start
794: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
795: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

Line 792: l_transaction_id okl_trx_contracts.id%TYPE;

788:
789: l_rbk_khr VARCHAR2(1) DEFAULT '?';
790: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;
791: l_rebook_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
792: l_transaction_id okl_trx_contracts.id%TYPE;
793: --4542290 start
794: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
795: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
796: l_max_bill_date DATE;

Line 794: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

790: l_orig_khr_id okc_k_headers_b.orig_system_id1%Type;
791: l_rebook_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
792: l_transaction_id okl_trx_contracts.id%TYPE;
793: --4542290 start
794: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
795: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
796: l_max_bill_date DATE;
797: l_sty_id NUMBER;
798: l_accrual_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

Line 798: l_accrual_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

794: l_trx_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
795: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
796: l_max_bill_date DATE;
797: l_sty_id NUMBER;
798: l_accrual_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
799: l_stream_name VARCHAR2(30);
800: --4542290 end
801:
802: --Bug#3156924 : Cursor modified to fetch transaction date

Line 810: okl_trx_contracts ktrx

806: --Bug# 4212626
807: ktrx.id,
808: source_trx_id -- 4542290
809: FROM okc_k_headers_b CHR,
810: okl_trx_contracts ktrx
811: where CHR.ID = p_chr_id
812: AND ktrx.KHR_ID = chr.id
813: AND ktrx.tsu_code = 'ENTERED'
814: AND ktrx.rbr_code IS NOT NULL

Line 819: -- FROM okl_trx_contracts ktrx

815: AND ktrx.tcn_type = 'TRBK'
816: AND ktrx.representation_type = 'PRIMARY' -- MGAAP 7263041
817: /*------------------------------------------------
818: --AND EXISTS (SELECT '1'
819: -- FROM okl_trx_contracts ktrx
820: -- WHERE ktrx.KHR_ID = chr.id
821: -- AND ktrx.tsu_code = 'ENTERED'
822: -- AND ktrx.rbr_code IS NOT NULL
823: -- AND ktrx.tcn_type = 'TRBK')

Line 832: l_mass_rbk_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

828: AND rbk_khr.STATUS <> 'PROCESSED'); --check with debdip
829:
830: l_mass_rbk_khr VARCHAR2(1) DEFAULT '?';
831: --Bug# 3156924
832: l_mass_rbk_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
833: --Bug# 4212626
834: l_mass_rbk_trx_id OKL_TRX_CONTRACTS.id%TYPE;
835: --4542290
836: l_source_trx_id OKL_TRX_CONTRACTS.ID%TYPE;

Line 834: l_mass_rbk_trx_id OKL_TRX_CONTRACTS.id%TYPE;

830: l_mass_rbk_khr VARCHAR2(1) DEFAULT '?';
831: --Bug# 3156924
832: l_mass_rbk_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
833: --Bug# 4212626
834: l_mass_rbk_trx_id OKL_TRX_CONTRACTS.id%TYPE;
835: --4542290
836: l_source_trx_id OKL_TRX_CONTRACTS.ID%TYPE;
837:
838: CURSOR l_source_trx_type_csr(p_trx_id NUMBER) IS

Line 836: l_source_trx_id OKL_TRX_CONTRACTS.ID%TYPE;

832: l_mass_rbk_date OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
833: --Bug# 4212626
834: l_mass_rbk_trx_id OKL_TRX_CONTRACTS.id%TYPE;
835: --4542290
836: l_source_trx_id OKL_TRX_CONTRACTS.ID%TYPE;
837:
838: CURSOR l_source_trx_type_csr(p_trx_id NUMBER) IS
839: SELECT TCN_TYPE
840: FROM OKL_TRX_CONTRACTS

Line 840: FROM OKL_TRX_CONTRACTS

836: l_source_trx_id OKL_TRX_CONTRACTS.ID%TYPE;
837:
838: CURSOR l_source_trx_type_csr(p_trx_id NUMBER) IS
839: SELECT TCN_TYPE
840: FROM OKL_TRX_CONTRACTS
841: WHERE ID = p_trx_id;
842:
843: l_source_trx_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
844: --4542290

Line 843: l_source_trx_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;

839: SELECT TCN_TYPE
840: FROM OKL_TRX_CONTRACTS
841: WHERE ID = p_trx_id;
842:
843: l_source_trx_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
844: --4542290
845: --cursor to check if usage line exists on the contract
846: CURSOR l_chk_usage_csr (p_chr_id IN Number) IS
847: SELECT '!'

Line 1053: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041

1049: is_debug_statement_on BOOLEAN;
1050: -- sjalasut: added local variables for subsidy pools enhancement. END
1051:
1052: -- dedey, Bug#4264314
1053: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041
1054: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
1055: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
1056: -- dedey, Bug#4264314
1057: