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 AUTHID CURRENT_USER AS
2 /* $Header: CSTRPMDDS.pls 120.0.12020000.2 2012/10/11 01:56:01 zazeng ship $ */
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   FUNCTION C_SOURCEFORMULA(P_ORG_ID IN NUMBER, P_TXN_SRC_TYPE_ID IN NUMBER, P_TXN_SRC_ID IN NUMBER ) RETURN VARCHAR2;
113 
114   FUNCTION BEFOREREPORT RETURN BOOLEAN;
115 
116   FUNCTION AFTERREPORT RETURN BOOLEAN;
117 
118   FUNCTION C_ACCT_PAD0FORMULA(C_ACCT_PAD0 IN VARCHAR2) RETURN VARCHAR2;
119 
120   FUNCTION C_ACCT_PAD1FORMULA(C_ACCT_PAD1 IN VARCHAR2) RETURN VARCHAR2;
121 
122   FUNCTION C_ACCT_PAD2FORMULA(C_ACCT_PAD2 IN VARCHAR2) RETURN VARCHAR2;
123 
124   FUNCTION C_ITEM_PAD1FORMULA(C_ITEM_PAD1 IN VARCHAR2) RETURN VARCHAR2;
125 
126   FUNCTION C_ITEM_PAD2FORMULA(C_ITEM_PAD2 IN VARCHAR2) RETURN VARCHAR2;
127 
128   FUNCTION C_SOURCE_WHEREFORMULA RETURN VARCHAR2;
129 
130   FUNCTION WHERE_VALUE RETURN VARCHAR2;
131 
132   FUNCTION C_WHERE_REASONFORMULA RETURN VARCHAR2;
133 
134   FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
135 
136   FUNCTION C_WHERE_CATFORMULA RETURN VARCHAR2;
137 
138   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
139 
140   FUNCTION C_TXN_TYPE_NAMEFORMULA RETURN VARCHAR2;
141 
142   FUNCTION C_REASON_NAMEFORMULA RETURN VARCHAR2;
143 
144   FUNCTION C_TYPE_OPTIONFORMULA RETURN VARCHAR2;
145 
146   FUNCTION C_FROM_TYPEFORMULA RETURN VARCHAR2;
147 
148   FUNCTION C_WHERE_TYPEFORMULA RETURN VARCHAR2;
149 
150   FUNCTION AFTERPFORM RETURN BOOLEAN;
151 
152   FUNCTION C_SOURCE_FROMFORMULA RETURN VARCHAR2;
153 
154   FUNCTION C_ACCT_VALUE0_RFORMULA(C_ACCT_VALUE0 IN NUMBER) RETURN NUMBER;
155 
156   FUNCTION VALUE_RFORMULA(VALUE IN NUMBER) RETURN NUMBER;
157 
158   FUNCTION C_REPORT_VALUE_RFORMULA(C_REPORT_VALUE IN NUMBER) RETURN NUMBER;
159 
160   FUNCTION C_ACCT_VALUE1_RFORMULA(C_ACCT_VALUE1 IN NUMBER) RETURN NUMBER;
161 
162   FUNCTION C_ITEM_VALUE2_RFORMULA(C_ITEM_VALUE2 IN NUMBER) RETURN NUMBER;
163 
164   FUNCTION C_REPORT_VALUE1_RFORMULA(C_REPORT_VALUE1 IN NUMBER) RETURN NUMBER;
165 
166   FUNCTION C_REPORT_VALUE2_RFORMULA(C_REPORT_VALUE2 IN NUMBER) RETURN NUMBER;
167 
168   FUNCTION VALUE1_RFORMULA(VALUE1 IN NUMBER) RETURN NUMBER;
169 
170   FUNCTION VALUE2_RFORMULA(VALUE2 IN NUMBER) RETURN NUMBER;
171 
172   FUNCTION C_RT_WHERE_CATFORMULA RETURN CHAR;
173 
174   FUNCTION C_RT_WHERE_REASONFORMULA RETURN CHAR;
175 
176   FUNCTION C_RT_TYPE_OPTIONFORMULA RETURN CHAR;
177 
178   FUNCTION C_TXN_QUANTITY(L_AE_LINE_ID IN NUMBER
179                          ,L_QUANTITY IN NUMBER) RETURN NUMBER;
180 
181   FUNCTION C_QUANTITYFORMULA(AE_LINE_ID IN NUMBER
182                             ,QUANTITY IN NUMBER) RETURN NUMBER;
183 
184   FUNCTION C_QUANTITY1FORMULA(AE_LINE_ID1 IN NUMBER
185                              ,QUANTITY1 IN NUMBER) RETURN NUMBER;
186 
187   FUNCTION C_QUANTITY2FORMULA(AE_LINE_ID2 IN NUMBER
188                              ,QUANTITY2 IN NUMBER) RETURN NUMBER;
189 
190   FUNCTION CP_APPLICATION_P RETURN VARCHAR2;
191 
192   FUNCTION CP_COST_GROUP_P RETURN VARCHAR2;
193 
194   FUNCTION CP_COST_TYPE_P RETURN VARCHAR2;
195 
196   FUNCTION CP_LEGAL_ENTITY_P RETURN VARCHAR2;
197 
198   FUNCTION CP_PERIOD_NAME_P RETURN VARCHAR2;
199 
200   FUNCTION CP_REQUESTED_BY_P RETURN VARCHAR2;
201 
202   FUNCTION CP_REQUEST_TIME_P RETURN VARCHAR2;
203 
204   FUNCTION CP_RESPONSIBILITY_P RETURN VARCHAR2;
205 
206   FUNCTION CP_PRECISION_P RETURN NUMBER;
207 
208   FUNCTION CP_SORT_BY_COV_P RETURN VARCHAR2;
209 
210   FUNCTION CP_TYPE_OPTION_COV_P RETURN VARCHAR2;
211 
212   FUNCTION CP_EXT_PRECISION_P RETURN NUMBER;
213 
214 END BOM_CSTRPMDD_XMLP_PKG;
215 
216