PACKAGE: APPS.XTR_XTRFXEXP_XMLP_PKG

Source

1 PACKAGE XTR_XTRFXEXP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRFXEXPS.pls 120.1 2007/12/28 12:48:47 npannamp noship $ */
3   REPORT_DATE2 DATE;
4 
5   REPORT_SHORT_NAME VARCHAR2(80);
6 
7   REPORT_NOS VARCHAR2(30);
8 
9   REPORT_GROUP VARCHAR2(32767);
10 
11   USE_DEFAULTS VARCHAR2(1);
12 
13   PERIOD_FROM DATE;
14 
15   Z1AND_CALL_DEP_ADV VARCHAR2(300);
16 
17   Z2TOTAL_HEDGE VARCHAR2(300);
18 
19   Z2END_OF_REPORT VARCHAR2(300);
20 
21   Z2TOTAL_EXPOSURE VARCHAR2(300);
22 
23   Z2COVER VARCHAR2(300);
24 
25   Z2NET_EXPOSURE VARCHAR2(300);
26 
27   Z2AMOUNT_REQ VARCHAR2(300);
28 
29   Z2FOR_POLICY VARCHAR2(300);
30 
31   Z1PARAMETERS VARCHAR2(300);
32 
33   Z1COMPANY VARCHAR2(300);
34 
35   Z1CURRENCY VARCHAR2(300);
36 
37   Z2FX_OPTION VARCHAR2(300);
38 
39   Z2CCY VARCHAR2(300);
40 
41   Z2FX_SPOT_FWDS VARCHAR2(300);
42 
43   Z2CURR_AC_BALANCE VARCHAR2(300);
44 
45   Z2NOTE_ALL_AMOUNTS VARCHAR2(300);
46 
47   Z2PAGE VARCHAR2(300);
48 
49   P_SQL_TRACE VARCHAR2(32767);
50 
51   P_DISPLAY_DEBUG VARCHAR2(32767);
52 
53   P_CONC_REQUEST_ID NUMBER;
54 
55   COMPANY_NAME_HEADER VARCHAR2(80);
56 
57   REPORT_SHORT_NAME2 VARCHAR2(240);
58 
59   COMPANY_CODE2 VARCHAR2(7);
60 
61   CURRENCY_CODE2 VARCHAR2(15);
62 
63   P_COMPANY VARCHAR2(7);
64 
65   P_CURRENCY VARCHAR2(15);
66 
67   REPORT_DATE VARCHAR2(100);
68 
69   P_FACTOR VARCHAR2(10);
70 
71   AMT_UNIT2 NUMBER;
72 
73   LP_FACTOR_DESC VARCHAR2(32767);
74 
75   Z1P_FACTOR VARCHAR2(300);
76 
77   P_EXPOSURE_TYPE VARCHAR2(50);
78 
79   P_1 VARCHAR2(200);
80 
81   Z1P_EXPOSURE_TYPE VARCHAR2(300);
82 
83   P_INCLUDE_INTERCOMP VARCHAR2(1);
84 
85   Z1P_INCLUDE_IC VARCHAR2(300);
86 
87   P_EXPOSURE_TYPE_DSP VARCHAR2(100);
88 
89   P_FACTOR_DSP VARCHAR2(100);
90 
91   P_YES_NO_DSP VARCHAR2(32767);
92 
93   TOTAL_HEDGE NUMBER;
94 
95   CP_PARA VARCHAR2(30);
96 
97   FUNCTION TOTAL_HEDGE1FORMULA RETURN VARCHAR2;
98 
99   FUNCTION TOTAL_HEDGEFORMULA RETURN NUMBER;
100 
101   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
102 
103   FUNCTION BEFOREREPORT RETURN BOOLEAN;
104 
105   FUNCTION AFTERREPORT RETURN BOOLEAN;
106 
107   FUNCTION AFTERPFORM RETURN BOOLEAN;
108 
109   FUNCTION BEFOREPFORM RETURN BOOLEAN;
110 
111   FUNCTION BETWEENPAGE RETURN BOOLEAN;
112 
113   FUNCTION CF_COH_CABALFORMULA(COMPANY IN VARCHAR2
114                               ,CCY IN VARCHAR2
115                               ,CASH_ON_HAND IN NUMBER) RETURN NUMBER;
116 
117   FUNCTION CF_TEXP_IGBALFORMULA(COMPANY IN VARCHAR2
118                                ,CCY IN VARCHAR2
119                                ,TOTAL_EXP IN NUMBER) RETURN NUMBER;
120 
121   FUNCTION CF_AMT_REQFORMULA(COVER IN VARCHAR2
122                             ,MIN_HEDGE IN NUMBER
123                             ,CF_TEXP_IGBAL IN NUMBER
124                             ,MAX_HEDGE IN NUMBER
125 			    ,TOTAL_HEDGE IN NUMBER) RETURN NUMBER;
126 
127   FUNCTION TOTAL_HEDGE_P RETURN NUMBER;
128 
129   FUNCTION CP_PARA_P RETURN VARCHAR2;
130 
131 END XTR_XTRFXEXP_XMLP_PKG;
132