1 PACKAGE JA_JAINYEDE_XMLP_PKG AS
2 /* $Header: JAINYEDES.pls 120.1 2007/12/25 16:34:18 dwkrishn noship $ */
3 END_DATE DATE;
4 END_DATE_N DATE;
5 END_DATE_N1 VARCHAR2(30);
6
7
8 START_DATE DATE;
9 START_DATE_N DATE;
10 START_DATE_N1 VARCHAR2(30);
11
12 BOOK_NAME VARCHAR2(30);
13
14 P_CONC_REQUEST_ID NUMBER;
15
16 P_CONTEXT_VALUE VARCHAR2(300) := 'India B Of Assets';
17
18 FUNCTION CF_1FORMULA RETURN VARCHAR2;
19
20 FUNCTION CF_2FORMULA(OP_TOT IN NUMBER
21 ,COS_TOT IN NUMBER
22 ,CS_4 IN NUMBER) RETURN NUMBER;
23
24 FUNCTION CF_3FORMULA(ASSET_ID_v IN NUMBER
25 ,BLOCK_ID1 IN NUMBER
26 ,COST IN NUMBER
27 ,SLNO IN NUMBER
28 ,BLOCK_ID IN NUMBER
29 ,RATE IN NUMBER
30 ,TYPE1 IN VARCHAR2
31 ,OPENING_WDV IN NUMBER
32 ,CLOSING_WDV IN NUMBER
33 ,DEPN_OF_ASSETS IN NUMBER
34 ,TOTAL IN NUMBER
35 ,UNPLANNED_DEPN IN NUMBER) RETURN NUMBER;
36
37 FUNCTION AFTERPFORM RETURN BOOLEAN;
38
39 FUNCTION CF_4FORMULA RETURN NUMBER;
40
41 FUNCTION CF_5FORMULA(BLOCK_ID IN NUMBER
42 ,TYPE1 IN VARCHAR2
43 ,RATE IN NUMBER) RETURN NUMBER;
44
45 FUNCTION CF_6FORMULA(BLOCK_ID_V IN NUMBER
46 ,TYPE1 IN VARCHAR2
47 ,OP_TOT IN NUMBER
48 ,COS_TOT IN NUMBER
49 ,RATE IN NUMBER) RETURN NUMBER;
50
51 PROCEDURE DEPRECIATION1(P_BLOCK_ID IN NUMBER
52 ,P_OPENING_WDV IN NUMBER
53 ,P_CLOSING_BALANCE IN NUMBER
54 ,P_OPENING_WDV_ADJ IN NUMBER
55 ,P_DEPN_ADJ IN NUMBER
56 ,P_YEAR_END IN DATE);
57
58 FUNCTION CF_7FORMULA(ASSET_ID IN NUMBER
59 ,BLOCK_ID1 IN NUMBER) RETURN NUMBER;
60
61 PROCEDURE RETIRE(P_YEAR_START IN DATE
62 ,P_YEAR_END IN DATE
63 ,P_BOOK_NAME IN VARCHAR2);
64
65 PROCEDURE RUN_DEP(P_YEAR_START IN DATE
66 ,P_YEAR_END IN DATE
67 ,P_BOOK_NAME IN VARCHAR2);
68
69 PROCEDURE RUN_DEP_MASS(P_YEAR_START IN DATE
70 ,P_YEAR_END IN DATE
71 ,P_BOOK_NAME IN VARCHAR2);
72
73 FUNCTION AFTERREPORT RETURN BOOLEAN;
74
75 FUNCTION CF_9FORMULA(BLOCK_ID IN NUMBER) RETURN NUMBER;
76
77 FUNCTION TOTALDEPRN(P_BOOK_NAME IN JAI_FA_AST_BLOCKS.BOOK_TYPE_CODE%TYPE
78 ,P_YEAR_START IN JAI_FA_AST_YEARS.YEAR_START%TYPE
79 ,P_YEAR_END IN JAI_FA_AST_YEARS.YEAR_END%TYPE
80 ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE
81 ,P_NO_ASSETS OUT NOCOPY VARCHAR2) RETURN NUMBER;
82
83 PROCEDURE DEL_ATTR1_NULL;
84
85 FUNCTION BEFOREPFORM RETURN BOOLEAN;
86
87 PROCEDURE UPD_FA_ADD_CONTXT;
88
89 FUNCTION BEFOREREPORT RETURN BOOLEAN;
90
91 FUNCTION CF_8FORMULA(COST IN NUMBER
92 ,TRANSACTION_HEADER_ID_IN IN NUMBER
93 ,DATE_EFFECTIVE IN DATE
94 ,ASSET_ID IN NUMBER) RETURN NUMBER;
95
96 FUNCTION GET_TRANSACTION_HEADER_ID(P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
97 ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
98 ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE) RETURN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
99
100 FUNCTION CF_CLOSING_WDV_TOTFORMULA(CF_6 IN NUMBER
101 ,CF_2 IN NUMBER) RETURN NUMBER;
102
103 FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
104 ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
105 ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
106 ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
107 ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER;
108
109 END JA_JAINYEDE_XMLP_PKG;
110
111
112