DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on OKL_POOLS

Line 409: -- Description : get stream elements amount from pool contents by okl_pools.id

405: ----------------------------------------------------------------------------------
406: -- Start of comments
407: --
408: -- Procedure Name : get_tot_receivable_amt
409: -- Description : get stream elements amount from pool contents by okl_pools.id
410: -- Business Rules :
411: -- Parameters :
412: -- Version : 1.0
413: -- End of comments

Line 416: p_pol_id IN okl_pools.id%TYPE

412: -- Version : 1.0
413: -- End of comments
414: ----------------------------------------------------------------------------------
415: FUNCTION get_tot_receivable_amt(
416: p_pol_id IN okl_pools.id%TYPE
417: ) RETURN NUMBER;
418: PRAGMA RESTRICT_REFERENCES (get_tot_receivable_amt, TRUST);
419:
420: ----------------------------------------------------------------------------------

Line 437: ,p_pol_id IN okl_pools.id%TYPE

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
437: ,p_pol_id IN okl_pools.id%TYPE
438: );
439: ----------------------------------------------------------------------------------
440: -- Start of comments
441: --

Line 462: -- Description : get asset principal amount from pool contents by okl_pools.id

458: ----------------------------------------------------------------------------------
459: -- Start of comments
460: --
461: -- Procedure Name : get_tot_principal_amt
462: -- Description : get asset principal amount from pool contents by okl_pools.id
463: -- Business Rules :
464: -- Parameters :
465: -- Version : 1.0
466: -- End of comments

Line 469: p_pol_id IN okl_pools.id%TYPE

465: -- Version : 1.0
466: -- End of comments
467: ----------------------------------------------------------------------------------
468: FUNCTION get_tot_principal_amt(
469: p_pol_id IN okl_pools.id%TYPE
470: ) RETURN NUMBER;
471: PRAGMA RESTRICT_REFERENCES (get_tot_principal_amt, TRUST);
472: ----------------------------------------------------------------------------------
473: -- Start of comments

Line 489: ,p_pol_id IN okl_pools.id%TYPE

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
489: ,p_pol_id IN okl_pools.id%TYPE
490: );
491: ----------------------------------------------------------------------------------
492: -- Start of comments
493: --

Line 651: ,p_pol_id IN okl_pools.id%TYPE);

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);
652:
653: ----------------------------------------------------------------------------------
654: -- Start of comments
655: --

Line 669: ,p_pol_id IN okl_pools.id%TYPE);

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);
670:
671: ----------------------------------------------------------------------------------
672: -- Start of comments
673: -- mvasudev

Line 738: ,p_pol_id IN okl_pools.id%TYPE

734: ,x_return_status OUT NOCOPY VARCHAR2
735: ,x_msg_count OUT NOCOPY NUMBER
736: ,x_msg_data OUT NOCOPY VARCHAR2
737: ,x_value OUT NOCOPY NUMBER
738: ,p_pol_id IN okl_pools.id%TYPE
739: );
740: ----------------------------------------------------------------------------------
741: -- Start of comments
742: --

Line 744: -- Description : get asset principal amount from pool contents by okl_pools.id

740: ----------------------------------------------------------------------------------
741: -- Start of comments
742: --
743: -- Procedure Name : get_tot_recv_amt_for_pend
744: -- Description : get asset principal amount from pool contents by okl_pools.id
745: -- Business Rules :
746: -- Parameters :
747: -- Version : 1.0
748: -- End of comments

Line 751: p_pol_id IN okl_pools.id%TYPE

747: -- Version : 1.0
748: -- End of comments
749: ----------------------------------------------------------------------------------
750: FUNCTION get_tot_recv_amt_for_pend(
751: p_pol_id IN okl_pools.id%TYPE
752: ) RETURN NUMBER;
753: PRAGMA RESTRICT_REFERENCES (get_tot_recv_amt_for_pend, TRUST);
754:
755: END Okl_Pool_Pvt;