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 6073: IF (OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count < 2) THEN

6069: i pls_integer;
6070: BEGIN
6071:
6072: -- only one changed line, query that line
6073: IF (OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count < 2) THEN
6074: RETURN 'N';
6075: END IF;
6076:
6077: -- find out the total number of lines in the order

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

6085: END IF;
6086: RETURN 'N';
6087: END;
6088:
6089: IF (l_total_lines > OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count) THEN
6090: IF l_debug_level > 0 THEN
6091: oe_debug_pub.add('total lines larger than changed '||l_total_lines
6092: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6093: END IF;

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

6088:
6089: IF (l_total_lines > OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count) THEN
6090: IF l_debug_level > 0 THEN
6091: oe_debug_pub.add('total lines larger than changed '||l_total_lines
6092: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6093: END IF;
6094: RETURN 'N';
6095: ELSE
6096: IF l_debug_level > 0 THEN

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

6094: RETURN 'N';
6095: ELSE
6096: IF l_debug_level > 0 THEN
6097: oe_debug_pub.add('total lines smaller than or equal to changed '||l_total_lines
6098: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6099: END IF;
6100:
6101: l_num_changed_lines := 0;
6102: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;

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

6098: ||' '||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6099: END IF;
6100:
6101: l_num_changed_lines := 0;
6102: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
6103: While i is Not Null Loop
6104: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
6105: l_num_changed_lines := l_num_changed_lines + 1;
6106: end if;

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

6100:
6101: l_num_changed_lines := 0;
6102: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
6103: While i is Not Null Loop
6104: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
6105: l_num_changed_lines := l_num_changed_lines + 1;
6106: end if;
6107: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
6108: End Loop;

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

6103: While i is Not Null Loop
6104: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
6105: l_num_changed_lines := l_num_changed_lines + 1;
6106: end if;
6107: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
6108: End Loop;
6109:
6110: IF l_debug_level > 0 THEN
6111: oe_debug_pub.add('total changed lines in this order '||l_num_changed_lines);

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

6132: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6133: j PLS_INTEGER;
6134: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6135: BEGIN
6136: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
6137: j := 1;
6138: While i is Not Null Loop
6139: Begin
6140: --bug 3020702

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

6138: While i is Not Null Loop
6139: Begin
6140: --bug 3020702
6141: IF l_debug_level > 0 THEN
6142: oe_debug_pub.add('header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
6143: END IF;
6144: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
6145:
6146: IF l_debug_level > 0 THEN

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

6140: --bug 3020702
6141: IF l_debug_level > 0 THEN
6142: oe_debug_pub.add('header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
6143: END IF;
6144: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
6145:
6146: IF l_debug_level > 0 THEN
6147: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
6148: END IF;

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

6143: END IF;
6144: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
6145:
6146: IF l_debug_level > 0 THEN
6147: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
6148: END IF;
6149: query_line(Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id,l_line_rec);
6150: x_line_tbl(j):=l_line_rec;
6151: j:=j+1;

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

6145:
6146: IF l_debug_level > 0 THEN
6147: oe_debug_pub.add('query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
6148: END IF;
6149: query_line(Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id,l_line_rec);
6150: x_line_tbl(j):=l_line_rec;
6151: j:=j+1;
6152:
6153: oe_debug_pub.add('link to line id:'|| l_line_rec.link_to_line_id);

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

6155: LOOP
6156: IF l_line_rec.link_to_line_id IS NOT null
6157: and l_line_rec.link_to_line_id <> FND_API.G_MISS_NUM
6158: and l_line_rec.link_to_line_id <> l_line_rec.line_id
6159: and NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT))
6160: and NOT G_ADDED_PARENT_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT)) THEN
6161: --child line has changed, need to send in parent lines to be repriced.
6162: --model line should not be added aga if exists in G_CHANGED_LINE_TBL.
6163: --use linked to line id to find the immediate parent.

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

6175: end if;
6176: Exception
6177: When no_data_found Then
6178: IF l_debug_level > 0 THEN
6179: Oe_Debug_Pub.add('No data found for line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
6180: END IF;
6181: End;
6182: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
6183: End Loop;

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

6178: IF l_debug_level > 0 THEN
6179: Oe_Debug_Pub.add('No data found for line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
6180: END IF;
6181: End;
6182: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
6183: End Loop;
6184: END Query_Changed_Lines;
6185:
6186: procedure calculate_adjustments(

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

6322: G_PASS_ALL_LINES := 'N';
6323: If G_INT_CHANGED_LINE_ON = 'Y'
6324: AND p_pricing_Events IS NOT NULL
6325: AND NOT (OE_GLOBALS.G_RECURSION_MODE <> 'Y' and p_pricing_events = 'BOOK')
6326: AND (p_pricing_events = 'SHIP' OR (NOT Oe_Line_Adj_Util.has_service_lines(p_header_id)))
6327: AND (p_action_code IS NULL or p_action_code <> 'PRICE_ORDER')
6328: --RT{
6329: AND p_pricing_events <> 'RETROBILL'
6330: --RT}

Line 6351: and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y'

6347: oe_debug_pub.add(' Changed_lines_flag returned from pricing:'||l_order_status_rec.Changed_lines_flag);
6348:
6349:
6350: If l_order_status_rec.ALL_LINES_FLAG = 'Y'
6351: and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y'
6352: and p_pricing_events <> 'SHIP'
6353: Then --bug 2965218
6354: ----------------------------------------------------------------
6355: --Pricing says pass all lines, use query_lines is more efficient

Line 6368: OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N'

6364: ELSE
6365: G_PASS_ALL_LINES := 'Y';
6366: END IF;
6367: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y'
6368: OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N'
6369: OR p_pricing_events = 'SHIP'
6370: Then
6371: IF Need_Query_All_Lines(p_header_id) = 'Y' THEN
6372: IF l_debug_level > 0 THEN

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

6376: ELSE
6377: -------------------------------------------------------------------
6378: --Pricing says passing only changed lines, use query_line
6379: --------------------------------------------------------------------
6380: oe_debug_pub.add('Query individual line changed:'||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6381:
6382: --bug4529937 have put the code to query for changed lines in a procedure
6383: Query_Changed_Lines(p_header_id => p_header_id,
6384: x_line_tbl => l_line_tbl);

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

6666: l_line_index := l_line_index + 1;
6667: Else
6668: oe_debug_pub.add('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);
6669: IF (G_PASS_ALL_LINES = 'R' and
6670: NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_Tbl(line_tbl_index).line_id,G_BINARY_LIMIT))
6671: and OE_CODE_CONTROL.Get_Code_Release_Level >= '110509')
6672: THEN
6673: l_check_line_flag := 'Y';
6674: ELSE