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 567: IF OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'CONFIG' OR

563: RETURN FALSE;
564: END IF;
565:
566: IF Return_Line(p_line_rec) THEN
567: IF OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'CONFIG' OR
568: OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'INCLUDED' THEN
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ITEM NOT INVOICEABLE ( 4 ) ' , 1 ) ;
571: END IF;

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

564: END IF;
565:
566: IF Return_Line(p_line_rec) THEN
567: IF OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'CONFIG' OR
568: OE_LINE_UTIL.Get_Return_Item_Type_Code(p_line_rec) = 'INCLUDED' THEN
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ITEM NOT INVOICEABLE ( 4 ) ' , 1 ) ;
571: END IF;
572: --bug5336639 start

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

1224: END IF;
1225: Get_Item_Description(p_line_rec, l_service_item_desc);
1226: IF l_service_reference_line_id IS NOT NULL THEN
1227: /*Bug3261460-Changes made to get the serviced item description*/
1228: -- l_line_rec := OE_LINE_UTIL.Query_Row(l_service_reference_line_id);
1229: -- Get_Item_Description(l_line_rec, l_item_serviced_desc);
1230: BEGIN
1231: select inventory_item_id,ordered_item_id,sold_to_org_id,item_identifier_type,ordered_item,org_id
1232: 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 1481: OE_Line_Util_Ext.Rowtype_Rec_To_API_Rec(p_record,l_line_rec);

1477: END IF;
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'Before the call to Rowtype_Rec_To_API_Rec ', 1);
1480: END IF;
1481: OE_Line_Util_Ext.Rowtype_Rec_To_API_Rec(p_record,l_line_rec);
1482: IF l_debug_level > 0 THEN
1483: oe_debug_pub.add( 'After the call to Rowtype_Rec_To_API_Rec ', 1);
1484: END IF;
1485:

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

1904: END IF;
1905: RFR_Children(p_line_rec.line_id, l_rfr_child_flag, l_rfr_children_tbl);
1906: IF (l_rfr_child_flag = 'Y') THEN
1907: FOR i IN 1..l_rfr_children_tbl.count LOOP
1908: OE_Line_Util.Query_Row(p_line_id => l_rfr_children_tbl(i), x_line_rec => l_child_rec);
1909: IF l_child_rec.inventory_item_id <> l_child_inventory_item_id then
1910: l_child_inventory_item_id := l_child_rec.inventory_item_id;
1911: select nvl(sum(ordered_quantity), 0), nvl(sum(fulfilled_quantity), 0)
1912: into l_child_total_ordered_qty, l_child_total_fulfilled_qty

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

1948: p_line_rec.inventory_item_id,
1949: l_rfr_sibling_flag, l_rfr_sibling_tbl);
1950: IF (l_rfr_sibling_flag = 'Y') THEN
1951: FOR i IN 1..l_rfr_sibling_tbl.count LOOP
1952: OE_Line_Util.Query_Row(p_line_id => l_rfr_sibling_tbl(i), x_line_rec =>l_sibling_rec );
1953: IF l_sibling_rec.inventory_item_id <> l_sibling_inventory_item_id THEN
1954: l_sibling_inventory_item_id := l_sibling_rec.inventory_item_id;
1955: select nvl(sum(ordered_quantity), 0), nvl(sum(fulfilled_quantity), 0)
1956: into l_sibling_total_ordered_qty, l_sibling_total_fulfilled_qty

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

2203: IF (l_rfr_child_flag = 'Y') THEN
2204: FOR i IN 1..l_rfr_children_tbl.count LOOP
2205: -- l_rfr_children_tbl is ordered by inventory_item_id
2206: -- so same inventory_item_id will come next to each other
2207: OE_Line_Util.Query_Row(p_line_id => l_rfr_children_tbl(i), x_line_rec => l_child_rec);
2208: IF l_debug_level > 0 THEN
2209: 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 ) ;
2210: END IF;
2211: IF l_child_rec.inventory_item_id <> l_child_inventory_item_id then

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

2287: ,l_rfr_sibling_flag
2288: ,l_rfr_sibling_tbl);
2289: IF l_rfr_sibling_flag = 'Y' THEN
2290: FOR i IN 1..l_rfr_sibling_tbl.count LOOP
2291: OE_Line_Util.Query_Row(p_line_id => l_rfr_sibling_tbl(i)
2292: ,x_line_rec => l_sibling_rec);
2293: IF l_debug_level > 0 THEN
2294: 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 ) ;
2295: END IF;

Line 5303: OE_Line_Util.Lock_Row(p_line_id=>config_line_id

5299: oe_debug_pub.add( 'FOUND CONFIG LINE : '||CONFIG_LINE_ID , 1 ) ;
5300: END IF;
5301: -- Initialize API return status to success
5302: x_return_status := FND_API.G_RET_STS_SUCCESS;
5303: OE_Line_Util.Lock_Row(p_line_id=>config_line_id
5304: , p_x_line_rec => l_line_rec
5305: , x_return_status => l_return_status
5306: );
5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

8084: Open Pending_Lines;
8085: LOOP
8086: Fetch Pending_Lines Into l_pending_line_id;
8087: EXIT WHEN Pending_Lines%NOTFOUND;
8088: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id,x_line_rec=>l_pending_line_rec);
8089: IF l_debug_level > 0 THEN
8090: oe_debug_pub.add( 'RFR: PENDING LINE ID : ' || TO_CHAR ( L_PENDING_LINE_ID ) , 5 ) ;
8091: END IF;
8092: IF Something_To_Invoice(l_pending_line_rec) THEN -- the pending line now has something to

Line 8532: oe_line_util.Query_Row

8528: x_return_status := FND_API.G_RET_STS_SUCCESS;
8529: G_ITEMTYPE := p_itemtype;
8530:
8531: --bug 5336623
8532: oe_line_util.Query_Row
8533: (p_line_id => p_line_id
8534: ,x_line_rec => l_line_rec
8535: );
8536: --bug 5336623

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

8534: ,x_line_rec => l_line_rec
8535: );
8536: --bug 5336623
8537:
8538: ----bug 5336623 commented the following call to OE_Line_Util.Lock_Row
8539: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id
8540: , p_x_line_rec => l_line_rec
8541: , x_return_status => l_return_status
8542: );

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

8535: );
8536: --bug 5336623
8537:
8538: ----bug 5336623 commented the following call to OE_Line_Util.Lock_Row
8539: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id
8540: , p_x_line_rec => l_line_rec
8541: , x_return_status => l_return_status
8542: );
8543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

8762: Open Pending_Lines;
8763: LOOP
8764: Fetch Pending_Lines Into l_pending_line_id;
8765: EXIT WHEN Pending_Lines%NOTFOUND;
8766: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id,x_line_rec=>l_pending_line_rec);
8767: IF l_debug_level > 0 THEN
8768: oe_debug_pub.add( 'RFR: PENDING LINE ID : ' || TO_CHAR ( L_PENDING_LINE_ID ) , 5 ) ;
8769: END IF;
8770: IF Something_To_Invoice(l_pending_line_rec) THEN -- the pending line now has something to

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

8994: del_line_ready_flag := 'Y';
8995: -- Fix for bug 2164555
8996: -- Fix for bug 2224248. Changed the variable l_line_rec to l_invoice_rec.
8997: ELSE
8998: l_invoice_rec :=OE_Line_Util.Query_Row(p_line_id=>l_line_id);
8999: --Bug2181628 Check if the current line's delivery_id is the same as the delivery_id
9000: --being processed.If it is the same then wait for this line,else do not wait indefinetely.
9001: --Bug3071154 Check the shippable flag also
9002: IF Shipping_Info_Available(l_invoice_rec)

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

9106: OPEN delivery_lines_cursor(l_delivery_line_id);
9107: LOOP
9108: FETCH delivery_lines_cursor INTO l_line_id;
9109: EXIT WHEN delivery_lines_cursor%NOTFOUND;
9110: OE_Line_Util.Query_Row(p_line_id=>l_line_id, x_line_rec=>l_line_rec);
9111: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
9112: IF l_debug_level > 0 THEN
9113: oe_debug_pub.add( 'LINE ID : '||L_LINE_REC.LINE_ID , 5 ) ;
9114: END IF;

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

9384: IF l_debug_level > 0 THEN
9385: oe_debug_pub.add( 'RFR: PENDING LINE ID ' || TO_CHAR ( L_PENDING_LINE_ID ) , 5 ) ;
9386: END IF;
9387: EXIT WHEN Pending_Lines%NOTFOUND;
9388: OE_Line_Util.Query_Row(p_line_id=>l_pending_line_id, x_line_rec=>l_pending_line_rec);
9389: IF Something_To_Invoice(l_pending_line_rec) THEN -- the pending line now has something to
9390: -- invoice because current line has been shipped
9391: -- check for delivery and invoice delivery if necessarily
9392: IF l_debug_level > 0 THEN