[Home] [Help]
PACKAGE: APPS.OKL_SEC_AGREEMENT_PVT
Source
1 PACKAGE OKL_SEC_AGREEMENT_PVT AS
2 /* $Header: OKLRSZAS.pls 120.4 2008/01/04 13:04:15 sosharma noship $ */
3 ----------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ----------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_AGREEMENT_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8
9 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12 G_EXCEPTION_ERROR EXCEPTION;
13 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18
19 ----------------------------------------------------------------------------
20 -- Data Structures
21 ----------------------------------------------------------------------------
22
23 TYPE secAgreement_rec_type IS RECORD (
24 ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM --NUMBER
25 ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(120)
26 ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := OKL_API.G_MISS_NUM--NUMBER
27 ,POL_ID OKL_POOLS.ID%TYPE := OKL_API.G_MISS_NUM --NUMBER
28 ,SHORT_DESCRIPTION OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(600)
29 ,START_DATE OKC_K_HEADERS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE --DATE
30 ,END_DATE OKC_K_HEADERS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE --DATE
31 ,DATE_APPROVED OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKL_API.G_MISS_DATE --DATE
32 ,SECURITIZATION_TYPE OKL_K_HEADERS.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
33 ,LESSOR_SERV_ORG_CODE OKL_K_HEADERS.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
34 ,RECOURSE_CODE OKL_K_HEADERS.RECOURSE_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
35 -- defualt to 'NEW'
36 ,STS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
37 -- default currency code from okl_pools.currency_code
38 ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(15)
39 ,CURRENCY_CONVERSION_TYPE OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
40 ,CURRENCY_CONVERSION_RATE OKL_K_HEADERS.CURRENCY_CONVERSION_RATE%TYPE := OKL_API.G_MISS_NUM--NUMBER
41 ,CURRENCY_CONVERSION_DATE OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE--DATE
42 ,trustee_party_roles_id okc_k_party_roles_b.id%type := OKL_API.G_MISS_NUM -- NUMBER
43 ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44 ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45 ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46 -- akjain,v115.6
47 ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48 -- arajagop Begin added for Flexfield Support
49 ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50 ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51 ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52 ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53 ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54 ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55 ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56 ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57 ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58 ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59 ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60 ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61 ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62 ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63 ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64 ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
65 -- arajagop End added for Flexfield Support
66 --added abhsaxen for Legal Entity Uptake
67 ,legal_entity_id OKL_K_HEADERS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
68 );
69
70 TYPE secAgreement_tbl_type IS TABLE OF secAgreement_rec_type
71 INDEX BY BINARY_INTEGER;
72
73 ----------------------------------------------------------------------------
74 -- Global Exception
75 ----------------------------------------------------------------------------
76 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
77
78 ----------------------------------------------------------------------------
79 -- Procedures and Functions
80 ------------------------------------------------------------------------------
81 ----------------------------------------------------------------------------------
82 -- Start of comments
83 --
84 -- Procedure Name : create_sec_agreement
85 -- Description : creates a securitization agreement
86 -- Business Rules :
87 -- Parameters :
88 -- Version : 1.0
89 -- End of comments
90 ----------------------------------------------------------------------------------
91 PROCEDURE create_sec_agreement(
92 p_api_version IN NUMBER
93 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 ,p_secAgreement_rec IN secAgreement_rec_type
98 ,x_secAgreement_rec OUT NOCOPY secAgreement_rec_type);
99
100 ----------------------------------------------------------------------------------
101 -- Start of comments
102 --
103 -- Procedure Name : update_sec_agreement
104 -- Description : updates a securitization agreement
105 -- Business Rules :
106 -- Parameters :
107 -- Version : 1.0
108 -- End of comments
109 ----------------------------------------------------------------------------------
110 PROCEDURE update_sec_agreement(
111 p_api_version IN NUMBER
112 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 ,x_msg_data OUT NOCOPY VARCHAR2
116 ,p_secAgreement_rec IN secAgreement_rec_type
117 ,x_secAgreement_rec OUT NOCOPY secAgreement_rec_type);
118
119 ----------------------------------------------------------------------------------
120 -- Start of comments
121 --
122 -- Procedure Name : activate_sec_agreement
123 -- Description : activate a securitization agreement
124 -- Business Rules :
125 -- Parameters :
126 -- Version : 1.0
127 -- End of comments
128 ----------------------------------------------------------------------------------
129 PROCEDURE activate_sec_agreement(
130 p_api_version IN NUMBER
131 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE);
136
137 ----------------------------------------------------------------------------------
138 -- Start of comments
139 --
140 -- Procedure Name : update_sec_agreement_sts
141 -- Description : updates a securitization agreement header, all lines status,
142 -- and pool header status
143 -- Business Rules :
144 -- Parameters :
145 -- Version : 1.0
146 -- End of comments
147 ----------------------------------------------------------------------------------
148 PROCEDURE update_sec_agreement_sts(
149 p_api_version IN NUMBER
150 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
151 ,x_return_status OUT NOCOPY VARCHAR2
152 ,x_msg_count OUT NOCOPY NUMBER
153 ,x_msg_data OUT NOCOPY VARCHAR2
154 ,p_sec_agreement_status IN okc_k_headers_b.sts_code%TYPE
155 ,p_sec_agreement_id IN okc_k_headers_b.id%TYPE)
156 ;
157
158 --Added by kthiruva on 18-Dec-2007
159 -- New method to validate an add request on an active investor agreement
160 --Bug 6691554 - Start of Changes
161 Procedure validate_add_request(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_chr_id IN NUMBER);
168
169 Procedure activate_add_request (
170 p_api_version IN NUMBER
171 ,p_init_msg_list IN VARCHAR2
172 ,x_return_status OUT NOCOPY VARCHAR2
173 ,x_msg_count OUT NOCOPY NUMBER
174 ,x_msg_data OUT NOCOPY VARCHAR2
175 ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE);
176
177 -- Bug 6691554 - End of Changes
178
179 /*
180 19-Dec-2007, ankushar Bug# 6691554
181 start changes, added new method to invoke Worklow Approval for the Add Contract Request
182 */
183 --------------------------------------------------------------------------------------------------
184 ----------------------------------Rasing Business Event ----------------------------------------
185 ------------------------------------------------------------------------------------------------
186 -------------------------------------------------------------------------------------------------
187 -- PROCEDURE submit_add_khr_request
188 ---------------------------------------------------------------------------
189 -- Start of comments
190 --
191 -- Procedure Name : submit_add_khr_request
192 -- Description :
193 -- Business Rules : Submit the Add Contracts Request for Approval.
194 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
195 -- x_msg_data, p_agreement_id, p_pool_id, x_pool_trx_status.
196 -- Version : 1.0
197 -- End of comments
198 ---------------------------------------------------------------------------
199 PROCEDURE submit_add_khr_request (p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_agreement_id IN OKC_K_HEADERS_V.ID%TYPE,
205 p_pool_id IN OKL_POOLS.ID%TYPE,
206 x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE);
207 /*
208 19-Dec-2007, ankushar Bug# 6691554
209 end changes
210 */
211 /* sosharma 03-01-2008
212 Added procedure to cancel the add request on active Investor Agreement
213 Start changes*/
214
215
216 Procedure cancel_add_request (
217 p_api_version IN NUMBER
218 ,p_init_msg_list IN VARCHAR2
219 ,x_return_status OUT NOCOPY VARCHAR2
220 ,x_msg_count OUT NOCOPY NUMBER
221 ,x_msg_data OUT NOCOPY VARCHAR2
222 ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE);
223
224 /* sosharma end changes */
225
226
227 END OKL_SEC_AGREEMENT_PVT;