PACKAGE: APPS.CE_INTEREST_CALC

Source

1 PACKAGE CE_INTEREST_CALC AUTHID CURRENT_USER AS
2 /* $Header: ceintcas.pls 120.2 2005/08/26 20:26:57 lkwan ship $ */
3 
4 --l_DEBUG varchar2(1);
5 
6 FUNCTION ROUNDUP(p_amount NUMBER,
7 		 p_round_factor NUMBER) RETURN NUMBER;
8 
9 FUNCTION get_interest_rate( p_bank_account_id IN NUMBER,
10 				p_balance_date   IN DATE,
11 				p_balance_amount IN NUMBER,
12 				p_interest_rate  IN OUT NOCOPY NUMBER ) RETURN NUMBER;
13 
14 PROCEDURE  delete_schedule_account( p_interest_schedule_id number,
15 				    p_bank_account_id 	   number,
16  				    p_interest_acct_type   varchar2,
17 				    p_cashpool_id  	   number
18 
19 					);
20 
21 PROCEDURE  get_balance_info(    p_from_date 		date,
22 				p_to_date 		date,
23 				p_interest_schedule_id 	number,
24 				p_bank_account_id 	number,
25  				p_interest_acct_type 	varchar2,
26 				p_cashpool_id  		number,
27 				p_row_count OUT NOCOPY  NUMBER);
28 
29 PROCEDURE  get_balance_pool_info(    p_from_date 		date,
30 				p_to_date 		date,
31 				p_interest_schedule_id 	number,
32 				p_bank_account_id 	number,
33  				p_interest_acct_type 	varchar2,
34 				p_cashpool_id  		number,
35 				p_row_count OUT NOCOPY  NUMBER);
36 
37 PROCEDURE  get_interest_info(  p_from_date 		date,
38 				p_to_date 		date,
39 				p_interest_schedule_id 	number,
40 				p_bank_account_id 	number,
41  				p_interest_acct_type 	varchar2,
42 				p_cashpool_id  		number,
43 				p_row_count OUT NOCOPY  NUMBER);
44 
45 PROCEDURE  get_interest_pool_info(  p_from_date 		date,
46 				p_to_date 		date,
47 				p_interest_schedule_id 	number,
48 				p_bank_account_id 	number,
49  				p_interest_acct_type 	varchar2,
50 				p_cashpool_id  		number,
51 				p_row_count OUT NOCOPY  NUMBER);
52 
53 PROCEDURE  set_end_date(  p_from_date 			date,
54 				p_to_date 		date,
55 				p_interest_schedule_id 	number,
56 				p_bank_account_id 	number ,
57 				p_interest_acct_type 	varchar2,
58 				p_cashpool_id  		number
59 				);
60 
61 PROCEDURE  set_int_rate(  	p_from_date 		date,
62 				p_to_date 		date,
63 				p_interest_schedule_id 	number,
64 				p_bank_account_id 	number,
65  				p_interest_acct_type 	varchar2,
66 				p_interest_rate		number
67 			);
68 
69 PROCEDURE  set_range_and_rate(  p_from_date 			date,
70 				p_to_date 		date,
71 				p_interest_schedule_id 	number,
72 				p_bank_account_id 	number ,
73 				p_interest_acct_type 	varchar2,
74 				p_cashpool_id  		number
75 				);
76 
77 PROCEDURE  calculate_interest(  p_from_date 		date,
78 				p_to_date 		date,
79 				p_interest_schedule_id 	number,
80 				p_bank_account_id 	number,
81  				p_interest_acct_type 	varchar2,
82 				p_cashpool_id  		number
83 				);
84 
85 PROCEDURE  int_cal_detail_main( p_from_date 		date,
86 				p_to_date 		date,
87 				p_interest_schedule_id 	number,
88 				p_bank_account_id 	number,
89 				p_interest_acct_type 	varchar2,
90 				p_cashpool_id  		number);
91 
92 PROCEDURE  int_cal_xtr( p_from_date 		IN	date,
93 			p_to_date  		IN	date,
94 			p_bank_account_id  	IN	number,
95 			p_interest_rate   	IN      NUMBER,
96 			p_interest_acct_type 	IN      varchar2,
97 			p_interest_amount	OUT NOCOPY number);
98 
99 END CE_INTEREST_CALC;