[Home] [Help]
PACKAGE: APPS.CE_LEVELING_UTILS
Source
1 PACKAGE CE_LEVELING_UTILS 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;