[Home] [Help]
PACKAGE: APPS.OKL_STRM_GEN_TEMPLATE_PVT
Source
1 Package okl_strm_gen_template_pvt AUTHID CURRENT_USER as
2 /* $Header: OKLRTSGS.pls 120.6 2005/11/15 11:50:36 rgooty noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
7 G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
8 G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
9 G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
10 G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
11 G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
15
16 G_OKL_ST_STRM_ONE_PRI_PURPOSE CONSTANT VARCHAR2(30) := 'OKL_ST_STRM_ONE_PRI_PURPOSE';
17 G_OKL_ST_MANDATORY_PRI_PURPOSE CONSTANT VARCHAR2(30) := 'OKL_ST_MANDATORY_PRI_PURPOSE';
18 G_OKL_ST_ALL_INS_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_ST_ALL_INS_PURPOSES';
19 G_OKL_ST_MANDATORY_DEP_PURPOSE CONSTANT VARCHAR2(30) := 'OKL_ST_MANDATORY_DEP_PURPOSE';
20 G_OKL_ST_UNIQUE_DEP_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_ST_UNIQUE_DEP_PURPOSES';
21 G_OKL_ST_INVALID_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_ST_INVALID_PURPOSES';
22 G_OKL_STRM_BILL_FLAG_YN CONSTANT VARCHAR2(30) := 'OKL_STRM_BILL_FLAG_YN';
23 G_OKL_IC_RR_PRC_ENG_EXT CONSTANT VARCHAR2(30) := 'OKL_IC_RR_PRC_ENG_EXT';
24 G_OKL_IC_RR_METH_FOR_LS CONSTANT VARCHAR2(30) := 'OKL_IC_RR_METH_FOR_LS';
25 G_OKL_DAY_CONVEN_VAL_EXT CONSTANT VARCHAR2(30) := 'OKL_DAY_CONVEN_VAL_EXT';
26 G_OKL_DAY_CONVEN_VAL_INT CONSTANT VARCHAR2(30) := 'OKL_DAY_CONVEN_VAL_INT';
27
28
29 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
30
31 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PVT';
33
34 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
36 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
37 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
38 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
39
40 G_OKL_INV_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_INV_PRIMARY_PURPOSES';
41 G_OKL_FIN_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_FIN_PRIMARY_PURPOSES';
42 G_OKL_FIN_DEPENDENT_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_FIN_DEPENDENT_PURPOSES';
43 G_OKL_STREAM_TYPE_PURPOSE CONSTANT VARCHAR2(30) := 'OKL_STREAM_TYPE_PURPOSE';
44 G_OKL_STREAM_ALL_BOOK_CLASS CONSTANT VARCHAR2(30) := 'OKL_STREAM_ALL_BOOK_CLASS';
45
46 G_INVESTOR_PRODUCT CONSTANT VARCHAR2(30) := 'INVESTOR';
47 G_STATUS_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
48 G_STATUS_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
49 G_STATUS_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
50 G_LEASEDF_DEAL_TYPE CONSTANT VARCHAR2(30) := 'LEASEDF';
51 G_LEASEST_DEAL_TYPE CONSTANT VARCHAR2(30) := 'LEASEST';
52 G_LEASEOP_DEAL_TYPE CONSTANT VARCHAR2(30) := 'LEASEOP';
53 G_LOAN_DEAL_TYPE CONSTANT VARCHAR2(30) := 'LOAN';
54 G_LOAN_REV_DEAL_TYPE CONSTANT VARCHAR2(30) := 'LOAN-REVOLVING';
55
56 G_INIT_VERSION CONSTANT NUMBER := 1.0;
57 G_INIT_TMPT_STATUS CONSTANT VARCHAR2(100) := 'NEW';
58 G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
59 G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
60 G_INIT_PRIMARY_YN_YES CONSTANT VARCHAR2(1) := 'Y';
61 G_INIT_PRIMARY_YN_NO CONSTANT VARCHAR2(1) := 'N';
62 G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
63
64
65 G_PURPOSE_TOKEN CONSTANT VARCHAR2(10) := 'PURPOSE';
66 G_DEP_PURPOSE_TOKEN CONSTANT VARCHAR2(10) := 'DEPPURPOSE';
67 G_DEAL_TYPE_TOKEN CONSTANT VARCHAR2(10) := 'DEAL_TYPE';
68 G_TYPE_ERROR CONSTANT VARCHAR2(12) := 'E';
69 G_TYPE_WARNING CONSTANT VARCHAR2(12) := 'W';
70 G_CP_SET_OUTCOME CONSTANT VARCHAR2(30) := 'CP_SET_OUTCOME';
71
72 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
73 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
74 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
75 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
76 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
77
78 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
79 G_EXCEPTION_ERROR EXCEPTION;
80 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
81
82 -- Stream Generation Template Set
83 SUBTYPE gttv_rec_type IS okl_gtt_pvt.gttv_rec_type;
84 SUBTYPE gttv_tbl_type IS okl_gtt_pvt.gttv_tbl_type;
85
86 -- Stream Generation Template
87 SUBTYPE gtsv_rec_type IS okl_gts_pvt.gtsv_rec_type;
88 SUBTYPE gtsv_tbl_type IS okl_gts_pvt.gtsv_tbl_type;
89
90 -- Stream Generation Template Pricing Parameters
91 SUBTYPE gtpv_rec_type IS okl_gtp_pvt.gtpv_rec_type;
92 SUBTYPE gtpv_tbl_type IS okl_gtp_pvt.gtpv_tbl_type;
93
94 -- Stream Generation Template Stream Types
95 SUBTYPE gtlv_rec_type IS okl_gtl_pvt.gtlv_rec_type;
96 SUBTYPE gtlv_tbl_type IS okl_gtl_pvt.gtlv_tbl_type;
97
98 TYPE error_msg_rec IS RECORD (
99 error_message VARCHAR2(2500) DEFAULT OKL_API.G_MISS_CHAR
100 ,error_type_code VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
101 ,error_type_meaning VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
102 );
103 TYPE error_msgs_tbl_type IS TABLE OF error_msg_rec
104 INDEX BY BINARY_INTEGER;
105
106 Procedure create_strm_gen_template(
107 p_api_version IN NUMBER
108 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
109 ,x_return_status OUT NOCOPY VARCHAR2
110 ,x_msg_count OUT NOCOPY NUMBER
111 ,x_msg_data OUT NOCOPY VARCHAR2
112 ,p_gtsv_rec IN gtsv_rec_type
113 ,p_gttv_rec IN gttv_rec_type
114 ,p_gtpv_tbl IN gtpv_tbl_type
115 ,p_gtlv_tbl IN gtlv_tbl_type
116 ,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
117 );
118
119 Procedure update_strm_gen_template(
120 p_api_version IN NUMBER
121 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_msg_count OUT NOCOPY NUMBER
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 ,p_gtsv_rec IN gtsv_rec_type
126 ,p_gttv_rec IN gttv_rec_type
127 ,p_gtpv_tbl IN gtpv_tbl_type
128 ,p_gtlv_tbl IN gtlv_tbl_type
129 ,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
130 );
131
132 Procedure update_dep_strms(
133 p_api_version IN NUMBER
134 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_gtt_id IN OKL_ST_GEN_TEMPLATES.ID%type
139 ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
140 ,p_gtlv_tbl IN gtlv_tbl_type
141 ,x_missing_deps OUT NOCOPY VARCHAR2
142 ,x_show_warn_flag OUT NOCOPY VARCHAR2
143 );
144
145 Procedure create_version_duplicate(
146 p_api_version IN NUMBER
147 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
148 ,x_return_status OUT NOCOPY VARCHAR2
149 ,x_msg_count OUT NOCOPY NUMBER
150 ,x_msg_data OUT NOCOPY VARCHAR2
151 ,p_gtt_id IN okl_st_gen_templates.id%type
152 ,p_mode IN VARCHAR2 DEFAULT G_DEFAULT_MODE
153 ,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
154 );
155
156 Procedure delete_tmpt_prc_params(
157 p_api_version IN NUMBER
158 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_count OUT NOCOPY NUMBER
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 ,p_gtpv_tbl IN gtpv_tbl_type
163 );
164
165 Procedure delete_pri_tmpt_lns(
166 p_api_version IN NUMBER
167 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
168 ,x_return_status OUT NOCOPY VARCHAR2
169 ,x_msg_count OUT NOCOPY NUMBER
170 ,x_msg_data OUT NOCOPY VARCHAR2
171 ,p_gtlv_tbl IN gtlv_tbl_type
172 );
173 Procedure delete_dep_tmpt_lns(
174 p_api_version IN NUMBER
175 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_gtlv_tbl IN gtlv_tbl_type
180 );
181
182 Procedure validate_template(
183 p_api_version IN NUMBER
184 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
185 ,x_return_status OUT NOCOPY VARCHAR2
186 ,x_msg_count OUT NOCOPY NUMBER
187 ,x_msg_data OUT NOCOPY VARCHAR2
188 ,p_gtt_id IN okl_st_gen_templates.id%type
189 ,x_error_msgs_tbl OUT NOCOPY error_msgs_tbl_type
190 ,x_return_tmpt_status OUT NOCOPY VARCHAR2
191 ,p_during_upd_flag IN VARCHAR2
192 );
193
194 Procedure activate_template(
195 p_api_version IN NUMBER
196 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
197 ,x_return_status OUT NOCOPY VARCHAR2
198 ,x_msg_count OUT NOCOPY NUMBER
199 ,x_msg_data OUT NOCOPY VARCHAR2
200 ,p_gtt_id IN okl_st_gen_templates.id%type
201 );
202
203 Procedure validate_for_warnings(
204 p_api_version IN NUMBER
205 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_count OUT NOCOPY NUMBER
208 ,x_msg_data OUT NOCOPY VARCHAR2
209 ,p_gtt_id IN okl_st_gen_templates.id%type
210 ,x_wrn_msgs_tbl OUT NOCOPY error_msgs_tbl_type
211 ,p_during_upd_flag IN VARCHAR
212 ,x_pri_purpose_list OUT NOCOPY VARCHAR
213 );
214
215 PROCEDURE update_pri_dep_of_sgt(
216 p_api_version IN NUMBER
217 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
218 ,x_return_status OUT NOCOPY VARCHAR2
219 ,x_msg_count OUT NOCOPY NUMBER
220 ,x_msg_data OUT NOCOPY VARCHAR2
221 ,p_gtsv_rec IN gtsv_rec_type
222 ,p_gttv_rec IN gttv_rec_type
223 ,p_gtpv_tbl IN gtpv_tbl_type
224 ,p_pri_gtlv_tbl IN gtlv_tbl_type
225 ,p_del_dep_gtlv_tbl IN gtlv_tbl_type
226 ,p_ins_dep_gtlv_tbl IN gtlv_tbl_type
227 ,x_gttv_rec OUT NOCOPY gttv_rec_type
228 ,x_pri_purpose_list OUT NOCOPY VARCHAR2);
229
230 End okl_strm_gen_template_pvt;