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_SLA_ACC_SOURCES_PVT dependencies on DUAL

Line 112: -- Contract ID and RENT/RESIDUAL stream type

108: AND rrb_qve.pqy_id = rrb_pqy.id
109: AND rrb_pqy.name = 'REVENUE_RECOGNITION_METHOD';
110:
111: -- Cursor to fetch the Investor Agreement Details provided the
112: -- Contract ID and RENT/RESIDUAL stream type
113: CURSOR c_investor_agreement_main_csr(p_khr_id NUMBER, p_sty_type VARCHAR2)
114: IS
115: SELECT
116: ia_chr.id ia_chr_id

Line 1218: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));

1214: l_teh_rec_in.rent_ia_product_name := t_rec.ia_product_name;
1215: END LOOP; -- c_investor_agreement_main_csr
1216:
1217: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1218: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
1219: FOR t_rec IN c_investor_agreement_main_csr(
1220: p_khr_id => l_khr_id
1221: ,p_sty_type => 'RESIDUAL VALUE')
1222: LOOP

Line 1221: ,p_sty_type => 'RESIDUAL VALUE')

1217: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1218: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
1219: FOR t_rec IN c_investor_agreement_main_csr(
1220: p_khr_id => l_khr_id
1221: ,p_sty_type => 'RESIDUAL VALUE')
1222: LOOP
1223: l_res_ia_chr_id := t_rec.ia_chr_id;
1224: l_teh_rec_in.res_ia_contract_number := t_rec.ia_contract_number;
1225: l_teh_rec_in.res_ia_product_name := t_rec.ia_product_name;

Line 3776: -- fetch and populate residual investor agreement attributes

3772: x_khr_source_rec.rent_ia_contract_number := l_investor_agree_main_csr_rec.ia_contract_number;
3773: x_khr_source_rec.rent_ia_product_name := l_investor_agree_main_csr_rec.ia_product_name;
3774: END LOOP; -- End for c_investor_agreement_main_csr
3775:
3776: -- fetch and populate residual investor agreement attributes
3777: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3778: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
3779: FOR t_rec IN c_investor_agreement_main_csr(
3780: p_khr_id => l_khr_id

Line 3778: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));

3774: END LOOP; -- End for c_investor_agreement_main_csr
3775:
3776: -- fetch and populate residual investor agreement attributes
3777: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3778: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
3779: FOR t_rec IN c_investor_agreement_main_csr(
3780: p_khr_id => l_khr_id
3781: ,p_sty_type => 'RESIDUAL VALUE')
3782: LOOP

Line 3781: ,p_sty_type => 'RESIDUAL VALUE')

3777: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3778: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
3779: FOR t_rec IN c_investor_agreement_main_csr(
3780: p_khr_id => l_khr_id
3781: ,p_sty_type => 'RESIDUAL VALUE')
3782: LOOP
3783: l_investor_agree_main_csr_rec := t_rec;
3784: l_res_ia_chr_id := l_investor_agree_main_csr_rec.ia_chr_id;
3785: x_khr_source_rec.res_ia_contract_number := l_investor_agree_main_csr_rec.ia_contract_number;

Line 8460: FROM DUAL;

8456: END IF;
8457: -- Select sequence for marking processes
8458: SELECT okl_opp_seq.NEXTVAL
8459: INTO l_seq_next
8460: FROM DUAL;
8461: -- Assign the input params to the Local Variables
8462: l_book_type_code := p_book_type_code;
8463: l_period_counter := p_period_counter;
8464: -- Log the Input Variables

Line 8528: log_msg(FND_FILE.LOG, 'Successfully Populated the Individual Collection Tables object_value, khr_id, volume tables');

8524: l_khr_id_tbl(dep_index) := l_deprn_contracts_tbl(dep_index).khr_id;
8525: l_volume_tbl(dep_index) := l_deprn_contracts_tbl(dep_index).no_of_assets;
8526: l_assigned_process_tbl(dep_index) := TO_CHAR(l_seq_next);
8527: END LOOP;
8528: log_msg(FND_FILE.LOG, 'Successfully Populated the Individual Collection Tables object_value, khr_id, volume tables');
8529: -- Bulk Insert all the records into the OKL_PARALLEL_PROCESSES
8530: log_msg(FND_FILE.LOG, 'Before calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8531: FORALL dep_index IN l_deprn_contracts_tbl.FIRST .. l_deprn_contracts_tbl.LAST
8532: INSERT INTO OKL_PARALLEL_PROCESSES (