DBA Data[Home] [Help]

APPS.OKL_AMORT_SCHED_PROCESS_PVT dependencies on OKC_K_HEADERS_B

Line 408: x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,p_chr_id in okc_k_headers_b.id%type,

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,
408: x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,p_chr_id in okc_k_headers_b.id%type,
409: p_req_id in okl_trx_requests.id%type) as
410: cursor trx_req_csr(p_chr_id in okc_k_headers_b.id%type,p_req_id in okl_trx_requests.id%type) is
411: select nvl(max(trx_req_id),-1) trx_req_id from OKL_AMORT_SCHED_HDRS
412: where trx_req_id = (select nvl(max(tr.id),-1) from okl_trx_requests tr

Line 410: cursor trx_req_csr(p_chr_id in okc_k_headers_b.id%type,p_req_id in okl_trx_requests.id%type) is

406:
407: procedure delete_old_sched(p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,p_chr_id in okc_k_headers_b.id%type,
409: p_req_id in okl_trx_requests.id%type) as
410: cursor trx_req_csr(p_chr_id in okc_k_headers_b.id%type,p_req_id in okl_trx_requests.id%type) is
411: select nvl(max(trx_req_id),-1) trx_req_id from OKL_AMORT_SCHED_HDRS
412: where trx_req_id = (select nvl(max(tr.id),-1) from okl_trx_requests tr
413: where dnz_khr_id = p_chr_id and id < p_req_id
414: and request_type_code='AMORITIZATION_SCHEDULE_CURRENT')

Line 469: procedure generate_amor_sched(p_chr_id in okc_k_headers_b.id%type,p_api_version IN NUMBER,

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,
470: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
471: p_trx_req_id in okl_trx_requests.id%type,p_user_id in number,
472: x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,
473: x_msg_data OUT NOCOPY VARCHAR2,x_summ_flag OUT boolean) as