[Home] [Help]
PACKAGE: APPS.BOM_CSTRIRVW_XMLP_PKG
Source
1 PACKAGE BOM_CSTRIRVW_XMLP_PKG AS
2 /* $Header: CSTRIRVWS.pls 120.0 2007/12/24 10:01:49 dwkrishn noship $ */
3 P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4 P_AS_OF_DATE1 VARCHAR2(40);
5 P_ORG_ID VARCHAR2(40);
6
7 P_CURRENCY_CODE VARCHAR2(15);
8
9 P_EXCHANGE_RATE NUMBER := 1;
10 qty_precision varchar2(100);
11 qty_precision1 varchar2(100);
12 P_SORT_OPTION NUMBER;
13
14 P_RPT_OPTION NUMBER;
15
16 P_ITEM_FROM VARCHAR2(800);
17
18 P_ITEM_TO VARCHAR2(800);
19
20 P_CATEGORY_SET NUMBER;
21
22 P_CAT_NUM NUMBER;
23
24 P_CAT_FROM VARCHAR2(800);
25
26 P_CAT_TO VARCHAR2(800);
27
28 P_SUBINV_FROM VARCHAR2(10);
29
30 P_SUBINV_TO VARCHAR2(10);
31
32 P_NEG_QTY NUMBER;
33
34 P_ZERO_COST NUMBER;
35
36 P_ORGANIZATION VARCHAR2(240);
37
38 ROUND_UNIT NUMBER;
39
40 P_ITEM_SEG VARCHAR2(2400);
41
42 P_CAT_SEG VARCHAR2(2400);
43
44 P_ITEM_WHERE VARCHAR2(2400);
45
46 P_CAT_WHERE VARCHAR2(2400);
47
48 P_SORT_BY VARCHAR2(80);
49
50 P_CAT_SET_NAME VARCHAR2(40);
51
52 P_GL_NUM NUMBER;
53
54 P_DETAIL_LEVEL VARCHAR2(80);
55
56 P_COST_TYPE_ID NUMBER;
57
58 P_DEF_COST_TYPE NUMBER;
59
60 P_COST_TYPE VARCHAR2(10);
61
62 P_EXT_PREC NUMBER;
63
64 P_QTY_WHERE VARCHAR2(1440);
65
66 P_ZERO_QTY NUMBER;
67
68 P_ITEM_REVISION NUMBER;
69
70 P_EXP_ITEM NUMBER;
71
72 P_UNCOSTED_TXN NUMBER;
73
74 P_QTY_PRECISION NUMBER;
75
76 P_SESSIONID NUMBER;
77
78 P_CURRENCY_DSP VARCHAR2(50);
79
80 P_VIEW_COST NUMBER;
81
82 P_REPORT_NAME VARCHAR2(240);
83
84 P_TRACE VARCHAR2(1);
85
86 P_COST_ORG_ID NUMBER;
87
88 P_PRECISION NUMBER;
89
90 P_SUBINV_WHERE VARCHAR2(2400);
91
92 P_EXCHANGE_RATE_CHAR VARCHAR2(38);
93
94 P_CG_FROM VARCHAR2(10);
95
96 P_CG_TO VARCHAR2(10);
97
98 P_COSTGROUP_WHERE VARCHAR2(2400);
99
100 P_CG_RANGE_WHERE VARCHAR2(2400);
101
102 P_PROJECT_ID NUMBER;
103
104 P_PROJECT_WHERE VARCHAR2(1500);
105
106 P_ITEM_LOCATIONS VARCHAR2(40);
107
108 P_PROJECT_MMT_WHERE VARCHAR2(1500);
109
110 P_PROJECT_NAME VARCHAR2(30);
111
112 P_PROJECT_NUMBER VARCHAR2(25);
113
114 P_EXP_SUB NUMBER;
115
116 P_AS_OF_DATE VARCHAR2(30);
117
118 P_TITLE VARCHAR2(240);
119
120 FUNCTION AFTERREPORT RETURN BOOLEAN;
121
122 FUNCTION BEFOREREPORT RETURN BOOLEAN;
123
124 FUNCTION IC_ROWCOUNTFORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
125
126 FUNCTION IC_TOTAL1FORMULA(IC_QUANTITY IN NUMBER
127 ,IC_TOTAL IN NUMBER) RETURN NUMBER;
128
129 FUNCTION CG_TOTAL1FORMULA(CG_QUANTITY IN NUMBER
130 ,CG_TOTAL IN NUMBER) RETURN NUMBER;
131
132 FUNCTION CG_ROWCOUNTFORMULA(CG_QUANTITY IN NUMBER) RETURN NUMBER;
133
134 FUNCTION CG_MATL1FORMULA(CG_QUANTITY IN NUMBER
135 ,CG_MATL IN NUMBER) RETURN NUMBER;
136
137 FUNCTION CG_MOVH1FORMULA(CG_QUANTITY IN NUMBER
138 ,CG_MOVH IN NUMBER) RETURN NUMBER;
139
140 FUNCTION CG_RES1FORMULA(CG_QUANTITY IN NUMBER
141 ,CG_RES IN NUMBER) RETURN NUMBER;
142
143 FUNCTION CG_OSP1FORMULA(CG_QUANTITY IN NUMBER
144 ,CG_OSP IN NUMBER) RETURN NUMBER;
145
146 FUNCTION CG_OVHD1FORMULA(CG_QUANTITY IN NUMBER
147 ,CG_OVHD IN NUMBER) RETURN NUMBER;
148
149 FUNCTION IC_ORDERFORMULA(IC_CATEGORY IN VARCHAR2
150 ,IC_CATEGORY_SEGMENT IN VARCHAR2
151 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
152
153 FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_NUMBER IN VARCHAR2
154 ,IC_ITEM_SEGMENT IN VARCHAR2
155 ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
156
157 FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY IN VARCHAR2
158 ,IC_CATEGORY_SEGMENT IN VARCHAR2
159 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
160
161 FUNCTION CG_ITEM_PSEGFORMULA(CG_ITEM_NUMBER IN VARCHAR2
162 ,CG_ITEM_SEGMENT IN VARCHAR2
163 ,CG_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
164
165 FUNCTION IC_QUANTITY1FORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
166
167 FUNCTION CG_CG_TOTALFORMULA(CG_CG_MATL IN NUMBER
168 ,CG_CG_MOVH IN NUMBER
169 ,CG_CG_RES IN NUMBER
170 ,CG_CG_OSP IN NUMBER
171 ,CG_CG_OVHD IN NUMBER) RETURN NUMBER;
172
173 FUNCTION CG_REP_TOTALFORMULA(CG_REP_MATL IN NUMBER
174 ,CG_REP_MOVH IN NUMBER
175 ,CG_REP_RES IN NUMBER
176 ,CG_REP_OSP IN NUMBER
177 ,CG_REP_OVHD IN NUMBER) RETURN NUMBER;
178
179 FUNCTION IC_ITEM_TOTAL_RFORMULA(IC_ITEM_TOTAL IN NUMBER) RETURN NUMBER;
180
181 FUNCTION IC_TOTAL_RFORMULA(IC_TOTAL IN NUMBER) RETURN NUMBER;
182
183 FUNCTION IC_REP_TOTAL_RFORMULA(IC_REP_TOTAL IN NUMBER) RETURN NUMBER;
184
185 FUNCTION IC_CAT_TOTAL_RFORMULA(IC_CAT_TOTAL IN NUMBER) RETURN NUMBER;
186
187 FUNCTION CG_TOTAL_RFORMULA(CG_TOTAL IN NUMBER) RETURN NUMBER;
188
189 FUNCTION CG_CG_MATL_RFORMULA(CG_CG_MATL IN NUMBER) RETURN NUMBER;
190
191 FUNCTION CG_CG_MOVH_RFORMULA(CG_CG_MOVH IN NUMBER) RETURN NUMBER;
192
193 FUNCTION CG_CG_OVHD_RFORMULA(CG_CG_OVHD IN NUMBER) RETURN NUMBER;
194
195 FUNCTION CG_CG_RES_RFORMULA(CG_CG_RES IN NUMBER) RETURN NUMBER;
196
197 FUNCTION CG_CG_OSP_RFORMULA(CG_CG_OSP IN NUMBER) RETURN NUMBER;
198
199 FUNCTION P_REPORT_NAMEVALIDTRIGGER RETURN BOOLEAN;
200
201 FUNCTION IC_UNIT_COST1FORMULA(IC_ITEM_QTY IN NUMBER
202 ,IC_ITEM_TOTAL IN NUMBER
203 ,IC_UNIT_COST IN NUMBER) RETURN NUMBER;
204
205 END BOM_CSTRIRVW_XMLP_PKG;
206