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 1191: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));

1187: l_teh_rec_in.rent_ia_product_name := t_rec.ia_product_name;
1188: END LOOP; -- c_investor_agreement_main_csr
1189:
1190: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1191: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
1192: FOR t_rec IN c_investor_agreement_main_csr(
1193: p_khr_id => l_khr_id
1194: ,p_sty_type => 'RESIDUAL VALUE')
1195: LOOP

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

1190: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1191: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
1192: FOR t_rec IN c_investor_agreement_main_csr(
1193: p_khr_id => l_khr_id
1194: ,p_sty_type => 'RESIDUAL VALUE')
1195: LOOP
1196: l_res_ia_chr_id := t_rec.ia_chr_id;
1197: l_teh_rec_in.res_ia_contract_number := t_rec.ia_contract_number;
1198: l_teh_rec_in.res_ia_product_name := t_rec.ia_product_name;

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

3713: x_khr_source_rec.rent_ia_contract_number := l_investor_agree_main_csr_rec.ia_contract_number;
3714: x_khr_source_rec.rent_ia_product_name := l_investor_agree_main_csr_rec.ia_product_name;
3715: END LOOP; -- End for c_investor_agreement_main_csr
3716:
3717: -- fetch and populate residual investor agreement attributes
3718: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3719: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
3720: FOR t_rec IN c_investor_agreement_main_csr(
3721: p_khr_id => l_khr_id

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

3715: END LOOP; -- End for c_investor_agreement_main_csr
3716:
3717: -- fetch and populate residual investor agreement attributes
3718: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3719: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
3720: FOR t_rec IN c_investor_agreement_main_csr(
3721: p_khr_id => l_khr_id
3722: ,p_sty_type => 'RESIDUAL VALUE')
3723: LOOP

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

3718: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3719: 'RESIDUAL VALUE: Executing the Cursor c_investor_agreement_main_csr l_khr_id = : ' || TO_CHAR(l_khr_id));
3720: FOR t_rec IN c_investor_agreement_main_csr(
3721: p_khr_id => l_khr_id
3722: ,p_sty_type => 'RESIDUAL VALUE')
3723: LOOP
3724: l_investor_agree_main_csr_rec := t_rec;
3725: l_res_ia_chr_id := l_investor_agree_main_csr_rec.ia_chr_id;
3726: x_khr_source_rec.res_ia_contract_number := l_investor_agree_main_csr_rec.ia_contract_number;

Line 8345: FROM DUAL;

8341: END IF;
8342: -- Select sequence for marking processes
8343: SELECT okl_opp_seq.NEXTVAL
8344: INTO l_seq_next
8345: FROM DUAL;
8346: -- Assign the input params to the Local Variables
8347: l_book_type_code := p_book_type_code;
8348: l_period_counter := p_period_counter;
8349: -- Log the Input Variables

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

8409: l_khr_id_tbl(dep_index) := l_deprn_contracts_tbl(dep_index).khr_id;
8410: l_volume_tbl(dep_index) := l_deprn_contracts_tbl(dep_index).no_of_assets;
8411: l_assigned_process_tbl(dep_index) := TO_CHAR(l_seq_next);
8412: END LOOP;
8413: log_msg(FND_FILE.LOG, 'Successfully Populated the Individual Collection Tables object_value, khr_id, volume tables');
8414: -- Bulk Insert all the records into the OKL_PARALLEL_PROCESSES
8415: log_msg(FND_FILE.LOG, 'Before calling the Bulk Insert into the OKL_PARALLEL_PROCESSES' );
8416: FORALL dep_index IN l_deprn_contracts_tbl.FIRST .. l_deprn_contracts_tbl.LAST
8417: INSERT INTO OKL_PARALLEL_PROCESSES (