PACKAGE: APPS.XTR_XTROHINS_XMLP_PKG

Source

1 PACKAGE XTR_XTROHINS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTROHINSS.pls 120.1 2007/12/28 12:58:32 npannamp noship $ */
3   P_COMPANY VARCHAR2(7);
4   P_HEDGE_TYPE VARCHAR2(30);
5   P_OBJECTIVE VARCHAR2(30);
6   P_STRATEGY VARCHAR2(30);
7   P_HEDGE_STATUS VARCHAR2(30);
8   P_AS_OF_DATE VARCHAR2(40);
9    P_AS_OF_DATE_1 VARCHAR2(40);
10   REPORT_NAME VARCHAR2(300);
11   P_CONC_REQUEST_ID NUMBER;
12   RP_COMPANY_NAME VARCHAR2(32767);
13   RP_HEDGE_OBJ VARCHAR2(80);
14   Z1AS_OF_DATE VARCHAR2(300);
15   Z1CCY VARCHAR2(300);
16   Z1COMPANY VARCHAR2(300);
17   Z1DEAL_AMOUNT VARCHAR2(300);
18   Z1FACTOR VARCHAR2(300);
19   Z1HEDGE VARCHAR2(300);
20   Z1HEDGE_AMOUNT VARCHAR2(300);
21   Z1HEDGE_OBJ VARCHAR2(300);
22   Z1HEDGE_TYPE VARCHAR2(300);
23   Z1HTYPE_TOTAL VARCHAR2(300);
24   Z1HITEM_TOTAL VARCHAR2(300);
25   Z1OBJECTIVE VARCHAR2(300);
26   Z1PARAMETERS VARCHAR2(300);
27   Z1STRATEGY VARCHAR2(300);
28   Z1EQUI VARCHAR2(300);
29   Z1END_OF_REPORT VARCHAR2(300);
30   Z1HEDGE_STRATEGY VARCHAR2(300);
31   Z1NO_DATA_FOUND VARCHAR2(300);
32   Z1HEDGE_NUM VARCHAR2(300);
33   P_REPORT_CCY VARCHAR2(15);
34   Z1REPORT_DATE VARCHAR2(300);
35   Z1PAGE VARCHAR2(300);
36   P_FACTOR NUMBER;
37   RP_FACTOR VARCHAR2(80);
38   RP_HEDGE_TYPE VARCHAR2(80);
39   Z1GT_SYSDATE VARCHAR2(300);
40   P_UNIT NUMBER;
41   Z1CONTRA VARCHAR2(300);
42   Z1DEAL VARCHAR2(300);
43   Z1SUBTYPE VARCHAR2(300);
44   Z1NUMBER VARCHAR2(300);
45   Z1NO_HINST_FOUND VARCHAR2(300);
46   Z1REPORT_CCY VARCHAR2(300);
47   Z1TYPE VARCHAR2(300);
48   Z1UNASSIGNED VARCHAR2(300);
49   P_DATE DATE;
50   Z1CURRENT VARCHAR2(300);
51   CP_NO_GL_RATE VARCHAR2(2000);
52   CP_IRS_NOTE VARCHAR2(400);
53   FUNCTION AFTERPFORM RETURN BOOLEAN;
54   FUNCTION GET_EQU_AMT(X_COMPANY_CODE IN VARCHAR2
55                       ,X_BASE_CCY IN VARCHAR2
56                       ,X_BASE_AMT IN NUMBER) RETURN NUMBER;
57   FUNCTION BEFOREREPORT RETURN BOOLEAN;
58   FUNCTION AFTERREPORT RETURN BOOLEAN;
59   FUNCTION GET_DSP_VALUE(TYPE IN VARCHAR2
60                         ,CODE IN VARCHAR2) RETURN VARCHAR2;
61   FUNCTION RCCY_AMTFORMULA(HEDGE_TYPE IN VARCHAR2
62                           ,HEDGE_CURRENCY IN VARCHAR2
63                           ,CURRENCY_DSP IN VARCHAR2
64                           ,COMPANY_CODE IN VARCHAR2
65                           ,HDG_CONTRA_AMT IN NUMBER) RETURN NUMBER;
66   FUNCTION DEAL_AMTFORMULA(DEAL_NO_1 IN NUMBER
67                           ,CURRENCY_DSP IN VARCHAR2
68                           ,HEDGE_TYPE IN VARCHAR2
69                           ,DEAL_TYPE IN VARCHAR2
70                           ,HEDGE_CURRENCY IN VARCHAR2) RETURN NUMBER;
71   FUNCTION CURRFORMULA(DEAL_NO_1 IN NUMBER
72                       ,DEAL_TYPE IN VARCHAR2
73                       ,HEDGE_TYPE IN VARCHAR2
74                       ,HEDGE_CURRENCY IN VARCHAR2) RETURN CHAR;
75   FUNCTION CONTRA_CCY_DSPFORMULA(DEAL_NO_1 IN NUMBER
76                                 ,HEDGE_TYPE IN VARCHAR2
77                                 ,HEDGE_CURRENCY IN VARCHAR2
78                                 ,DEAL_TYPE IN VARCHAR2) RETURN CHAR;
79   FUNCTION OBJECTIVE_DSPFORMULA(OBJECTIVE_CODE IN VARCHAR2) RETURN CHAR;
80   FUNCTION HDG_CONTRA_AMTFORMULA(DEAL_NO_1 IN NUMBER
81                                 ,CURRENCY_DSP IN VARCHAR2
82                                 ,HEDGE_TYPE IN VARCHAR2
83                                 ,CHEDGE_AMOUNT IN NUMBER
84                                 ,DEAL_TYPE IN VARCHAR2) RETURN NUMBER;
85   FUNCTION RPT_CCYFORMULA(COMPANY_CODE IN VARCHAR2) RETURN CHAR;
86   FUNCTION HEDGE_TYPE_DSPFORMULA(HEDGE_TYPE IN VARCHAR2) RETURN CHAR;
87   FUNCTION COMPANY_NAMEFORMULA(COMPANY_CODE IN VARCHAR2) RETURN CHAR;
88   FUNCTION CHEDGE_AMOUNTFORMULA(HEDGE_NO IN NUMBER) RETURN NUMBER;
89   FUNCTION CP_NO_GL_RATE_P RETURN VARCHAR2;
90   FUNCTION CP_IRS_NOTE_P RETURN VARCHAR2;
91 END XTR_XTROHINS_XMLP_PKG;
92