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_AMORT_SCHED_PROCESS_PVT dependencies on OKL_LOAN_AMORT_SCHEDULE_PVT

Line 147: p_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,p_amor_line_id in AMORT_LINE_ID,

143: -- Version : 1.0
144: -- History : srsreeni created.
145: procedure insert_lines(p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,
147: p_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,p_amor_line_id in AMORT_LINE_ID,
148: p_pri_id in OKL_AMORT_SCHED_HDRS.AMORT_HDR_ID%type,
149: p_int_id in OKL_AMORT_SCHED_HDRS.AMORT_HDR_ID%type,p_pri_bal_id in OKL_AMORT_SCHED_HDRS.AMORT_HDR_ID%type,
150: p_date_from_id in OKL_AMORT_SCHED_HDRS.AMORT_HDR_ID%type,p_loan_pymnt_id in OKL_AMORT_SCHED_HDRS.AMORT_HDR_ID%type,
151: p_pastproj_id in OKL_AMORT_SCHED_HDRS.AMORT_HDR_ID%type default NULL,

Line 277: p_det_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,

273: -- Version : 1.0
274: -- History : srsreeni created.
275: procedure prepare_insert_lines(p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,
277: p_det_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,
278: p_summ_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,
279: p_amor_hdr_id in amort_hdr_id_tbl_type,p_proj_interest_rate in number) as
280: l_det_amor_line_id AMORT_LINE_ID := AMORT_LINE_ID(-1);
281: l_summ_amor_line_id AMORT_LINE_ID := AMORT_LINE_ID(-1);

Line 278: p_summ_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,

274: -- History : srsreeni created.
275: procedure prepare_insert_lines(p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,
277: p_det_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,
278: p_summ_amort_sched_tbl in OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type,
279: p_amor_hdr_id in amort_hdr_id_tbl_type,p_proj_interest_rate in number) as
280: l_det_amor_line_id AMORT_LINE_ID := AMORT_LINE_ID(-1);
281: l_summ_amor_line_id AMORT_LINE_ID := AMORT_LINE_ID(-1);
282: l_rec_count number := 0;

Line 478: l_det_amort_sched_tbl OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type;

474: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_AMOR_SCHED';
475: l_api_version CONSTANT NUMBER := 1.0;
476: l_amor_hdr_id amort_hdr_id_tbl_type;
477: l_summ_flag boolean := false;
478: l_det_amort_sched_tbl OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type;
479: l_summ_amort_sched_tbl OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type;
480: l_proj_interest_rate number;
481: begin
482: g_user_id := p_user_id;

Line 479: l_summ_amort_sched_tbl OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type;

475: l_api_version CONSTANT NUMBER := 1.0;
476: l_amor_hdr_id amort_hdr_id_tbl_type;
477: l_summ_flag boolean := false;
478: l_det_amort_sched_tbl OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type;
479: l_summ_amort_sched_tbl OKL_LOAN_AMORT_SCHEDULE_PVT.amort_sched_tbl_type;
480: l_proj_interest_rate number;
481: begin
482: g_user_id := p_user_id;
483: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 498: -- dbms_output.put_line('B4 invoking OKL_LOAN_AMORT_SCHEDULE_PVT - Detail');

494: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497:
498: -- dbms_output.put_line('B4 invoking OKL_LOAN_AMORT_SCHEDULE_PVT - Detail');
499: --Invoke the API to obtain the generated amoritization schedule
500: --Invoke with Summary and Detail to generate the reports
501: OKL_LOAN_AMORT_SCHEDULE_PVT.load_loan_amort_schedule(
502: p_api_version => p_api_version,

Line 501: OKL_LOAN_AMORT_SCHEDULE_PVT.load_loan_amort_schedule(

497:
498: -- dbms_output.put_line('B4 invoking OKL_LOAN_AMORT_SCHEDULE_PVT - Detail');
499: --Invoke the API to obtain the generated amoritization schedule
500: --Invoke with Summary and Detail to generate the reports
501: OKL_LOAN_AMORT_SCHEDULE_PVT.load_loan_amort_schedule(
502: p_api_version => p_api_version,
503: p_init_msg_list => OKL_API.G_TRUE,
504: x_return_status => x_return_status,
505: x_msg_count => x_msg_count,

Line 511: -- dbms_output.put_line('B4 invoking OKL_LOAN_AMORT_SCHEDULE_PVT - Summary');

507: p_chr_id => p_chr_id,
508: p_report_type => G_REPORT_TYPE_DETAIL,
509: x_proj_interest_rate => l_proj_interest_rate,
510: x_amort_sched_tbl => l_det_amort_sched_tbl);
511: -- dbms_output.put_line('B4 invoking OKL_LOAN_AMORT_SCHEDULE_PVT - Summary');
512: OKL_LOAN_AMORT_SCHEDULE_PVT.load_loan_amort_schedule(
513: p_api_version => p_api_version,
514: p_init_msg_list => OKL_API.G_TRUE,
515: x_return_status => x_return_status,

Line 512: OKL_LOAN_AMORT_SCHEDULE_PVT.load_loan_amort_schedule(

508: p_report_type => G_REPORT_TYPE_DETAIL,
509: x_proj_interest_rate => l_proj_interest_rate,
510: x_amort_sched_tbl => l_det_amort_sched_tbl);
511: -- dbms_output.put_line('B4 invoking OKL_LOAN_AMORT_SCHEDULE_PVT - Summary');
512: OKL_LOAN_AMORT_SCHEDULE_PVT.load_loan_amort_schedule(
513: p_api_version => p_api_version,
514: p_init_msg_list => OKL_API.G_TRUE,
515: x_return_status => x_return_status,
516: x_msg_count => x_msg_count,