eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ONT_OEXCEXP_XMLP_PKG

Source


1 PACKAGE ONT_OEXCEXP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXCEXPS.pls 120.1.12020000.2 2012/07/03 09:48:29 amallik ship $ */
3   P_CUSTOMER_NAME_HIGH VARCHAR2(360);
4 
5   P_CUSTOMER_NAME_LOW VARCHAR2(360);
6 
7   P_CUST_NUMBER_HIGH VARCHAR2(30);
8 
9   P_CUST_NUMBER_LOW VARCHAR2(30);
10 
11   P_CR_CHECK_RULE_ID NUMBER;
12 
13   P_PROF_CLASS_LOW VARCHAR2(40);
14 
15   P_PROF_CLASS_HIGH VARCHAR2(40);
16 
17   P_CONC_REQUEST_ID NUMBER;
18 
19   P_ORG_ID NUMBER;
20 
21   P_ORDER_BY VARCHAR2(40) := ' '; -- 13009506
22 
23   P_RETURN_STATUS VARCHAR2(1);
24 
25   P_REPORT_BY_OPTION VARCHAR2(30);
26 
27   P_SPECIFIC_PARTY_ID NUMBER;
28 
29   P_SPEC_PARTY_NUM_ID NUMBER;
30 
31   P_PARTY_NAME_LOW VARCHAR2(360);
32 
33   P_PARTY_NAME_HIGH VARCHAR2(360);
34 
35   P_PARTY_NUMBER_LOW VARCHAR2(30);
36 
37   P_PARTY_NUMBER_HIGH VARCHAR2(30);
38 
39   P_PARTY_NAME VARCHAR2(360);
40 
41   CP_TOTAL_EXPOSURE NUMBER;
42 
43   CP_BASE_CURRENCY VARCHAR2(5);
44 
45   CP_CUST_LIMIT_GRAND_TOTAL NUMBER;
46 
47   CP_CUST_EXPOSURE_GRAND_TOTAL NUMBER;
48 
49   CP_CUST_AVAILABLE_GRAND_TOTAL NUMBER;
50 
51   CP_SITE_TOTAL_EXPOSURE NUMBER;
52 
53   CP_BASE_CURRENCY1 VARCHAR2(5);
54 
55   CP_UNCHECKED_EXPOSURE NUMBER;
56 
57   CP_PARTY_EXP_GRAND_TOTAL NUMBER;
58 
59   CP_PARTY_BASE_CURRENCY VARCHAR2(15);
60 
61   CP_PARTY_NAME_TOTAL_EXP VARCHAR2(360);
62 
63   CP_PARTY_NAME_UNCHECK VARCHAR2(360);
64 
65   CP_PARTY_SUM_GRAND_AVAIL NUMBER := 0;
66 
67   CP_BASE_CURRENCY_D VARCHAR2(30);
68 
69   CP_EXPOSURE_TOTAL_D NUMBER;
70 
71   CP_PARTY_DTL_GRAND_TOTAL_AVAIL NUMBER := 0;
72 
73   CP_BASE_CURRENCY_CUST VARCHAR2(30);
74 
75   CP_TOTAL_UNCHECKED_EXP_CUST NUMBER := 0;
76 
77   CP_TOTAL_AVAIL_PARTY_CUST NUMBER;
78 
79   CP_EXP_AND_UNCHECKED NUMBER;
80 
81   CP_CUSTOMER_LOW VARCHAR2(380);
82 
83   CP_CUSTOMER_HIGH VARCHAR2(380);
84 
85   CP_PROF_CLASS_LOW VARCHAR2(30);
86 
87   CP_PROF_CLASS_HIGH VARCHAR2(30);
88 
89   CP_CUST_NUM_LOW VARCHAR2(30);
90 
91   CP_CUST_NUM_HIGH VARCHAR2(30);
92 
93   CP_OPERATING_UNIT VARCHAR2(240);
94 
95   CP_REPORT_OPTION VARCHAR2(80);
96 
97   CP_HIERARCHY_NAME VARCHAR2(200);
98 
99   CP_PARTY_NAME VARCHAR2(360);
100 
101   CP_PARTY_NUMBER VARCHAR2(30);
102 
103   CP_CHECK_RULE VARCHAR2(240);
104 
105   RP_COMPANY_NAME VARCHAR2(240);
106 
107   FUNCTION CF_GET_RULE_NAMEFORMULA RETURN NUMBER;
108 
109   FUNCTION BEFOREREPORT RETURN BOOLEAN;
110 
111   FUNCTION CF_GET_TOTAL_EXPOSUREFORMULA(CS_BASE_EXPOSURE_SUM IN NUMBER
112                                        ,UNCHECKED_EXPOSURE IN NUMBER) RETURN NUMBER;
113 
114   FUNCTION CF_GET_OPER_UNITFORMULA RETURN NUMBER;
115 
116   FUNCTION CF_GET_BASE_CURRFORMULA(BASE_CURRENCY2 IN VARCHAR2) RETURN NUMBER;
117 
118   FUNCTION CF_GET_SITE_TOTAL_EXPFORMULA(CS_SITE_EXPOSURE_SUM IN NUMBER
119                                        ,D_UNCHECKED_EXPOSURE IN NUMBER) RETURN NUMBER;
120 
121   FUNCTION CF_GET_BASE_CURRENCY1FORMULA(D_BASE_CURRENCY IN VARCHAR2) RETURN NUMBER;
122 
123   FUNCTION AFTERREPORT RETURN BOOLEAN;
124 
125   FUNCTION CF_GET_LIMIT_G_TOTALFORMULA(D_CUSTOMER_ID IN NUMBER) RETURN NUMBER;
126 
127   FUNCTION CF_GET_EXP_G_TOTALFORMULA(D_CUSTOMER_ID IN NUMBER) RETURN NUMBER;
128 
129   FUNCTION CF_GET_AVAIL_G_TOTALFO(D_CUSTOMER_ID IN NUMBER) RETURN NUMBER;
130 
131   FUNCTION AFTERPFORM RETURN BOOLEAN;
132 
133   FUNCTION CF_PARTY_GET_TOTALSFORMULA(CS_PARTY_BASE_CUR_EXPOSURE_SUM IN NUMBER
134                                      ,UNCHECKED_EXPOSURE_P IN NUMBER) RETURN NUMBER;
135 
136   FUNCTION CF_GET_PARTY_BASE_CURRENCYFORM(BASE_CURRENCY_P IN VARCHAR2) RETURN NUMBER;
137 
138   FUNCTION CF_GET_REPORT_OPTIONFORMULA RETURN NUMBER;
139 
140   FUNCTION CF_GET_BASE_CUR_DFORMULA(BASE_CURRENCY_D IN VARCHAR2) RETURN NUMBER;
141 
142   FUNCTION CF_GET_EXPOSURE_TOTAL_DFORMULA(CS_EXPOSURE_SUM_D IN NUMBER
143                                          ,UNCHECKED_EXPOSURE_D IN NUMBER) RETURN NUMBER;
144 
145   FUNCTION CF_GET_HIERARCHY_NAMEFORMULA RETURN NUMBER;
146 
147   FUNCTION CF_GET_B_CURRENCY_CUSTFORMULA(BASE_CURRENCY_CUST IN VARCHAR2) RETURN NUMBER;
148 
149   FUNCTION CF_GET_EXP_AND_UNCHFORMULA(BASE_EXPOSURE_CUST IN NUMBER) RETURN NUMBER;
150 
151   FUNCTION CF_GET_PARTY_NAME_TOTALFORMULA(PARTY_NAME IN VARCHAR2) RETURN NUMBER;
152 
153   FUNCTION CF_GET_PARTY_NAME_UNFORMULA(PARTY_NAME IN VARCHAR2) RETURN NUMBER;
154 
155   FUNCTION CF_GET_PARTY_NAMEFORMULA RETURN NUMBER;
156 
157   PROCEDURE GET_HIERARCHY;
158 
159   FUNCTION CF_TOTAL_UNCHECKED_EXP_CUSTFOR(CS_TOTAL_EXP_AND_UNCH IN NUMBER
160                                          ,UNCHECKED_EXPOSURE_CUST IN NUMBER) RETURN NUMBER;
161 
162   FUNCTION CF_TOTAL_AVAIL_PARTY_CUSTFORMU(CS_TOTAL_OVERALL_CUST IN NUMBER) RETURN NUMBER;
163 
164   FUNCTION CF_PARTY_SUM_GRAND_AVAILFORMUL(CS_PARTY_BASE_CUR_OVERALL_SUM IN NUMBER) RETURN NUMBER;
165 
166   FUNCTION CF_PARTY_DTL_GRAND_TOTAL_AVAIL(CS_OVERALL_LIMIT_SUM_D IN NUMBER) RETURN NUMBER;
167 
168   FUNCTION CP_PARTY_NAMEFORMULA RETURN CHAR;
169 
170   FUNCTION CP_TOTAL_EXPOSURE_P RETURN NUMBER;
171 
172   FUNCTION CP_BASE_CURRENCY_P RETURN VARCHAR2;
173 
174   FUNCTION CP_CUST_LIMIT_GRAND_TOTAL_P RETURN NUMBER;
175 
176   FUNCTION CP_CUST_EXPOSURE_GRAND_TOTAL_P RETURN NUMBER;
177 
178   FUNCTION CP_CUST_AVAILABLE_GRAND_TOT_P RETURN NUMBER;
179 
180   FUNCTION CP_SITE_TOTAL_EXPOSURE_P RETURN NUMBER;
181 
182   FUNCTION CP_BASE_CURRENCY1_P RETURN VARCHAR2;
183 
184   FUNCTION CP_UNCHECKED_EXPOSURE_P RETURN NUMBER;
185 
186   FUNCTION CP_PARTY_EXP_GRAND_TOTAL_P RETURN NUMBER;
187 
188   FUNCTION CP_PARTY_BASE_CURRENCY_P RETURN VARCHAR2;
189 
190   FUNCTION CP_PARTY_NAME_TOTAL_EXP_P RETURN VARCHAR2;
191 
192   FUNCTION CP_PARTY_NAME_UNCHECK_P RETURN VARCHAR2;
193 
194   FUNCTION CP_PARTY_SUM_GRAND_AVAIL_P RETURN NUMBER;
195 
196   FUNCTION CP_BASE_CURRENCY_D_P RETURN VARCHAR2;
197 
198   FUNCTION CP_EXPOSURE_TOTAL_D_P RETURN NUMBER;
199 
200   FUNCTION CP_PARTY_DTL_GRAND_TOTAL_AVAI RETURN NUMBER;
201 
202   FUNCTION CP_BASE_CURRENCY_CUST_P RETURN VARCHAR2;
203 
204   FUNCTION CP_TOTAL_UNCHECKED_EXP_CUST_P RETURN NUMBER;
205 
206   FUNCTION CP_TOTAL_AVAIL_PARTY_CUST_P RETURN NUMBER;
207 
208   FUNCTION CP_EXP_AND_UNCHECKED_P RETURN NUMBER;
209 
210   FUNCTION CP_CUSTOMER_LOW_P RETURN VARCHAR2;
211 
212   FUNCTION CP_CUSTOMER_HIGH_P RETURN VARCHAR2;
213 
214   FUNCTION CP_PROF_CLASS_LOW_P RETURN VARCHAR2;
215 
216   FUNCTION CP_PROF_CLASS_HIGH_P RETURN VARCHAR2;
217 
218   FUNCTION CP_CUST_NUM_LOW_P RETURN VARCHAR2;
219 
220   FUNCTION CP_CUST_NUM_HIGH_P RETURN VARCHAR2;
221 
222   FUNCTION CP_OPERATING_UNIT_P RETURN VARCHAR2;
223 
224   FUNCTION CP_REPORT_OPTION_P RETURN VARCHAR2;
225 
226   FUNCTION CP_HIERARCHY_NAME_P RETURN VARCHAR2;
227 
228   FUNCTION CP_PARTY_NAME_P RETURN VARCHAR2;
229 
230   FUNCTION CP_PARTY_NUMBER_P RETURN VARCHAR2;
231 
232   FUNCTION CP_CHECK_RULE_P RETURN VARCHAR2;
233 
234   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
235 
236   FUNCTION M_HIERARCHYFORMATTRIGGER RETURN VARCHAR2;
237 
238   FUNCTION M_9FORMATTRIGGER RETURN NUMBER;
239 
240   FUNCTION M_6FORMATTRIGGER RETURN VARCHAR2;
241 
242   END ONT_OEXCEXP_XMLP_PKG;
243