DBA Data[Home] [Help]

PACKAGE: APPS.XTR_CASHPOOL_UTLS

Source


1 PACKAGE XTR_CASHPOOL_UTLS AUTHID CURRENT_USER as
2 /* $Header: xtrpools.pls 120.0.12010000.2 2008/08/06 10:43:59 srsampat ship $ */
3 
4 PROCEDURE INSERT_IAC_CASHPOOL (p_cashpool_id 	NUMBER,
5 			       p_party_code	VARCHAR2,
6 			       p_iac_portfolio  VARCHAR2,
7 			       p_iac_product_type VARCHAR2);
8 
9 PROCEDURE INSERT_IG_CASHPOOL (p_cashpool_id    NUMBER,
10                               p_portfolio  VARCHAR2,
11                               p_product_type VARCHAR2,
12 			      p_rounding_type VARCHAR2,
13 			      p_day_count_type VARCHAR2,
14 			      p_pricing_model  VARCHAR2,
15 		              p_fund_limit	VARCHAR2,
16 			      p_invest_limit	VARCHAR2,
17 			      p_party_code	VARCHAR2,
18 			      p_party_portfolio VARCHAR2,
19 			      p_party_product_type	VARCHAR2,
20 			      p_party_pricing_model	VARCHAR2,
21 			      p_party_fund_limit	VARCHAR2,
22 			      p_party_invest_limit	VARCHAR2);
23 
24 PROCEDURE UPDATE_IAC_CASHPOOL (p_cashpool_id    NUMBER,
25                                p_iac_portfolio  VARCHAR2,
26                                p_iac_product_type VARCHAR2);
27 
28 PROCEDURE UPDATE_IG_CASHPOOL (p_cashpool_id    NUMBER,
29                               p_portfolio  VARCHAR2,
30                               p_product_type VARCHAR2,
31                               p_rounding_type VARCHAR2,
32                               p_day_count_type VARCHAR2,
33                               p_pricing_model  VARCHAR2,
34                               p_fund_limit      VARCHAR2,
35                               p_invest_limit    VARCHAR2,
36                               p_party_code      VARCHAR2,
37                               p_party_portfolio VARCHAR2,
38                               p_party_product_type      VARCHAR2,
39                               p_party_pricing_model     VARCHAR2,
40                               p_party_fund_limit        VARCHAR2,
41                               p_party_invest_limit      VARCHAR2);
42 
43 PROCEDURE UPDATE_IG_ROW_CASHPOOL (p_cashpool_id    NUMBER,
44                               p_fund_limit      VARCHAR2,
45                               p_invest_limit    VARCHAR2,
46                               p_party_code      VARCHAR2,
47                               p_party_portfolio VARCHAR2,
48                               p_party_product_type      VARCHAR2,
49                               p_party_pricing_model     VARCHAR2,
50                               p_party_fund_limit        VARCHAR2,
51                               p_party_invest_limit      VARCHAR2);
52 
53 PROCEDURE DELETE_XTR_CASHPOOL (p_cashpool_id NUMBER,
54 			       p_party_code VARCHAR2);
55 
56 PROCEDURE DEFAULT_IAC_IG_ATTRIBUTES (p_company_code NUMBER,
57                                      x_iac_portfolio OUT NOCOPY VARCHAR2,
58                                      x_iac_product_type OUT NOCOPY VARCHAR2,
59                                      x_portfolio OUT NOCOPY VARCHAR2,
60                                      x_product_type OUT NOCOPY VARCHAR2,
61                                      x_rounding_type OUT NOCOPY VARCHAR2,
62                                      x_day_count_type OUT NOCOPY VARCHAR2,
63                                      x_pricing_model OUT NOCOPY VARCHAR2);
64 END XTR_CASHPOOL_UTLS;