1 PACKAGE Xtr_Settlement_Summary_P AUTHID CURRENT_USER AS
2 /* $Header: xtrsetls.pls 120.0.12010000.2 2008/08/06 10:44:38 srsampat ship $ */
3 --
4 -- Stored procedures/functions for settlements
5 --
6
7
8 Procedure INS_SETTLEMENT_SUMMARY(p_settlement_number IN Number,
9 p_company IN VARCHAR2,
10 p_currency IN VARCHAR2,
11 p_settlement_amount IN Number,
12 p_settlement_date IN Date,
13 p_company_acct_no IN Varchar2,
14 p_cparty_acct_no IN Varchar2,
15 p_net_ID IN Number,
16 p_status IN Varchar2,
17 p_created_by IN Number,
18 p_creation_date IN Date,
19 p_external_source IN Varchar2,
20 p_cparty_code IN Varchar2, -- bug 3832387
21 p_settlement_ID OUT NOCOPY Number );
22
23 Procedure UPD_SETTLEMENT_SUMMARY(p_flag IN Char,
24 p_netoff_number IN number,
25 p_settlement_ID IN Number);
26
27 Procedure UPD_Settlement_Summary(p_flag IN Char,
28 p_netoff_number IN Number,
29 p_settlement_ID IN Number,
30 p_amount IN Number);
31
32 Procedure UPD_Settlement_Summary(p_settlement_number IN Number,
33 p_amount IN Number);
34
35 Procedure DEL_SETTLEMENT_SUMMARY(p_settle_date IN Date,
36 p_currency IN Varchar2,
37 p_acct_no IN Varchar2,
38 p_cpacct_no IN Varchar2,
39 p_company_code IN Varchar2,
40 p_flag IN Char,
41 p_return OUT NOCOPY Char);
42
43 Procedure DEL_SETTLEMENT_SUMMARY(p_settlement_number IN Number,
44 p_settlement_amount IN Number);
45
46 Procedure Include_Settlement_Group(p_settlement_number IN Number,
47 p_netoff_number IN Number,
48 p_company IN Varchar2,
49 p_currency IN Varchar2,
50 p_settlement_amount IN Number,
51 p_settlement_date IN Date,
52 p_company_acct_no IN Varchar2,
53 p_cparty_acct_no IN Varchar2,
54 p_created_by IN Number,
55 p_creation_date IN Date,
56 p_cparty_code IN Varchar2); -- bug 3832387
57
58 END;
59