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.

APPS.OE_SHIPPING_WF dependencies on OE_BULK_WF_UTIL

Line 184: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN

180: -- CODE CHANGES FOR BUG#6029753 ENDS HERE
181:
182: -- If it is BULK Mode then no need to query these values from Database
183:
184: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add('SHP BULK MODE' , 5 ) ;
187: END IF;
188: -- bug 4070931 starts

Line 193: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

189: IF OE_SHIPPING_INTEGRATION_PVT.G_BULK_WSH_INTERFACE_CALLED = TRUE THEN
190: app_exception.raise_exception;
191: END IF; -- bug 4070931 ends
192:
193: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
194: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
195:
196: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
197:

Line 194: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

190: app_exception.raise_exception;
191: END IF; -- bug 4070931 ends
192:
193: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
194: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
195:
196: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
197:
198: l_order_source_id := OE_BULK_ORDER_PVT.G_LINE_REC.order_source_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 196: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

192:
193: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
194: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
195:
196: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
197:
198: l_order_source_id := OE_BULK_ORDER_PVT.G_LINE_REC.order_source_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
199:
200: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_document_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 198: l_order_source_id := OE_BULK_ORDER_PVT.G_LINE_REC.order_source_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

194: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
195:
196: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
197:
198: l_order_source_id := OE_BULK_ORDER_PVT.G_LINE_REC.order_source_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
199:
200: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_document_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
201:
202: l_orig_sys_line_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_line_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 200: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_document_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);

196: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
197:
198: l_order_source_id := OE_BULK_ORDER_PVT.G_LINE_REC.order_source_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
199:
200: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_document_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
201:
202: l_orig_sys_line_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_line_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
203:
204: l_orig_sys_shipment_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_shipment_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 202: l_orig_sys_line_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_line_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);

198: l_order_source_id := OE_BULK_ORDER_PVT.G_LINE_REC.order_source_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
199:
200: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_document_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
201:
202: l_orig_sys_line_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_line_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
203:
204: l_orig_sys_shipment_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_shipment_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
205:
206: l_change_sequence := OE_BULK_ORDER_PVT.G_LINE_REC.change_sequence(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 204: l_orig_sys_shipment_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_shipment_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);

200: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_document_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
201:
202: l_orig_sys_line_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_line_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
203:
204: l_orig_sys_shipment_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_shipment_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
205:
206: l_change_sequence := OE_BULK_ORDER_PVT.G_LINE_REC.change_sequence(OE_BULK_WF_UTIL.G_LINE_INDEX);
207:
208: /* Commenting for Bug 3319095

Line 206: l_change_sequence := OE_BULK_ORDER_PVT.G_LINE_REC.change_sequence(OE_BULK_WF_UTIL.G_LINE_INDEX);

202: l_orig_sys_line_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_line_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
203:
204: l_orig_sys_shipment_ref := OE_BULK_ORDER_PVT.G_LINE_REC.orig_sys_shipment_ref(OE_BULK_WF_UTIL.G_LINE_INDEX);
205:
206: l_change_sequence := OE_BULK_ORDER_PVT.G_LINE_REC.change_sequence(OE_BULK_WF_UTIL.G_LINE_INDEX);
207:
208: /* Commenting for Bug 3319095
209: l_source_document_type_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_type_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
210:

Line 209: l_source_document_type_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_type_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

205:
206: l_change_sequence := OE_BULK_ORDER_PVT.G_LINE_REC.change_sequence(OE_BULK_WF_UTIL.G_LINE_INDEX);
207:
208: /* Commenting for Bug 3319095
209: l_source_document_type_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_type_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
210:
211: l_source_document_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
212:
213: l_source_document_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 211: l_source_document_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

207:
208: /* Commenting for Bug 3319095
209: l_source_document_type_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_type_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
210:
211: l_source_document_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
212:
213: l_source_document_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
214: */
215:

Line 213: l_source_document_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);

209: l_source_document_type_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_type_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
210:
211: l_source_document_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
212:
213: l_source_document_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.source_document_line_id(OE_BULK_WF_UTIL.G_LINE_INDEX);
214: */
215:
216: ELSE
217: -- # 2416391, locking issue

Line 264: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NULL THEN

260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'TOP MODEL LINE ID : '||L_TOP_MODEL_LINE_ID , 3 ) ;
262: END IF;
263:
264: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NULL THEN
265:
266: IF nvl(l_top_model_line_id,0) <> 0 THEN
267:
268: IF l_debug_level > 0 THEN