PACKAGE: APPS.CE_LEVELING_UTILS

Source

1 PACKAGE CE_LEVELING_UTILS AUTHID CURRENT_USER as
2 /* $Header: celutils.pls 120.4 2006/05/05 11:27:17 svali ship $ */
3 
4 PROCEDURE Generate_Button(p_as_of_date		DATE,
5 			p_accept_limit_error	VARCHAR2,
6 			p_run_id VARCHAR2);
7 
8 PROCEDURE Cash_Leveling (errbuf			OUT NOCOPY VARCHAR2,
9 			retcode			OUT NOCOPY NUMBER,
10 			p_as_of_date		IN VARCHAR2,
11 			p_accept_limit_error 	IN VARCHAR2,
12 			p_run_id VARCHAR2);
13 
14 PROCEDURE Generate_Fund_Transfer (X_from_bank_account_id	NUMBER,
15 			 	X_to_bank_account_id		NUMBER,
16 				X_cashpool_id			NUMBER,
17 				X_amount			NUMBER,
18 				X_transfer_date			DATE,
19 				X_settlement_authorized		VARCHAR2,
20 				X_accept_limit_error		VARCHAR2,
21 				X_request_id			NUMBER,
22 				X_deal_type	OUT NOCOPY	VARCHAR2,
23 				X_deal_no	OUT NOCOPY	NUMBER,
24 				X_trx_number	OUT NOCOPY	NUMBER,
25 				X_offset_deal_no OUT NOCOPY	NUMBER,
26 				X_offset_trx_number OUT NOCOPY	NUMBER,
27 				X_success_flag 	OUT NOCOPY	VARCHAR2,
28 				X_statement_line_id		NUMBER,
29 				X_msg_count	OUT NOCOPY	NUMBER,
30 				X_cashflows_created_flag OUT NOCOPY VARCHAR2,
31 				X_called_by_flag		VARCHAR2);
32 
33 PROCEDURE Populate_Nested_Accounts(p_parent_cashpool_id NUMBER,
34 				p_cashpool_id NUMBER);
35 
36 PROCEDURE Delete_Sub_Accounts(p_cashpool_id NUMBER);
37 
38 PROCEDURE Update_Parent_Nested_Accounts(p_cashpool_id NUMBER,
39 				p_parent_cashpool_id NUMBER);
40 
41 PROCEDURE Populate_Target_Balances(p_bank_account_id	NUMBER,
42 				p_min_target_balance	NUMBER,
43 				p_max_target_balance 	NUMBER,
44 				p_min_payment_amt	NUMBER,
45 				p_min_receipt_amt	NUMBER,
46 				p_round_factor		VARCHAR2,
47 				p_round_rule		VARCHAR2);
48 
49 PROCEDURE Populate_BAT_Payment_Details(p_bank_account_id	NUMBER,
50 				p_payment_method_code		VARCHAR2,
51 				p_bank_charge_bearer_code	VARCHAR2,
52 				p_payment_reason_code		VARCHAR2,
53 				p_payment_reason_comments	VARCHAR2,
54 				p_remittance_message1		VARCHAR2,
55 				p_remittance_message2		VARCHAR2,
56 				p_remittance_message3		VARCHAR2);
57 
58 PROCEDURE Update_Bank_Account_Id(p_old_bank_account_id	NUMBER,
59 				p_new_bank_account_id	NUMBER);
60 
61 FUNCTION Match_Cashpool(p_header_bank_account_id	IN NUMBER,
62                     	p_offset_bank_account_num	IN VARCHAR2,
63                     	p_trx_type 			IN VARCHAR2,
64                     	p_trx_date			IN DATE,
65                     	p_offset_bank_account_id 	OUT NOCOPY NUMBER,
66                     	p_cashpool_id            	OUT NOCOPY NUMBER)
67 		RETURN BOOLEAN;
68 
69 END CE_LEVELING_UTILS;