1 PACKAGE ce_bal_util AS
2 /*$Header: cebaluts.pls 120.2 2005/10/07 18:42:52 xxwang noship $ */
3
4 TYPE t_date_table IS TABLE OF ce_t_date;
5
6 TYPE t_balance_table IS TABLE OF ce_t_balance;
7
8
9 TYPE acct_id_refcursor IS REF CURSOR RETURN ce_cashpool_sub_accts%ROWTYPE;
10
11 /*=======================================================================+
12 | PUBLIC FUNCTION get_date_range |
13 | |
14 | DESCRIPTION |
15 | A pipelined function to return all the days between a date range. |
16 | |
17 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
18 | |
19 | ARGUMENTS |
20 | IN: |
21 | p_start_date Start Date. |
22 | p_end_date End Date. |
23 | OUT: |
24 | |
25 | RETURN |
26 | A table of days within the range. |
27 | MODIFICATION HISTORY |
28 | 03-FEB-2004 Xin Wang Created. |
29 +=======================================================================*/
30
31 FUNCTION get_date_range(p_start IN DATE,
32 p_end IN DATE) RETURN t_date_table PIPELINED;
33
34
35 FUNCTION get_balance(p_date IN DATE,
36 p_accts IN acct_id_refcursor) RETURN t_balance_table PIPELINED;
37
38
39 FUNCTION get_pool_balance (p_cashpool_id IN NUMBER,
40 p_balance_date IN DATE) RETURN NUMBER;
41
42 END ce_bal_util;