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_PRICE_PVT dependencies on OE_LINE_ADJ_UTIL

Line 5794: IF (OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count < 2) THEN

5790: i pls_integer;
5791: BEGIN
5792:
5793: -- only one changed line, query that line
5794: IF (OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count < 2) THEN
5795: RETURN 'N';
5796: END IF;
5797:
5798: -- find out the total number of lines in the order

Line 5810: IF (l_total_lines > OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count) THEN

5806: END IF;
5807: RETURN 'N';
5808: END;
5809:
5810: IF (l_total_lines > OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count) THEN
5811: IF l_debug_level > 0 THEN
5812: oe_debug_pub.add('total lines larger than changed '||l_total_lines
5813: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
5814: END IF;

Line 5813: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);

5809:
5810: IF (l_total_lines > OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count) THEN
5811: IF l_debug_level > 0 THEN
5812: oe_debug_pub.add('total lines larger than changed '||l_total_lines
5813: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
5814: END IF;
5815: RETURN 'N';
5816: ELSE
5817: IF l_debug_level > 0 THEN

Line 5819: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);

5815: RETURN 'N';
5816: ELSE
5817: IF l_debug_level > 0 THEN
5818: oe_debug_pub.add('total lines smaller than or equal to changed '||l_total_lines
5819: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
5820: END IF;
5821:
5822: l_num_changed_lines := 0;
5823: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;

Line 5823: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;

5819: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
5820: END IF;
5821:
5822: l_num_changed_lines := 0;
5823: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5824: While i is Not Null Loop
5825: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5826: l_num_changed_lines := l_num_changed_lines + 1;
5827: end if;

Line 5825: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then

5821:
5822: l_num_changed_lines := 0;
5823: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5824: While i is Not Null Loop
5825: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5826: l_num_changed_lines := l_num_changed_lines + 1;
5827: end if;
5828: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5829: End Loop;

Line 5828: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);

5824: While i is Not Null Loop
5825: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5826: l_num_changed_lines := l_num_changed_lines + 1;
5827: end if;
5828: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5829: End Loop;
5830:
5831: IF l_debug_level > 0 THEN
5832: oe_debug_pub.add('total changed lines in this order '||l_num_changed_lines);

Line 5857: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;

5853: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
5854: j PLS_INTEGER;
5855: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5856: BEGIN
5857: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5858: j := 1;
5859: While i is Not Null Loop
5860: Begin
5861: --bug 3020702

Line 5863: oe_debug_pub.add('header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);

5859: While i is Not Null Loop
5860: Begin
5861: --bug 3020702
5862: IF l_debug_level > 0 THEN
5863: oe_debug_pub.add('header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5864: END IF;
5865: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5866:
5867: IF l_debug_level > 0 THEN

Line 5865: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then

5861: --bug 3020702
5862: IF l_debug_level > 0 THEN
5863: oe_debug_pub.add('header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5864: END IF;
5865: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5866:
5867: IF l_debug_level > 0 THEN
5868: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5869: END IF;

Line 5868: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

5864: END IF;
5865: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5866:
5867: IF l_debug_level > 0 THEN
5868: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5869: END IF;
5870: query_line(Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id,l_line_rec);
5871: x_line_tbl(j):=l_line_rec;
5872: j:=j+1;

Line 5870: query_line(Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id,l_line_rec);

5866:
5867: IF l_debug_level > 0 THEN
5868: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5869: END IF;
5870: query_line(Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id,l_line_rec);
5871: x_line_tbl(j):=l_line_rec;
5872: j:=j+1;
5873:
5874: oe_debug_pub.add('link to line id:'|| l_line_rec.link_to_line_id);

Line 5880: and NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT))

5876: LOOP
5877: IF l_line_rec.link_to_line_id IS NOT null
5878: and l_line_rec.link_to_line_id <> FND_API.G_MISS_NUM
5879: and l_line_rec.link_to_line_id <> l_line_rec.line_id
5880: and NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT))
5881: and NOT G_ADDED_PARENT_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT)) THEN
5882: --child line has changed, need to send in parent lines to be repriced.
5883: --model line should not be added aga if exists in G_CHANGED_LINE_TBL.
5884: --use linked to line id to find the immediate parent.

Line 5900: Oe_Debug_Pub.add('No data found for line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

5896: end if;
5897: Exception
5898: When no_data_found Then
5899: IF l_debug_level > 0 THEN
5900: Oe_Debug_Pub.add('No data found for line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5901: END IF;
5902: End;
5903: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5904: End Loop;

Line 5903: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);

5899: IF l_debug_level > 0 THEN
5900: Oe_Debug_Pub.add('No data found for line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5901: END IF;
5902: End;
5903: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5904: End Loop;
5905: END Query_Changed_Lines;
5906:
5907: procedure calculate_adjustments(

Line 6047: AND (p_pricing_events = 'SHIP' OR (NOT Oe_Line_Adj_Util.has_service_lines(p_header_id)))

6043: G_PASS_ALL_LINES := 'N';
6044: If G_INT_CHANGED_LINE_ON = 'Y'
6045: AND p_pricing_Events IS NOT NULL
6046: AND NOT (OE_GLOBALS.G_RECURSION_MODE <> 'Y' and p_pricing_events = 'BOOK')
6047: AND (p_pricing_events = 'SHIP' OR (NOT Oe_Line_Adj_Util.has_service_lines(p_header_id)))
6048: AND (p_action_code IS NULL or p_action_code <> 'PRICE_ORDER')
6049: --RT{
6050: AND p_pricing_events <> 'RETROBILL'
6051: --RT}

Line 6063: If l_order_status_rec.ALL_LINES_FLAG = 'Y' and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y' and p_pricing_events <> 'SHIP'

6059: oe_debug_pub.add(' All_lines_flag returned from pricing:'||l_order_status_rec.all_lines_flag);
6060: oe_debug_pub.add(' Changed_lines_flag returned from pricing:'||l_order_status_rec.Changed_lines_flag);
6061:
6062:
6063: If l_order_status_rec.ALL_LINES_FLAG = 'Y' and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y' and p_pricing_events <> 'SHIP'
6064: Then --bug 2965218
6065: ----------------------------------------------------------------
6066: --Pricing says pass all lines, use query_lines is more efficient
6067: --action_code = 'PRICE_ORDER' user asks for repricing all lines

Line 6078: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y' OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N' OR p_pricing_events = 'SHIP'

6074: G_PASS_ALL_LINES := 'R';
6075: ELSE
6076: G_PASS_ALL_LINES := 'Y';
6077: END IF;
6078: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y' OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N' OR p_pricing_events = 'SHIP'
6079: Then
6080: IF Need_Query_All_Lines(p_header_id) = 'Y' THEN
6081: IF l_debug_level > 0 THEN
6082: oe_debug_pub.add(' Need query all lines because all lines are changed');

Line 6089: oe_debug_pub.add('Query individual line changed:'||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);

6085: ELSE
6086: -------------------------------------------------------------------
6087: --Pricing says passing only changed lines, use query_line
6088: --------------------------------------------------------------------
6089: oe_debug_pub.add('Query individual line changed:'||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6090:
6091: --bug4529937 have put the code to query for changed lines in a procedure
6092: Query_Changed_Lines(p_header_id => p_header_id,
6093: x_line_tbl => l_line_tbl);

Line 6383: NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_Tbl(line_tbl_index).line_id,G_BINARY_LIMIT)) and

6379: l_line_index := l_line_index + 1;
6380: Else
6381: oe_debug_pub.add('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);
6382: IF (G_PASS_ALL_LINES = 'R' and
6383: NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_Tbl(line_tbl_index).line_id,G_BINARY_LIMIT)) and
6384: OE_CODE_CONTROL.Get_Code_Release_Level >= '110509') THEN
6385: l_check_line_flag := 'Y';
6386: ELSE
6387: l_check_line_flag := 'N';