[Home] [Help]
PACKAGE: APPS.OKL_AMORT_SCHED_PROCESS_PVT
Source
1 package OKL_AMORT_SCHED_PROCESS_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRLAMS.pls 120.3 2008/02/20 00:48:17 srsreeni noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AMORT_SCHED_PROCESS_PVT';
4 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
5 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
6 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
7 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8 G_REPORT_TYPE_SUMMARY CONSTANT VARCHAR2(50) := 'SUMMARY';
9 G_REPORT_TYPE_DETAIL CONSTANT VARCHAR2(50) := 'DETAIL';
10 G_REPORT_TYPE_SUMMARY_C CONSTANT VARCHAR2(50) := 'S';
11 G_REPORT_TYPE_DETAIL_C CONSTANT VARCHAR2(50) := 'D';
12 G_PRINCIPAL_TYPE CONSTANT VARCHAR2(30) := 'PRINCIPAL';
13 G_INTEREST_TYPE CONSTANT VARCHAR2(30) := 'INTEREST';
14 G_PRINCIPAL_BAL_TYPE CONSTANT VARCHAR2(30) := 'PRINCIPAL_BALANCE';
15 G_LOAN_PAYMENT CONSTANT VARCHAR2(30) := 'LOAN_PAYMENT';
16 G_DATE_FROM CONSTANT VARCHAR2(30) := 'DATE_FROM';
17 G_DATE_TO CONSTANT VARCHAR2(30) := 'DATE_TO';
18 G_PERIOD CONSTANT VARCHAR2(30) := 'PERIOD';
19 G_PAST_PROJ CONSTANT VARCHAR2(20) := 'PAST_OR_PROJECTED';
20 G_PROJ_INTEREST_RATE CONSTANT VARCHAR2(20) := 'PROJ_INTEREST_RATE';
21 G_ORDER_BY CONSTANT VARCHAR2(20) := 'ORDER_BY';
22 G_SUMM_COLUMNS CONSTANT number := 7;
23 G_DET_COLUMNS CONSTANT number := 8;
24 g_user_id number := -1;
25 ------------------------------------------------------------------------------
26 -- Record Type
27 ------------------------------------------------------------------------------
28 TYPE amort_hdr_id_rec_type IS RECORD (
29 pri_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30 pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31 int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32 int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33 pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34 pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35 loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36 loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37 date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38 date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39 date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40 proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41 -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42 pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43 order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
44 order_by_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type
45 );
46
47 TYPE amort_hdr_id_tbl_type is table of amort_hdr_id_rec_type INDEX BY BINARY_INTEGER;
48 TYPE amort_line_id is table of number;
49 procedure generate_amor_sched(p_chr_id in okc_k_headers_b.id%type,p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51 p_trx_req_id in okl_trx_requests.id%type,
52 p_user_id in number,
53 x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,x_summ_flag OUT boolean);
55 procedure delete_old_sched(p_api_version IN NUMBER,p_init_msg_list IN
56 VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT
58 NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,p_chr_id in
59 okc_k_headers_b.id%type,
60 p_req_id in
61 okl_trx_requests.id%type);
62 end OKL_AMORT_SCHED_PROCESS_PVT;