1 PACKAGE JA_JAAUFREV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAAUFREVS.pls 120.1 2007/12/25 16:06:47 dwkrishn noship $ */
3 P_MASS_REVAL_ID NUMBER;
4
5 P_BOOK_TYPE_CODE VARCHAR2(40);
6
7 P_ASSET_CLASS VARCHAR2(40);
8
9 P_DUMMY NUMBER;
10
11 P_CONC_REQUEST_ID NUMBER := 0;
12
13 RESERVE NUMBER;
14
15 FUNCTION BEFOREREPORT RETURN BOOLEAN;
16
17 FUNCTION AFTERREPORT RETURN BOOLEAN;
18
19 FUNCTION C_NEW_DEP_RSVFORMULA(TH_ID IN NUMBER
20 ,BOOK_TYPE_CODE IN VARCHAR2
21 ,ASSET_ID IN NUMBER) RETURN NUMBER;
22
23 FUNCTION D_ASSET_CLASSFORMULA RETURN VARCHAR2;
24
25 FUNCTION PROFIT_LOSSFORMULA(TOT_OLD_REVAL_RSV IN NUMBER
26 ,TOT_REVAL_RSV IN NUMBER) RETURN NUMBER;
27
28 FUNCTION C_CATEGORYFORMULA(ASSET_CLASS IN NUMBER) RETURN VARCHAR2;
29
30 FUNCTION C_OLD_COSTFORMULA(OLD_COST IN NUMBER
31 ,C_OLD_REVAL_RSV IN NUMBER
32 ,C_OLD_DEP_RSV IN NUMBER) RETURN NUMBER;
33
34 FUNCTION C_OLD_REVAL_RSVFORMULA(ASSET_ID IN NUMBER
35 ,BOOK_TYPE_CODE IN VARCHAR2
36 ,TH_ID IN NUMBER) RETURN NUMBER;
37
38 FUNCTION C_OLD_DEP_RSVFORMULA(ASSET_ID IN NUMBER
39 ,BOOK_TYPE_CODE IN VARCHAR2
40 ,TH_ID IN NUMBER) RETURN NUMBER;
41
42 FUNCTION C_ACTUAL_COSTFORMULA(C_OLD_COST IN NUMBER
43 ,C_OLD_REVAL_RSV IN NUMBER
44 ,C_OLD_DEP_RSV IN NUMBER) RETURN NUMBER;
45
46 FUNCTION C_REVAL_RSVFORMULA(ADJ_COST IN NUMBER
47 ,C_NEW_DEP_RSV IN NUMBER) RETURN NUMBER;
48
49 FUNCTION C_NEW_COSTFORMULA(C_ACTUAL_COST IN NUMBER
50 ,ADJ_COST IN NUMBER) RETURN NUMBER;
51
52 FUNCTION C_NEW_REVAL_RSVFORMULA(C_OLD_REVAL_RSV IN NUMBER
53 ,C_REVAL_RSV IN NUMBER) RETURN NUMBER;
54
55 FUNCTION RESERVE_P RETURN NUMBER;
56
57 END JA_JAAUFREV_XMLP_PKG;
58
59
[Home] [Help]