[Home] [Help]
PACKAGE BODY: APPS.OKL_CS_CREATE_QUOTE_PVT
Source
1 PACKAGE BODY OKL_CS_CREATE_QUOTE_PVT AS
2 /* $Header: OKLRCTQB.pls 120.2 2007/12/17 05:04:44 asawanka ship $ */
3
4 G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
5 G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
6 G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7 G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_cs_create_quote_pvt.';
8 --------------------------------------------------------
9 --NOTE: This procedure is a wrapper over OKL_AM_CREATE_QUOTE_PVT
10 --This procedure accepts the parameter as table type and in turn
11 --calls the procedure that accepts the record type API in loop.
12 --For all practical purposes, only one record will be passed in
13 -- the pl/sql table and so the record api is called only once.
14 --------------------------------------------------------
15 PROCEDURE create_terminate_quote(
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_quot_tbl IN quot_tbl_type,
22 p_assn_tbl IN OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type,
23 p_qpyv_tbl IN qpyv_tbl_type DEFAULT G_EMPTY_QPYV_TBL,
24 x_quot_tbl OUT NOCOPY quot_tbl_type,
25 x_tqlv_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.tqlv_tbl_type,
26 x_assn_tbl OUT NOCOPY OKL_AM_CREATE_QUOTE_PUB.assn_tbl_type)AS
27
28 l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
29 i NUMBER := 0;
30 l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
31
32 -- asawanka added for debug feature start
33 l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_terminate_quote';
34 is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
35 is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
36 is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
37 -- asawanka added for debug feature end
38 BEGIN
39 IF (is_debug_procedure_on) THEN
40 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
41 END IF;
42
43 OKC_API.init_msg_list(p_init_msg_list);
44 IF (p_quot_tbl.COUNT > 0) THEN
45 i := p_quot_tbl.FIRST;
46 LOOP
47 IF (is_debug_statement_on) THEN
48 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.create_terminate_quote with parameters: ');
49 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).id : '||p_quot_tbl(i).id );
50 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).qrs_code : '||p_quot_tbl(i).qrs_code );
51 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).qst_code : '||p_quot_tbl(i).qst_code );
52 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).consolidated_qte_id : '||p_quot_tbl(i).consolidated_qte_id );
53 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).khr_id : '||p_quot_tbl(i).khr_id );
54 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).art_id : '||p_quot_tbl(i).art_id );
55 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).qtp_code : '||p_quot_tbl(i).qtp_code );
56 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).trn_code : '||p_quot_tbl(i).trn_code );
57 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).pdt_id : '||p_quot_tbl(i).pdt_id );
58 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).date_effective_from : '||p_quot_tbl(i).date_effective_from );
59 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).quote_number : '||p_quot_tbl(i).quote_number );
60 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).early_termination_yn : '||p_quot_tbl(i).early_termination_yn );
61 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).partial_yn : '||p_quot_tbl(i).partial_yn );
62 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).preproceeds_yn : '||p_quot_tbl(i).preproceeds_yn );
63 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).summary_format_yn : '||p_quot_tbl(i).summary_format_yn );
64 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).consolidated_yn : '||p_quot_tbl(i).consolidated_yn );
65 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).date_requested : '||p_quot_tbl(i).date_requested );
66 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).date_proposal : '||p_quot_tbl(i).date_proposal );
67 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).date_effective_to : '||p_quot_tbl(i).date_effective_to );
68 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).date_accepted : '||p_quot_tbl(i).date_accepted );
69 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).payment_received_yn : '||p_quot_tbl(i).payment_received_yn );
70 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).requested_by : '||p_quot_tbl(i).requested_by );
71 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).approved_yn : '||p_quot_tbl(i).approved_yn );
72 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).accepted_yn : '||p_quot_tbl(i).accepted_yn );
73 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).org_id : '||p_quot_tbl(i).org_id );
74 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).purchase_amount : '||p_quot_tbl(i).purchase_amount );
75 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).purchase_formula : '||p_quot_tbl(i).purchase_formula );
76 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).asset_value : '||p_quot_tbl(i).asset_value );
77 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).residual_value : '||p_quot_tbl(i).residual_value );
78 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).unbilled_receivables : '||p_quot_tbl(i).unbilled_receivables );
79 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).gain_loss : '||p_quot_tbl(i).gain_loss );
80 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).PERDIEM_AMOUNT : '||p_quot_tbl(i).PERDIEM_AMOUNT );
81 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).currency_code : '||p_quot_tbl(i).currency_code );
82 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).currency_conversion_code : '||p_quot_tbl(i).currency_conversion_code );
83 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).legal_entity_id : '||p_quot_tbl(i).legal_entity_id );
84 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_quot_tbl(i).repo_quote_indicator_yn : '||p_quot_tbl(i).repo_quote_indicator_yn );
85
86 IF (p_assn_tbl.COUNT > 0) THEN
87 FOR l IN p_assn_tbl.FIRST..p_assn_tbl.LAST LOOP
88 IF p_assn_tbl.exists(l) THEN
89 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_assn_tbl('||l||').'||'p_asset_id :'|| p_assn_tbl(l).p_asset_id );
90 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_assn_tbl('||l||').'||'p_asset_number :'|| p_assn_tbl(l).p_asset_number );
91 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_assn_tbl('||l||').'||'p_asset_qty :'|| p_assn_tbl(l).p_asset_qty );
92 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_assn_tbl('||l||').'||'p_quote_qty :'|| p_assn_tbl(l).p_quote_qty );
93 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_assn_tbl('||l||').'||'p_split_asset_number :'|| p_assn_tbl(l).p_split_asset_number);
94 END IF;
95 End loop;
96 END IF;
97 IF (p_qpyv_tbl.COUNT > 0) THEN
98 FOR l IN p_qpyv_tbl.FIRST..p_qpyv_tbl.LAST LOOP
99 IF p_qpyv_tbl.exists(l) THEN
100 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).id = ' || p_qpyv_tbl(l).id );
101 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).qte_id = ' || p_qpyv_tbl(l).qte_id );
102 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).cpl_id = ' || p_qpyv_tbl(l).cpl_id );
103 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).object_version_number = ' || p_qpyv_tbl(l).object_version_number );
104 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).date_sent = ' || p_qpyv_tbl(l).date_sent );
105 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).created_by = ' || p_qpyv_tbl(l).created_by );
106 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).creation_date = ' || p_qpyv_tbl(l).creation_date );
107 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).last_updated_by = ' || p_qpyv_tbl(l).last_updated_by );
108 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).last_update_date = ' || p_qpyv_tbl(l).last_update_date );
109 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).last_update_login = ' || p_qpyv_tbl(l).last_update_login );
110 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).qpt_code = ' || p_qpyv_tbl(l).qpt_code );
111 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).delay_days = ' || p_qpyv_tbl(l).delay_days );
112 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).allocation_percentage = ' || p_qpyv_tbl(l).allocation_percentage );
113 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).email_address = ' || p_qpyv_tbl(l).email_address );
114 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).party_jtot_object1_code = ' || p_qpyv_tbl(l).party_jtot_object1_code );
115 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).party_object1_id1 = ' || p_qpyv_tbl(l).party_object1_id1 );
116 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).party_object1_id2 = ' || p_qpyv_tbl(l).party_object1_id2 );
117 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).contact_jtot_object1_code = ' || p_qpyv_tbl(l).contact_jtot_object1_code );
118 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).contact_object1_id1 = ' || p_qpyv_tbl(l).contact_object1_id1 );
119 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qpyv_tbl(l).contact_object1_id2 = ' || p_qpyv_tbl(l).contact_object1_id2 );
120
121 END IF;
122 End loop;
123
124 END IF;
125 END IF;
126 okl_am_create_quote_pub.create_terminate_quote(
127 p_api_version => p_api_version,
128 p_init_msg_list => FND_API.G_FALSE,
129 x_return_status => x_return_status,
130 x_msg_count => x_msg_count,
131 x_msg_data => x_msg_data,
132 p_quot_rec => p_quot_tbl(i),
133 p_assn_tbl => p_assn_tbl,
134 p_qpyv_tbl => p_qpyv_tbl,
135 x_quot_rec => x_quot_tbl(i),
136 x_tqlv_tbl => x_tqlv_tbl,
137 x_assn_tbl => x_assn_tbl);
138 IF (is_debug_statement_on) THEN
139 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.create_terminate_quote , return status: ' || x_return_status);
140 END IF;
141
142 IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
143 IF (is_debug_exception_on) THEN
144 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
145 END IF;
146 IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
147 l_overall_status := x_return_status;
148 END IF;
149 END IF;
150 EXIT WHEN (i = p_quot_tbl.LAST);
151 i := p_quot_tbl.NEXT(i);
152 END LOOP;
153 x_return_status := l_overall_status;
154 END IF;
155 IF (is_debug_procedure_on) THEN
156 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
157 END IF;
158 END create_terminate_quote;
159
160
161 PROCEDURE fetch_rule_quote_parties (
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2,
167 p_qtev_tbl IN quot_tbl_type,
168 x_qpyv_tbl OUT NOCOPY okl_quote_parties_pub.qpyv_tbl_type,
169 x_q_party_uv_tbl OUT NOCOPY okl_am_parties_pvt.q_party_uv_tbl_type,
170 x_record_count OUT NOCOPY NUMBER)
171 IS
172 i NUMBER := 0;
173 l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
174 -- asawanka added for debug feature start
175 l_module_name VARCHAR2(500) := G_MODULE_NAME || 'fetch_rule_quote_parties';
176 is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
177 is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
178 is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
179 -- asawanka added for debug feature end
180 BEGIN
181 IF (is_debug_procedure_on) THEN
182 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
183 END IF;
184 OKC_API.init_msg_list(p_init_msg_list);
185 IF (p_qtev_tbl.COUNT > 0) THEN
186 i := p_qtev_tbl.FIRST;
187 LOOP
188 IF (is_debug_statement_on) THEN
189 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.fetch_rule_quote_parties with parameters: ');
190 IF p_qtev_tbl.count > 0 THEN
191 FOR k IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
192 IF p_qtev_tbl.exists(k) THEN
193 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).id = ' || p_qtev_tbl(k).id );
194 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).qrs_code = ' || p_qtev_tbl(k).qrs_code );
195 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).qst_code = ' || p_qtev_tbl(k).qst_code );
196 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).consolidated_qte_id = ' || p_qtev_tbl(k).consolidated_qte_id );
197 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).khr_id = ' || p_qtev_tbl(k).khr_id );
198 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).art_id = ' || p_qtev_tbl(k).art_id );
199 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).qtp_code = ' || p_qtev_tbl(k).qtp_code );
200 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).trn_code = ' || p_qtev_tbl(k).trn_code );
201 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).pop_code_end = ' || p_qtev_tbl(k).pop_code_end );
202 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).pop_code_early = ' || p_qtev_tbl(k).pop_code_early );
203 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).pdt_id = ' || p_qtev_tbl(k).pdt_id );
204 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_effective_from = ' || p_qtev_tbl(k).date_effective_from );
205 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).quote_number = ' || p_qtev_tbl(k).quote_number );
206 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).object_version_number = ' || p_qtev_tbl(k).object_version_number );
207 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).purchase_percent = ' || p_qtev_tbl(k).purchase_percent );
208 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).term = ' || p_qtev_tbl(k).term );
209 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_restructure_start = ' || p_qtev_tbl(k).date_restructure_start );
210 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_due = ' || p_qtev_tbl(k).date_due );
211 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_approved = ' || p_qtev_tbl(k).date_approved );
212 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_restructure_end = ' || p_qtev_tbl(k).date_restructure_end );
213 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).remaining_payments = ' || p_qtev_tbl(k).remaining_payments );
214 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).rent_amount = ' || p_qtev_tbl(k).rent_amount );
215 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).yield = ' || p_qtev_tbl(k).yield );
216 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).residual_amount = ' || p_qtev_tbl(k).residual_amount );
217 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).principal_paydown_amount = ' || p_qtev_tbl(k).principal_paydown_amount );
218 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_frequency = ' || p_qtev_tbl(k).payment_frequency );
219 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).early_termination_yn = ' || p_qtev_tbl(k).early_termination_yn );
220 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).partial_yn = ' || p_qtev_tbl(k).partial_yn );
221 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).preproceeds_yn = ' || p_qtev_tbl(k).preproceeds_yn );
222 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).summary_format_yn = ' || p_qtev_tbl(k).summary_format_yn );
223 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).consolidated_yn = ' || p_qtev_tbl(k).consolidated_yn );
224 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_requested = ' || p_qtev_tbl(k).date_requested );
225 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_proposal = ' || p_qtev_tbl(k).date_proposal );
226 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_effective_to = ' || p_qtev_tbl(k).date_effective_to );
227 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_accepted = ' || p_qtev_tbl(k).date_accepted );
228 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_received_yn = ' || p_qtev_tbl(k).payment_received_yn );
229 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).requested_by = ' || p_qtev_tbl(k).requested_by );
230 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_yn = ' || p_qtev_tbl(k).approved_yn );
231 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).accepted_yn = ' || p_qtev_tbl(k).accepted_yn );
232 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_payment_received = ' || p_qtev_tbl(k).date_payment_received );
233 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_by = ' || p_qtev_tbl(k).approved_by );
234 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).org_id = ' || p_qtev_tbl(k).org_id );
235 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).request_id = ' || p_qtev_tbl(k).request_id );
236 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_application_id = ' || p_qtev_tbl(k).program_application_id );
237 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_id = ' || p_qtev_tbl(k).program_id );
238 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_update_date = ' || p_qtev_tbl(k).program_update_date );
239 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute_category = ' || p_qtev_tbl(k).attribute_category );
240 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute1 = ' || p_qtev_tbl(k).attribute1 );
241 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute2 = ' || p_qtev_tbl(k).attribute2 );
242 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute3 = ' || p_qtev_tbl(k).attribute3 );
243 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute4 = ' || p_qtev_tbl(k).attribute4 );
244 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute5 = ' || p_qtev_tbl(k).attribute5 );
245 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute6 = ' || p_qtev_tbl(k).attribute6 );
246 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute7 = ' || p_qtev_tbl(k).attribute7 );
247 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute8 = ' || p_qtev_tbl(k).attribute8 );
248 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute9 = ' || p_qtev_tbl(k).attribute9 );
249 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute10 = ' || p_qtev_tbl(k).attribute10 );
250 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute11 = ' || p_qtev_tbl(k).attribute11 );
251 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute12 = ' || p_qtev_tbl(k).attribute12 );
252 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute13 = ' || p_qtev_tbl(k).attribute13 );
253 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute14 = ' || p_qtev_tbl(k).attribute14 );
254 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute15 = ' || p_qtev_tbl(k).attribute15 );
255 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).created_by = ' || p_qtev_tbl(k).created_by );
256 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).creation_date = ' || p_qtev_tbl(k).creation_date );
257 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_updated_by = ' || p_qtev_tbl(k).last_updated_by );
258 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_update_date = ' || p_qtev_tbl(k).last_update_date );
259 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_restructure_end = ' || p_qtev_tbl(k).date_restructure_end );
260 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).remaining_payments = ' || p_qtev_tbl(k).remaining_payments );
261 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).rent_amount = ' || p_qtev_tbl(k).rent_amount );
262 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).yield = ' || p_qtev_tbl(k).yield );
263 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).residual_amount = ' || p_qtev_tbl(k).residual_amount );
264 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).principal_paydown_amount = ' || p_qtev_tbl(k).principal_paydown_amount );
265 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_frequency = ' || p_qtev_tbl(k).payment_frequency );
266 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).early_termination_yn = ' || p_qtev_tbl(k).early_termination_yn );
267 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).partial_yn = ' || p_qtev_tbl(k).partial_yn );
268 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).preproceeds_yn = ' || p_qtev_tbl(k).preproceeds_yn );
269 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).summary_format_yn = ' || p_qtev_tbl(k).summary_format_yn );
270 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).consolidated_yn = ' || p_qtev_tbl(k).consolidated_yn );
271 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_requested = ' || p_qtev_tbl(k).date_requested );
272 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_proposal = ' || p_qtev_tbl(k).date_proposal );
273 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_effective_to = ' || p_qtev_tbl(k).date_effective_to );
274 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_accepted = ' || p_qtev_tbl(k).date_accepted );
275 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_received_yn = ' || p_qtev_tbl(k).payment_received_yn );
276 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).requested_by = ' || p_qtev_tbl(k).requested_by );
277 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_yn = ' || p_qtev_tbl(k).approved_yn );
278 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).accepted_yn = ' || p_qtev_tbl(k).accepted_yn );
279 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_payment_received = ' || p_qtev_tbl(k).date_payment_received );
280 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_by = ' || p_qtev_tbl(k).approved_by );
281 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).org_id = ' || p_qtev_tbl(k).org_id );
282 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).request_id = ' || p_qtev_tbl(k).request_id );
283 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_application_id = ' || p_qtev_tbl(k).program_application_id );
284 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_id = ' || p_qtev_tbl(k).program_id );
285 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_update_date = ' || p_qtev_tbl(k).program_update_date );
286 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute_category = ' || p_qtev_tbl(k).attribute_category );
287 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute1 = ' || p_qtev_tbl(k).attribute1 );
288 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute2 = ' || p_qtev_tbl(k).attribute2 );
289 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute3 = ' || p_qtev_tbl(k).attribute3 );
290 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute4 = ' || p_qtev_tbl(k).attribute4 );
291 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute5 = ' || p_qtev_tbl(k).attribute5 );
292 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute6 = ' || p_qtev_tbl(k).attribute6 );
293 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute7 = ' || p_qtev_tbl(k).attribute7 );
294 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute8 = ' || p_qtev_tbl(k).attribute8 );
295 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute9 = ' || p_qtev_tbl(k).attribute9 );
296 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute10 = ' || p_qtev_tbl(k).attribute10 );
297 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute11 = ' || p_qtev_tbl(k).attribute11 );
298 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute12 = ' || p_qtev_tbl(k).attribute12 );
299 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute13 = ' || p_qtev_tbl(k).attribute13 );
300 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute14 = ' || p_qtev_tbl(k).attribute14 );
301 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute15 = ' || p_qtev_tbl(k).attribute15 );
302 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).created_by = ' || p_qtev_tbl(k).created_by );
303 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).creation_date = ' || p_qtev_tbl(k).creation_date );
304 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_updated_by = ' || p_qtev_tbl(k).last_updated_by );
305 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_update_date = ' || p_qtev_tbl(k).last_update_date );
306 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_update_login = ' || p_qtev_tbl(k).last_update_login );
307 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).purchase_amount = ' || p_qtev_tbl(k).purchase_amount );
308 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).purchase_formula = ' || p_qtev_tbl(k).purchase_formula );
309 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).asset_value = ' || p_qtev_tbl(k).asset_value );
310 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).residual_value = ' || p_qtev_tbl(k).residual_value );
311 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).unbilled_receivables = ' || p_qtev_tbl(k).unbilled_receivables );
312 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).gain_loss = ' || p_qtev_tbl(k).gain_loss );
313 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).PERDIEM_AMOUNT = ' || p_qtev_tbl(k).PERDIEM_AMOUNT );
314 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_code = ' || p_qtev_tbl(k).currency_code );
315 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_code = ' || p_qtev_tbl(k).currency_conversion_code );
316 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_type = ' || p_qtev_tbl(k).currency_conversion_type );
317 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_rate = ' || p_qtev_tbl(k).currency_conversion_rate );
318 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_date = ' || p_qtev_tbl(k).currency_conversion_date );
319 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).legal_entity_id = ' || p_qtev_tbl(k).legal_entity_id );
320 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).repo_quote_indicator_yn = ' || p_qtev_tbl(k).repo_quote_indicator_yn );
321
322 END IF;
323 END LOOP;
324 END IF;
325 END IF;
326 okl_am_parties_pvt.fetch_rule_quote_parties (
327 p_api_version => p_api_version,
328 p_init_msg_list => p_init_msg_list,
329 x_msg_count => x_msg_count,
330 x_msg_data => x_msg_data,
331 x_return_status => x_return_status,
332 p_qtev_rec => p_qtev_tbl(i),
333 x_qpyv_tbl => x_qpyv_tbl,
334 x_q_party_uv_tbl => x_q_party_uv_tbl,
335 x_record_count => x_record_count);
336 IF (is_debug_statement_on) THEN
337 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.fetch_rule_quote_parties , return status: ' || x_return_status);
338 END IF;
339 IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
340 IF (is_debug_exception_on) THEN
341 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
342 END IF;
343 IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
344 l_overall_status := x_return_status;
345 END IF;
346 END IF;
347 EXIT WHEN (i = p_qtev_tbl.LAST);
348 i := p_qtev_tbl.NEXT(i);
349 END LOOP;
350
351 x_return_status := l_overall_status;
352 END IF;
353 IF (is_debug_procedure_on) THEN
354 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
355 END IF;
356 END fetch_rule_quote_parties;
357
358 PROCEDURE submit_for_approval(
359 p_api_version IN NUMBER,
360 p_init_msg_list IN VARCHAR2,
361 x_return_status OUT NOCOPY VARCHAR2,
362 x_msg_count OUT NOCOPY NUMBER,
363 x_msg_data OUT NOCOPY VARCHAR2,
364 p_term_tbl IN quot_tbl_type,
365 x_term_tbl OUT NOCOPY quot_tbl_type) AS
366
367 l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
368 i NUMBER := 0;
369 l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
370 -- asawanka added for debug feature start
371 l_module_name VARCHAR2(500) := G_MODULE_NAME || 'submit_for_approval';
372 is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
373 is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
374 is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
375 -- asawanka added for debug feature end
376 BEGIN
377 IF (is_debug_procedure_on) THEN
378 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
379 END IF;
380 OKC_API.init_msg_list(p_init_msg_list);
381 IF (p_term_tbl.COUNT > 0) THEN
382 i := p_term_tbl.FIRST;
383 LOOP
384 IF (is_debug_statement_on) THEN
385 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.submit_for_approval with parameters: ');
386 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).id : '||p_term_tbl(i).id );
387 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).qrs_code : '||p_term_tbl(i).qrs_code );
388 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).qst_code : '||p_term_tbl(i).qst_code );
389 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).consolidated_qte_id : '||p_term_tbl(i).consolidated_qte_id );
390 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).khr_id : '||p_term_tbl(i).khr_id );
391 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).art_id : '||p_term_tbl(i).art_id );
392 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).qtp_code : '||p_term_tbl(i).qtp_code );
393 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).trn_code : '||p_term_tbl(i).trn_code );
394 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).pdt_id : '||p_term_tbl(i).pdt_id );
395 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).date_effective_from : '||p_term_tbl(i).date_effective_from );
396 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).quote_number : '||p_term_tbl(i).quote_number );
397 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).early_termination_yn : '||p_term_tbl(i).early_termination_yn );
398 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).partial_yn : '||p_term_tbl(i).partial_yn );
399 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).preproceeds_yn : '||p_term_tbl(i).preproceeds_yn );
400 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).summary_format_yn : '||p_term_tbl(i).summary_format_yn );
401 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).consolidated_yn : '||p_term_tbl(i).consolidated_yn );
402 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).date_requested : '||p_term_tbl(i).date_requested );
403 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).date_proposal : '||p_term_tbl(i).date_proposal );
404 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).date_effective_to : '||p_term_tbl(i).date_effective_to );
405 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).date_accepted : '||p_term_tbl(i).date_accepted );
406 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).payment_received_yn : '||p_term_tbl(i).payment_received_yn );
407 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).requested_by : '||p_term_tbl(i).requested_by );
408 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).approved_yn : '||p_term_tbl(i).approved_yn );
409 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).accepted_yn : '||p_term_tbl(i).accepted_yn );
410 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).org_id : '||p_term_tbl(i).org_id );
411 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).purchase_amount : '||p_term_tbl(i).purchase_amount );
412 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).purchase_formula : '||p_term_tbl(i).purchase_formula );
413 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).asset_value : '||p_term_tbl(i).asset_value );
414 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).residual_value : '||p_term_tbl(i).residual_value );
415 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).unbilled_receivables : '||p_term_tbl(i).unbilled_receivables );
416 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).gain_loss : '||p_term_tbl(i).gain_loss );
417 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).PERDIEM_AMOUNT : '||p_term_tbl(i).PERDIEM_AMOUNT );
418 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).currency_code : '||p_term_tbl(i).currency_code );
419 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).currency_conversion_code : '||p_term_tbl(i).currency_conversion_code );
420 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).legal_entity_id : '||p_term_tbl(i).legal_entity_id );
421 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_term_tbl(i).repo_quote_indicator_yn : '||p_term_tbl(i).repo_quote_indicator_yn );
422
423 END IF;
424 OKL_AM_TERMNT_QUOTE_PUB.submit_for_approval(
425 p_api_version => p_api_version,
426 p_init_msg_list => FND_API.G_FALSE,
427 x_return_status => x_return_status,
428 x_msg_count => x_msg_count,
429 x_msg_data => x_msg_data,
430 p_term_rec => p_term_tbl(i),
431 x_term_rec => x_term_tbl(i));
432 IF (is_debug_statement_on) THEN
433 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.submit_for_approval , return status: ' || x_return_status);
434 END IF;
435
436 IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
437 IF (is_debug_exception_on) THEN
438 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
439 END IF;
440 IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
441 l_overall_status := x_return_status;
442 END IF;
443 END IF;
444 EXIT WHEN (i = p_term_tbl.LAST);
445 i := p_term_tbl.NEXT(i);
446 END LOOP;
447 x_return_status := l_overall_status;
448 END IF;
449 IF (is_debug_procedure_on) THEN
450 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
451 END IF;
452 END submit_for_approval;
453
454 PROCEDURE send_terminate_quote (
455 p_api_version IN NUMBER,
456 p_init_msg_list IN VARCHAR2,
457 x_return_status OUT NOCOPY VARCHAR2,
458 x_msg_count OUT NOCOPY NUMBER,
459 x_msg_data OUT NOCOPY VARCHAR2,
460 p_party_tbl IN okl_am_parties_pvt.q_party_uv_tbl_type,
461 x_party_tbl OUT NOCOPY okl_am_parties_pvt.q_party_uv_tbl_type,
462 p_qtev_tbl IN quot_tbl_type,
463 x_qtev_tbl OUT NOCOPY quot_tbl_type) as
464
465 l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
466 i NUMBER := 0;
467 l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
468 -- asawanka added for debug feature start
469 l_module_name VARCHAR2(500) := G_MODULE_NAME || 'send_terminate_quote';
470 is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
471 is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
472 is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
473 -- asawanka added for debug feature end
474 BEGIN
475 IF (is_debug_procedure_on) THEN
476 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
477 END IF;
478 OKC_API.init_msg_list(p_init_msg_list);
479 IF (p_qtev_tbl.COUNT > 0) THEN
480 i := p_qtev_tbl.FIRST;
481 LOOP
482 IF (is_debug_statement_on) THEN
483 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Calling okl_am_create_quote_pub.send_terminate_quote with parameters: ');
484 IF p_qtev_tbl.COUNT > 0 THEN
485 FOR k IN p_qtev_tbl.FIRST..p_qtev_tbl.LAST LOOP
486 IF p_qtev_tbl.exists(k) THEN
487 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).id = ' || p_qtev_tbl(k).id );
488 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).qrs_code = ' || p_qtev_tbl(k).qrs_code );
489 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).qst_code = ' || p_qtev_tbl(k).qst_code );
490 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).consolidated_qte_id = ' || p_qtev_tbl(k).consolidated_qte_id );
491 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).khr_id = ' || p_qtev_tbl(k).khr_id );
492 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).art_id = ' || p_qtev_tbl(k).art_id );
493 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).qtp_code = ' || p_qtev_tbl(k).qtp_code );
494 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).trn_code = ' || p_qtev_tbl(k).trn_code );
495 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).pop_code_end = ' || p_qtev_tbl(k).pop_code_end );
496 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).pop_code_early = ' || p_qtev_tbl(k).pop_code_early );
497 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).pdt_id = ' || p_qtev_tbl(k).pdt_id );
498 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_effective_from = ' || p_qtev_tbl(k).date_effective_from );
499 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).quote_number = ' || p_qtev_tbl(k).quote_number );
500 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).object_version_number = ' || p_qtev_tbl(k).object_version_number );
501 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).purchase_percent = ' || p_qtev_tbl(k).purchase_percent );
502 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).term = ' || p_qtev_tbl(k).term );
503 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_restructure_start = ' || p_qtev_tbl(k).date_restructure_start );
504 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_due = ' || p_qtev_tbl(k).date_due );
505 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_approved = ' || p_qtev_tbl(k).date_approved );
506 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_restructure_end = ' || p_qtev_tbl(k).date_restructure_end );
507 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).remaining_payments = ' || p_qtev_tbl(k).remaining_payments );
508 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).rent_amount = ' || p_qtev_tbl(k).rent_amount );
509 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).yield = ' || p_qtev_tbl(k).yield );
510 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).residual_amount = ' || p_qtev_tbl(k).residual_amount );
511 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).principal_paydown_amount = ' || p_qtev_tbl(k).principal_paydown_amount );
512 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_frequency = ' || p_qtev_tbl(k).payment_frequency );
513 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).early_termination_yn = ' || p_qtev_tbl(k).early_termination_yn );
514 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).partial_yn = ' || p_qtev_tbl(k).partial_yn );
515 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).preproceeds_yn = ' || p_qtev_tbl(k).preproceeds_yn );
516 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).summary_format_yn = ' || p_qtev_tbl(k).summary_format_yn );
517 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).consolidated_yn = ' || p_qtev_tbl(k).consolidated_yn );
518 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_requested = ' || p_qtev_tbl(k).date_requested );
519 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_proposal = ' || p_qtev_tbl(k).date_proposal );
520 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_effective_to = ' || p_qtev_tbl(k).date_effective_to );
521 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_accepted = ' || p_qtev_tbl(k).date_accepted );
522 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_received_yn = ' || p_qtev_tbl(k).payment_received_yn );
523 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).requested_by = ' || p_qtev_tbl(k).requested_by );
524 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_yn = ' || p_qtev_tbl(k).approved_yn );
525 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).accepted_yn = ' || p_qtev_tbl(k).accepted_yn );
526 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_payment_received = ' || p_qtev_tbl(k).date_payment_received );
527 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_by = ' || p_qtev_tbl(k).approved_by );
528 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).org_id = ' || p_qtev_tbl(k).org_id );
529 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).request_id = ' || p_qtev_tbl(k).request_id );
530 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_application_id = ' || p_qtev_tbl(k).program_application_id );
531 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_id = ' || p_qtev_tbl(k).program_id );
532 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_update_date = ' || p_qtev_tbl(k).program_update_date );
533 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute_category = ' || p_qtev_tbl(k).attribute_category );
534 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute1 = ' || p_qtev_tbl(k).attribute1 );
535 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute2 = ' || p_qtev_tbl(k).attribute2 );
536 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute3 = ' || p_qtev_tbl(k).attribute3 );
537 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute4 = ' || p_qtev_tbl(k).attribute4 );
538 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute5 = ' || p_qtev_tbl(k).attribute5 );
539 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute6 = ' || p_qtev_tbl(k).attribute6 );
540 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute7 = ' || p_qtev_tbl(k).attribute7 );
541 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute8 = ' || p_qtev_tbl(k).attribute8 );
542 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute9 = ' || p_qtev_tbl(k).attribute9 );
543 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute10 = ' || p_qtev_tbl(k).attribute10 );
544 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute11 = ' || p_qtev_tbl(k).attribute11 );
545 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute12 = ' || p_qtev_tbl(k).attribute12 );
546 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute13 = ' || p_qtev_tbl(k).attribute13 );
547 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute14 = ' || p_qtev_tbl(k).attribute14 );
548 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute15 = ' || p_qtev_tbl(k).attribute15 );
549 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).created_by = ' || p_qtev_tbl(k).created_by );
550 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).creation_date = ' || p_qtev_tbl(k).creation_date );
551 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_updated_by = ' || p_qtev_tbl(k).last_updated_by );
552 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_update_date = ' || p_qtev_tbl(k).last_update_date );
553 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_restructure_end = ' || p_qtev_tbl(k).date_restructure_end );
554 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).remaining_payments = ' || p_qtev_tbl(k).remaining_payments );
555 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).rent_amount = ' || p_qtev_tbl(k).rent_amount );
556 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).yield = ' || p_qtev_tbl(k).yield );
557 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).residual_amount = ' || p_qtev_tbl(k).residual_amount );
558 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).principal_paydown_amount = ' || p_qtev_tbl(k).principal_paydown_amount );
559 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_frequency = ' || p_qtev_tbl(k).payment_frequency );
560 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).early_termination_yn = ' || p_qtev_tbl(k).early_termination_yn );
561 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).partial_yn = ' || p_qtev_tbl(k).partial_yn );
562 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).preproceeds_yn = ' || p_qtev_tbl(k).preproceeds_yn );
563 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).summary_format_yn = ' || p_qtev_tbl(k).summary_format_yn );
564 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).consolidated_yn = ' || p_qtev_tbl(k).consolidated_yn );
565 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_requested = ' || p_qtev_tbl(k).date_requested );
566 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_proposal = ' || p_qtev_tbl(k).date_proposal );
567 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_effective_to = ' || p_qtev_tbl(k).date_effective_to );
568 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_accepted = ' || p_qtev_tbl(k).date_accepted );
569 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).payment_received_yn = ' || p_qtev_tbl(k).payment_received_yn );
570 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).requested_by = ' || p_qtev_tbl(k).requested_by );
571 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_yn = ' || p_qtev_tbl(k).approved_yn );
572 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).accepted_yn = ' || p_qtev_tbl(k).accepted_yn );
573 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).date_payment_received = ' || p_qtev_tbl(k).date_payment_received );
574 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).approved_by = ' || p_qtev_tbl(k).approved_by );
575 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).org_id = ' || p_qtev_tbl(k).org_id );
576 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).request_id = ' || p_qtev_tbl(k).request_id );
577 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_application_id = ' || p_qtev_tbl(k).program_application_id );
578 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_id = ' || p_qtev_tbl(k).program_id );
579 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).program_update_date = ' || p_qtev_tbl(k).program_update_date );
580 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute_category = ' || p_qtev_tbl(k).attribute_category );
581 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute1 = ' || p_qtev_tbl(k).attribute1 );
582 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute2 = ' || p_qtev_tbl(k).attribute2 );
583 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute3 = ' || p_qtev_tbl(k).attribute3 );
584 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute4 = ' || p_qtev_tbl(k).attribute4 );
585 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute5 = ' || p_qtev_tbl(k).attribute5 );
586 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute6 = ' || p_qtev_tbl(k).attribute6 );
587 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute7 = ' || p_qtev_tbl(k).attribute7 );
588 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute8 = ' || p_qtev_tbl(k).attribute8 );
589 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute9 = ' || p_qtev_tbl(k).attribute9 );
590 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute10 = ' || p_qtev_tbl(k).attribute10 );
591 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute11 = ' || p_qtev_tbl(k).attribute11 );
592 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute12 = ' || p_qtev_tbl(k).attribute12 );
593 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute13 = ' || p_qtev_tbl(k).attribute13 );
594 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute14 = ' || p_qtev_tbl(k).attribute14 );
595 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).attribute15 = ' || p_qtev_tbl(k).attribute15 );
596 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).created_by = ' || p_qtev_tbl(k).created_by );
597 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).creation_date = ' || p_qtev_tbl(k).creation_date );
598 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_updated_by = ' || p_qtev_tbl(k).last_updated_by );
599 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_update_date = ' || p_qtev_tbl(k).last_update_date );
600 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).last_update_login = ' || p_qtev_tbl(k).last_update_login );
601 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).purchase_amount = ' || p_qtev_tbl(k).purchase_amount );
602 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).purchase_formula = ' || p_qtev_tbl(k).purchase_formula );
603 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).asset_value = ' || p_qtev_tbl(k).asset_value );
604 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).residual_value = ' || p_qtev_tbl(k).residual_value );
605 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).unbilled_receivables = ' || p_qtev_tbl(k).unbilled_receivables );
606 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).gain_loss = ' || p_qtev_tbl(k).gain_loss );
607 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).PERDIEM_AMOUNT = ' || p_qtev_tbl(k).PERDIEM_AMOUNT );
608 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_code = ' || p_qtev_tbl(k).currency_code );
609 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_code = ' || p_qtev_tbl(k).currency_conversion_code );
610 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_type = ' || p_qtev_tbl(k).currency_conversion_type );
611 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_rate = ' || p_qtev_tbl(k).currency_conversion_rate );
612 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).currency_conversion_date = ' || p_qtev_tbl(k).currency_conversion_date );
613 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).legal_entity_id = ' || p_qtev_tbl(k).legal_entity_id );
614 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_qtev_tbl(k).repo_quote_indicator_yn = ' || p_qtev_tbl(k).repo_quote_indicator_yn );
615
616 END IF;
617 END LOOP;
618 END IF;
619 IF p_party_tbl.COUNT > 0 THEN
620 FOR l IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP
621 IF p_party_tbl.exists(l) THEN
622 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).quote_id = ' || p_party_tbl(l).quote_id );
623 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).contract_id = ' || p_party_tbl(l).contract_id );
624 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).k_buy_or_sell = ' || p_party_tbl(l).k_buy_or_sell );
625 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_party_id = ' || p_party_tbl(l).qp_party_id );
626 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_role_code = ' || p_party_tbl(l).qp_role_code );
627 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_party_role = ' || p_party_tbl(l).qp_party_role );
628 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_date_sent = ' || p_party_tbl(l).qp_date_sent );
629 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_date_hold = ' || p_party_tbl(l).qp_date_hold );
630 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_created_by = ' || p_party_tbl(l).qp_created_by );
631 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_creation_date = ' || p_party_tbl(l).qp_creation_date );
632 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_last_updated_by = ' || p_party_tbl(l).qp_last_updated_by );
633 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_last_update_date = ' || p_party_tbl(l).qp_last_update_date );
634 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).qp_last_update_login = ' || p_party_tbl(l).qp_last_update_login );
635 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).kp_party_id = ' || p_party_tbl(l).kp_party_id );
636 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).kp_role_code = ' || p_party_tbl(l).kp_role_code );
637 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).kp_party_role = ' || p_party_tbl(l).kp_party_role );
638 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).po_party_id1 = ' || p_party_tbl(l).po_party_id1 );
639 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).po_party_id2 = ' || p_party_tbl(l).po_party_id2 );
640 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).po_party_object = ' || p_party_tbl(l).po_party_object );
641 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).po_party_name = ' || p_party_tbl(l).po_party_name );
642 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).po_party_desc = ' || p_party_tbl(l).po_party_desc );
643 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_contact_id1 = ' || p_party_tbl(l).co_contact_id1 );
644 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_contact_id2 = ' || p_party_tbl(l).co_contact_id2 );
645 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_contact_object = ' || p_party_tbl(l).co_contact_object );
646 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_contact_name = ' || p_party_tbl(l).co_contact_name );
647 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_contact_desc = ' || p_party_tbl(l).co_contact_desc );
648 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_email = ' || p_party_tbl(l).co_email );
649 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_order_num = ' || p_party_tbl(l).co_order_num );
650 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).co_date_sent = ' || p_party_tbl(l).co_date_sent );
651 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_point_id = ' || p_party_tbl(l).cp_point_id );
652 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_point_type = ' || p_party_tbl(l).cp_point_type );
653 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_primary_flag = ' || p_party_tbl(l).cp_primary_flag );
654 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_email = ' || p_party_tbl(l).cp_email );
655 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_details = ' || p_party_tbl(l).cp_details );
656 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_order_num = ' || p_party_tbl(l).cp_order_num );
657 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,' p_party_tbl(l).cp_date_sent = ' || p_party_tbl(l).cp_date_sent );
658 END IF;
659 END LOOP;
660 END IF;
661 END IF;
662 OKL_AM_SEND_FULFILLMENT_PUB.send_terminate_quote(
663 p_api_version => p_api_version,
664 p_init_msg_list => FND_API.G_FALSE,
665 x_return_status => x_return_status,
666 x_msg_count => x_msg_count,
667 x_msg_data => x_msg_data,
668 p_party_tbl => p_party_tbl,
669 x_party_tbl => x_party_tbl,
670 p_qtev_rec => p_qtev_tbl(i),
671 x_qtev_rec => x_qtev_tbl(i));
672
673 IF (is_debug_statement_on) THEN
674 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_create_quote_pub.send_terminate_quote , return status: ' || x_return_status);
675 END IF;
676
677 IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
678 IF (is_debug_exception_on) THEN
679 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
680 END IF;
681 IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
682 l_overall_status := x_return_status;
683 END IF;
684 END IF;
685 EXIT WHEN (i = p_qtev_tbl.LAST);
686 i := p_qtev_tbl.NEXT(i);
687 END LOOP;
688 x_return_status := l_overall_status;
689 END IF;
690 IF (is_debug_procedure_on) THEN
691 OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
692 END IF;
693 END send_terminate_quote;
694 END OKL_CS_CREATE_QUOTE_PVT;