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
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: ----------------------------------------------------------------------------------
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: --
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
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
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: --
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: --
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
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: --
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
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;