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.17 2008/06/16 07:17:14 rpillay noship $ */
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 2331: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version

2327: RAISE G_EXCEPTION_ERROR;
2328: END IF;
2329:
2330: lp_poxv_rec := p_poxv_rec;
2331: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version
2332: ,p_init_msg_list => p_init_msg_list
2333: ,x_return_status => l_return_status
2334: ,x_msg_count => x_msg_count
2335: ,x_msg_data => x_msg_data

Line 2379: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

2375: l_rv_date_updated := TRUE;
2376: END IF;
2377: END IF;
2378:
2379: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
2380: ,p_init_msg_list => p_init_msg_list
2381: ,x_return_status => l_return_status
2382: ,x_msg_count => x_msg_count
2383: ,x_msg_data => x_msg_data

Line 2460: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version

2456: lp_pocv_rec_cre.stm_id := l_okl_stm_rec.id;
2457: END LOOP; -- l_okl_stm_rec
2458:
2459: lx_pocv_rec := NULL;
2460: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version
2461: ,p_init_msg_list => p_init_msg_list
2462: ,x_return_status => l_return_status
2463: ,x_msg_count => x_msg_count
2464: ,x_msg_data => x_msg_data

Line 2480: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

2476: lp_pocv_rec_upd.status_code := G_POC_STS_ACTIVE;
2477:
2478: lx_pocv_rec := NULL;
2479:
2480: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
2481: ,p_init_msg_list => p_init_msg_list
2482: ,x_return_status => l_return_status
2483: ,x_msg_count => x_msg_count
2484: ,x_msg_data => x_msg_data

Line 2564: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2560: WHERE pocb.khr_id = p_khr_id
2561: AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)
2562: AND pocb.sty_id = styb.id
2563: AND styb.stream_type_subclass = NVL(p_stream_type_subclass,styb.stream_type_subclass)
2564: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2565: AND pocb.transaction_number_out IS NULL;
2566:
2567:
2568: -- Cursor to get the Lease Contract End Date

Line 2888: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2884: SELECT DISTINCT pol_id
2885: FROM okl_pool_contents
2886: WHERE khr_id = p_khr_id
2887: AND kle_id = p_kle_id
2888: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2889: AND transaction_number_out IS NULL;
2890:
2891: -- Cursor to get all the Pool Contents for this Asset Line
2892: CURSOR l_okl_poc_csr(p_pol_id IN NUMBER)

Line 2904: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

2900: FROM okl_pool_contents
2901: WHERE pol_id = p_pol_id
2902: AND khr_id = p_khr_id
2903: AND kle_id = p_kle_id
2904: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2905: AND transaction_number_out IS NULL;
2906:
2907: -- Cursor to get the Latest Streams for this Asset Line
2908: CURSOR l_okl_stm_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER)

Line 2986: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version

2982: -- legal_entity_id populated in the record
2983: lp_poxv_rec.legal_entity_id := lp_legal_entity_id;
2984: -- end ankushar Legal Entity changes
2985:
2986: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version
2987: ,p_init_msg_list => p_init_msg_list
2988: ,x_return_status => l_return_status
2989: ,x_msg_count => x_msg_count
2990: ,x_msg_data => x_msg_data

Line 3009: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

3005: lp_pocv_rec.transaction_number_out := lx_poxv_rec.transaction_number;
3006: lp_pocv_rec.status_code := G_POC_STS_INACTIVE;
3007: lp_pocv_rec.date_inactive := p_effective_date;
3008:
3009: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
3010: ,p_init_msg_list => p_init_msg_list
3011: ,x_return_status => l_return_status
3012: ,x_msg_count => x_msg_count
3013: ,x_msg_data => x_msg_data

Line 3048: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version

3044: */
3045: lp_pocv_rec_cre.pox_id:= lx_poxv_rec.id;
3046: /* sosharma end changes*/
3047:
3048: Okl_Pool_Pvt.create_pool_contents(p_api_version => p_api_version
3049: ,p_init_msg_list => p_init_msg_list
3050: ,x_return_status => l_return_status
3051: ,x_msg_count => x_msg_count
3052: ,x_msg_data => x_msg_data

Line 3068: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version

3064: lp_pocv_rec_upd.status_code := G_POC_STS_ACTIVE;
3065:
3066: lx_pocv_rec := NULL;
3067:
3068: Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
3069: ,p_init_msg_list => p_init_msg_list
3070: ,x_return_status => l_return_status
3071: ,x_msg_count => x_msg_count
3072: ,x_msg_data => x_msg_data