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_INVOICE_PUB dependencies on OE_LINE_UTIL

Line 393: Oe_Line_Util.Query_Row(p_line_id, l_line_rec);

389: Where line_id = p_line_id;
390:
391: --OIP SUN ER changes
392: If p_flow_status_code = 'INVOICED' then
393: Oe_Line_Util.Query_Row(p_line_id, l_line_rec);
394: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(l_line_rec.header_id,
395: l_line_rec.line_id,
396: 'INVOICED');
397: end if;

Line 409: Oe_Line_Util.Query_Row(p_line_id, l_line_rec);

405:
406: IF Oe_Genesis_Util.Status_Needs_Sync(p_flow_status_code) THEN
407: IF Oe_Genesis_Util.Source_AIA_Enabled(p_order_source_id)
408: THEN
409: Oe_Line_Util.Query_Row(p_line_id, l_line_rec);
410: Oe_Header_Util.Query_Row(l_line_rec.header_id, l_header_rec);
411:
412: SELECT oe_xml_message_seq_s.NEXTVAL
413: INTO l_item_key_sso

Line 773: IF OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'CONFIG' OR

769: RETURN FALSE;
770: END IF;
771:
772: IF Return_Line(p_line_rec) THEN
773: IF OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'CONFIG' OR
774: OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'INCLUDED' THEN
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'ITEM NOT INVOICEABLE ( 4 ) ' , 1 ) ;
777: END IF;

Line 774: OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'INCLUDED' THEN

770: END IF;
771:
772: IF Return_Line(p_line_rec) THEN
773: IF OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'CONFIG' OR
774: OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'INCLUDED' THEN
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'ITEM NOT INVOICEABLE ( 4 ) ' , 1 ) ;
777: END IF;
778: --bug5336639 start

Line 1445: -- l_line_rec := OE_LINE_UTIL.Query_Row(l_service_reference_line_id);

1441: END IF;
1442: Get_Item_Description(p_line_rec, l_service_item_desc);
1443: IF l_service_reference_line_id IS NOT NULL THEN
1444: /*Bug3261460-Changes made to get the serviced item description*/
1445: -- l_line_rec := OE_LINE_UTIL.Query_Row(l_service_reference_line_id);
1446: -- Get_Item_Description(l_line_rec, l_item_serviced_desc);
1447: BEGIN
1448: select inventory_item_id,ordered_item_id,sold_to_org_id,item_identifier_type,ordered_item,org_id
1449: into l_inventory_item_id,l_ordered_item_id,l_sold_to_org_id,l_item_identifier_type,l_ordered_item,l_org_id

Line 1698: OE_Line_Util_Ext.Rowtype_Rec_To_API_Rec(p_record,l_line_rec);

1694: END IF;
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'Before the call to Rowtype_Rec_To_API_Rec ', 1);
1697: END IF;
1698: OE_Line_Util_Ext.Rowtype_Rec_To_API_Rec(p_record,l_line_rec);
1699: IF l_debug_level > 0 THEN
1700: oe_debug_pub.add( 'After the call to Rowtype_Rec_To_API_Rec ', 1);
1701: END IF;
1702:

Line 2125: OE_Line_Util.Query_Row(p_line_id => l_rfr_children_tbl(i), x_line_rec => l_child_rec);

2121: END IF;
2122: RFR_Children(p_line_rec.line_id, l_rfr_child_flag, l_rfr_children_tbl);
2123: IF (l_rfr_child_flag = 'Y') THEN
2124: FOR i IN 1..l_rfr_children_tbl.count LOOP
2125: OE_Line_Util.Query_Row(p_line_id => l_rfr_children_tbl(i), x_line_rec => l_child_rec);
2126: IF l_child_rec.inventory_item_id <> l_child_inventory_item_id then
2127: l_child_inventory_item_id := l_child_rec.inventory_item_id;
2128: select nvl(sum(ordered_quantity), 0), nvl(sum(fulfilled_quantity), 0)
2129: into l_child_total_ordered_qty, l_child_total_fulfilled_qty

Line 2169: OE_Line_Util.Query_Row(p_line_id => l_rfr_sibling_tbl(i), x_line_rec =>l_sibling_rec );

2165: p_line_rec.inventory_item_id,
2166: l_rfr_sibling_flag, l_rfr_sibling_tbl);
2167: IF (l_rfr_sibling_flag = 'Y') THEN
2168: FOR i IN 1..l_rfr_sibling_tbl.count LOOP
2169: OE_Line_Util.Query_Row(p_line_id => l_rfr_sibling_tbl(i), x_line_rec =>l_sibling_rec );
2170: IF l_sibling_rec.inventory_item_id <> l_sibling_inventory_item_id THEN
2171: l_sibling_inventory_item_id := l_sibling_rec.inventory_item_id;
2172: select nvl(sum(ordered_quantity), 0), nvl(sum(fulfilled_quantity), 0)
2173: into l_sibling_total_ordered_qty, l_sibling_total_fulfilled_qty

Line 2424: OE_Line_Util.Query_Row(p_line_id => l_rfr_children_tbl(i), x_line_rec => l_child_rec);

2420: IF (l_rfr_child_flag = 'Y') THEN
2421: FOR i IN 1..l_rfr_children_tbl.count LOOP
2422: -- l_rfr_children_tbl is ordered by inventory_item_id
2423: -- so same inventory_item_id will come next to each other
2424: OE_Line_Util.Query_Row(p_line_id => l_rfr_children_tbl(i), x_line_rec => l_child_rec);
2425: IF l_debug_level > 0 THEN
2426: oe_debug_pub.add( 'RFR: L_CHILD_REC.LINE_ID: '||L_CHILD_REC.LINE_ID ||' L_CHILD_REC.INVENTORY_ITEM_ID: '|| L_CHILD_REC.INVENTORY_ITEM_ID , 5 ) ;
2427: END IF;
2428: IF l_child_rec.inventory_item_id <> l_child_inventory_item_id then

Line 2508: OE_Line_Util.Query_Row(p_line_id => l_rfr_sibling_tbl(i)

2504: ,l_rfr_sibling_flag
2505: ,l_rfr_sibling_tbl);
2506: IF l_rfr_sibling_flag = 'Y' THEN
2507: FOR i IN 1..l_rfr_sibling_tbl.count LOOP
2508: OE_Line_Util.Query_Row(p_line_id => l_rfr_sibling_tbl(i)
2509: ,x_line_rec => l_sibling_rec);
2510: IF l_debug_level > 0 THEN
2511: oe_debug_pub.add( 'RFR:L_SIBLING_REC.LINE_ID: ' ||L_SIBLING_REC.LINE_ID ||' L_SIBLING_REC.INVENTORY_ITEM_ID:' ||L_SIBLING_REC.INVENTORY_ITEM_ID , 3 ) ;
2512: END IF;

Line 5547: OE_Line_Util.Lock_Row(p_line_id=>config_line_id

5543: oe_debug_pub.add( 'FOUND CONFIG LINE : '||CONFIG_LINE_ID , 1 ) ;
5544: END IF;
5545: -- Initialize API return status to success
5546: x_return_status := FND_API.G_RET_STS_SUCCESS;
5547: OE_Line_Util.Lock_Row(p_line_id=>config_line_id
5548: , p_x_line_rec => l_line_rec
5549: , x_return_status => l_return_status
5550: );
5551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 8483: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id,x_line_rec=>l_pending_line_rec);

8479: Open Pending_Lines;
8480: LOOP
8481: Fetch Pending_Lines Into l_pending_line_id;
8482: EXIT WHEN Pending_Lines%NOTFOUND;
8483: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id,x_line_rec=>l_pending_line_rec);
8484: IF l_debug_level > 0 THEN
8485: oe_debug_pub.add( 'RFR: PENDING LINE ID : ' || TO_CHAR ( L_PENDING_LINE_ID ) , 5 ) ;
8486: END IF;
8487: IF Something_To_Invoice(l_pending_line_rec) THEN -- the pending line now has something to

Line 8952: oe_line_util.Query_Row

8948: x_return_status := FND_API.G_RET_STS_SUCCESS;
8949: G_ITEMTYPE := p_itemtype;
8950:
8951: --bug 5336623
8952: oe_line_util.Query_Row
8953: (p_line_id => p_line_id
8954: ,x_line_rec => l_line_rec
8955: );
8956: --bug 5336623

Line 8958: ----bug 5336623 commented the following call to OE_Line_Util.Lock_Row

8954: ,x_line_rec => l_line_rec
8955: );
8956: --bug 5336623
8957:
8958: ----bug 5336623 commented the following call to OE_Line_Util.Lock_Row
8959: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id
8960: , p_x_line_rec => l_line_rec
8961: , x_return_status => l_return_status
8962: );

Line 8959: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id

8955: );
8956: --bug 5336623
8957:
8958: ----bug 5336623 commented the following call to OE_Line_Util.Lock_Row
8959: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id
8960: , p_x_line_rec => l_line_rec
8961: , x_return_status => l_return_status
8962: );
8963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 9317: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id,x_line_rec=>l_pending_line_rec);

9313: Open Pending_Lines;
9314: LOOP
9315: Fetch Pending_Lines Into l_pending_line_id;
9316: EXIT WHEN Pending_Lines%NOTFOUND;
9317: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id,x_line_rec=>l_pending_line_rec);
9318: IF l_debug_level > 0 THEN
9319: oe_debug_pub.add( 'RFR: PENDING LINE ID : ' || TO_CHAR ( L_PENDING_LINE_ID ) , 5 ) ;
9320: END IF;
9321: IF Something_To_Invoice(l_pending_line_rec) THEN -- the pending line now has something to

Line 9558: l_invoice_rec :=OE_Line_Util.Query_Row(p_line_id=>l_line_id);

9554: del_line_ready_flag := 'Y';
9555: -- Fix for bug 2164555
9556: -- Fix for bug 2224248. Changed the variable l_line_rec to l_invoice_rec.
9557: ELSE
9558: l_invoice_rec :=OE_Line_Util.Query_Row(p_line_id=>l_line_id);
9559: --Bug2181628 Check if the current line's delivery_id is the same as the delivery_id
9560: --being processed.If it is the same then wait for this line,else do not wait indefinetely.
9561: --Bug3071154 Check the shippable flag also
9562: IF Shipping_Info_Available(l_invoice_rec)

Line 9670: OE_Line_Util.Query_Row(p_line_id=>l_line_id, x_line_rec=>l_line_rec);

9666: OPEN delivery_lines_cursor(l_delivery_line_id);
9667: LOOP
9668: FETCH delivery_lines_cursor INTO l_line_id;
9669: EXIT WHEN delivery_lines_cursor%NOTFOUND;
9670: OE_Line_Util.Query_Row(p_line_id=>l_line_id, x_line_rec=>l_line_rec);
9671: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
9672: IF l_debug_level > 0 THEN
9673: oe_debug_pub.add( 'LINE ID : '||L_LINE_REC.LINE_ID , 5 ) ;
9674: END IF;

Line 9948: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id, x_line_rec=>l_pending_line_rec);

9944: IF l_debug_level > 0 THEN
9945: oe_debug_pub.add( 'RFR: PENDING LINE ID ' || TO_CHAR ( L_PENDING_LINE_ID ) , 5 ) ;
9946: END IF;
9947: EXIT WHEN Pending_Lines%NOTFOUND;
9948: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id, x_line_rec=>l_pending_line_rec);
9949: IF Something_To_Invoice(l_pending_line_rec) THEN -- the pending line now has something to
9950: -- invoice because current line has been shipped
9951: -- check for delivery and invoice delivery if necessarily
9952: IF l_debug_level > 0 THEN