1 PACKAGE WIP_WIPUTVAL_XMLP_PKG AS
2 /* $Header: WIPUTVALS.pls 120.1 2008/01/31 12:57:59 npannamp noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4 lp_struct_num number;
5
6 P_ASSY_FLEX VARCHAR2(850);
7
8 P_ORGANIZATION_ID NUMBER;
9
10 P_CLOSED_JOBS NUMBER;
11
12 P_ACCT_PERIOD_ID NUMBER;
13
14 P_CLASS_TYPE NUMBER;
15
16 P_FROM_CLASS VARCHAR2(10);
17
18 P_TO_CLASS VARCHAR2(10);
19
20 P_FROM_JOB VARCHAR2(40);
21
22 P_TO_JOB VARCHAR2(40);
23
24 P_FROM_ASSEMBLY VARCHAR2(850);
25
26 P_TO_ASSEMBLY VARCHAR2(850);
27
28 P_CURRENCY_CODE VARCHAR2(15);
29
30 P_FLEXWHERE VARCHAR2(2400);
31 P_FLEXWHERE1 VARCHAR2(2400);
32 P_FLEXWHERE2 VARCHAR2(2400);
33 P_FLEXWHERE3 VARCHAR2(2400);
34
35
36 P_STRUCT_NUM NUMBER;
37
38 P_ACCT_FLEX VARCHAR2(850);
39
40 P_REPORT_TYPE NUMBER;
41
42 P_EXCHANGE_RATE NUMBER := 1;
43
44 P_INVERSE_RATE VARCHAR2(40);
45
46 P_RATE_TYPE NUMBER;
47
48 P_DEBUG NUMBER;
49
50 P_OUTER VARCHAR2(32767);
51
52 P_EXCHANGE_RATE_CHAR VARCHAR2(38);
53
54 P_PROJECT_ID NUMBER;
55
56 P_PROJECT_WHERE VARCHAR2(1500) := '1=1';
57
58 FUNCTION BEFOREREPORT RETURN BOOLEAN;
59
60 FUNCTION C_DJ_PERIOD_ACTIVITYFORMULA(C_DJ_CI_PTD IN NUMBER
61 ,C_DJ_CR_PTD IN NUMBER
62 ,C_DJ_VR_PTD IN NUMBER) RETURN NUMBER;
63
64 FUNCTION C_DJ_ENDING_BALANCEFORMULA(C_DJ_CI_CUM IN NUMBER
65 ,C_DJ_CR_CUM IN NUMBER
66 ,C_DJ_VR_CUM IN NUMBER) RETURN NUMBER;
67
68 FUNCTION CLOSED_JOBS(C_PERIOD_START_DATE IN VARCHAR2
69 ,C_PERIOD_CLOSE_DATE IN VARCHAR2) RETURN CHARACTER;
70
71 FUNCTION C_LIMIT_TYPESFORMULA RETURN VARCHAR2;
72
73 FUNCTION LIMIT_CLASSES RETURN CHARACTER;
74
75 FUNCTION LIMIT_JOBS RETURN CHARACTER;
76
77 FUNCTION LIMIT_CLASSES_RS RETURN CHARACTER;
78
79 FUNCTION C_ACCT_PERIOD_ACTFORMULA(P_PTD_OR_CUM IN VARCHAR2
80 ,C_ACCT_CI_PTD IN NUMBER
81 ,C_ACCT_CR_PTD IN NUMBER
82 ,C_ACCT_EL_VAR_PTD IN NUMBER
83 ,C_ACCT_CI_CUM IN NUMBER
84 ,C_ACCT_CR_CUM IN NUMBER
85 ,C_ACCT_EL_VAR_CUM IN NUMBER) RETURN NUMBER;
86
87 FUNCTION C_SUBTITLEFORMULA(REP_TYPE IN VARCHAR2
88 ,ORG_CURRENCY IN VARCHAR2) RETURN VARCHAR2;
89
90 FUNCTION C_WIP_PERIOD_ACTFORMULA(P_PTD_OR_CUM IN VARCHAR2
91 ,C_WIP_CI_PTD IN NUMBER
92 ,C_WIP_CR_PTD IN NUMBER
93 ,C_WIP_EL_VAR_PTD IN NUMBER
94 ,C_WIP_CI_CUM IN NUMBER
95 ,C_WIP_CR_CUM IN NUMBER
96 ,C_WIP_EL_VAR_CUM IN NUMBER) RETURN NUMBER;
97
98 FUNCTION C_FLEXWHEREFORMULA RETURN VARCHAR2;
99
100 FUNCTION C_DJ_CI_PTDFORMULA(C_DJ_LAST_DATE IN NUMBER
101 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
102 ,C_DJ_CI_LAST IN NUMBER) RETURN NUMBER;
103
104 FUNCTION C_DJ_CR_PTDFORMULA(C_DJ_LAST_DATE IN NUMBER
105 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
106 ,C_DJ_CR_LAST IN NUMBER) RETURN NUMBER;
107
108 FUNCTION C_DJ_VR_PTDFORMULA(C_DJ_LAST_DATE IN NUMBER
109 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
110 ,C_DJ_VR_LAST IN NUMBER) RETURN NUMBER;
111
112 FUNCTION C_ACCT_CI_PTDFORMULA(C_ACCT_LAST_DATE IN NUMBER
113 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
114 ,C_ACCT_CI_LAST IN NUMBER) RETURN NUMBER;
115
116 FUNCTION C_ACCT_CR_PTDFORMULA(C_ACCT_LAST_DATE IN NUMBER
117 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
118 ,C_ACCT_CR_LAST IN NUMBER) RETURN NUMBER;
119
120 FUNCTION C_ACCT_EL_VAR_PTDFORMULA(C_ACCT_LAST_DATE IN NUMBER
121 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
122 ,C_ACCT_EL_VAR_LAST IN NUMBER) RETURN NUMBER;
123
124 FUNCTION C_ACCT_SING_VAR_PTDFORMULA(C_ACCT_LAST_DATE IN NUMBER
125 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
126 ,C_ACCT_SING_LAST IN NUMBER) RETURN NUMBER;
127
128 FUNCTION C_WIP_CI_PTDFORMULA(C_WIP_LAST_DATE IN NUMBER
129 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
130 ,C_WIP_CI_LAST IN NUMBER) RETURN NUMBER;
131
132 FUNCTION C_WIP_CR_PTDFORMULA(C_WIP_LAST_DATE IN NUMBER
133 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
134 ,C_WIP_CR_LAST IN NUMBER) RETURN NUMBER;
135
136 FUNCTION C_WIP_EL_VAR_PTDFORMULA(C_WIP_LAST_DATE IN NUMBER
137 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
138 ,C_WIP_EL_VAR_LAST IN NUMBER) RETURN NUMBER;
139
140 FUNCTION C_WIP_SING_PTDFORMULA(C_WIP_LAST_DATE IN NUMBER
141 ,C_PERIOD_CLOSE_DATE IN VARCHAR2
142 ,C_WIP_SING_LAST IN NUMBER) RETURN NUMBER;
143
144 FUNCTION C_DJ_CIFORMULA(P_PTD_OR_CUM IN VARCHAR2
145 ,C_DJ_CI_PTD IN NUMBER
146 ,C_DJ_CI_CUM IN NUMBER) RETURN NUMBER;
147
148 FUNCTION C_DJ_CRFORMULA(P_PTD_OR_CUM IN VARCHAR2
149 ,C_DJ_CR_PTD IN NUMBER
150 ,C_DJ_CR_CUM IN NUMBER) RETURN NUMBER;
151
152 FUNCTION C_DJ_VRFORMULA(P_PTD_OR_CUM IN VARCHAR2
153 ,C_DJ_VR_PTD IN NUMBER
154 ,C_DJ_VR_CUM IN NUMBER) RETURN NUMBER;
155
156 FUNCTION C_ACCT_CIFORMULA(P_PTD_OR_CUM IN VARCHAR2
157 ,C_ACCT_CI_PTD IN NUMBER
158 ,C_ACCT_CI_CUM IN NUMBER) RETURN NUMBER;
159
160 FUNCTION C_ACCT_CRFORMULA(P_PTD_OR_CUM IN VARCHAR2
161 ,C_ACCT_CR_PTD IN NUMBER
162 ,C_ACCT_CR_CUM IN NUMBER) RETURN NUMBER;
163
164 FUNCTION C_ACCT_EL_VARFORMULA(P_PTD_OR_CUM IN VARCHAR2
165 ,C_ACCT_EL_VAR_PTD IN NUMBER
166 ,C_ACCT_EL_VAR_CUM IN NUMBER) RETURN NUMBER;
167
168 FUNCTION C_ACCT_SINGFORMULA(P_PTD_OR_CUM IN VARCHAR2
169 ,C_ACCT_SING_VAR_PTD IN NUMBER
170 ,C_ACCT_SING_VAR_CUM IN NUMBER) RETURN NUMBER;
171
172 FUNCTION C_WIP_CIFORMULA(P_PTD_OR_CUM IN VARCHAR2
173 ,C_WIP_CI_PTD IN NUMBER
174 ,C_WIP_CI_CUM IN NUMBER) RETURN NUMBER;
175
176 FUNCTION C_WIP_CRFORMULA(P_PTD_OR_CUM IN VARCHAR2
177 ,C_WIP_CR_PTD IN NUMBER
178 ,C_WIP_CR_CUM IN NUMBER) RETURN NUMBER;
179
180 FUNCTION C_WIP_EL_VARFORMULA(P_PTD_OR_CUM IN VARCHAR2
181 ,C_WIP_EL_VAR_PTD IN NUMBER
182 ,C_WIP_EL_VAR_CUM IN NUMBER) RETURN NUMBER;
183
184 FUNCTION C_WIP_SINGFORMULA(P_PTD_OR_CUM IN VARCHAR2
185 ,C_WIP_SING_PTD IN NUMBER
186 ,C_WIP_SING_CUM IN NUMBER) RETURN NUMBER;
187
188 FUNCTION P_PTD_OR_CUMFORMULA RETURN VARCHAR2;
189
190 FUNCTION AFTERREPORT RETURN BOOLEAN;
191
192 FUNCTION C_ACCT_SORTFORMULA(C_ACCT_SORT IN VARCHAR2) RETURN VARCHAR2;
193
194 FUNCTION C_WIP_ACCT_SORTFORMULA(C_WIP_ACCT_SORT IN VARCHAR2) RETURN VARCHAR2;
195
196 FUNCTION AFTERPFORM RETURN BOOLEAN;
197
198 END WIP_WIPUTVAL_XMLP_PKG;
199