[Home] [Help]
PACKAGE: APPS.XTR_LIMITS_P
Source
1 PACKAGE XTR_LIMITS_P AUTHID CURRENT_USER as
2 /* $Header: xtrlmtss.pls 120.1 2005/06/29 10:28:37 badiredd ship $ */
3 ----------------------------------------------------------------------------------------------------------------
4 FUNCTION WEIGHTED_USAGE(p_deal_type VARCHAR2,
5 p_deal_subtype VARCHAR2,
6 p_amount_date DATE,
7 p_hce_amount NUMBER) RETURN NUMBER;
8 -- Calculate amount utilised for this limit code, by this cparty/company combination.
9 FUNCTION CONVERT_TO_HCE_AMOUNT(p_amount_to_convert NUMBER,
10 p_currency VARCHAR2,
11 p_company_code VARCHAR2) RETURN NUMBER;
12 -- Calculate home-currency-equivalent for p_amount_to_convert
13 FUNCTION GET_HCE_AMOUNT(p_amount_to_convert NUMBER,
14 p_currency VARCHAR2) RETURN NUMBER;
15 -- Calculate home-currency-equivalent for p_amount_to_convert
16 FUNCTION LOG_FULL_LIMITS_CHECK (
17 p_DEAL_NUMBER NUMBER,
18 p_TRANSACTION_NUMBER NUMBER,
19 p_COMPANY_CODE VARCHAR2,
20 p_DEAL_TYPE VARCHAR2,
21 p_DEAL_SUBTYPE VARCHAR2,
22 p_CPARTY_CODE VARCHAR2,
23 p_PRODUCT_TYPE VARCHAR2,
24 p_LIMIT_CODE VARCHAR2,
25 p_LIMIT_PARTY VARCHAR2,
26 p_AMOUNT_DATE DATE,
27 p_AMOUNT NUMBER,
28 p_DEALER_CODE VARCHAR2,
29 p_CURRENCY VARCHAR2,
30 p_CURRENCY_SECOND VARCHAR2 DEFAULT NULL) return number;
31 -- Second currency and amount incase of FX deals added for bug 1289530
32 -- Update limit excess log
33 PROCEDURE UPDATE_LIMIT_EXCESS_LOG ( p_deal_no NUMBER,
34 p_trans_no NUMBER,
35 p_user VARCHAR2,
36 p_log_id NUMBER);
37 -- Recalculate all limit hce amts / weightings
38 PROCEDURE CALC_ALL_MIRROR_DDA_LIMIT_ROW(p_auto_recalc VARCHAR2);
39 -- Cover routine so CALC_ALL_MIRROR_DDA_LIMIT can be called as a concurrent
40 -- program.
41 PROCEDURE update_weightings (
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY NUMBER);
44 -- Calculate the utilised_amount field for all dda mirror rows.
45 PROCEDURE MIRROR_DDA_LIMIT_ROW_PROC (
46 p_action VARCHAR2,
47 p_old_LIMIT_CODE VARCHAR2,
48 p_old_DEAL_NUMBER NUMBER,
49 p_old_TRANSACTION_NUMBER NUMBER,
50 p_new_product_type VARCHAR2,
51 p_new_COMPANY_CODE VARCHAR2,
52 p_new_LIMIT_PARTY VARCHAR2,
53 p_new_LIMIT_CODE VARCHAR2,
54 p_new_AMOUNT_DATE DATE,
55 p_new_AMOUNT NUMBER,
56 p_new_HCE_AMOUNT NUMBER,
57 p_new_DEALER_CODE VARCHAR2,
58 p_new_DEAL_NUMBER NUMBER,
59 p_new_DEAL_TYPE VARCHAR2,
60 p_new_TRANSACTION_NUMBER NUMBER,
61 p_new_DEAL_SUBTYPE VARCHAR2,
62 p_new_PORTFOLIO_CODE VARCHAR2,
63 p_new_STATUS_CODE VARCHAR2,
64 p_new_currency VARCHAR2,
65 p_amount_type VARCHAR2,
66 p_transaction_rate NUMBER,
67 p_currency_combination VARCHAR2,
68 p_account_no VARCHAR2,
69 p_commence_date DATE);
70 -- This procedure is called by a DB trigger on table DDA whenever a DDA record is
71 -- UPDATED/DELETED/INSERTED. This procedure has two purposes:
72 -- 1) maintain a mirror of the non-null-limit-code DDA records in table mirror_dda_limit_row.
73 -- 2) calculate and store the current limit usage amount for each mirror record whenever a
74 -- mirror row is inserted/updated.
75 PROCEDURE GET_LIM_GLOBAL ( p_deal_no NUMBER,
76 p_company_code VARCHAR2,
77 p_limit_code VARCHAR2,
78 p_limit_amt OUT NOCOPY number,
79 p_util_amt OUT NOCOPY number,
80 p_err_code OUT NOCOPY varchar2);
81 PROCEDURE GET_LIM_GROUP ( p_deal_no NUMBER,
82 p_company_code VARCHAR2,
83 p_limit_type VARCHAR2,
84 p_group_party VARCHAR2,
85 p_limit_amt OUT NOCOPY number,
86 p_util_amt OUT NOCOPY number,
87 p_err_code OUT NOCOPY varchar2);
88 PROCEDURE GET_LIM_SOVEREIGN ( p_deal_no NUMBER,
89 p_company_code VARCHAR2,
90 p_country_code VARCHAR2,
91 p_limit_amt OUT NOCOPY number,
92 p_util_amt OUT NOCOPY number,
93 p_err_code OUT NOCOPY varchar2);
94 PROCEDURE GET_LIM_DEALER_DEAL ( p_deal_no NUMBER,
95 p_dealer_code VARCHAR2,
96 p_deal_type VARCHAR2,
97 p_product_type VARCHAR2,
98 p_limit_amt OUT NOCOPY number,
99 p_err_code OUT NOCOPY varchar2);
100 PROCEDURE GET_LIM_INTRA_DAY ( p_deal_no NUMBER,
101 p_dealer_code VARCHAR2,
102 p_deal_type VARCHAR2,
103 p_limit_amt OUT NOCOPY number,
104 p_util_amt OUT NOCOPY number,
105 p_err_code OUT NOCOPY varchar2);
106 PROCEDURE GET_LIM_CPARTY ( p_deal_no NUMBER,
107 p_company_code VARCHAR2,
108 p_cparty_code VARCHAR2,
109 p_limit_code VARCHAR2,
110 p_limit_amt OUT NOCOPY number,
111 p_util_amt OUT NOCOPY number,
112 p_err_code OUT NOCOPY varchar2);
113 PROCEDURE GET_ACTUAL_SETTLE_EXCESS ( p_deal_no NUMBER,
114 p_company_code VARCHAR2,
115 p_limit_party VARCHAR2,
116 p_amount_date DATE,
117 p_limit_amt OUT NOCOPY number,
118 p_util_amt OUT NOCOPY number,
119 p_err_code OUT NOCOPY varchar2);
120 PROCEDURE GET_LIM_SETTLE ( p_deal_no NUMBER,
121 p_company_code VARCHAR2,
122 p_limit_party VARCHAR2,
123 p_amount_date DATE,
124 p_limit_amt OUT NOCOPY number,
125 p_util_amt OUT NOCOPY number,
126 p_err_code OUT NOCOPY varchar2);
127 PROCEDURE GET_LIM_CCY ( p_deal_no NUMBER,
128 p_currency VARCHAR2,
129 p_limit_amt OUT NOCOPY number,
130 p_util_amt OUT NOCOPY number,
131 p_err_code OUT NOCOPY varchar2);
132 PROCEDURE MAINTAIN_EXCESS_LOG( p_log_id NUMBER,
133 p_action VARCHAR2,
134 p_user VARCHAR2);
135 -- Procedure to update all limits table with the most up-to-date information
136 -- from XTR_MIRROR_DDA_LIMIT_ROW_V
137 PROCEDURE reinitialize_limits (
138 errbuf OUT NOCOPY VARCHAR2,
139 retcode OUT NOCOPY NUMBER);
140 --------------------------------------------------------------------------------------------------------------------
141 end XTR_LIMITS_P;