1 PACKAGE JA_JAINASST_XMLP_PKG AS
2 /* $Header: JAINASSTS.pls 120.1 2007/12/25 16:13:29 dwkrishn noship $ */
3 BOOK_NAME VARCHAR2(40);
4
5 P_TYPE VARCHAR2(60);
6
7 START_DATE DATE;
8
9 LSTART_DATE varchar2(30);
10
11 END_DATE DATE;
12
13 LEND_DATE varchar2(30);
14
15 P_CONC_REQUEST_ID NUMBER;
16
17 P_CONTEXT_VALUE VARCHAR2(300) := 'India B Of Assets';
18
19 FUNCTION CF_1FORMULA RETURN VARCHAR2;
20
21 FUNCTION CF_3FORMULA(OP_TOT IN NUMBER
22 ,COS_TOT IN NUMBER
23 ,CS_4 IN NUMBER) RETURN NUMBER;
24
25 FUNCTION CF_4FORMULA(BLOCK_ID IN NUMBER
26 ,TYPE IN VARCHAR2
27 ,RATE IN NUMBER) RETURN NUMBER;
28
29 FUNCTION CF_5FORMULA(ASSET_ID IN NUMBER
30 ,BLOCK_ID1 IN NUMBER) RETURN NUMBER;
31
32 FUNCTION CF_6FORMULA(BLOCK_ID IN NUMBER
33 ,TYPE IN VARCHAR2
34 ,OP_TOT IN NUMBER
35 ,COS_TOT IN NUMBER
36 ,RATE IN NUMBER) RETURN NUMBER;
37
38 FUNCTION AFTERPFORM RETURN BOOLEAN;
39
40 FUNCTION AFTERREPORT RETURN BOOLEAN;
41
42 FUNCTION CF_8FORMULA(BLOCK_ID IN NUMBER) RETURN NUMBER;
43
44 FUNCTION BEFOREREPORT RETURN BOOLEAN;
45
46 FUNCTION CF_ADDITIONS_COSTFORMULA(COST IN NUMBER
47 ,TRANSACTION_HEADER_ID_IN IN NUMBER
48 ,DATE_EFFECTIVE IN DATE
49 ,ASSET_ID IN NUMBER) RETURN NUMBER;
50
51 FUNCTION CF_CLOSING_WDV_TOTALFORMULA(DEP_TOT IN NUMBER
52 ,CF_3 IN NUMBER) RETURN NUMBER;
53
54 FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
55 ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
56 ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
57 ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
58 ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER;
59
60 END JA_JAINASST_XMLP_PKG;
61
62