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_CSTRACCR_XMLP_PKG

Source


1 PACKAGE BOM_CSTRACCR_XMLP_PKG AS
2 /* $Header: CSTRACCRS.pls 120.0 2007/12/24 09:49:52 dwkrishn noship $ */
3   P_TITLE VARCHAR2(50);
4 
5 
6   P_CONC_REQUEST_ID NUMBER := 0;
7 
8   P_VENDOR_FROM VARCHAR2(240);
9 
10   P_VENDOR_TO VARCHAR2(240);
11 
12   P_GL_DATE_FROM DATE;
13 
14   P_GL_DATE_TO DATE;
15 
16   P_QTY_PRECISION NUMBER;
17 
18   QTY_PRECISION varchar2(50);
19 
20   P_ACCT_SEG VARCHAR2(1440);
21 
22   P_ITEM_SEG VARCHAR2(1440);
23 
24   P_ITEM_WHERE VARCHAR2(2000);
25 
26   P_ITEM_NUM NUMBER;
27 
28   P_ITEM_FROM VARCHAR2(900);
29 
30   P_ITEM_TO VARCHAR2(900);
31 
32   P_CHART_OF_ACCOUNTS_ID NUMBER;
33 
34    LP_CHART_OF_ACCOUNTS_ID NUMBER;
35 
36   P_WRITTEN_OFF VARCHAR2(1);
37 
38   LP_WRITTEN_OFF VARCHAR2(1);
39 
40   P_ZERO_BALANCE VARCHAR2(1);
41 
42   P_REBUILD_REPORT VARCHAR2(1);
43 
44   P_REQUEST_ID NUMBER;
45 
46   P_COMPANY VARCHAR2(40);
47 
48   P_ORG_ID VARCHAR2(40);
49 
50   P_CURRENCY_CODE VARCHAR2(15);
51 
52   P_SORT_OPTION VARCHAR2(25);
53 
54   P_SORT_BY VARCHAR2(40);
55 
56   ROUND_UNIT NUMBER;
57 
58 LP_AGE_DAYS NUMBER;
59   P_AGE_DAYS NUMBER;
60 
61   P_RULE VARCHAR2(1);
62 
63   P_TRACE VARCHAR2(1);
64 
65   P_ACCRUAL_CODE VARCHAR2(80):='RECEIPT';
66 
67   P_DEBUG VARCHAR2(1);
68 
69   P_EXT_PREC NUMBER;
70 
71   P_ITEM_VENDOR VARCHAR2(240);
72 
73   P_APPL_ID NUMBER:=201;
74 
75   P_PROGRAM_ID NUMBER:=0;
76 
77   P_QTY_PRES NUMBER;
78 
79   P_QTY_TOLERANCE NUMBER;
80 
81   P_AMT_TOLERANCE NUMBER;
82 
83   SORT_BY_ALTERNATE VARCHAR2(5);
84 
85   P_PERIOD NUMBER;
86 
87   P_LEGAL_ENTITY NUMBER;
88 
89   P_COST_TYPE NUMBER;
90 
91   P_COST_GROUP NUMBER;
92 
93   P_OPERATING_UNIT NUMBER;
94 
95   P_LEGAL_ENTITY_NAME VARCHAR2(240);
96 
97   P_COST_TYPE_NAME VARCHAR2(30);
98 
99   P_COST_GROUP_NAME VARCHAR2(30);
100 
101   P_PERIOD_NAME VARCHAR2(32767);
102 
103   P_MASTER_ORG_ID NUMBER;
104 
105   dummy1 BOOLEAN;
106 
107   dummy2 BOOLEAN;
108 
109   dummy3 BOOLEAN;
110 
111   dummy4 BOOLEAN;
112 
113   P_SET_OF_BOOKS_ID NUMBER;
114 
115   FUNCTION AFTERREPORT RETURN BOOLEAN;
116 
117   FUNCTION AFTERPFORM RETURN BOOLEAN;
118 
119   PROCEDURE DELETE_TABLE;
120 
121   FUNCTION NET_ACCRUAL_BALFORMULA(T_AMOUNT IN NUMBER
122                                  ,IPV IN NUMBER) RETURN NUMBER;
123 
124   FUNCTION SORT_COLUMNFORMULA(ITEM_RAW IN VARCHAR2
125                              ,ITEM_SEG IN VARCHAR2
126                              ,VENDOR_NAME IN VARCHAR2
127                              ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
128 
129   FUNCTION ITEM_PSEGFORMULA(ITEM_RAW IN VARCHAR2
130                            ,ITEM_SEG IN VARCHAR2
131                            ,ITEM_ID IN NUMBER
132                            ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
133 
134   FUNCTION ITEM_VENDORFORMULA(ITEM_RAW IN VARCHAR2
135                              ,ITEM_SEG IN VARCHAR2
136                              ,VENDOR_NAME IN VARCHAR2) RETURN VARCHAR2;
137 
138   FUNCTION ACCT_PSEGFORMULA(ACCT_RAW IN VARCHAR2
139                            ,ACCT_SEG IN VARCHAR2
140                            ,ACCT_PSEG IN VARCHAR2) RETURN VARCHAR2;
141 
142   PROCEDURE INSERT_AP_DATA;
143 
144   PROCEDURE INSERT_AP_MISC;
145 
146   PROCEDURE INSERT_PO_DATA;
147 
148   PROCEDURE MATCH_INV_HEADER;
149 
150   PROCEDURE MATCH_INV_ITEM;
151 
152   PROCEDURE MATCH_INV_LINE;
153 
154   PROCEDURE MATCH_ITEM;
155 
156   PROCEDURE MATCH_NO_ITEM;
157 
158   PROCEDURE MATCH_NO_PO;
159 
160   PROCEDURE POPULATE_TEMP_TABLE;
161 
162   PROCEDURE CALC_IPV;
163 
164   FUNCTION PO_LINE_SORTFORMULA(PO_LINE_NUM IN NUMBER) RETURN NUMBER;
165 
166   FUNCTION INSTALL_STATUS RETURN BOOLEAN;
167 
168   PROCEDURE IDENT_ACCOUNTS;
169 
170   PROCEDURE UPDATE_WRITEOFF;
171 
172   PROCEDURE CALC_BUCKET;
173 
174   PROCEDURE INSERT_MFG_DATA;
175 
176   FUNCTION BEFOREREPORT RETURN BOOLEAN;
177 
178   FUNCTION SORT_COLUMN_DSPFORMULA(ITEM_RAW IN VARCHAR2
179                                  ,ITEM_SEG IN VARCHAR2
180                                  ,VENDOR_NAME IN VARCHAR2) RETURN VARCHAR2;
181 
182   FUNCTION INDICATORFORMULA(WRITE_OFF_ID IN NUMBER) RETURN VARCHAR2;
183 
184   FUNCTION P_QTY_TOLERANCEVALIDTRIGGER RETURN BOOLEAN;
185 
186   FUNCTION SORT_COLUMN_ALTFORMULA(ITEM_RAW IN VARCHAR2
187                                  ,ITEM_SEG IN VARCHAR2
188                                  ,VENDOR_NAME IN VARCHAR2
189                                  ,VENDOR_NAME_ALT IN VARCHAR2
190                                  ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
191 
192   FUNCTION P_PERIODVALIDTRIGGER RETURN BOOLEAN;
193 
194   FUNCTION P_COST_GROUPVALIDTRIGGER RETURN BOOLEAN;
195 
196   FUNCTION P_COST_TYPEVALIDTRIGGER RETURN BOOLEAN;
197 
198   FUNCTION P_LEGAL_ENTITYVALIDTRIGGER RETURN BOOLEAN;
199 
200   PROCEDURE MATCH_RECEIPT;
201 
202   PROCEDURE MATCH_CONDITION;
203 
204   PROCEDURE INSERT_MISC_MFG_DATA;
205 
206   FUNCTION GET(APPL_ID IN INTEGER
207               ,DEP_APPL_ID IN INTEGER
208               ,STATUS OUT NOCOPY VARCHAR2
209               ,INDUSTRY OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
210 
211   FUNCTION GET_APP_INFO(APPLICATION_SHORT_NAME IN VARCHAR2
212                        ,STATUS OUT NOCOPY VARCHAR2
213                        ,INDUSTRY OUT NOCOPY VARCHAR2
214                        ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
215 
216   FUNCTION GET_APP_INFO_OTHER(APPLICATION_SHORT_NAME IN VARCHAR2
217                              ,TARGET_SCHEMA IN VARCHAR2
218                              ,STATUS OUT NOCOPY VARCHAR2
219                              ,INDUSTRY OUT NOCOPY VARCHAR2
220                              ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
221 
222 END BOM_CSTRACCR_XMLP_PKG;
223