eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SECURITIZATION_PVT dependencies on OKL_POOL_PVT

Line 6: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;

2: /* $Header: OKLRSZSB.pls 120.19.12020000.1 2012/06/28 18:27:36 appldev ship $ */
3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------
6: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
7: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
8: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
9: G_FINAL_DATE CONSTANT DATE := Okl_Pool_Pvt.G_FINAL_DATE;
10:

Line 7: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;

3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------
6: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
7: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
8: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
9: G_FINAL_DATE CONSTANT DATE := Okl_Pool_Pvt.G_FINAL_DATE;
10:
11: G_STY_INV_RENT_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RENT_BUYBACK';

Line 8: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;

4: -- Global Message Constants
5: ----------------------------------------------------------------------------
6: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
7: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
8: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
9: G_FINAL_DATE CONSTANT DATE := Okl_Pool_Pvt.G_FINAL_DATE;
10:
11: G_STY_INV_RENT_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RENT_BUYBACK';
12: G_STY_INV_RESIDUAL_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RESIDUAL_BUYBACK';

Line 9: G_FINAL_DATE CONSTANT DATE := Okl_Pool_Pvt.G_FINAL_DATE;

5: ----------------------------------------------------------------------------
6: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
7: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
8: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
9: G_FINAL_DATE CONSTANT DATE := Okl_Pool_Pvt.G_FINAL_DATE;
10:
11: G_STY_INV_RENT_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RENT_BUYBACK';
12: G_STY_INV_RESIDUAL_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RESIDUAL_BUYBACK';
13: G_STY_SUBCLASS_RENT CONSTANT VARCHAR2(4) := 'RENT';

Line 2275: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2271: AND pocb.khr_id = p_khr_id
2272: AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)
2273: AND pocb.sty_id = styb.id
2274: AND styb.stream_type_subclass = NVL(p_stream_type_subclass,styb.stream_type_subclass)
2275: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2276: AND pocb.transaction_number_out IS NULL;
2277:
2278: -- Cursor to get Latest Streams for this Lease Contract/Asset Line
2279: CURSOR l_okl_stm_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER)

Line 2353: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version

2349: RAISE G_EXCEPTION_ERROR;
2350: END IF;
2351:
2352: lp_poxv_rec := p_poxv_rec;
2353: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version
2354: ,p_init_msg_list => p_init_msg_list
2355: ,x_return_status => l_return_status
2356: ,x_msg_count => x_msg_count
2357: ,x_msg_data => x_msg_data

Line 2410: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

2406: l_rv_date_updated := TRUE;
2407: END IF;
2408: END IF;
2409:
2410: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
2411: ,p_init_msg_list => p_init_msg_list
2412: ,x_return_status => l_return_status
2413: ,x_msg_count => x_msg_count
2414: ,x_msg_data => x_msg_data

Line 2515: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version

2511: lp_pocv_rec_cre.stm_id := l_okl_stm_rec.id;
2512: END LOOP; -- l_okl_stm_rec
2513:
2514: lx_pocv_rec := NULL;
2515: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version
2516: ,p_init_msg_list => p_init_msg_list
2517: ,x_return_status => l_return_status
2518: ,x_msg_count => x_msg_count
2519: ,x_msg_data => x_msg_data

Line 2535: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

2531: lp_pocv_rec_upd.status_code := G_POC_STS_ACTIVE;
2532:
2533: lx_pocv_rec := NULL;
2534:
2535: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
2536: ,p_init_msg_list => p_init_msg_list
2537: ,x_return_status => l_return_status
2538: ,x_msg_count => x_msg_count
2539: ,x_msg_data => x_msg_data

Line 2619: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2615: WHERE pocb.khr_id = p_khr_id
2616: AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)
2617: AND pocb.sty_id = styb.id
2618: AND styb.stream_type_subclass = NVL(p_stream_type_subclass,styb.stream_type_subclass)
2619: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2620: AND pocb.transaction_number_out IS NULL;
2621:
2622:
2623: -- Cursor to get the Lease Contract End Date

Line 2943: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2939: SELECT DISTINCT pol_id
2940: FROM okl_pool_contents
2941: WHERE khr_id = p_khr_id
2942: AND kle_id = p_kle_id
2943: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2944: AND transaction_number_out IS NULL;
2945:
2946: -- Cursor to get all the Pool Contents for this Asset Line
2947: CURSOR l_okl_poc_csr(p_pol_id IN NUMBER)

Line 2959: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2955: FROM okl_pool_contents
2956: WHERE pol_id = p_pol_id
2957: AND khr_id = p_khr_id
2958: AND kle_id = p_kle_id
2959: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2960: AND transaction_number_out IS NULL;
2961:
2962: -- Cursor to get the Latest Streams for this Asset Line
2963: CURSOR l_okl_stm_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER)

Line 3041: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version

3037: -- legal_entity_id populated in the record
3038: lp_poxv_rec.legal_entity_id := lp_legal_entity_id;
3039: -- end ankushar Legal Entity changes
3040:
3041: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version
3042: ,p_init_msg_list => p_init_msg_list
3043: ,x_return_status => l_return_status
3044: ,x_msg_count => x_msg_count
3045: ,x_msg_data => x_msg_data

Line 3064: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

3060: lp_pocv_rec.transaction_number_out := lx_poxv_rec.transaction_number;
3061: lp_pocv_rec.status_code := G_POC_STS_INACTIVE;
3062: lp_pocv_rec.date_inactive := p_effective_date;
3063:
3064: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
3065: ,p_init_msg_list => p_init_msg_list
3066: ,x_return_status => l_return_status
3067: ,x_msg_count => x_msg_count
3068: ,x_msg_data => x_msg_data

Line 3103: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version

3099: */
3100: lp_pocv_rec_cre.pox_id:= lx_poxv_rec.id;
3101: /* sosharma end changes*/
3102:
3103: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version
3104: ,p_init_msg_list => p_init_msg_list
3105: ,x_return_status => l_return_status
3106: ,x_msg_count => x_msg_count
3107: ,x_msg_data => x_msg_data

Line 3123: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

3119: lp_pocv_rec_upd.status_code := G_POC_STS_ACTIVE;
3120:
3121: lx_pocv_rec := NULL;
3122:
3123: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
3124: ,p_init_msg_list => p_init_msg_list
3125: ,x_return_status => l_return_status
3126: ,x_msg_count => x_msg_count
3127: ,x_msg_data => x_msg_data