PACKAGE: APPS.FA_FASRVRVW_XMLP_PKG

Source

1 PACKAGE FA_FASRVRVW_XMLP_PKG AS
2 /* $Header: FASRVRVWS.pls 120.0.12010000.1 2008/07/28 13:17:40 appldev ship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_MASS_REVAL_ID NUMBER;
6 P_MASS_REVAL_ID1 NUMBER;
7   P_MIN_PRECISION NUMBER := 2;
8 
9   OLD_DEP_RSV NUMBER;
10 
11   OLD_REVAL_RSV NUMBER;
12 
13   DESCRIPTION VARCHAR2(80);
14 
15   REVAL_DATE DATE;
16 
17   BOOK VARCHAR2(15);
18 
19   CURRENCY_CODE VARCHAR2(15);
20 
21   RP_COMPANY_NAME VARCHAR2(30);
22 
23   RP_REPORT_NAME VARCHAR2(240);
24 
25   FUNCTION BEFOREREPORT RETURN BOOLEAN;
26 
27   FUNCTION AFTERREPORT RETURN BOOLEAN;
28 
29   FUNCTION G_CATEGORYGROUPFILTER RETURN BOOLEAN;
30 
31   FUNCTION MASS_REVAL_IDFORMULA RETURN NUMBER;
32 
33   FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
34 
35   FUNCTION REVAL_PCFORMULA RETURN NUMBER;
36 
37   FUNCTION REVAL_PCTFORMULA(REVAL_PCT IN VARCHAR2) RETURN VARCHAR2;
38 
39   FUNCTION ASS_FOUNDFORMULA(ASS_FOUND IN VARCHAR2) RETURN VARCHAR2;
40 
41   FUNCTION ASS_REVAL_PCTFORMULA(ASS_REVAL_PCT IN VARCHAR2) RETURN VARCHAR2;
42 
43   FUNCTION D_OLD_LIFEFORMULA(OLD_LIFE IN NUMBER) RETURN VARCHAR2;
44 
45   FUNCTION D_NEW_LIFEFORMULA(NEW_LIFE IN NUMBER) RETURN VARCHAR2;
46 
47   FUNCTION ASS_FRRFFORMULA(ASS_FRRF IN VARCHAR2) RETURN VARCHAR2;
48 
49   FUNCTION ASS_LEFFORMULA(ASS_LEF IN VARCHAR2) RETURN VARCHAR2;
50 
51   FUNCTION ASS_LECFORMULA(ASS_LEC IN VARCHAR2) RETURN VARCHAR2;
52 
53   FUNCTION ASS_MFRRFORMULA(ASS_MFRR IN VARCHAR2) RETURN VARCHAR2;
54 
55   FUNCTION NEW_DEP_RSVFORMULA RETURN NUMBER;
56 
57   FUNCTION NEW_REVAL_RSVFORMULA(NEW_REVAL_RSV IN NUMBER) RETURN NUMBER;
58 
59   FUNCTION ADJ_DEP_RSVFORMULA(TH_ID IN NUMBER
60                              ,ASSET_ID IN NUMBER
61                              ,NEW_DEP_RSV IN NUMBER) RETURN NUMBER;
62 
63   FUNCTION ADJ_REVAL_RSVFORMULA(TH_ID IN NUMBER
64                                ,ASSET_ID IN NUMBER
65                                ,NEW_REVAL_RSV IN NUMBER) RETURN NUMBER;
66 
67   FUNCTION FRRFFORMULA(FRRF IN VARCHAR2) RETURN VARCHAR2;
68 
69   FUNCTION MFRRFORMULA(MFRR IN VARCHAR2) RETURN VARCHAR2;
70 
71   FUNCTION LEFFORMULA(LEF IN VARCHAR2) RETURN VARCHAR2;
72 
73   FUNCTION LECFORMULA(LEC IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION D_FOUNDFORMULA(D_FOUND IN VARCHAR2) RETURN VARCHAR2;
76 
77   FUNCTION OLD_DEP_RSV_P RETURN NUMBER;
78 
79   FUNCTION OLD_REVAL_RSV_P RETURN NUMBER;
80 
81   FUNCTION DESCRIPTION_P RETURN VARCHAR2;
82 
83   FUNCTION REVAL_DATE_P RETURN DATE;
84 
85   FUNCTION BOOK_P RETURN VARCHAR2;
86 
87   FUNCTION CURRENCY_CODE_P RETURN VARCHAR2;
88 
89   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
90 
91   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
92 
93 END FA_FASRVRVW_XMLP_PKG;
94