151: -- Set the restructure values
152: lx_csm_lease_header.jtot_object1_code := 'OKL_TRX_QUOTES_B';
153: lx_csm_lease_header.object1_id1 := l_qtev_rec.id;
154: lx_csm_lease_header.orp_code :=
155: Okl_Create_Streams_Pub.G_ORP_CODE_RESTRUCTURE_AM;
156: -- Update the original contract term
157: lx_csm_lease_header.term := l_new_periods;
158: -- What to adjust
159: lx_csm_lease_header.adjust :=
156: -- Update the original contract term
157: lx_csm_lease_header.term := l_new_periods;
158: -- What to adjust
159: lx_csm_lease_header.adjust :=
160: OKL_CREATE_STREAMS_PUB.G_ADJUST; --'Rent';
161: lx_csm_lease_header.adjustment_method :=
162: OKL_CREATE_STREAMS_PUB.G_ADJUSTMENT_METHOD; --'Proportional';
163:
164: -- Delete this table, not required
158: -- What to adjust
159: lx_csm_lease_header.adjust :=
160: OKL_CREATE_STREAMS_PUB.G_ADJUST; --'Rent';
161: lx_csm_lease_header.adjustment_method :=
162: OKL_CREATE_STREAMS_PUB.G_ADJUSTMENT_METHOD; --'Proportional';
163:
164: -- Delete this table, not required
165: lx_req_stream_types_tbl.DELETE;
166:
189: lx_rents_tbl(l_ind).advance_or_arrears := l_advance_or_arrears;
190: lx_rents_tbl(l_ind).structure := l_structure;
191: lx_rents_tbl(l_ind).period := l_period;
192: lx_rents_tbl(l_ind).description := 'RENT';
193: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
194: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
195: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
196: lx_rents_tbl(l_ind).lock_level_step := OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;
197: lx_rents_tbl(l_ind).date_start := l_str_rec.start_date;
190: lx_rents_tbl(l_ind).structure := l_structure;
191: lx_rents_tbl(l_ind).period := l_period;
192: lx_rents_tbl(l_ind).description := 'RENT';
193: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
194: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
195: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
196: lx_rents_tbl(l_ind).lock_level_step := OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;
197: lx_rents_tbl(l_ind).date_start := l_str_rec.start_date;
198: lx_rents_tbl(l_ind).amount := l_str_rec.amount;
191: lx_rents_tbl(l_ind).period := l_period;
192: lx_rents_tbl(l_ind).description := 'RENT';
193: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
194: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
195: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
196: lx_rents_tbl(l_ind).lock_level_step := OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;
197: lx_rents_tbl(l_ind).date_start := l_str_rec.start_date;
198: lx_rents_tbl(l_ind).amount := l_str_rec.amount;
199: lx_rents_tbl(l_ind).number_of_periods := 1;
192: lx_rents_tbl(l_ind).description := 'RENT';
193: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
194: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
195: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
196: lx_rents_tbl(l_ind).lock_level_step := OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;
197: lx_rents_tbl(l_ind).date_start := l_str_rec.start_date;
198: lx_rents_tbl(l_ind).amount := l_str_rec.amount;
199: lx_rents_tbl(l_ind).number_of_periods := 1;
200: ELSE
250: lx_rents_tbl(l_ind).advance_or_arrears := l_advance_or_arrears;
251: lx_rents_tbl(l_ind).structure := l_structure;
252: lx_rents_tbl(l_ind).period := l_period;
253: lx_rents_tbl(l_ind).description := 'RENT';
254: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
255: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
256: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
257: lx_rents_tbl(l_ind).lock_level_step := NULL;
258: lx_rents_tbl(l_ind).date_start := l_next_billing_date;
251: lx_rents_tbl(l_ind).structure := l_structure;
252: lx_rents_tbl(l_ind).period := l_period;
253: lx_rents_tbl(l_ind).description := 'RENT';
254: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
255: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
256: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
257: lx_rents_tbl(l_ind).lock_level_step := NULL;
258: lx_rents_tbl(l_ind).date_start := l_next_billing_date;
259: lx_rents_tbl(l_ind).amount := 0;
252: lx_rents_tbl(l_ind).period := l_period;
253: lx_rents_tbl(l_ind).description := 'RENT';
254: lx_rents_tbl(l_ind).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
255: lx_rents_tbl(l_ind).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
256: lx_rents_tbl(l_ind).query_level_yn := OKL_CREATE_STREAMS_PUB.G_FND_YES;
257: lx_rents_tbl(l_ind).lock_level_step := NULL;
258: lx_rents_tbl(l_ind).date_start := l_next_billing_date;
259: lx_rents_tbl(l_ind).amount := 0;
260: lx_rents_tbl(l_ind).number_of_periods := l_new_periods;
303: END IF;
304:
305: END LOOP;
306:
307: -- Call OKL_CREATE_STREAMS_PUB with the modified parameters which calls supertrump
308: OKL_CREATE_STREAMS_PUB.create_streams_lease_restr (
309: p_api_version => p_api_version,
310: p_init_msg_list => p_init_msg_list,
311: p_skip_prc_engine => l_skip_prc_engine,
304:
305: END LOOP;
306:
307: -- Call OKL_CREATE_STREAMS_PUB with the modified parameters which calls supertrump
308: OKL_CREATE_STREAMS_PUB.create_streams_lease_restr (
309: p_api_version => p_api_version,
310: p_init_msg_list => p_init_msg_list,
311: p_skip_prc_engine => l_skip_prc_engine,
312: p_csm_lease_header => lx_csm_lease_header,