[Home] [Help]
PACKAGE: APPS.BOM_CSTREIVW_XMLP_PKG
Source
1 PACKAGE BOM_CSTREIVW_XMLP_PKG AS
2 /* $Header: CSTREIVWS.pls 120.0 2007/12/24 09:58:03 dwkrishn noship $ */
3 P_CAT_WHERE VARCHAR2(2400) :='1 = 1';
4 P_AS_OF_DATE1 VARCHAR2(40);
5 qty_precision varchar2(40);
6 P_EXP_ITEM NUMBER;
7
8 P_RPT_OPTION NUMBER;
9
10 P_UNCOSTED_TXN VARCHAR2(40);
11
12 P_VIEW_COST NUMBER;
13
14 P_ZERO_COST NUMBER;
15
16 P_ZERO_QTY NUMBER;
17
18 ROUND_UNIT NUMBER;
19
20 P_CATEGORY_SET NUMBER;
21
22 P_CAT_FROM VARCHAR2(800);
23
24 P_CAT_NUM NUMBER;
25
26 P_CAT_SEG VARCHAR2(2400);
27
28 P_CAT_SET_NAME VARCHAR2(40);
29
30 P_CAT_TO VARCHAR2(800);
31
32 P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
33
34 P_COST_ORG_ID NUMBER;
35
36 P_COST_TYPE VARCHAR2(10);
37
38 P_COST_TYPE_ID NUMBER;
39
40 P_CURRENCY_CODE VARCHAR2(15);
41
42 P_CURRENCY_DSP VARCHAR2(50);
43
44 P_DEF_COST_TYPE NUMBER;
45
46 P_DETAIL_LEVEL VARCHAR2(80);
47
48 P_EXCHANGE_RATE NUMBER := 1;
49
50 P_EXCHANGE_RATE_CHAR VARCHAR2(38);
51
52 P_GL_NUM NUMBER;
53
54 P_ITEM_FROM VARCHAR2(800);
55
56 P_ITEM_SEG VARCHAR2(2400);
57
58 P_ITEM_TO VARCHAR2(800);
59
60 P_ITEM_WHERE VARCHAR2(2400);
61
62 P_NEG_QTY NUMBER;
63
64 P_ORGANIZATION VARCHAR2(240);
65
66 P_ORG_ID VARCHAR2(40);
67
68 P_QTY_PRECISION NUMBER;
69
70 P_QTY_WHERE VARCHAR2(800);
71
72 P_SESSIONID NUMBER;
73
74 P_SORT_BY VARCHAR2(80);
75
76 P_SORT_OPTION NUMBER;
77
78 P_TRACE VARCHAR2(1);
79
80 P_CG_FROM VARCHAR2(10);
81
82 P_CG_TO VARCHAR2(10);
83
84 P_EXP_SUB NUMBER;
85
86 P_AS_OF_DATE VARCHAR2(30);
87
88 P_TITLE VARCHAR2(240);
89
90 P_INTRANSIT NUMBER;
91
92 FUNCTION BEFOREPFORM RETURN BOOLEAN;
93
94 FUNCTION AFTERPFORM RETURN BOOLEAN;
95
96 FUNCTION BEFOREREPORT RETURN BOOLEAN;
97
98 FUNCTION AFTERREPORT RETURN BOOLEAN;
99
100 FUNCTION CG_ITEM_PSEGFORMULA(CG_ITEM_NUMBER IN VARCHAR2
101 ,CG_ITEM_SEGMENT IN VARCHAR2
102 ,CG_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
103
104 FUNCTION CG_MATL1FORMULA(CG_QUANTITY IN NUMBER
105 ,CG_MATL IN NUMBER) RETURN NUMBER;
106
107 FUNCTION CG_MOVH1FORMULA(CG_QUANTITY IN NUMBER
108 ,CG_MOVH IN NUMBER) RETURN NUMBER;
109
110 FUNCTION CG_OSP1FORMULA(CG_QUANTITY IN NUMBER
111 ,CG_OSP IN NUMBER) RETURN NUMBER;
112
113 FUNCTION CG_OVHD1FORMULA(CG_QUANTITY IN NUMBER
114 ,CG_OVHD IN NUMBER) RETURN NUMBER;
115
116 FUNCTION CG_RES1FORMULA(CG_QUANTITY IN NUMBER
117 ,CG_RES IN NUMBER) RETURN NUMBER;
118
119 FUNCTION CG_ROWCOUNTFORMULA(CG_QUANTITY IN NUMBER) RETURN NUMBER;
120
121 FUNCTION CG_TOTAL1FORMULA(CG_QUANTITY IN NUMBER
122 ,CG_TOTAL IN NUMBER) RETURN NUMBER;
123
124 FUNCTION IC_MATL1FORMULA(IC_QUANTITY IN NUMBER
125 ,IC_MATL IN NUMBER) RETURN NUMBER;
126
127 FUNCTION IC_MOVH1FORMULA(IC_QUANTITY IN NUMBER
128 ,IC_MOVH IN NUMBER) RETURN NUMBER;
129
130 FUNCTION IC_OSP1FORMULA(IC_QUANTITY IN NUMBER
131 ,IC_OSP IN NUMBER) RETURN NUMBER;
132
133 FUNCTION IC_OVHD1FORMULA(IC_QUANTITY IN NUMBER
134 ,IC_OVHD IN NUMBER) RETURN NUMBER;
135
136 FUNCTION IC_QUANTITY1FORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
137
138 FUNCTION IC_RES1FORMULA(IC_QUANTITY IN NUMBER
139 ,IC_RES IN NUMBER) RETURN NUMBER;
140
141 FUNCTION IC_ROWCOUNTFORMULA(IC_QUANTITY IN NUMBER) RETURN NUMBER;
142
143 FUNCTION IC_TOTAL1FORMULA(IC_QUANTITY IN NUMBER
144 ,IC_TOTAL IN NUMBER) RETURN NUMBER;
145
146 FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY_SEGMENT IN VARCHAR2
147 ,IC_CATEGORY IN VARCHAR2
148 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
149
150 FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_SEGMENT IN VARCHAR2
151 ,IC_ITEM_NUMBER IN VARCHAR2
152 ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
153
154 FUNCTION IC_ORDERFORMULA(IC_ITEM_NUMBER IN VARCHAR2
155 ,IC_CATEGORY IN VARCHAR2
156 ,IC_ITEM_SEGMENT IN VARCHAR2
157 ,IC_CATEGORY_SEGMENT IN VARCHAR2
158 ,IC_ITEM_PSEG IN VARCHAR2
159 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
160
161 END BOM_CSTREIVW_XMLP_PKG;
162