[Home] [Help]
PACKAGE: APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT
Source
1 PACKAGE OKL_CS_PRINCIPAL_PAYDOWN_PVT AS
2 /* $Header: OKLRPPDS.pls 120.4 2005/12/20 19:10:22 rkuttiya noship $ */
3
4 --Added for 11i10+
5
6 TYPE payment_rec_type IS RECORD (
7 KHR_ID NUMBER,
8 KLE_ID NUMBER,
9 STY_ID NUMBER,
10 start_date DATE,
11 structure VARCHAR2(1),
12 arrears_yn VARCHAR2(1),
13 periods NUMBER,
14 frequency VARCHAR2(1),
15 amount NUMBER,
16 stub_days NUMBER,
17 stub_amount NUMBER);
18
19
20 TYPE payment_tbl_type IS TABLE OF payment_rec_type INDEX BY BINARY_INTEGER;
21
22
23 G_FIN_ASSET_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'FINANCIAL_ASSET_LINE';
24 G_OBJECT_SRC_TABLE CONSTANT VARCHAR2(30) := 'OKL_TRX_REQUESTS';
25 G_PROPOSED_STATUS CONSTANT VARCHAR2(30) := 'PROPOSED';
26 G_CASH_FLOW_TYPE CONSTANT VARCHAR2(30) := 'PAYMENT_SCHEDULE';
27 G_PPD_REASON_CODE CONSTANT VARCHAR2(30) := 'PRINCIPAL_PAYDOWN';
28
29
30 --End Addn for 11i10+
31
32 PROCEDURE create_working_copy(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
35 p_commit IN VARCHAR2 := OKL_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_chr_id IN NUMBER,
40 x_chr_id OUT NOCOPY NUMBER);
41
42 PROCEDURE update_hdr_info(
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
47 p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
48 p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
49 p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE);
50
51
52 PROCEDURE calculate(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,
59 x_trqv_tbl OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type);
60
61 PROCEDURE update_ppd_request(
62 p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,p_trqv_rec IN okl_trx_requests_pub.trqv_rec_type
68 ,x_trqv_rec OUT NOCOPY okl_trx_requests_pub.trqv_rec_type);
69
70 PROCEDURE create_ppd_invoice (
71 p_khr_id IN NUMBER,
72 p_ppd_amount IN NUMBER,
73 p_ppd_desc IN VARCHAR2 DEFAULT NULL,
74 p_syndication_code IN VARCHAR2 DEFAULT NULL,
75 p_factoring_code IN VARCHAR2 DEFAULT NULL,
76 x_tai_id OUT NOCOPY NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2);
80
81 --Added the following for 11i10+ project
82 PROCEDURE cancel_ppd(
83 p_api_version IN NUMBER
84 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 ,p_khr_id IN NUMBER);
89
90 PROCEDURE invoice_apply_ppd(
91 p_api_version IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 ,p_khr_id IN NUMBER
97 ,p_trx_id IN NUMBER);
98
99 FUNCTION check_for_ppd (
100 p_khr_id IN NUMBER
101 ,p_effective_date IN DATE)
102 RETURN VARCHAR2;
103
104 FUNCTION check_if_ppd
105 (p_request_id IN NUMBER)
106 RETURN VARCHAR2;
107
108
109 PROCEDURE store_payments(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_ppd_request_id IN NUMBER,
116 p_ppd_khr_id IN NUMBER,
117 p_payment_structure IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
118 x_cfo_id OUT NOCOPY NUMBER);
119
120 PROCEDURE store_principal_payments(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_ppd_request_id IN NUMBER,
127 p_ppd_khr_id IN NUMBER,
128 p_payment_structure IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
129 x_cfo_id OUT NOCOPY NUMBER);
130
131
132 PROCEDURE store_esg_payments(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_ppd_request_id IN NUMBER,
139 p_ppd_khr_id IN NUMBER,
140 p_payment_tbl IN payment_tbl_type);
141
142 PROCEDURE store_stm_payments(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_ppd_request_id IN NUMBER,
149 p_ppd_khr_id IN NUMBER,
150 p_payment_tbl IN payment_tbl_type,
151 x_cfo_id OUT NOCOPY NUMBER);
152
153
154 PROCEDURE process_ppd(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_ppd_request_id IN NUMBER);
161
162 --This will be called from WF
163 PROCEDURE invoice_bill_apply(
164 p_api_version IN NUMBER
165 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_msg_count OUT NOCOPY NUMBER
168 ,x_msg_data OUT NOCOPY VARCHAR2
169 ,p_khr_id IN NUMBER
170 ,p_req_id IN NUMBER);
171
172 --rkuttiya added for 11i OKL.H Variable Rate
173 PROCEDURE process_lpd(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_ppd_request_id IN NUMBER) ;
180
181 END OKL_CS_PRINCIPAL_PAYDOWN_PVT;