[Home] [Help]
PACKAGE: APPS.OKL_CREATE_STREAMS_PUB
Source
1 PACKAGE Okl_Create_Streams_Pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPCSMS.pls 115.13 2003/10/30 21:37:00 smahapat noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
8 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
9
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_CREATE_STREAMS_PUB';
12
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16
17
18 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
19 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
20 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
21 G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
22 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25
26
27 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
28 G_EXCEPTION_ERROR EXCEPTION;
29 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30
31 G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_BOOKING;
32 G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33 G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34 -- mvasudev , sno, changed "QUOT" to "QUOTE"
35 G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36 G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37 G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38
39 G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40 G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41 G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42 G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43 G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44 G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45 G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46 G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47
48 G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49 G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50 G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51 G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52 G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53 G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54 G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55 G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56 G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57 G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58 G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59 G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
60 G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
61
62
63 SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
64 SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
65 SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66 SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67 SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68 SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69 SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70
71 SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
72 SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
73 SUBTYPE csm_loan_level_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_level_tbl_type;
74
75 PROCEDURE Create_Streams_Lease_Book(
76 p_api_version IN NUMBER
77 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
78 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
79 ,p_csm_lease_header IN csm_lease_rec_type
80 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
81 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
82 ,p_csm_yields_tbl IN csm_yields_tbl_type
83 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
84 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
85 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
86 ,x_trans_id OUT NOCOPY NUMBER
87 ,x_trans_status OUT NOCOPY VARCHAR2
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93
94 PROCEDURE Create_Streams_Loan_Book(
95 p_api_version IN NUMBER
96 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
97 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
98 ,p_csm_loan_header IN csm_loan_rec_type
99 ,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
100 ,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
101 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
102 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
103 ,p_csm_yields_tbl IN csm_yields_tbl_type
104 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
105 ,x_trans_id OUT NOCOPY NUMBER
106 ,x_trans_status OUT NOCOPY VARCHAR2
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112
113 PROCEDURE invoke_pricing_engine(
114 p_api_version IN NUMBER
115 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
116 ,p_sifv_rec IN sifv_rec_type
117 ,x_sifv_rec OUT NOCOPY sifv_rec_type
118 ,x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 -- 04/30/2002
124 -- Procedure to Create Streams for Lease Type Contract - Restructure
125 PROCEDURE Create_Streams_Lease_Restr (
126 p_api_version IN NUMBER
127 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
128 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
129 ,p_csm_lease_header IN csm_lease_rec_type
130 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
131 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
132 ,p_csm_yields_tbl IN csm_yields_tbl_type
133 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
134 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
135 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
136 ,x_trans_id OUT NOCOPY NUMBER
137 ,x_trans_status OUT NOCOPY VARCHAR2
138 ,x_return_status OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140 ,x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143 -- Procedure to Create Streams for Loan Type Contract
144 PROCEDURE Create_Streams_Loan_Restr (
145 p_api_version IN NUMBER
146 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
147 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
148 ,p_csm_loan_header IN csm_loan_rec_type
149 ,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
150 ,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
151 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
152 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
153 ,p_csm_yields_tbl IN csm_yields_tbl_type
154 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
155 ,x_trans_id OUT NOCOPY NUMBER
156 ,x_trans_status OUT NOCOPY VARCHAR2
157 ,x_return_status OUT NOCOPY VARCHAR2
158 ,x_msg_count OUT NOCOPY NUMBER
159 ,x_msg_data OUT NOCOPY VARCHAR2
160 );
161
162 -- end, 04/30/2002
163
164 PROCEDURE Create_Streams_Lease_Quote(
165 p_api_version IN NUMBER
166 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
167 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
168 ,p_csm_lease_header IN csm_lease_rec_type
169 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
170 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
171 ,p_csm_yields_tbl IN csm_yields_tbl_type
172 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
173 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
174 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
175 ,x_trans_id OUT NOCOPY NUMBER
176 ,x_trans_status OUT NOCOPY VARCHAR2
177 ,x_return_status OUT NOCOPY VARCHAR2
178 ,x_msg_count OUT NOCOPY NUMBER
179 ,x_msg_data OUT NOCOPY VARCHAR2);
180
181
182 END Okl_Create_Streams_Pub;