APPS.OKL_AMORT_SCHED_PROCESS_PVT dependencies on STANDARD

Line 10: -- IN : p_api_version - Standard input parameter

6: -- Pre-reqs : None
7: -- Function : This procedure inserts the Amortization Schedule generated
8: -- into the OKL_AMORT_SCHED_HDRS
9: -- Parameters :
10: -- IN : p_api_version - Standard input parameter
11: -- p_init_msg_list - Standard input parameter
12: -- p_trx_req_id - Request ID from okl_trx_requests table
13: -- p_summ_flag - Boolean value indicating whether summary is available
14: -- OUT : x_return_status - Standard output parameter for Output status

Line 11: -- p_init_msg_list - Standard input parameter

7: -- Function : This procedure inserts the Amortization Schedule generated
8: -- into the OKL_AMORT_SCHED_HDRS
9: -- Parameters :
10: -- IN : p_api_version - Standard input parameter
11: -- p_init_msg_list - Standard input parameter
12: -- p_trx_req_id - Request ID from okl_trx_requests table
13: -- p_summ_flag - Boolean value indicating whether summary is available
14: -- OUT : x_return_status - Standard output parameter for Output status
15: -- x_msg_count - Standard output parameter

Line 14: -- OUT : x_return_status - Standard output parameter for Output status

10: -- IN : p_api_version - Standard input parameter
11: -- p_init_msg_list - Standard input parameter
12: -- p_trx_req_id - Request ID from okl_trx_requests table
13: -- p_summ_flag - Boolean value indicating whether summary is available
14: -- OUT : x_return_status - Standard output parameter for Output status
15: -- x_msg_count - Standard output parameter
16: -- x_msg_data - Standard output parameter
17: -- x_amor_hdr_id - The header ID record
18: -- Version : 1.0

Line 15: -- x_msg_count - Standard output parameter

11: -- p_init_msg_list - Standard input parameter
12: -- p_trx_req_id - Request ID from okl_trx_requests table
13: -- p_summ_flag - Boolean value indicating whether summary is available
14: -- OUT : x_return_status - Standard output parameter for Output status
15: -- x_msg_count - Standard output parameter
16: -- x_msg_data - Standard output parameter
17: -- x_amor_hdr_id - The header ID record
18: -- Version : 1.0
19: -- History : srsreeni created.

Line 16: -- x_msg_data - Standard output parameter

12: -- p_trx_req_id - Request ID from okl_trx_requests table
13: -- p_summ_flag - Boolean value indicating whether summary is available
14: -- OUT : x_return_status - Standard output parameter for Output status
15: -- x_msg_count - Standard output parameter
16: -- x_msg_data - Standard output parameter
17: -- x_amor_hdr_id - The header ID record
18: -- Version : 1.0
19: -- History : srsreeni created.
20: procedure insert_hdr(p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,

Line 124: -- IN : p_api_version - Standard input parameter

120: -- Pre-reqs : None
121: -- Function : This procedure inserts the Amortization Schedule generated
122: -- into the OKL_AMORT_SCHED_LINES
123: -- Parameters :
124: -- IN : p_api_version - Standard input parameter
125: -- p_init_msg_list - Standard input parameter
126: -- p_amort_sched_tbl - PL/SQL table for amor schedule
127: -- p_amor_line_id - PL/SQL table containing AMORT_LINE_ID
128: -- p_pri_id - Principal Header Id

Line 125: -- p_init_msg_list - Standard input parameter

121: -- Function : This procedure inserts the Amortization Schedule generated
122: -- into the OKL_AMORT_SCHED_LINES
123: -- Parameters :
124: -- IN : p_api_version - Standard input parameter
125: -- p_init_msg_list - Standard input parameter
126: -- p_amort_sched_tbl - PL/SQL table for amor schedule
127: -- p_amor_line_id - PL/SQL table containing AMORT_LINE_ID
128: -- p_pri_id - Principal Header Id
129: -- p_int_id - Interest Header Id

Line 140: -- OUT : x_return_status - Standard output parameter for Output status

136: -- p_summ_flag - Indicates Summary Report or not
137: -- p_proj_interest_rate - The interest rate used for
138: -- calculating projected schedule
139: -- p_order_by_id - The order by Header Id
140: -- OUT : x_return_status - Standard output parameter for Output status
141: -- x_msg_count - Standard output parameter
142: -- x_msg_data - Standard output parameter
143: -- Version : 1.0
144: -- History : srsreeni created.

Line 141: -- x_msg_count - Standard output parameter

137: -- p_proj_interest_rate - The interest rate used for
138: -- calculating projected schedule
139: -- p_order_by_id - The order by Header Id
140: -- OUT : x_return_status - Standard output parameter for Output status
141: -- x_msg_count - Standard output parameter
142: -- x_msg_data - Standard output parameter
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,

Line 142: -- x_msg_data - Standard output parameter

138: -- calculating projected schedule
139: -- p_order_by_id - The order by Header Id
140: -- OUT : x_return_status - Standard output parameter for Output status
141: -- x_msg_count - Standard output parameter
142: -- x_msg_data - Standard output parameter
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,

Line 263: -- IN : p_api_version - Standard input parameter

259: -- Pre-reqs : None
260: -- Function : This procedure prepares for inserting the Amortization Schedule generated
261: -- into the OKL_AMORT_SCHED_LINES
262: -- Parameters :
263: -- IN : p_api_version - Standard input parameter
264: -- p_init_msg_list - Standard input parameter
265: -- p_det_amort_sched_tbl - PL/SQL table for Detail amor schedule
266: -- p_summ_amort_sched_tbl - PL/SQL table for Summary amor schedule
267: -- p_amor_hdr_id - The header ID record

Line 264: -- p_init_msg_list - Standard input parameter

260: -- Function : This procedure prepares for inserting the Amortization Schedule generated
261: -- into the OKL_AMORT_SCHED_LINES
262: -- Parameters :
263: -- IN : p_api_version - Standard input parameter
264: -- p_init_msg_list - Standard input parameter
265: -- p_det_amort_sched_tbl - PL/SQL table for Detail amor schedule
266: -- p_summ_amort_sched_tbl - PL/SQL table for Summary amor schedule
267: -- p_amor_hdr_id - The header ID record
268: -- p_proj_interest_rate - The Projected interest

Line 270: -- OUT : x_return_status - Standard output parameter for Output status

266: -- p_summ_amort_sched_tbl - PL/SQL table for Summary amor schedule
267: -- p_amor_hdr_id - The header ID record
268: -- p_proj_interest_rate - The Projected interest
269: -- rate
270: -- OUT : x_return_status - Standard output parameter for Output status
271: -- x_msg_count - Standard output parameter
272: -- x_msg_data - Standard output parameter
273: -- Version : 1.0
274: -- History : srsreeni created.

Line 271: -- x_msg_count - Standard output parameter

267: -- p_amor_hdr_id - The header ID record
268: -- p_proj_interest_rate - The Projected interest
269: -- rate
270: -- OUT : x_return_status - Standard output parameter for Output status
271: -- x_msg_count - Standard output parameter
272: -- x_msg_data - Standard output parameter
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,

Line 272: -- x_msg_data - Standard output parameter

268: -- p_proj_interest_rate - The Projected interest
269: -- rate
270: -- OUT : x_return_status - Standard output parameter for Output status
271: -- x_msg_count - Standard output parameter
272: -- x_msg_data - Standard output parameter
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,

Line 397: -- IN : p_api_version - Standard input parameter

393: -- Pre-reqs : None
394: -- Function : This procedure deletes the Amortization Schedule generated
395: -- in the past for the contract.Deletes both Summary and Detail
396: -- Parameters :
397: -- IN : p_api_version - Standard input parameter
398: -- p_init_msg_list - Standard input parameter
399: -- p_chr_id - Contract ID
400: -- p_req_id - Request ID from okl_trx_requests table
401: -- OUT : x_return_status - Standard output parameter for Output status

Line 398: -- p_init_msg_list - Standard input parameter

394: -- Function : This procedure deletes the Amortization Schedule generated
395: -- in the past for the contract.Deletes both Summary and Detail
396: -- Parameters :
397: -- IN : p_api_version - Standard input parameter
398: -- p_init_msg_list - Standard input parameter
399: -- p_chr_id - Contract ID
400: -- p_req_id - Request ID from okl_trx_requests table
401: -- OUT : x_return_status - Standard output parameter for Output status
402: -- x_msg_count - Standard output parameter

Line 401: -- OUT : x_return_status - Standard output parameter for Output status

397: -- IN : p_api_version - Standard input parameter
398: -- p_init_msg_list - Standard input parameter
399: -- p_chr_id - Contract ID
400: -- p_req_id - Request ID from okl_trx_requests table
401: -- OUT : x_return_status - Standard output parameter for Output status
402: -- x_msg_count - Standard output parameter
403: -- x_msg_data - Standard output parameter
404: -- Version : 1.0
405: -- History : srsreeni created.

Line 402: -- x_msg_count - Standard output parameter

398: -- p_init_msg_list - Standard input parameter
399: -- p_chr_id - Contract ID
400: -- p_req_id - Request ID from okl_trx_requests table
401: -- OUT : x_return_status - Standard output parameter for Output status
402: -- x_msg_count - Standard output parameter
403: -- x_msg_data - Standard output parameter
404: -- Version : 1.0
405: -- History : srsreeni created.
406:

Line 403: -- x_msg_data - Standard output parameter

399: -- p_chr_id - Contract ID
400: -- p_req_id - Request ID from okl_trx_requests table
401: -- OUT : x_return_status - Standard output parameter for Output status
402: -- x_msg_count - Standard output parameter
403: -- x_msg_data - Standard output parameter
404: -- Version : 1.0
405: -- History : srsreeni created.
406:
407: procedure delete_old_sched(p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,

Line 463: -- OUT : x_return_status - Standard output parameter for Output status

459: -- Parameters :
460: -- IN : p_chr_id - Contract ID
461: -- p_trx_req_id - Request ID from okl_trx_requests table
462: -- p_user_id - User ID requesting the schedule
463: -- OUT : x_return_status - Standard output parameter for Output status
464: -- x_msg_count - Standard output parameter
465: -- x_msg_data - Standard output parameter
466: -- x_summ_flag - Boolean indicating whether Summary is available or not
467: -- Version : 1.0

Line 464: -- x_msg_count - Standard output parameter

460: -- IN : p_chr_id - Contract ID
461: -- p_trx_req_id - Request ID from okl_trx_requests table
462: -- p_user_id - User ID requesting the schedule
463: -- OUT : x_return_status - Standard output parameter for Output status
464: -- x_msg_count - Standard output parameter
465: -- x_msg_data - Standard output parameter
466: -- x_summ_flag - Boolean indicating whether Summary is available or not
467: -- Version : 1.0
468: -- History : srsreeni created.

Line 465: -- x_msg_data - Standard output parameter

461: -- p_trx_req_id - Request ID from okl_trx_requests table
462: -- p_user_id - User ID requesting the schedule
463: -- OUT : x_return_status - Standard output parameter for Output status
464: -- x_msg_count - Standard output parameter
465: -- x_msg_data - Standard output parameter
466: -- x_summ_flag - Boolean indicating whether Summary is available or not
467: -- Version : 1.0
468: -- History : srsreeni created.
469: procedure generate_amor_sched(p_chr_id in okc_k_headers_b.id%type,p_api_version IN NUMBER,