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_POOL_PVT dependencies on OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POOL_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

Line 9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POOL_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POOL_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:

Line 11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';

Line 20: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18:
19: -- mvasudev
20: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
21: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
22: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
23: G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
24:

Line 21: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';

17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18:
19: -- mvasudev
20: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
21: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
22: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
23: G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
24:
25: -- cklee

Line 49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

45: /* ankushar 26-JUL-2007
46: Bug#6000531
47: start changes
48: */
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
51: /* ankushar end changes 26-Jul-2007*/
52:
53: -- Bug#2829983

Line 50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

46: Bug#6000531
47: start changes
48: */
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
50: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
51: /* ankushar end changes 26-Jul-2007*/
52:
53: -- Bug#2829983
54: G_POL_STS_NEW CONSTANT VARCHAR2(3) := 'NEW';

Line 168: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

164: -- End of comments
165: ----------------------------------------------------------------------------------
166: PROCEDURE create_pool(
167: p_api_version IN NUMBER
168: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
169: ,x_return_status OUT NOCOPY VARCHAR2
170: ,x_msg_count OUT NOCOPY NUMBER
171: ,x_msg_data OUT NOCOPY VARCHAR2
172: ,p_polv_rec IN polv_rec_type

Line 187: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

183: -- End of comments
184: ----------------------------------------------------------------------------------
185: PROCEDURE update_pool(
186: p_api_version IN NUMBER
187: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_count OUT NOCOPY NUMBER
190: ,x_msg_data OUT NOCOPY VARCHAR2
191: ,p_polv_rec IN polv_rec_type

Line 206: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

202: -- End of comments
203: ----------------------------------------------------------------------------------
204: PROCEDURE delete_pool(
205: p_api_version IN NUMBER
206: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
209: ,x_msg_data OUT NOCOPY VARCHAR2
210: ,p_polv_rec IN polv_rec_type

Line 225: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

221: -- End of comments
222: ----------------------------------------------------------------------------------
223: PROCEDURE create_pool_contents(
224: p_api_version IN NUMBER
225: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
226: ,x_return_status OUT NOCOPY VARCHAR2
227: ,x_msg_count OUT NOCOPY NUMBER
228: ,x_msg_data OUT NOCOPY VARCHAR2
229: ,p_pocv_rec IN pocv_rec_type

Line 244: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

240: -- End of comments
241: ----------------------------------------------------------------------------------
242: PROCEDURE create_pool_contents(
243: p_api_version IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
245: ,x_return_status OUT NOCOPY VARCHAR2
246: ,x_msg_count OUT NOCOPY NUMBER
247: ,x_msg_data OUT NOCOPY VARCHAR2
248: ,p_pocv_tbl IN pocv_tbl_type

Line 264: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

260: -- End of comments
261: ----------------------------------------------------------------------------------
262: PROCEDURE update_pool_contents(
263: p_api_version IN NUMBER
264: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
265: ,x_return_status OUT NOCOPY VARCHAR2
266: ,x_msg_count OUT NOCOPY NUMBER
267: ,x_msg_data OUT NOCOPY VARCHAR2
268: ,p_pocv_rec IN pocv_rec_type

Line 283: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

279: -- End of comments
280: ----------------------------------------------------------------------------------
281: PROCEDURE update_pool_contents(
282: p_api_version IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
284: ,x_return_status OUT NOCOPY VARCHAR2
285: ,x_msg_count OUT NOCOPY NUMBER
286: ,x_msg_data OUT NOCOPY VARCHAR2
287: ,p_pocv_tbl IN pocv_tbl_type

Line 304: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

300: -- End of comments
301: ----------------------------------------------------------------------------------
302: PROCEDURE delete_pool_contents(
303: p_api_version IN NUMBER
304: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
305: ,x_return_status OUT NOCOPY VARCHAR2
306: ,x_msg_count OUT NOCOPY NUMBER
307: ,x_msg_data OUT NOCOPY VARCHAR2
308: ,p_pocv_rec IN pocv_rec_type

Line 323: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

319: ----------------------------------------------------------------------------------
320:
321: PROCEDURE delete_pool_contents(
322: p_api_version IN NUMBER
323: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
324: ,x_return_status OUT NOCOPY VARCHAR2
325: ,x_msg_count OUT NOCOPY NUMBER
326: ,x_msg_data OUT NOCOPY VARCHAR2
327: ,p_pocv_tbl IN pocv_tbl_type

Line 342: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

338: -- End of comments
339: ----------------------------------------------------------------------------------
340: PROCEDURE create_pool_transaction(
341: p_api_version IN NUMBER
342: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
343: ,x_return_status OUT NOCOPY VARCHAR2
344: ,x_msg_count OUT NOCOPY NUMBER
345: ,x_msg_data OUT NOCOPY VARCHAR2
346: ,p_poxv_rec IN poxv_rec_type

Line 362: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

358: -- End of comments
359: ----------------------------------------------------------------------------------
360: PROCEDURE update_pool_transaction(
361: p_api_version IN NUMBER
362: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2
366: ,p_poxv_rec IN poxv_rec_type

Line 382: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

378: -- End of comments
379: ----------------------------------------------------------------------------------
380: PROCEDURE delete_pool_transaction(
381: p_api_version IN NUMBER
382: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
383: ,x_return_status OUT NOCOPY VARCHAR2
384: ,x_msg_count OUT NOCOPY NUMBER
385: ,x_msg_data OUT NOCOPY VARCHAR2
386: ,p_poxv_rec IN poxv_rec_type

Line 432: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

428: -- End of comments
429: ----------------------------------------------------------------------------------
430: PROCEDURE get_tot_recei_amt(
431: p_api_version IN NUMBER
432: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
433: ,x_return_status OUT NOCOPY VARCHAR2
434: ,x_msg_count OUT NOCOPY NUMBER
435: ,x_msg_data OUT NOCOPY VARCHAR2
436: ,x_value OUT NOCOPY NUMBER

Line 451: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

447: -- End of comments
448: ----------------------------------------------------------------------------------
449: PROCEDURE get_tot_receivable_amt(
450: p_api_version IN NUMBER
451: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2
455: ,x_value OUT NOCOPY NUMBER

Line 484: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

480: -- End of comments
481: ----------------------------------------------------------------------------------
482: PROCEDURE recal_tot_princ_amt(
483: p_api_version IN NUMBER
484: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
485: ,x_return_status OUT NOCOPY VARCHAR2
486: ,x_msg_count OUT NOCOPY NUMBER
487: ,x_msg_data OUT NOCOPY VARCHAR2
488: ,x_value OUT NOCOPY NUMBER

Line 504: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

500: -- End of comments
501: ----------------------------------------------------------------------------------
502: PROCEDURE recal_tot_principal_amt(
503: p_api_version IN NUMBER
504: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
505: ,x_return_status OUT NOCOPY VARCHAR2
506: ,x_msg_count OUT NOCOPY NUMBER
507: ,x_msg_data OUT NOCOPY VARCHAR2
508: ,x_value OUT NOCOPY NUMBER

Line 526: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

522: -- Create by Search Criteria: Query Streams from contracts + Create
523:
524: PROCEDURE add_pool_contents(
525: p_api_version IN NUMBER
526: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
527: ,x_return_status OUT NOCOPY VARCHAR2
528: ,x_msg_count OUT NOCOPY NUMBER
529: ,x_msg_data OUT NOCOPY VARCHAR2
530: ,x_row_count OUT NOCOPY NUMBER

Line 533: ,p_multi_org IN VARCHAR2 DEFAULT okl_api.g_true

529: ,x_msg_data OUT NOCOPY VARCHAR2
530: ,x_row_count OUT NOCOPY NUMBER
531: ,p_currency_code IN VARCHAR2
532: ,p_pol_id IN NUMBER
533: ,p_multi_org IN VARCHAR2 DEFAULT okl_api.g_true
534: ,p_cust_object1_id1 IN NUMBER DEFAULT NULL
535: ,p_sic_code IN VARCHAR2 DEFAULT NULL
536: ,p_khr_id IN NUMBER DEFAULT NULL
537: ,p_pre_tax_yield_from IN NUMBER DEFAULT NULL

Line 580: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

576: -- Create by Search Criteria: Query Streams from contracts + Create
577:
578: PROCEDURE cleanup_pool_contents(
579: p_api_version IN NUMBER
580: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
581: ,x_return_status OUT NOCOPY VARCHAR2
582: ,x_msg_count OUT NOCOPY NUMBER
583: ,x_msg_data OUT NOCOPY VARCHAR2
584: ,p_currency_code IN VARCHAR2

Line 586: ,p_multi_org IN VARCHAR2 DEFAULT okl_api.g_true

582: ,x_msg_count OUT NOCOPY NUMBER
583: ,x_msg_data OUT NOCOPY VARCHAR2
584: ,p_currency_code IN VARCHAR2
585: ,p_pol_id IN NUMBER
586: ,p_multi_org IN VARCHAR2 DEFAULT okl_api.g_true
587: ,p_cust_object1_id1 IN NUMBER DEFAULT NULL
588: ,p_sic_code IN VARCHAR2 DEFAULT NULL
589: ,p_dnz_chr_id IN NUMBER DEFAULT NULL
590: ,p_pre_tax_yield_from IN NUMBER DEFAULT NULL

Line 647: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

643: -- End of comments
644: ----------------------------------------------------------------------------------
645: PROCEDURE update_pool_status_active(
646: p_api_version IN NUMBER
647: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_pol_id IN okl_pools.id%TYPE);

Line 665: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

661: -- End of comments
662: ----------------------------------------------------------------------------------
663: PROCEDURE update_pool_status_expired(
664: p_api_version IN NUMBER
665: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
666: ,x_return_status OUT NOCOPY VARCHAR2
667: ,x_msg_count OUT NOCOPY NUMBER
668: ,x_msg_data OUT NOCOPY VARCHAR2
669: ,p_pol_id IN okl_pools.id%TYPE);

Line 684: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

680: -- End of comments
681: ----------------------------------------------------------------------------------
682: PROCEDURE get_total_stream_amount(
683: p_api_version IN NUMBER
684: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
685: ,x_return_status OUT NOCOPY VARCHAR2
686: ,x_msg_count OUT NOCOPY NUMBER
687: ,x_msg_data OUT NOCOPY VARCHAR2
688: ,p_poc_id IN okl_pool_contents.id%TYPE