20:
21: SUBTYPE mstv_rec_type IS okl_mst_pvt.mstv_rec_type;
22: SUBTYPE mstv_tbl_type IS okl_mst_pvt.mstv_tbl_type;
23:
24: subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
25:
26: subtype thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;
27: subtype thpv_tbl_type IS OKL_TRX_ASSETS_PUB.thpv_tbl_type;
28:
212: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
213: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
214: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
215: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
216: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
217: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
218: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
219: );
220:
213: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
214: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
215: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
216: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
217: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
218: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
219: );
220:
221: PROCEDURE apply_mass_rebook(
214: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
215: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
216: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
217: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
218: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
219: );
220:
221: PROCEDURE apply_mass_rebook(
222: p_api_version IN NUMBER,
231: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
232: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
233: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
234: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
235: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
236: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
237: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
238: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
239: );
232: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
233: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
234: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
235: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
236: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
237: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
238: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
239: );
240:
234: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
235: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
236: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
237: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
238: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
239: );
240:
241: PROCEDURE apply_mass_rebook(
242: p_api_version IN NUMBER,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
248: p_kle_tbl IN kle_tbl_type,
249: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
250: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
251: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
252: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
253: p_ppd_amount IN NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
248: p_kle_tbl IN kle_tbl_type,
249: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
250: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
251: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
252: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
253: p_ppd_amount IN NUMBER,
254: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
247: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
248: p_kle_tbl IN kle_tbl_type,
249: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
250: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
251: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
252: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
253: p_ppd_amount IN NUMBER,
254: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
255: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
248: p_kle_tbl IN kle_tbl_type,
249: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
250: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
251: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
252: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
253: p_ppd_amount IN NUMBER,
254: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
255: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
256: );