PACKAGE: APPS.XTR_XTRDDHTY_XMLP_PKG

Source

1 PACKAGE XTR_XTRDDHTY_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRDDHTYS.pls 120.1 2007/12/28 12:47:16 npannamp noship $ */
3   P_COMPANY VARCHAR2(7);
4 
5   P_RISK_TYPE VARCHAR2(30);
6 
7   P_HEDGE_TYPE VARCHAR2(30);
8 
9   P_OBJECTIVE VARCHAR2(30);
10 
11   P_STRATEGY VARCHAR2(30);
12 
13   P_HEDGE_STATUS VARCHAR2(30);
14 
15   P_AS_OF_DATE VARCHAR2(40);
16   P_AS_OF_DATE_1 VARCHAR2(40);
17 
18   REPORT_NAME VARCHAR2(300);
19 
20   P_CONC_REQUEST_ID NUMBER;
21 
22   RP_COMPANY_NAME VARCHAR2(32767);
23 
24   RP_HEDGE_STATUS VARCHAR2(80);
25 
26   RP_STRATEGY_NAME VARCHAR2(80);
27 
28   Z1AMOUNT VARCHAR2(300);
29 
30   Z1AS_OF_DATE VARCHAR2(300);
31 
32   Z1CCY VARCHAR2(300);
33 
34   Z1COMPANY VARCHAR2(300);
35 
36   Z1DER_DISCL VARCHAR2(300);
37 
38   Z1END_DATE VARCHAR2(300);
39 
40   Z1EQUI VARCHAR2(300);
41 
42   Z1FACTOR VARCHAR2(300);
43 
44   Z1HEDGE VARCHAR2(300);
45 
46   Z1HEDGE_INST VARCHAR2(300);
47 
48   Z1HEDGE_ITEM VARCHAR2(300);
49 
50   Z1HEDGE_TYPE VARCHAR2(300);
51 
52   Z1HSTGY_TOTAL VARCHAR2(300);
53 
54   Z1HTYPE_TOTAL VARCHAR2(300);
55 
56   Z1NUMBER VARCHAR2(300);
57 
58   Z1OBJECTIVE VARCHAR2(300);
59 
60   Z1OBJECTIVE_DESC VARCHAR2(300);
61 
62   Z1PARAMETERS VARCHAR2(300);
63 
64   Z1POLICY_REF VARCHAR2(300);
65 
66   Z1RISK_TYPE VARCHAR2(300);
67 
68   Z1START_DATE VARCHAR2(300);
69 
70   Z1STRATEGY VARCHAR2(300);
71 
72   Z1STRATEGY_NAME VARCHAR2(300);
73 
74   Z2END_OF_REPORT VARCHAR2(300);
75 
76   Z2HEDGE_STATUS VARCHAR2(300);
77 
78   Z2NO_DATA_FOUND VARCHAR2(300);
79 
80   Z2STRATEGY VARCHAR2(300);
81 
82   P_REPORT_CCY VARCHAR2(15);
83 
84   Z1REPORT_CCY VARCHAR2(300);
85 
86   Z2REPORT_DATE VARCHAR2(300);
87 
88   Z2PAGE VARCHAR2(300);
89 
90   P_FACTOR NUMBER;
91 
92   RP_FACTOR VARCHAR2(80);
93 
94   RP_RISK_TYPE VARCHAR2(80);
95 
96   RP_OBJECTIVE VARCHAR2(80);
97 
98   RP_HEDGE_TYPE VARCHAR2(80);
99 
100   Z1GT_SYSDATE VARCHAR2(300);
101 
102   P_UNIT NUMBER;
103 
104   P_DATE DATE;
105 
106   Z1CUR_HEDGE VARCHAR2(300);
107 
108   Z1ITEM_AMOUNT VARCHAR2(300);
109 
110   Z1INST_AMOUNT VARCHAR2(300);
111 
112   CP_NO_GL_RATE VARCHAR2(2000);
113 
114   CP_NOT_CURRENT VARCHAR2(2000);
115 
116   FUNCTION HITEM_AMTFORMULA(HEDGE_NO IN NUMBER
117                            ,HEDGE_APPROACH IN VARCHAR2
118                            ,HEDGE_AMOUNT IN NUMBER) RETURN NUMBER;
119 
120   FUNCTION HINST_AMTFORMULA(CHINST_AMT IN NUMBER) RETURN NUMBER;
121 
122   FUNCTION HITEM_RCCYFORMULA(COMPANY_CODE IN VARCHAR2
123                             ,HEDGE_CURRENCY IN VARCHAR2
124                             ,HITEM_AMT IN NUMBER) RETURN NUMBER;
125 
126   FUNCTION HINST_RCCYFORMULA(COMPANY_CODE IN VARCHAR2
127                             ,HEDGE_CURRENCY IN VARCHAR2
128                             ,HINST_AMT IN NUMBER) RETURN NUMBER;
129 
130   FUNCTION AFTERPFORM RETURN BOOLEAN;
131 
132   FUNCTION GET_EQU_AMT(X_COMPANY_CODE IN VARCHAR2
133                       ,X_BASE_CCY IN VARCHAR2
134                       ,X_BASE_AMT IN NUMBER) RETURN NUMBER;
135 
136   FUNCTION BEFOREREPORT RETURN BOOLEAN;
137 
138   FUNCTION COMPANY_NAMEFORMULA(COMPANY_CODE IN VARCHAR2) RETURN CHAR;
139 
140   FUNCTION HEDGE_TYPE_DSPFORMULA(HEDGE_TYPE IN VARCHAR2) RETURN CHAR;
141 
142   FUNCTION OBJECTIVE_NAMEFORMULA(OBJECTIVE_CODE IN VARCHAR2) RETURN CHAR;
143 
144   FUNCTION OBJECTIVE_DESCFORMULA(OBJECTIVE_CODE IN VARCHAR2) RETURN CHAR;
145 
146   FUNCTION RISK_TYPE_DSPFORMULA(RISK_TYPE IN VARCHAR2) RETURN CHAR;
147 
148   FUNCTION STARFORMULA(HEDGE_STATUS IN VARCHAR2) RETURN CHAR;
149 
150   FUNCTION RPT_CCYFORMULA(COMPANY_CODE IN VARCHAR2) RETURN CHAR;
151 
152   FUNCTION AFTERREPORT RETURN BOOLEAN;
153 
154   FUNCTION CHINST_AMTFORMULA(HEDGE_NO IN NUMBER) RETURN NUMBER;
155 
156   FUNCTION CP_NO_GL_RATE_P RETURN VARCHAR2;
157 
158   FUNCTION CP_NOT_CURRENT_P RETURN VARCHAR2;
159 
160 
161 END XTR_XTRDDHTY_XMLP_PKG;
162