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

Source


1 package OE_TRANSACTION_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: OEXUTRNS.pls 120.2.12020000.4 2013/01/31 08:05:02 spothula ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_ORG_ID in number,
7   X_TRANSACTION_TYPE_ID in NUMBER,
8   X_TRANSACTION_TYPE_CODE in VARCHAR2,
9   X_ORDER_CATEGORY_CODE in VARCHAR2,
10   X_START_DATE_ACTIVE in DATE,
11   X_END_DATE_ACTIVE in DATE,
12   X_REQUEST_ID in NUMBER,
13   X_CURRENCY_CODE in VARCHAR2,
14   X_CONVERSION_TYPE_CODE in VARCHAR2,
15   X_CUST_TRX_TYPE_ID in NUMBER,
16   X_COST_OF_GOODS_SOLD_ACCOUNT in NUMBER,
17   X_ENTRY_CREDIT_CHECK_RULE_ID in NUMBER,
18   X_SHIPPING_CREDIT_CHECK_RULE_I in NUMBER,
19   X_PICKING_CREDIT_CHECK_RULE_ID in NUMBER,
20   X_PACKING_CREDIT_CHECK_RULE_ID in NUMBER,
21   X_PRICE_LIST_ID in NUMBER,
22   X_ENFORCE_LINE_PRICES_FLAG in VARCHAR2,
23   X_WAREHOUSE_ID in NUMBER,
24   X_DEMAND_CLASS_CODE in VARCHAR2,
25   X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
26   X_SHIPPING_METHOD_CODE in VARCHAR2,
27   X_FREIGHT_TERMS_CODE in VARCHAR2,
28   X_FOB_POINT_CODE in VARCHAR2,
29   X_SHIP_SOURCE_TYPE_CODE in VARCHAR2,
30   X_AGREEMENT_TYPE_CODE in VARCHAR2,
31   X_AGREEMENT_REQUIRED_FLAG in VARCHAR2,
32   X_PO_REQUIRED_FLAG in VARCHAR2,
33   X_INVOICING_RULE_ID in NUMBER,
34   X_INVOICING_CREDIT_METHOD_CODE in VARCHAR2,
35   X_ACCOUNTING_RULE_ID in NUMBER,
36   X_ACCOUNTING_CREDIT_METHOD_COD in VARCHAR2,
37   X_INVOICE_SOURCE_ID in VARCHAR2,
38   X_NON_DELIVERY_INVOICE_SOURCE_ in VARCHAR2,
39   X_DEFAULT_INBOUND_LINE_TYPE_ID in NUMBER,
40   X_DEFAULT_OUTBOUND_LINE_TYPE_I in NUMBER,
41   X_INSPECTION_REQUIRED_FLAG in VARCHAR2,
42   X_DEPOT_REPAIR_CODE in VARCHAR2,
43   X_AUTO_SCHEDULING_FLAG in VARCHAR2,
44   X_SCHEDULING_LEVEL_CODE in VARCHAR2,
45   X_CONTEXT in VARCHAR2,
46   X_ATTRIBUTE1 in VARCHAR2,
47   X_ATTRIBUTE2 in VARCHAR2,
48   X_ATTRIBUTE3 in VARCHAR2,
49   X_ATTRIBUTE4 in VARCHAR2,
50   X_ATTRIBUTE5 in VARCHAR2,
51   X_ATTRIBUTE6 in VARCHAR2,
52   X_ATTRIBUTE7 in VARCHAR2,
53   X_ATTRIBUTE8 in VARCHAR2,
54   X_ATTRIBUTE9 in VARCHAR2,
55   X_ATTRIBUTE10 in VARCHAR2,
56   X_ATTRIBUTE11 in VARCHAR2,
57   X_ATTRIBUTE12 in VARCHAR2,
58   X_ATTRIBUTE13 in VARCHAR2,
59   X_ATTRIBUTE14 in VARCHAR2,
60   X_ATTRIBUTE15 in VARCHAR2,
61   X_NAME in VARCHAR2,
62   X_DESCRIPTION in VARCHAR2,
63   X_LAYOUT_TEMPLATE_ID in number,
64   X_CREATION_DATE in DATE,
65   X_CREATED_BY in NUMBER,
66   X_LAST_UPDATE_DATE in DATE,
67   X_LAST_UPDATED_BY in NUMBER,
68   X_LAST_UPDATE_LOGIN in NUMBER,
69   X_SALES_DOCUMENT_TYPE_CODE in VARCHAR2,
70   X_TAX_CALCULATION_EVENT IN VARCHAR2 := NULL,
71   X_MIN_MARGIN_PERCENT in NUMBER Default null,
72   X_DEFAULT_FULFILLMENT_SET   in VARCHAR2 default null,
73   X_DEFAULT_LINE_SET_CODE     in VARCHAR2 default null,
74   X_def_transaction_phase_code     in VARCHAR2 default null,
75   X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
76   X_CONTRACT_TEMPLATE_ID in number,
77   X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --ER#16014135 --CC Reversal
78   X_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
79 );
80 
81 procedure LOCK_ROW (
82   X_TRANSACTION_TYPE_ID in NUMBER,
83   X_TRANSACTION_TYPE_CODE in VARCHAR2,
84   X_ORDER_CATEGORY_CODE in VARCHAR2,
85   X_START_DATE_ACTIVE in DATE,
86   X_END_DATE_ACTIVE in DATE,
87   X_REQUEST_ID in NUMBER,
88   X_CURRENCY_CODE in VARCHAR2,
89   X_CONVERSION_TYPE_CODE in VARCHAR2,
90   X_CUST_TRX_TYPE_ID in NUMBER,
91   X_COST_OF_GOODS_SOLD_ACCOUNT in NUMBER,
92   X_ENTRY_CREDIT_CHECK_RULE_ID in NUMBER,
93   X_SHIPPING_CREDIT_CHECK_RULE_I in NUMBER,
94   X_PICKING_CREDIT_CHECK_RULE_ID in NUMBER,
95   X_PACKING_CREDIT_CHECK_RULE_ID in NUMBER,
96   X_PRICE_LIST_ID in NUMBER,
97   X_ENFORCE_LINE_PRICES_FLAG in VARCHAR2,
98   X_WAREHOUSE_ID in NUMBER,
99   X_DEMAND_CLASS_CODE in VARCHAR2,
100   X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
101   X_SHIPPING_METHOD_CODE in VARCHAR2,
102   X_FREIGHT_TERMS_CODE in VARCHAR2,
103   X_FOB_POINT_CODE in VARCHAR2,
104   X_SHIP_SOURCE_TYPE_CODE in VARCHAR2,
105   X_AGREEMENT_TYPE_CODE in VARCHAR2,
106   X_AGREEMENT_REQUIRED_FLAG in VARCHAR2,
107   X_PO_REQUIRED_FLAG in VARCHAR2,
108   X_INVOICING_RULE_ID in NUMBER,
109   X_INVOICING_CREDIT_METHOD_CODE in VARCHAR2,
110   X_ACCOUNTING_RULE_ID in NUMBER,
111   X_ACCOUNTING_CREDIT_METHOD_COD in VARCHAR2,
112   X_INVOICE_SOURCE_ID in VARCHAR2,
113   X_NON_DELIVERY_INVOICE_SOURCE_ in VARCHAR2,
114   X_DEFAULT_INBOUND_LINE_TYPE_ID in NUMBER,
115   X_DEFAULT_OUTBOUND_LINE_TYPE_I in NUMBER,
116   X_INSPECTION_REQUIRED_FLAG in VARCHAR2,
117   X_DEPOT_REPAIR_CODE in VARCHAR2,
118   X_AUTO_SCHEDULING_FLAG in VARCHAR2,
119   X_SCHEDULING_LEVEL_CODE in VARCHAR2,
120   X_CONTEXT in VARCHAR2,
121   X_ATTRIBUTE1 in VARCHAR2,
122   X_ATTRIBUTE2 in VARCHAR2,
123   X_ATTRIBUTE3 in VARCHAR2,
124   X_ATTRIBUTE4 in VARCHAR2,
125   X_ATTRIBUTE5 in VARCHAR2,
126   X_ATTRIBUTE6 in VARCHAR2,
127   X_ATTRIBUTE7 in VARCHAR2,
128   X_ATTRIBUTE8 in VARCHAR2,
129   X_ATTRIBUTE9 in VARCHAR2,
130   X_ATTRIBUTE10 in VARCHAR2,
131   X_ATTRIBUTE11 in VARCHAR2,
132   X_ATTRIBUTE12 in VARCHAR2,
133   X_ATTRIBUTE13 in VARCHAR2,
134   X_ATTRIBUTE14 in VARCHAR2,
135   X_ATTRIBUTE15 in VARCHAR2,
136   X_NAME in VARCHAR2,
137   X_DESCRIPTION in VARCHAR2,
138   X_LAYOUT_TEMPLATE_ID in number,
139   X_TAX_CALCULATION_EVENT IN VARCHAR2 := NULL,
140   X_MIN_MARGIN_PERCENT in NUMBER Default Null,
141   X_DEFAULT_FULFILLMENT_SET   in VARCHAR2 default null,
142   X_DEFAULT_LINE_SET_CODE     in VARCHAR2 default null,
143   X_def_transaction_phase_code     in VARCHAR2 default null,
144   X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
145   X_CONTRACT_TEMPLATE_ID in number,
146   X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --ER#16014135 --CC Reversal
147   X_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
148 );
149 
150 procedure UPDATE_ROW (
151   X_TRANSACTION_TYPE_ID in NUMBER,
152   X_TRANSACTION_TYPE_CODE in VARCHAR2 default null,
153   X_ORDER_CATEGORY_CODE in VARCHAR2 default null,
154   X_START_DATE_ACTIVE in DATE default null,
155   X_END_DATE_ACTIVE in DATE default null,
156   X_REQUEST_ID in NUMBER default null,
157   X_CURRENCY_CODE in VARCHAR2 default null,
158   X_CONVERSION_TYPE_CODE in VARCHAR2 default null,
159   X_CUST_TRX_TYPE_ID in NUMBER default null,
160   X_COST_OF_GOODS_SOLD_ACCOUNT in NUMBER default null,
161   X_ENTRY_CREDIT_CHECK_RULE_ID in NUMBER default null,
162   X_SHIPPING_CREDIT_CHECK_RULE_I in NUMBER default null,
163   X_PICKING_CREDIT_CHECK_RULE_ID in NUMBER default null,
164   X_PACKING_CREDIT_CHECK_RULE_ID in NUMBER default null,
165   X_PRICE_LIST_ID in NUMBER default null,
166   X_ENFORCE_LINE_PRICES_FLAG in VARCHAR2 default null,
167   X_WAREHOUSE_ID in NUMBER default null,
168   X_DEMAND_CLASS_CODE in VARCHAR2 default null,
169   X_SHIPMENT_PRIORITY_CODE in VARCHAR2 default null,
170   X_SHIPPING_METHOD_CODE in VARCHAR2 default null,
171   X_FREIGHT_TERMS_CODE in VARCHAR2 default null,
172   X_FOB_POINT_CODE in VARCHAR2 default null,
173   X_SHIP_SOURCE_TYPE_CODE in VARCHAR2 default null,
174   X_AGREEMENT_TYPE_CODE in VARCHAR2 default null,
175   X_AGREEMENT_REQUIRED_FLAG in VARCHAR2 default null,
176   X_PO_REQUIRED_FLAG in VARCHAR2 default null,
177   X_INVOICING_RULE_ID in NUMBER default null,
178   X_INVOICING_CREDIT_METHOD_CODE in VARCHAR2 default null,
179   X_ACCOUNTING_RULE_ID in NUMBER default null,
180   X_ACCOUNTING_CREDIT_METHOD_COD in VARCHAR2 default null,
181   X_INVOICE_SOURCE_ID in VARCHAR2 default null,
182   X_NON_DELIVERY_INVOICE_SOURCE_ in VARCHAR2 default null,
183   X_DEFAULT_INBOUND_LINE_TYPE_ID in NUMBER default null,
184   X_DEFAULT_OUTBOUND_LINE_TYPE_I in NUMBER default null,
185   X_INSPECTION_REQUIRED_FLAG in VARCHAR2 default null,
186   X_DEPOT_REPAIR_CODE in VARCHAR2 default null,
187   X_AUTO_SCHEDULING_FLAG in VARCHAR2 default null,
188   X_SCHEDULING_LEVEL_CODE in VARCHAR2 default null,
189   X_CONTEXT in VARCHAR2 default null,
190   X_ATTRIBUTE1 in VARCHAR2 default null,
191   X_ATTRIBUTE2 in VARCHAR2 default null,
192   X_ATTRIBUTE3 in VARCHAR2 default null,
193   X_ATTRIBUTE4 in VARCHAR2 default null,
194   X_ATTRIBUTE5 in VARCHAR2 default null,
195   X_ATTRIBUTE6 in VARCHAR2 default null,
196   X_ATTRIBUTE7 in VARCHAR2 default null,
197   X_ATTRIBUTE8 in VARCHAR2 default null,
198   X_ATTRIBUTE9 in VARCHAR2 default null,
199   X_ATTRIBUTE10 in VARCHAR2 default null,
200   X_ATTRIBUTE11 in VARCHAR2 default null,
201   X_ATTRIBUTE12 in VARCHAR2 default null,
202   X_ATTRIBUTE13 in VARCHAR2 default null,
203   X_ATTRIBUTE14 in VARCHAR2 default null,
204   X_ATTRIBUTE15 in VARCHAR2 default null,
205   X_NAME in VARCHAR2 default null,
206   X_DESCRIPTION in VARCHAR2 default null,
207   X_LAYOUT_TEMPLATE_ID in number default null,
208   X_LAST_UPDATE_DATE in DATE default null,
209   X_LAST_UPDATED_BY in NUMBER default null,
210   X_LAST_UPDATE_LOGIN in NUMBER default null,
211   X_TAX_CALCULATION_EVENT IN VARCHAR2 default null,
212   X_MIN_MARGIN_PERCENT in NUMBER default null,
213   X_DEFAULT_FULFILLMENT_SET      in VARCHAR2 default null,
214   X_DEFAULT_LINE_SET_CODE       in VARCHAR2 default null,
215   X_def_transaction_phase_code     in VARCHAR2 default null,
216   X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
217   X_CONTRACT_TEMPLATE_ID in number default null,
218   X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --ER#16014135 --CC Reversal
219   X_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
220 );
221 
222 procedure DELETE_ROW (
223   X_TRANSACTION_TYPE_ID in NUMBER
224 );
225 procedure ADD_LANGUAGE;
226 
227 procedure Load_Row (
228   X_TRANSACTION_TYPE_ID in NUMBER,
229   X_TRANSACTION_TYPE_CODE in VARCHAR2,
230   X_ORDER_CATEGORY_CODE in VARCHAR2,
231   X_START_DATE_ACTIVE in DATE,
232   X_END_DATE_ACTIVE in DATE,
233   X_REQUEST_ID in NUMBER,
234   X_CURRENCY_CODE in VARCHAR2,
235   X_CONVERSION_TYPE_CODE in VARCHAR2,
236   X_CUST_TRX_TYPE_ID in NUMBER,
237   X_COST_OF_GOODS_SOLD_ACCOUNT in NUMBER,
238   X_ENTRY_CREDIT_CHECK_RULE_ID in NUMBER,
239   X_SHIPPING_CREDIT_CHECK_RULE_I in NUMBER,
240   X_PICKING_CREDIT_CHECK_RULE_ID in NUMBER,
241   X_PACKING_CREDIT_CHECK_RULE_ID in NUMBER,
242   X_PRICE_LIST_ID in NUMBER,
243   X_ENFORCE_LINE_PRICES_FLAG in VARCHAR2,
244   X_WAREHOUSE_ID in NUMBER,
245   X_DEMAND_CLASS_CODE in VARCHAR2,
246   X_SHIPMENT_PRIORITY_CODE in VARCHAR2,
247   X_SHIPPING_METHOD_CODE in VARCHAR2,
248   X_FREIGHT_TERMS_CODE in VARCHAR2,
249   X_FOB_POINT_CODE in VARCHAR2,
250   X_SHIP_SOURCE_TYPE_CODE in VARCHAR2,
251   X_AGREEMENT_TYPE_CODE in VARCHAR2,
252   X_AGREEMENT_REQUIRED_FLAG in VARCHAR2,
253   X_PO_REQUIRED_FLAG in VARCHAR2,
254   X_INVOICING_RULE_ID in NUMBER,
255   X_INVOICING_CREDIT_METHOD_CODE in VARCHAR2,
256   X_ACCOUNTING_RULE_ID in NUMBER,
257   X_ACCOUNTING_CREDIT_METHOD_COD in VARCHAR2,
258   X_INVOICE_SOURCE_ID in VARCHAR2,
259   X_NON_DELIVERY_INVOICE_SOURCE_ in VARCHAR2,
260   X_DEFAULT_INBOUND_LINE_TYPE_ID in NUMBER,
261   X_DEFAULT_OUTBOUND_LINE_TYPE_I in NUMBER,
262   X_INSPECTION_REQUIRED_FLAG in VARCHAR2,
263   X_DEPOT_REPAIR_CODE in VARCHAR2,
264   X_AUTO_SCHEDULING_FLAG in VARCHAR2,
265   X_SCHEDULING_LEVEL_CODE in VARCHAR2,
266   X_CONTEXT in VARCHAR2,
267   X_ATTRIBUTE1 in VARCHAR2,
268   X_ATTRIBUTE2 in VARCHAR2,
269   X_ATTRIBUTE3 in VARCHAR2,
270   X_ATTRIBUTE4 in VARCHAR2,
271   X_ATTRIBUTE5 in VARCHAR2,
272   X_ATTRIBUTE6 in VARCHAR2,
273   X_ATTRIBUTE7 in VARCHAR2,
274   X_ATTRIBUTE8 in VARCHAR2,
275   X_ATTRIBUTE9 in VARCHAR2,
276   X_ATTRIBUTE10 in VARCHAR2,
277   X_ATTRIBUTE11 in VARCHAR2,
278   X_ATTRIBUTE12 in VARCHAR2,
279   X_ATTRIBUTE13 in VARCHAR2,
280   X_ATTRIBUTE14 in VARCHAR2,
281   X_ATTRIBUTE15 in VARCHAR2,
282   X_NAME in VARCHAR2,
283   X_DESCRIPTION in VARCHAR2,
284   X_LAYOUT_TEMPLATE_ID in number,
285   X_CREATION_DATE in DATE,
286   X_CREATED_BY in NUMBER,
287   X_LAST_UPDATE_DATE in DATE,
288   X_LAST_UPDATED_BY in NUMBER,
289   X_LAST_UPDATE_LOGIN in NUMBER,
290   X_TAX_CALCULATION_EVENT IN VARCHAR2,
291   X_DEFAULT_FULFILLMENT_SET      in VARCHAR2 default null,
292   X_DEFAULT_LINE_SET_CODE       in VARCHAR2 default null,
293   X_def_transaction_phase_code     in VARCHAR2 default null,
294   X_quote_num_as_ord_num_flag  in VARCHAR2 default null,
295   X_CONTRACT_TEMPLATE_ID in number,
296   X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --ER#16014135 --CC Reversal
297   X_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
298 );
299 
300 Procedure Translate_Row(Transaction_type_id IN NUMBER,
301 	      		    Name IN VARCHAR2,
302 				    Description IN VARCHAR2);
303 
304 Procedure Val_Ord_Change( p_application_id IN NUMBER,
305 					p_entity_short_name in VARCHAR2,
306 					p_validation_entity_short_name in VARCHAR2,
307 					p_validation_tmplt_short_name in VARCHAR2,
308 					p_record_set_tmplt_short_name in VARCHAR2,
309 					p_scope in VARCHAR2,
310 					p_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
311 
312 Procedure Is_Manual( p_application_id IN NUMBER,
313 					p_entity_short_name in VARCHAR2,
314 					p_validation_entity_short_name in VARCHAR2,
315 					p_validation_tmplt_short_name in VARCHAR2,
316 					p_record_set_tmplt_short_name in VARCHAR2,
317 					p_scope in VARCHAR2,
318 					p_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
319 
320 --bug 6321217 new procedure added
321 Procedure Validate_lang_tbl (p_transaction_id IN number,
322                               p_language IN varchar2,
323                               p_name     IN varchar2,
324                               p_description IN varchar2
325                               );
326 
327 
328 
329 end OE_TRANSACTION_TYPES_PKG;