DBA Data[Home] [Help]

PACKAGE: APPS.CE_INTEREST_SCHED_PKG

Source


1 PACKAGE CE_INTEREST_SCHED_PKG AUTHID CURRENT_USER AS
2 /* $Header: ceintscs.pls 120.1 2005/07/29 20:38:20 lkwan ship $ */
3 
4 --l_DEBUG varchar2(1);
5 PROCEDURE  xtr_schedule_update(p_ce_bank_account_id 	IN 	number,
6 			   	p_interest_rounding 	IN 	varchar2,
7 				p_interest_includes 	IN 	varchar2,
8 				p_basis 		IN 	varchar2,
9 				p_day_count_basis 	IN 	varchar2,
10 				x_return_status 	OUT NOCOPY varchar2,
11 				x_msg_count	 	OUT NOCOPY number,
12 				x_msg_data	 	OUT NOCOPY varchar2
13 			  );
14 
15 PROCEDURE  remove_schedule_account(p_interest_schedule_id IN	number,
16 				   p_bank_account_id 	  IN	number,
17 			      	   x_return_status        IN OUT NOCOPY VARCHAR2,
18     			      	   x_msg_count               OUT NOCOPY NUMBER,
19 			      	   x_msg_data                OUT NOCOPY VARCHAR2
20 				);
21 
22 PROCEDURE  assign_schedule_account(p_interest_schedule_id IN 	number,
23 				   p_bank_account_id 	  IN	number,
24 			   	   p_basis 		  IN 	varchar2,
25 			   	   p_interest_includes 	  IN 	varchar2,
26 			   	   p_interest_rounding 	  IN 	varchar2,
27 			  	   p_day_count_basis 	  IN 	varchar2,
28 			      	   x_return_status        IN OUT NOCOPY VARCHAR2,
29     			      	   x_msg_count               OUT NOCOPY NUMBER,
30 			      	   x_msg_data                OUT NOCOPY VARCHAR2
31 				);
32 
33 
34 PROCEDURE  delete_interest_rates(p_interest_schedule_id number,
35 				 p_effective_date 	date);
36 
37 PROCEDURE  delete_bal_ranges(p_interest_schedule_id number);
38 
39 PROCEDURE  delete_schedule(p_interest_schedule_id IN	number,
40 			   x_return_status	  IN OUT NOCOPY VARCHAR2,
41     			   x_msg_count      	     OUT NOCOPY NUMBER,
42 			   x_msg_data       	     OUT NOCOPY VARCHAR2
43 				);
44 
45 
46 PROCEDURE  update_schedule(p_interest_schedule_id IN 	number,
47 			   p_basis 		  IN 	varchar2,
48 			   p_interest_includes 	  IN 	varchar2,
49 			   p_interest_rounding 	  IN 	varchar2,
50 			   p_day_count_basis 	  IN 	varchar2,
51 			   x_return_status	  IN OUT NOCOPY VARCHAR2,
52     			   x_msg_count      	     OUT NOCOPY NUMBER,
53 			   x_msg_data       	     OUT NOCOPY VARCHAR2
54 			  );
55 
56 
57 END CE_INTEREST_SCHED_PKG;