1 PACKAGE IGI_IGIIARRV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGIIARRVS.pls 120.0.12010000.1 2008/07/29 08:58:48 appldev ship $ */
3 P_BOOK VARCHAR2(15);
4 DO_INSERT number;
5 P_COMPANY1 VARCHAR2(40);
6
7 P_COMPANY2 VARCHAR2(40);
8
9 P_COST_CENTER1 VARCHAR2(40);
10
11 P_COST_CENTER2 VARCHAR2(40);
12
13 P_ACCOUNT1 VARCHAR2(40);
14
15 P_ACCOUNT2 VARCHAR2(40);
16
17 P_CONC_REQUEST_ID NUMBER;
18
19 P_PERIOD1 VARCHAR2(15);
20
21 P_PERIOD2 VARCHAR2(15);
22
23 P_REPORT_TYPE VARCHAR2(15);
24
25 ACCT_BAL_APROMPT VARCHAR2(222);
26
27 ACCT_CC_APROMPT VARCHAR2(222);
28
29 RP_BAL_LPROMPT VARCHAR2(222);
30
31 RP_CC_APROMPT VARCHAR2(222);
32
33 RP_COMPANY_NAME VARCHAR2(30);
34
35 RP_REPORT_NAME VARCHAR2(80);
36
37 RP_CC_LPROMPT VARCHAR2(80);
38
39 FUNCTION DO_INSERTFORMULA RETURN NUMBER;
40
41 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2
42 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
43
44 FUNCTION COST_BEGINNINGFORMULA(BALANCE_TYPE IN VARCHAR2
45 ,BEGINNING IN NUMBER) RETURN NUMBER;
46
47 FUNCTION COST_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
48 ,ADDITION IN NUMBER) RETURN NUMBER;
49
50 FUNCTION COST_DEPRECIATIONFORMULA(BALANCE_TYPE IN VARCHAR2
51 ,DEPRECIATION IN NUMBER) RETURN NUMBER;
52
53 FUNCTION COST_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
54 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
55
56 FUNCTION COST_RETIREMENTFORMULA(BALANCE_TYPE IN VARCHAR2
57 ,RETIREMENT IN NUMBER) RETURN NUMBER;
58
59 FUNCTION COST_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
60 ,REVALUATION IN NUMBER) RETURN NUMBER;
61
62 FUNCTION COST_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
63 ,RECLASS IN NUMBER) RETURN NUMBER;
64
65 FUNCTION COST_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2
66 ,TRANSFER IN NUMBER) RETURN NUMBER;
67
68 FUNCTION COST_ENDINGFORMULA(BALANCE_TYPE IN VARCHAR2
69 ,ENDING IN NUMBER) RETURN NUMBER;
70
71 FUNCTION GFUND_BEGINNINGFORMULA(BALANCE_TYPE IN VARCHAR2
72 ,BEGINNING IN NUMBER) RETURN NUMBER;
73
74 FUNCTION GFUND_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
75 ,ADDITION IN NUMBER) RETURN NUMBER;
76
77 FUNCTION GFUND_DEPRECIATIONFORMULA(BALANCE_TYPE IN VARCHAR2
78 ,DEPRECIATION IN NUMBER) RETURN NUMBER;
79
80 FUNCTION GFUND_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
81 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
82
83 FUNCTION GFUND_RETIREMENTFORMULA(BALANCE_TYPE IN VARCHAR2
84 ,RETIREMENT IN NUMBER) RETURN NUMBER;
85
86 FUNCTION GFUND_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
87 ,REVALUATION IN NUMBER) RETURN NUMBER;
88
89 FUNCTION GFUND_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
90 ,RECLASS IN NUMBER) RETURN NUMBER;
91
92 FUNCTION GFUND_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2
93 ,TRANSFER IN NUMBER) RETURN NUMBER;
94
95 FUNCTION GFUND_ENDINGFORMULA(BALANCE_TYPE IN VARCHAR2
96 ,ENDING IN NUMBER) RETURN NUMBER;
97
98 FUNCTION BLOG_BEGINNINGFORMULA(BALANCE_TYPE IN VARCHAR2
99 ,BEGINNING IN NUMBER) RETURN NUMBER;
100
101 FUNCTION BLOG_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
102 ,ADDITION IN NUMBER) RETURN NUMBER;
103
104 FUNCTION BLOG_DEPRECIATIONFORMULA(BALANCE_TYPE IN VARCHAR2
105 ,DEPRECIATION IN NUMBER) RETURN NUMBER;
106
107 FUNCTION BLOG_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
108 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
109
110 FUNCTION BLOG_RETIREMENTFORMULA(BALANCE_TYPE IN VARCHAR2
111 ,RETIREMENT IN NUMBER) RETURN NUMBER;
112
113 FUNCTION BLOG_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
114 ,REVALUATION IN NUMBER) RETURN NUMBER;
115
116 FUNCTION BLOG_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
117 ,RECLASS IN NUMBER) RETURN NUMBER;
118
119 FUNCTION BLOG_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2
120 ,TRANSFER IN NUMBER) RETURN NUMBER;
121
122 FUNCTION BLOG_ENDINGFORMULA(BALANCE_TYPE IN VARCHAR2
123 ,ENDING IN NUMBER) RETURN NUMBER;
124
125 FUNCTION NET_BEGINNINGFORMULA(BALANCE_TYPE IN VARCHAR2
126 ,BEGINNING IN NUMBER) RETURN NUMBER;
127
128 FUNCTION NET_ADDITIONFORMULA(BALANCE_TYPE IN VARCHAR2
129 ,ADDITION IN NUMBER) RETURN NUMBER;
130
131 FUNCTION NET_DEPRECIATIONFORMULA(BALANCE_TYPE IN VARCHAR2
132 ,DEPRECIATION IN NUMBER) RETURN NUMBER;
133
134 FUNCTION NET_ADJUSTMENTFORMULA(BALANCE_TYPE IN VARCHAR2
135 ,ADJUSTMENT IN NUMBER) RETURN NUMBER;
136
137 FUNCTION NET_RETIREMENTFORMULA(BALANCE_TYPE IN VARCHAR2
138 ,RETIREMENT IN NUMBER) RETURN NUMBER;
139
140 FUNCTION NET_REVALUATIONFORMULA(BALANCE_TYPE IN VARCHAR2
141 ,REVALUATION IN NUMBER) RETURN NUMBER;
142
143 FUNCTION NET_RECLASSFORMULA(BALANCE_TYPE IN VARCHAR2
144 ,RECLASS IN NUMBER) RETURN NUMBER;
145
146 FUNCTION NET_TRANSFERFORMULA(BALANCE_TYPE IN VARCHAR2
147 ,TRANSFER IN NUMBER) RETURN NUMBER;
148
149 FUNCTION NET_ENDINGFORMULA(BALANCE_TYPE IN VARCHAR2
150 ,ENDING IN NUMBER) RETURN NUMBER;
151
152 FUNCTION BEFOREREPORT RETURN BOOLEAN;
153
154 FUNCTION AFTERREPORT RETURN BOOLEAN;
155
156 FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
157
158 FUNCTION ACCT_CC_APROMPT_P RETURN VARCHAR2;
159
160 FUNCTION RP_BAL_LPROMPT_P RETURN VARCHAR2;
161
162 FUNCTION RP_CC_APROMPT_P RETURN VARCHAR2;
163
164 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
165
166 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
167
168 FUNCTION RP_CC_LPROMPT_P RETURN VARCHAR2;
169
170 END IGI_IGIIARRV_XMLP_PKG;