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.BOM_CSTRPMDD_XMLP_PKG

Source


1 PACKAGE BOM_CSTRPMDD_XMLP_PKG AS
2 /* $Header: CSTRPMDDS.pls 120.0 2007/12/24 10:14:34 dwkrishn noship $ */
3   P_SOURCE_TYPE_ID NUMBER;
4 
5   P_STRUCT_NUM VARCHAR2(15);
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_ITEM_FLEX VARCHAR2(2000);
10 
11   P_ACCT_FLEX VARCHAR2(2000);
12 
13   P_WHERE_ACCT VARCHAR2(2000);
14 
15   P_ACCT_LO VARCHAR2(900);
16 
17   P_SOURCE_LO VARCHAR2(900);
18 
19   P_SOURCE_HI VARCHAR2(900);
20 
21   P_SOURCE_WHERE VARCHAR2(2000);
22 
23   P_ACCT_HI VARCHAR2(900);
24 
25   P_SORT_ID NUMBER;
26 
27   P_TXN_TYPE_ID NUMBER;
28 
29   P_WHERE_ITEM VARCHAR2(2000);
30 
31   P_ITEM_LO VARCHAR2(900);
32 
33   P_ITEM_HI VARCHAR2(900);
34 
35   P_VALUE_LO NUMBER;
36 
37   P_VALUE_HI NUMBER;
38 
39   P_CBO_FLAG VARCHAR2(40);
40 
41   P_ACCT_STRUCT_NUM NUMBER;
42 
43   P_CAT_HI VARCHAR2(900);
44 
45   P_CAT_LO VARCHAR2(900);
46 
47   P_REASON_ID NUMBER;
48 
49   P_WHERE_CAT VARCHAR2(2000);
50 
51   P_CAT_SET_ID NUMBER;
52 
53   P_SO_FLEX VARCHAR2(2000);
54 
55   P_ALIAS_FLEX VARCHAR2(2000);
56 
57   P_GL_FLEX VARCHAR2(2000);
58 
59   P_TYPE_OPTION NUMBER;
60 
61   P_CAT_STRUCT_NUM VARCHAR2(15);
62 
63   P_ITEM_SORT VARCHAR2(900);
64 
65   P_ACCT_SORT VARCHAR2(900);
66 
67   P_QUANTITY_PRECISION NUMBER;
68 
69   P_TRACE_FLAG NUMBER;
70 
71   P_CURRENCY_CODE VARCHAR2(15);
72 
73   P_EXCHANGE_RATE NUMBER;
74 
75   P_LEGAL_ENTITY_ID NUMBER;
76 
77   P_COST_GROUP_ID NUMBER;
78 
79   P_COST_TYPE_ID NUMBER;
80 
81   P_PERIOD_ID NUMBER;
82 
83   P_SOURCE_WHERE2 VARCHAR2(2000) := ' and 1=1';
84 
85   Qty_precision varchar2(100);
86 
87   CP_APPLICATION VARCHAR2(240);
88 
89   CP_COST_GROUP VARCHAR2(32767);
90 
91   CP_COST_TYPE VARCHAR2(32767);
92 
93   CP_LEGAL_ENTITY VARCHAR2(240);
94 
95   CP_PERIOD_NAME VARCHAR2(15);
96 
97   CP_REQUESTED_BY VARCHAR2(100);
98 
99   CP_REQUEST_TIME VARCHAR2(30);
100 
101   CP_RESPONSIBILITY VARCHAR2(200);
102 
103   CP_PRECISION NUMBER := 1;
104 
105   CP_SORT_BY_COV VARCHAR2(80);
106 
107   CP_TYPE_OPTION_COV VARCHAR2(80);
108 
109   CP_EXT_PRECISION NUMBER;
110 
111   FUNCTION C_SOURCE_TYPE_NAMEFORMULA RETURN VARCHAR2;
112 
113   FUNCTION BEFOREREPORT RETURN BOOLEAN;
114 
115   FUNCTION AFTERREPORT RETURN BOOLEAN;
116 
117   FUNCTION C_ACCT_PAD0FORMULA(C_ACCT_PAD0 IN VARCHAR2) RETURN VARCHAR2;
118 
119   FUNCTION C_ACCT_PAD1FORMULA(C_ACCT_PAD1 IN VARCHAR2) RETURN VARCHAR2;
120 
121   FUNCTION C_ACCT_PAD2FORMULA(C_ACCT_PAD2 IN VARCHAR2) RETURN VARCHAR2;
122 
123   FUNCTION C_ITEM_PAD1FORMULA(C_ITEM_PAD1 IN VARCHAR2) RETURN VARCHAR2;
124 
125   FUNCTION C_ITEM_PAD2FORMULA(C_ITEM_PAD2 IN VARCHAR2) RETURN VARCHAR2;
126 
127   FUNCTION C_SOURCE_WHEREFORMULA RETURN VARCHAR2;
128 
129   FUNCTION WHERE_VALUE RETURN VARCHAR2;
130 
131   FUNCTION C_WHERE_REASONFORMULA RETURN VARCHAR2;
132 
133   FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
134 
135   FUNCTION C_WHERE_CATFORMULA RETURN VARCHAR2;
136 
137   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
138 
139   FUNCTION C_TXN_TYPE_NAMEFORMULA RETURN VARCHAR2;
140 
141   FUNCTION C_REASON_NAMEFORMULA RETURN VARCHAR2;
142 
143   FUNCTION C_TYPE_OPTIONFORMULA RETURN VARCHAR2;
144 
145   FUNCTION C_FROM_TYPEFORMULA RETURN VARCHAR2;
146 
147   FUNCTION C_WHERE_TYPEFORMULA RETURN VARCHAR2;
148 
149   FUNCTION AFTERPFORM RETURN BOOLEAN;
150 
151   FUNCTION C_SOURCE_FROMFORMULA RETURN VARCHAR2;
152 
153   FUNCTION C_ACCT_VALUE0_RFORMULA(C_ACCT_VALUE0 IN NUMBER) RETURN NUMBER;
154 
155   FUNCTION VALUE_RFORMULA(VALUE IN NUMBER) RETURN NUMBER;
156 
157   FUNCTION C_REPORT_VALUE_RFORMULA(C_REPORT_VALUE IN NUMBER) RETURN NUMBER;
158 
159   FUNCTION C_ACCT_VALUE1_RFORMULA(C_ACCT_VALUE1 IN NUMBER) RETURN NUMBER;
160 
161   FUNCTION C_ITEM_VALUE2_RFORMULA(C_ITEM_VALUE2 IN NUMBER) RETURN NUMBER;
162 
163   FUNCTION C_REPORT_VALUE1_RFORMULA(C_REPORT_VALUE1 IN NUMBER) RETURN NUMBER;
164 
165   FUNCTION C_REPORT_VALUE2_RFORMULA(C_REPORT_VALUE2 IN NUMBER) RETURN NUMBER;
166 
167   FUNCTION VALUE1_RFORMULA(VALUE1 IN NUMBER) RETURN NUMBER;
168 
169   FUNCTION VALUE2_RFORMULA(VALUE2 IN NUMBER) RETURN NUMBER;
170 
171   FUNCTION C_RT_WHERE_CATFORMULA RETURN CHAR;
172 
173   FUNCTION C_RT_WHERE_REASONFORMULA RETURN CHAR;
174 
175   FUNCTION C_RT_TYPE_OPTIONFORMULA RETURN CHAR;
176 
177   FUNCTION C_TXN_QUANTITY(L_AE_LINE_ID IN NUMBER
178                          ,L_QUANTITY IN NUMBER) RETURN NUMBER;
179 
180   FUNCTION C_QUANTITYFORMULA(AE_LINE_ID IN NUMBER
181                             ,QUANTITY IN NUMBER) RETURN NUMBER;
182 
183   FUNCTION C_QUANTITY1FORMULA(AE_LINE_ID1 IN NUMBER
184                              ,QUANTITY1 IN NUMBER) RETURN NUMBER;
185 
186   FUNCTION C_QUANTITY2FORMULA(AE_LINE_ID2 IN NUMBER
187                              ,QUANTITY2 IN NUMBER) RETURN NUMBER;
188 
189   FUNCTION CP_APPLICATION_P RETURN VARCHAR2;
190 
191   FUNCTION CP_COST_GROUP_P RETURN VARCHAR2;
192 
193   FUNCTION CP_COST_TYPE_P RETURN VARCHAR2;
194 
195   FUNCTION CP_LEGAL_ENTITY_P RETURN VARCHAR2;
196 
197   FUNCTION CP_PERIOD_NAME_P RETURN VARCHAR2;
198 
199   FUNCTION CP_REQUESTED_BY_P RETURN VARCHAR2;
200 
201   FUNCTION CP_REQUEST_TIME_P RETURN VARCHAR2;
202 
203   FUNCTION CP_RESPONSIBILITY_P RETURN VARCHAR2;
204 
205   FUNCTION CP_PRECISION_P RETURN NUMBER;
206 
207   FUNCTION CP_SORT_BY_COV_P RETURN VARCHAR2;
208 
209   FUNCTION CP_TYPE_OPTION_COV_P RETURN VARCHAR2;
210 
211   FUNCTION CP_EXT_PRECISION_P RETURN NUMBER;
212 
213 END BOM_CSTRPMDD_XMLP_PKG;
214 
215