eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.INV_INVIRITD_XMLP_PKG

Source


1 PACKAGE INV_INVIRITD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVIRITDS.pls 120.2 2008/01/08 06:54:03 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_CAT_STRUCT_NUM NUMBER;
8 
9   P_CONDITION VARCHAR2(40);
10 
11   P_ITEM_FLEX VARCHAR2(900);
12 
13   P_ITEM_WHERE VARCHAR2(2000);
14 
15   P_CAT_FLEX VARCHAR2(900);
16 
17   P_CAT_WHERE VARCHAR2(2000);
18 
19   P_ITEM_LO VARCHAR2(900);
20 
21   P_ITEM_HI VARCHAR2(900);
22 
23   P_CAT_LO VARCHAR2(900);
24 
25   P_CAT_HI VARCHAR2(900);
26 
27   P_STRUCT_NUM NUMBER;
28 
29   P_BREAK_ID NUMBER;
30 
31   P_CAT_SET_ID NUMBER;
32 
33   P_BOM_ITEM_FLEX VARCHAR2(900);
34 
35   P_ENG_ITEM_FLEX VARCHAR2(900);
36 
37   P_CST_ACCT_FLEX VARCHAR2(900);
38 
39   P_ACCT_STRUCT_NUM NUMBER;
40 
41   P_GEN_INFO NUMBER;
42 
43   P_BOM_INFO NUMBER;
44 
45   P_CST_INFO NUMBER;
46 
47   P_PO_INFO NUMBER;
48 
49   P_RCV_INFO NUMBER;
50 
51   P_ALL_INFO NUMBER;
52 
53   P_PO_EXP_ACCT_FLEX VARCHAR2(900);
54 
55   P_PO_ENC_ACCT_FLEX VARCHAR2(900);
56 
57   P_PO_ACAT_FLEX VARCHAR2(900) := '(PACF.SEGMENT1||''\n''||PACF.SEGMENT2||''\n''||PACF.SEGMENT3||''\n''||PACF.SEGMENT4||''\n''||PACF.SEGMENT5||''\n''||PACF.SEGMENT6||''\n''||PACF.SEGMENT7)';
58 
59   P_ACAT_STRUCT_NUM NUMBER;
60 
61   P_INV_INFO NUMBER;
62 
63   P_PHYS_INFO NUMBER;
64 
65   P_GP_INFO NUMBER;
66 
67   P_MPS_INFO NUMBER;
68 
69   P_LEAD_INFO NUMBER;
70 
71   P_WIP_INFO NUMBER;
72 
73   P_OE_INFO NUMBER;
74 
75   P_INVC_INFO NUMBER;
76 
77   P_WIP_LOC_FLEX VARCHAR2(900);
78 
79   P_INVC_ACCT_FLEX VARCHAR2(900);
80 
81   P_FA_INSTALLED NUMBER;
82 
83   P_ORDERBY VARCHAR2(900);
84 
85   P_SERVICE_INFO NUMBER;
86 
87   P_NO_VALUE VARCHAR2(80);
88 
89   P_WEB_INFO NUMBER;
90 
91   CP_ITEM_NEW_ATTRIBUTES VARCHAR2(40);
92 
93   P_EAM_INFO VARCHAR2(200);
94 
95   P_VALUE_YES VARCHAR2(40);
96 
97   P_VALUE_NO VARCHAR2(40);
98 
99   P_YES_VALUE VARCHAR2(32767);
100 
101   P_OPM_INFO NUMBER;
102 
103   FUNCTION BEFOREREPORT RETURN BOOLEAN;
104 
105   FUNCTION AFTERREPORT RETURN BOOLEAN;
106 
107   FUNCTION C_GEN_INFO_SELFORMULA RETURN VARCHAR2;
108 
109   FUNCTION C_GEN_INFO_FROMFORMULA RETURN VARCHAR2;
110 
111   FUNCTION C_GEN_INFO_WHEREFORMULA RETURN VARCHAR2;
112 
113   FUNCTION AFTERPFORM RETURN BOOLEAN;
114 
115   FUNCTION C_CAT_FROMFORMULA RETURN VARCHAR2;
116 
117   FUNCTION C_CAT_WHEREFORMULA RETURN VARCHAR2;
118 
119   FUNCTION C_CAT_PADFORMULA(C_CAT_FIELD IN VARCHAR2
120                            ,C_CAT_PAD IN VARCHAR2) RETURN VARCHAR2;
121 
122   FUNCTION C_BOM_SELFORMULA RETURN VARCHAR2;
123 
124   FUNCTION C_BOM_FROMFORMULA RETURN VARCHAR2;
125 
126   FUNCTION C_BOM_WHEREFORMULA RETURN VARCHAR2;
127 
128   FUNCTION C_CST_SELFORMULA RETURN VARCHAR2;
129 
130   FUNCTION C_CST_FROMFORMULA RETURN VARCHAR2;
131 
132   FUNCTION C_CST_WHEREFORMULA RETURN VARCHAR2;
133 
134   FUNCTION C_PO_SELFORMULA RETURN VARCHAR2;
135 
136   FUNCTION C_PO_FROMFORMULA RETURN VARCHAR2;
137 
138   FUNCTION C_PO_WHEREFORMULA RETURN VARCHAR2;
139 
140   FUNCTION C_RCV_SELFORMULA RETURN VARCHAR2;
141 
142   FUNCTION C_RCV_FROMFORMULA RETURN VARCHAR2;
143 
144   FUNCTION C_RCV_WHEREFORMULA RETURN VARCHAR2;
145 
146   FUNCTION C_PHYS_SELFORMULA RETURN VARCHAR2;
147 
148   FUNCTION C_GP_SELFORMULA RETURN VARCHAR2;
149 
150   FUNCTION C_GP_FROMFORMULA RETURN VARCHAR2;
151 
152   FUNCTION C_GP_WHEREFORMULA RETURN VARCHAR2;
153 
154   FUNCTION C_MPS_SELFORMULA RETURN VARCHAR2;
155 
156   FUNCTION C_MPS_WHEREFORMULA RETURN VARCHAR2;
157 
158   FUNCTION C_MPS_FROMFORMULA RETURN VARCHAR2;
159 
160   FUNCTION C_LEAD_SELFORMULA RETURN VARCHAR2;
161 
162   FUNCTION C_WIP_SELFORMULA RETURN VARCHAR2;
163 
164   FUNCTION C_WIP_FROMFORMULA RETURN VARCHAR2;
165 
166   FUNCTION C_WIP_WHEREFORMULA RETURN VARCHAR2;
167 
168   FUNCTION C_OE_SELFORMULA RETURN VARCHAR2;
169 
170   FUNCTION C_OE_FROMFORMULA RETURN VARCHAR2;
171 
172   FUNCTION C_OE_WHEREFORMULA RETURN VARCHAR2;
173 
174   FUNCTION C_INVC_SELFORMULA RETURN VARCHAR2;
175 
176   FUNCTION C_INVC_FROMFORMULA RETURN VARCHAR2;
177 
178   FUNCTION C_INVC_WHEREFORMULA RETURN VARCHAR2;
179 
180   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
181 
182   FUNCTION C_ITEM_PADFORMULA(C_ITEM_FIELD IN VARCHAR2
183                             ,C_ITEM_PAD IN VARCHAR2) RETURN VARCHAR2;
184 
185   FUNCTION C_PHYS_FROMFORMULA RETURN VARCHAR2;
186 
187   FUNCTION C_PHYS_WHEREFORMULA RETURN VARCHAR2;
188 
189   FUNCTION C_CAT_PAD2FORMULA(C_CAT_FIELD2 IN VARCHAR2
190                             ,C_CAT_PAD2 IN VARCHAR2) RETURN VARCHAR2;
191 
192   FUNCTION C_SERVICE_INFO_SELFORMULA RETURN VARCHAR2;
193 
194   FUNCTION C_SERVICE_INFO_FROMFORMULA RETURN NUMBER;
195 
196   FUNCTION C_SERVICE_INFO_WHEREFORMULA RETURN NUMBER;
197 
198   FUNCTION RESOLVE_VENDOR_WARRANTY(VENDOR_WARRANTY_FLAG IN VARCHAR2) RETURN VARCHAR2;
199 
200   FUNCTION RESOLVE_SERVICE_ITEM_FLAG(SERVICE_ITEM_FLAG IN VARCHAR2) RETURN VARCHAR2;
201 
202   FUNCTION RESOLVE_SERVICEABLE_PRODUCT(SERVICEABLE_PRODUCT_FLAG IN VARCHAR2) RETURN VARCHAR2;
203 
204   FUNCTION RESOLVE_MATERIAL_BILLABLE(MATERIAL_BILLABLE_FLAG IN VARCHAR2) RETURN VARCHAR2;
205 
206   FUNCTION C_WEB_SELFORMULA RETURN VARCHAR2;
207 
208   FUNCTION C_EAM_FROMFORMULA RETURN CHAR;
209 
210   FUNCTION C_EAM_SELFORMULA RETURN CHAR;
211 
212   FUNCTION C_EAM_WHEREFORMULA RETURN CHAR;
213 
214   FUNCTION C_OPM_FROMFORMULA RETURN VARCHAR2;
215 
216   FUNCTION C_OPM_SELFORMULA RETURN VARCHAR2;
217 
218   FUNCTION C_OPM_WHEREFORMULA RETURN VARCHAR2;
219 
220   FUNCTION C_INV_WHEREFORMULA RETURN VARCHAR2;
221 
222   FUNCTION C_INV_SELFORMULA RETURN VARCHAR2;
223 
224   FUNCTION C_INV_FROMFORMULA RETURN VARCHAR2;
225 
226   FUNCTION C_INVC_SELECT(C_invc_acct_field varchar2) RETURN VARCHAR2;
227 
228   FUNCTION C_WIP_SELECT(C_WIP_LOC_FIELD VARCHAR2) RETURN VARCHAR2;
229 
230   FUNCTION C_EXP_SELECT(C_EXP_ACCT_FIELD VARCHAR2) RETURN VARCHAR2;
231 
232   FUNCTION C_ENC_SELECT(C_ENC_ACCT_FIELD VARCHAR2) RETURN VARCHAR2;
233 
234   FUNCTION C_ACAT_SELECT(C_ACAT_FIELD VARCHAR2) RETURN VARCHAR2;
235 
236   FUNCTION C_CST_SELECT(C_CST_ACCT_FIELD VARCHAR2) RETURN VARCHAR2;
237 
238 END INV_INVIRITD_XMLP_PKG;
239