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

Line 4230: -- IF oe_line_util.Process_Characteristics -- INVCONV

4226: px_req_line_tbl(l_line_index).LINE_UOM_CODE := p_Line_rec.Order_quantity_uom;
4227: px_req_line_tbl(l_line_index).PRICED_QUANTITY := p_Line_rec.pricing_quantity; -- OPM 2547940 moved this up to here from below next block
4228:
4229: -- start OPM 2046190
4230: -- IF oe_line_util.Process_Characteristics -- INVCONV
4231: IF oe_line_util.dual_uom_control -- INVCONV
4232: (p_line_rec.inventory_item_id
4233: ,p_line_rec.ship_from_org_id
4234: ,l_item_rec) THEN

Line 4231: IF oe_line_util.dual_uom_control -- INVCONV

4227: px_req_line_tbl(l_line_index).PRICED_QUANTITY := p_Line_rec.pricing_quantity; -- OPM 2547940 moved this up to here from below next block
4228:
4229: -- start OPM 2046190
4230: -- IF oe_line_util.Process_Characteristics -- INVCONV
4231: IF oe_line_util.dual_uom_control -- INVCONV
4232: (p_line_rec.inventory_item_id
4233: ,p_line_rec.ship_from_org_id
4234: ,l_item_rec) THEN
4235:

Line 4368: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(p_Line_rec);

4364: p_pricing_event ='SHIP' Then
4365: px_req_line_tbl(l_line_index).PRICE_FLAG := 'N';
4366: End If;
4367:
4368: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(p_Line_rec);
4369:
4370: -- Do not fetch the price for Configuration items and Included Items
4371: If l_item_type_code in( 'CONFIG','INCLUDED')
4372: Then

Line 5493: oe_line_util.query_row(p_Reference_line_Id,L_Line_Rec );

5489: -- Parent Line is not found in px_line_tbl
5490: Begin
5491: line_Tbl_index := px_line_tbl.count+1;
5492:
5493: oe_line_util.query_row(p_Reference_line_Id,L_Line_Rec );
5494: px_Line_Tbl(line_Tbl_index) := L_Line_Rec;
5495: -- Parent Line is only for info purpose, don't calculate price
5496: -- px_Line_Tbl(line_Tbl_index).calculate_price_flag := 'N';
5497: -- modified by lkxu, to be used in repricing

Line 5767: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);

5763: ----------------------------------------------------------------
5764: --Pricing says pass all lines, use query_lines is more efficient
5765: ----------------------------------------------------------------
5766: adj_debug('Query all_lines');
5767: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
5768: g_pass_all_lines:='Y';
5769: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y' OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N' Then
5770: -------------------------------------------------------------------
5771: --Pricing says pass only changed lines, use query_line

Line 5782: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

5778: --bug 3020702
5779: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5780: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5781: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5782: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5783: j:=j+1;
5784: end if;
5785: Exception when no_data_found then
5786: oe_debug_pub.add('Not found line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

Line 5817: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);

5813: -- only to pass all lines when the returned all_lines_flag is Y.
5814: IF G_PASS_ALL_LINES = 'Y' THEN
5815: Begin
5816: adj_debug('querying up all lines in header: '||p_Header_id,3);
5817: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
5818: --1472635
5819: l_all_lines_from_db := True;
5820: Exception when no_data_found then
5821: -- No need to process this order

Line 5833: oe_line_util.query_rows(p_line_id =>p_line_id, x_line_tbl=>l_Line_Tbl );

5829: G_STMT_NO := 'calculate_adjustments#50';
5830: If x_line_Tbl.count = 0 Then
5831: Begin
5832:
5833: oe_line_util.query_rows(p_line_id =>p_line_id, x_line_tbl=>l_Line_Tbl );
5834:
5835:
5836: Exception when no_data_found then
5837: -- No need to process this line

Line 5909: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then

5905: End If;
5906: --End 2124989
5907:
5908: -- Do not price the config items
5909: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then
5910:
5911:
5912: -- Populate that Global Structure
5913: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);

Line 6144: /*oe_line_util.query_rows(p_header_id =>l_header_id, x_line_tbl=>l_temp_Line_Tbl );

6140: l_header_id := p_header_id;
6141: End If;
6142: --adj_debug('BCT order header id '||l_header_id);
6143:
6144: /*oe_line_util.query_rows(p_header_id =>l_header_id, x_line_tbl=>l_temp_Line_Tbl );
6145: i2 := l_temp_line_tbl.first;
6146: While i2 is not Null Loop
6147: If l_temp_line_tbl(i2).calculate_price_flag In ('N','P') Then
6148: --adj_debug('BCT2000 any frozen line found');

Line 7498: OE_Line_Util.Query_Row

7494: -- End 2270949
7495:
7496: G_STMT_NO := 'Process_Other_Item_Line#20';
7497:
7498: OE_Line_Util.Query_Row
7499: ( p_Line_id => l_line_Adj_Rec.Line_Id
7500: , x_line_rec => l_line_rec);
7501:
7502: if l_line_rec.operation = FND_API.G_MISS_CHAR then

Line 8304: l_process := -- INVCONV oe_line_util.Process_Characteristics -- OPM 2547940

8300: G_STMT_NO := 'Calculate_Price#10';
8301: i:= p_Line_Tbl.First;
8302: adj_debug('Honor Price flag :'||p_honor_price_flag,2);
8303: While i is not null Loop
8304: l_process := -- INVCONV oe_line_util.Process_Characteristics -- OPM 2547940
8305: oe_line_util.dual_uom_control -- INVCONV
8306: (p_line_tbl(i).inventory_item_id
8307: ,p_line_tbl(i).ship_from_org_id
8308: ,l_item_rec);

Line 8305: oe_line_util.dual_uom_control -- INVCONV

8301: i:= p_Line_Tbl.First;
8302: adj_debug('Honor Price flag :'||p_honor_price_flag,2);
8303: While i is not null Loop
8304: l_process := -- INVCONV oe_line_util.Process_Characteristics -- OPM 2547940
8305: oe_line_util.dual_uom_control -- INVCONV
8306: (p_line_tbl(i).inventory_item_id
8307: ,p_line_tbl(i).ship_from_org_id
8308: ,l_item_rec);
8309:

Line 8730: IF oe_line_util.dual_uom_control -- INVCONV

8726: END IF;
8727:
8728: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
8729: -- need to adjust the operand so that invoicing will show correct amount (ordered qty * USP (adjusted) )
8730: IF oe_line_util.dual_uom_control -- INVCONV
8731: -- Process_Characteristics invconv
8732: (p_line_tbl(i).inventory_item_id
8733: ,p_line_tbl(i).ship_from_org_id
8734: ,l_item_rec) THEN

Line 8747: END IF; --oe_line_util.dual_uom_control -- INVCONV

8743: * (p_line_tbl(i).shipped_quantity2/p_line_tbl(i).ordered_quantity);
8744: oe_debug_pub.ADD('OPM NEW operand : '|| to_char(p_Line_Adj_Tbl(j).operand),5);
8745: END IF;
8746: END IF;
8747: END IF; --oe_line_util.dual_uom_control -- INVCONV
8748: -- OPM 2547940 end
8749:
8750:
8751: Else

Line 8772: IF oe_line_util.dual_uom_control -- INVCONV PROCESS_CHAR

8768:
8769: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
8770: -- need to adjust the adjusted_amount so that invoicing will show correct amount (ordered qty * USP (adjusted) )
8771:
8772: IF oe_line_util.dual_uom_control -- INVCONV PROCESS_CHAR
8773:
8774: (p_line_tbl(i).inventory_item_id
8775: ,p_line_tbl(i).ship_from_org_id
8776: ,l_item_rec) THEN

Line 8787: END IF; --oe_line_util.dual_uom_control -- INVCONV

8783: p_Line_Adj_Tbl(j).adjusted_amount := (p_Line_Adj_tbl(j).adjusted_amount_per_pqty* p_line_tbl(i).pricing_quantity )/p_line_tbl(i).ordered_quantity2
8784: * (p_line_tbl(i).shipped_quantity2/p_line_tbl(i).ordered_quantity);
8785: END IF;
8786: END IF;
8787: END IF; --oe_line_util.dual_uom_control -- INVCONV
8788: -- OPM 2547940 end
8789:
8790:
8791: If G_DEBUG Then

Line 9000: OE_Line_Util.Query_Row(p_Line_id => l_prg_line_id,

8996: END IF;
8997:
8998: IF NOT l_found_prg_line then
8999: adj_debug('PRG not in p_line_tbl, so query for line '||l_prg_line_id);
9000: OE_Line_Util.Query_Row(p_Line_id => l_prg_line_id,
9001: x_line_rec => l_line_rec);
9002: END IF;
9003:
9004: if (l_line_rec.booked_flag <> 'Y' OR

Line 9201: OE_Line_Util.Query_Row

9197:
9198: If x_Line_Tbl.count = 0 Then
9199: Begin
9200:
9201: OE_Line_Util.Query_Row
9202: ( p_Line_id => p_req_line_tbl(i).line_id
9203: , x_line_rec => l_line_rec);
9204: Exception when no_data_found then
9205: null;

Line 9206: adj_debug('process_adjustments OE_Line_Util.Query_Row , no data found');

9202: ( p_Line_id => p_req_line_tbl(i).line_id
9203: , x_line_rec => l_line_rec);
9204: Exception when no_data_found then
9205: null;
9206: adj_debug('process_adjustments OE_Line_Util.Query_Row , no data found');
9207: End;
9208: Else
9209: J:= x_Line_Tbl.First;
9210: While J is not null loop

Line 9451: ( ( oe_line_util.dual_uom_control -- INVCONV

9447:
9448: or -- OPM 2547940 start
9449: -- pricing by quantity2 - this is for case when order line is split from shipping and new line gets generated
9450: -- and this line has to be re-priced for catchweight pricing for OPM if pricing in secondary quantity
9451: ( ( oe_line_util.dual_uom_control -- INVCONV
9452: (l_line_rec.inventory_item_id
9453: ,l_line_rec.ship_from_org_id
9454: ,l_item_rec) )
9455: and p_req_line_tbl(i).line_Type_code ='LINE'

Line 9678: oe_line_util.Get_Return_Item_Type_Code

9674: and (
9675: ((
9676: ( l_line_tbl.exists( p_req_line_detail_Tbl(j).line_index)
9677: and
9678: oe_line_util.Get_Return_Item_Type_Code
9679: (l_line_tbl( p_req_line_detail_Tbl(j).line_index))<> 'INCLUDED'
9680: )
9681: Or not l_line_tbl.exists (p_req_line_detail_Tbl(j).line_index )
9682:

Line 10234: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then

10230: adj_debug('Payment_term , before process order '||l_line_tbl(i).payment_term_id,2);
10231: End If;
10232:
10233: -- uom begin
10234: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then
10235: l_line_tbl(i).unit_list_price_per_pqty := 0;
10236: end if;
10237:
10238: If l_line_tbl(i).unit_Selling_price_per_pqty is null or

Line 10239: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')

10235: l_line_tbl(i).unit_list_price_per_pqty := 0;
10236: end if;
10237:
10238: If l_line_tbl(i).unit_Selling_price_per_pqty is null or
10239: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')
10240: then
10241: l_line_tbl(i).unit_Selling_price_per_pqty := l_line_tbl(i).unit_list_price_per_pqty;
10242: end if;
10243:

Line 10254: IF oe_line_util.dual_uom_control -- INVCONV

10250:
10251: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
10252: -- need to adjust the unit selling price so that invoicing will show correct amount (ordered qty * USP (adjusted) )
10253:
10254: IF oe_line_util.dual_uom_control -- INVCONV
10255: (l_line_tbl(i).inventory_item_id
10256: ,l_line_tbl(i).ship_from_org_id
10257: ,l_item_rec) THEN
10258: IF l_item_rec.ont_pricing_qty_source = 'S' THEN -- price by quantity 2 -- INVCONV

Line 10269: END IF; --oe_line_util.dual_uom_control -- INVCONV

10265: * (l_line_tbl(i).shipped_quantity2/l_line_tbl(i).ordered_quantity);
10266: oe_debug_pub.ADD('OPM NEW USP : '|| to_char(l_line_tbl(i).unit_selling_price),5);
10267: END IF;
10268: END IF;
10269: END IF; --oe_line_util.dual_uom_control -- INVCONV
10270: -- OPM 2547940 end
10271:
10272:
10273: -- uom end

Line 10372: OE_LINE_UTIL.Lock_Row(x_return_status => x_return_status,

10368: Else
10369: l_line_tbl_final(l).operation := OE_GLOBALS.G_OPR_UPDATE;
10370: l_num_changed_lines := l_num_changed_lines + 1;
10371: adj_debug('lock row '||i||' '||l_old_line_tbl(l).line_id,1);
10372: OE_LINE_UTIL.Lock_Row(x_return_status => x_return_status,
10373: p_x_line_rec => l_old_line_tbl(l)
10374: );
10375:
10376: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 10519: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl_Final(j));

10515: IF l_Line_Tbl_Final(j).unit_selling_price IS NULL
10516: OR l_line_tbl_final(j).unit_list_price IS NULL
10517: OR l_line_tbl_final(j).price_list_id IS NULL THEN
10518: --
10519: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl_Final(j));
10520: --
10521: IF (l_item_type_code <> 'CONFIG'
10522: AND l_item_type_code <> 'INCLUDED') THEN
10523: --

Line 10975: OE_Line_Util.Query_Rows(p_line_id => p_line_id

10971: OE_MSG_PUB.Add;
10972: END IF;
10973: RAISE FND_API.G_EXC_ERROR;
10974: elsif (px_line_Tbl.count = 0) Then
10975: OE_Line_Util.Query_Rows(p_line_id => p_line_id
10976: , x_line_tbl => px_line_tbl);
10977: end if;
10978: adj_debug('lines count'||px_line_tbl.count);
10979: l_source_document_type_id := px_line_Tbl(1).source_document_type_id;

Line 11317: oe_line_util.query_rows(

11313: l_Req_Control_Rec.Simulation_Flag := 'N';
11314:
11315: If p_header_id is null then
11316:
11317: oe_line_util.query_rows(
11318: p_line_id => p_line_id
11319: , x_line_tbl => l_line_tbl1
11320: );
11321:

Line 11333: oe_line_util.query_rows(

11329: p_header_id => p_header_id
11330: , x_header_rec => l_header_rec
11331: );
11332:
11333: oe_line_util.query_rows(
11334: p_header_id => p_header_id
11335: , x_line_tbl => l_Line_Tbl1
11336: );
11337: end if;

Line 11459: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then

11455: l_line_tbl(i).change_comments := 'PRICING';
11456: adj_debug('Audit Reason passed as '||l_line_tbl(i).change_reason,1);
11457:
11458: -- uom begin
11459: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then
11460: l_line_tbl(i).unit_list_price_per_pqty := 0;
11461: l_line_tbl(i).pricing_quantity := l_line_tbl(i).ordered_quantity;
11462: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
11463: end if;

Line 11466: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')

11462: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
11463: end if;
11464:
11465: If l_line_tbl(i).unit_Selling_price_per_pqty is null or
11466: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')
11467: then
11468: l_line_tbl(i).unit_Selling_price_per_pqty := l_line_tbl(i).unit_list_price_per_pqty;
11469:
11470: End If;

Line 11482: IF oe_line_util.dual_uom_control -- invconv

11478:
11479: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
11480: -- need to adjust the adjusted_amount so that invoicing will show correct amount (ordered qty * USP (adjusted) )
11481:
11482: IF oe_line_util.dual_uom_control -- invconv
11483: (l_line_tbl(i).inventory_item_id
11484: ,l_line_tbl(i).ship_from_org_id
11485: ,l_item_rec) THEN
11486: IF l_item_rec.ont_pricing_qty_source = 'S' THEN -- price by quantity 2 -- INVCONV

Line 11499: END IF; --oe_line_util.dual_uom_control -- INVCONV

11495: * (l_line_tbl(i).shipped_quantity2/l_line_tbl(i).ordered_quantity);
11496:
11497: END IF;
11498: END IF;
11499: END IF; --oe_line_util.dual_uom_control -- INVCONV
11500: -- OPM 2547940 end
11501:
11502: oe_debug_pub.add('unit price'||l_line_tbl(i).unit_list_price||'+'||l_line_tbl(i).unit_selling_price,1);
11503: oe_debug_pub.add('unit price per pqty'||l_line_tbl(i).unit_list_price_per_pqty||'+'||l_line_tbl(i).unit_selling_price_per_pqty,1);

Line 11701: oe_Line_util.query_row(

11697: ELSE
11698: adj_debug('Old price_action way, order has no prg');
11699: Begin
11700: l_x_line_tbl(i).Line_id := l_Line_id;
11701: oe_Line_util.query_row(
11702: p_Line_id => l_Line_id
11703: , x_line_rec => l_x_Line_Tbl(i)
11704: );
11705: Exception when no_data_found then

Line 11767: oe_Line_util.query_row(

11763: IF (l_new_header or last_record_line_id = l_line_id) and l_x_line_tbl.count > 0 THEN
11764: IF last_record_line_id = l_line_id and l_prev_line_hdr_id = l_header_id THEN
11765: Begin
11766: l_x_line_tbl(j).Line_id := l_Line_id;
11767: oe_Line_util.query_row(
11768: p_Line_id => l_Line_id
11769: , x_line_rec => l_x_Line_Tbl(j)
11770: );
11771: Exception when no_data_found then

Line 11796: oe_Line_util.query_row(

11792:
11793: adj_debug('Old price_action way, order has no prg');
11794: Begin
11795: l_x_line_tbl(j).Line_id := l_Line_id;
11796: oe_Line_util.query_row(
11797: p_Line_id => l_Line_id
11798: , x_line_rec => l_x_Line_Tbl(j)
11799: );
11800: j := j + 1;

Line 12104: oe_Line_util.query_row(

12100: adj_debug('Old price_action way, order has no prg');
12101: Begin
12102:
12103: l_x_line_tbl(i).Line_id := l_Line_id;
12104: oe_Line_util.query_row(
12105: p_Line_id => l_Line_id
12106: , x_line_rec => l_x_Line_Tbl(i)
12107: );
12108: Exception when no_data_found then

Line 12799: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);

12795: if not (p_level = 'ORDER' and p_freight_flag) then --- bug 7655559
12796: --passing all lines under this header
12797: oe_debug_pub.add(' Query Rows under same header');
12798:
12799: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
12800: oe_debug_pub.add('#of rows returned='|| to_char(l_line_tbl.count));
12801: oe_debug_pub.add('no.rows in l_line_tbl = '|| to_char(l_line_tbl.count));
12802:
12803: -- Bug 1713035

Line 12835: --oe_line_util.query_row(p_line_id =>p_line_id,x_line_rec=>l_line_rec);

12831:
12832: Elsif p_line_id is not null Then
12833: --just pass one line
12834: oe_debug_pub.add(' Query Rows under for line line id:'||p_line_id);
12835: --oe_line_util.query_row(p_line_id =>p_line_id,x_line_rec=>l_line_rec);
12836:
12837: -- Bug 1713035
12838: -- Use oe_oe_form_line.get_line instead of query_rows
12839: oe_debug_pub.add('calling get_line in oe_oe_form_line');