2042: p_termination_date IN DATE,
2043: p_ialn_tbl IN ialn_tbl_type,
2044: x_return_status OUT NOCOPY VARCHAR2) IS
2045:
2046: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2047: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2048: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2049: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2050:
2044: x_return_status OUT NOCOPY VARCHAR2) IS
2045:
2046: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2047: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2048: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2049: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2050:
2051: lp_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2052: lp_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2047: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2048: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2049: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2050:
2051: lp_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2052: lp_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2053: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2054: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2055:
2049: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2050:
2051: lp_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2052: lp_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2053: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2054: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2055:
2056: l_trn_reason_code VARCHAR2(30) := 'EXP';
2057: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2289: l_row_found BOOLEAN := FALSE;
2290: l_legal_entity_id NUMBER;
2291:
2292: -- RMUNJULU Bug 3455354
2293: l_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2294: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2295:
2296: l_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2297: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2290: l_legal_entity_id NUMBER;
2291:
2292: -- RMUNJULU Bug 3455354
2293: l_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2294: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2295:
2296: l_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2297: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2298: