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_ADJ_UTIL

Line 282: oe_line_adj_util.delete_row(p_line_id => p_line_rec.line_id);

278: lock_control = lock_control +1
279: Where Line_id = p_line_rec.line_id;
280:
281: --Delete all related adjustments
282: oe_line_adj_util.delete_row(p_line_id => p_line_rec.line_id);
283:
284: --set cascade flag to reflect changes.
285: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
286: Oe_Debug_Pub.add('Leaving reset_fields');

Line 1111: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);

1107:
1108: -- Set missing old record elements to NULL.
1109:
1110: -- l_old_Line_Adj_rec :=
1111: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);
1112: --bug 2721485 Begin
1113: adj_debug('Line id :'||l_line_adj_rec.line_id,3);
1114: if OE_GLOBALS.G_PRICING_RECURSION = 'N' and
1115: l_line_adj_rec.line_id is not null then

Line 1163: OE_Line_Adj_Util.Query_Row

1159: IF l_old_Line_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM
1160: OR l_old_Line_Adj_rec.line_id IS NULL
1161: THEN
1162:
1163: OE_Line_Adj_Util.Query_Row
1164: ( p_price_adjustment_id => l_Line_Adj_rec.price_adjustment_id
1165: , x_line_adj_rec => l_old_Line_Adj_rec
1166: );
1167:

Line 1175: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);

1171:
1172: -- Set missing old record elements to NULL.
1173:
1174: -- l_old_Line_Adj_rec :=
1175: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);
1176:
1177: END IF;
1178:
1179: -- Complete new record from old

Line 1182: OE_Line_Adj_Util.Complete_Record

1178:
1179: -- Complete new record from old
1180:
1181: -- l_Line_Adj_rec :=
1182: OE_Line_Adj_Util.Complete_Record
1183: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1184: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1185: );
1186:

Line 1257: OE_Line_Adj_Util.Clear_Dependent_Attr

1253: -- Clear dependent attributes.
1254:
1255: IF l_control_rec.clear_dependents THEN
1256:
1257: OE_Line_Adj_Util.Clear_Dependent_Attr
1258: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1259: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1260: --, x_Line_Adj_rec => l_Line_Adj_rec
1261: );

Line 1292: adj_debug('Before OE_Line_Adj_Util.Apply_Attribute_Changes ',2);

1288: THEN
1289:
1290: -- This will also log request/s to check duplicity/fixed_price
1291: -- check of price adjustment entered
1292: adj_debug('Before OE_Line_Adj_Util.Apply_Attribute_Changes ',2);
1293: OE_Line_Adj_Util.Apply_Attribute_Changes
1294: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1295: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1296: --, x_Line_Adj_rec => l_Line_Adj_rec

Line 1293: OE_Line_Adj_Util.Apply_Attribute_Changes

1289:
1290: -- This will also log request/s to check duplicity/fixed_price
1291: -- check of price adjustment entered
1292: adj_debug('Before OE_Line_Adj_Util.Apply_Attribute_Changes ',2);
1293: OE_Line_Adj_Util.Apply_Attribute_Changes
1294: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1295: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1296: --, x_Line_Adj_rec => l_Line_Adj_rec
1297: );

Line 1298: adj_debug('After OE_Line_Adj_Util.Apply_Attribute_Changes ',2);

1294: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1295: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1296: --, x_Line_Adj_rec => l_Line_Adj_rec
1297: );
1298: adj_debug('After OE_Line_Adj_Util.Apply_Attribute_Changes ',2);
1299:
1300: END IF;
1301:
1302:

Line 1307: oe_line_adj_util.log_adj_requests(l_return_status,

1303: -- If there has any activity causing a change in any attribute
1304: -- log a request for repricing
1305: /* IF l_control_rec.change_attributes
1306: THEN
1307: oe_line_adj_util.log_adj_requests(l_return_status,
1308: l_line_adj_rec,
1309: l_old_line_adj_rec);
1310:
1311: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1390: Oe_LINE_ADJ_Util.Pre_Write_Process

1386:
1387: /* Start AuditTrail */
1388: OE_DEBUG_PUB.add('OEXVADJB:calling to insert audit history for line adj from pre_write_process', 2);
1389:
1390: Oe_LINE_ADJ_Util.Pre_Write_Process
1391: (p_x_line_adj_rec => l_line_adj_rec,
1392: p_old_line_adj_rec => l_old_line_adj_rec);
1393: OE_DEBUG_PUB.add('OEXVADJB:After calling to insert audit history for line adj from pre_write_process', 2);
1394: /* End AuditTrail */

Line 1398: OE_Line_Adj_Util.Delete_Row

1394: /* End AuditTrail */
1395:
1396: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1397:
1398: OE_Line_Adj_Util.Delete_Row
1399: ( p_price_adjustment_id => l_Line_Adj_rec.price_adjustment_id
1400: );
1401:
1402: -- Log a delayed request to cause repricing due to deleted

Line 1467: OE_Line_Adj_Util.Update_Row (l_Line_Adj_rec);

1463: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1464: oe_debug_pub.add(' updating list line id:'||l_Line_Adj_rec.list_line_id);
1465: oe_debug_pub.add(' l_line_adj_rec adjusted_amount:'||l_Line_Adj_rec.adjusted_amount);
1466: oe_debug_pub.add(' line_id:'||l_Line_Adj_rec.line_id);
1467: OE_Line_Adj_Util.Update_Row (l_Line_Adj_rec);
1468:
1469: ELSIF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1470:
1471: l_Line_Adj_rec.creation_date := SYSDATE;

Line 1475: OE_Line_Adj_Util.Insert_Row (l_Line_Adj_rec);

1471: l_Line_Adj_rec.creation_date := SYSDATE;
1472: l_Line_Adj_rec.created_by := FND_GLOBAL.USER_ID;
1473:
1474: adj_debug('Before insert row',2);
1475: OE_Line_Adj_Util.Insert_Row (l_Line_Adj_rec);
1476: adj_debug('After insert row',2);
1477:
1478: END IF;
1479:

Line 5665: If (l_order_status_rec.ALL_LINES_FLAG = 'Y' and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y') --bug 2965218

5661: oe_debug_pub.add('Cache header operation:'||oe_order_pub.g_hdr.operation);
5662:
5663:
5664: If G_INT_CHANGED_LINE_ON = 'Y' Then
5665: If (l_order_status_rec.ALL_LINES_FLAG = 'Y' and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y') --bug 2965218
5666: -- or p_multiple_events = 'Y'
5667: or (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE
5668: and p_control_rec.pricing_event = 'BOOK')
5669: or p_action_code = 'PRICE_ORDER' --user request to reprice all lines

Line 5670: or Oe_Line_Adj_Util.has_service_lines(p_header_id)

5666: -- or p_multiple_events = 'Y'
5667: or (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE
5668: and p_control_rec.pricing_event = 'BOOK')
5669: or p_action_code = 'PRICE_ORDER' --user request to reprice all lines
5670: or Oe_Line_Adj_Util.has_service_lines(p_header_id)
5671: Then
5672: ----------------------------------------------------------------
5673: --Pricing says pass all lines, use query_lines is more efficient
5674: ----------------------------------------------------------------

Line 5678: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y' OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N' Then

5674: ----------------------------------------------------------------
5675: adj_debug('Query all_lines');
5676: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
5677: g_pass_all_lines:='Y';
5678: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y' OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N' Then
5679: -------------------------------------------------------------------
5680: --Pricing says pass only changed lines, use query_line
5681: --------------------------------------------------------------------
5682: oe_debug_pub.add('Query individual line');

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

5680: --Pricing says pass only changed lines, use query_line
5681: --------------------------------------------------------------------
5682: oe_debug_pub.add('Query individual line');
5683: g_pass_all_lines:='N';
5684: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5685: While i is Not Null Loop
5686: Begin
5687: --bug 3020702
5688: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);

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

5684: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5685: While i is Not Null Loop
5686: Begin
5687: --bug 3020702
5688: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5689: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5690: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5692: j:=j+1;

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

5685: While i is Not Null Loop
5686: Begin
5687: --bug 3020702
5688: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5689: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5690: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5692: j:=j+1;
5693: end if;

Line 5690: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

5686: Begin
5687: --bug 3020702
5688: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5689: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5690: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5692: j:=j+1;
5693: end if;
5694: Exception when no_data_found then

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

5687: --bug 3020702
5688: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5689: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5690: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5692: j:=j+1;
5693: end if;
5694: Exception when no_data_found then
5695: oe_debug_pub.add('Not found line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

Line 5695: oe_debug_pub.add('Not found line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5692: j:=j+1;
5693: end if;
5694: Exception when no_data_found then
5695: oe_debug_pub.add('Not found line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5696: End;
5697: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5698: End Loop;
5699: End If;

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

5693: end if;
5694: Exception when no_data_found then
5695: oe_debug_pub.add('Not found line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5696: End;
5697: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5698: End Loop;
5699: End If;
5700:
5701: Else

Line 6909: OE_Line_Adj_Util.Query_Rows(p_Line_Id => p_line_id,x_line_adj_tbl=>l_Line_Adj_Tbl );

6905:
6906: if p_line_id is not null then
6907: G_STMT_NO := 'Append_Adjustment_Lines#20';
6908: adj_debug('BCT p_line_id is not null:'||TO_CHAR(p_line_id));
6909: OE_Line_Adj_Util.Query_Rows(p_Line_Id => p_line_id,x_line_adj_tbl=>l_Line_Adj_Tbl );
6910: else
6911: adj_debug('BCT p_line_id is null');
6912: G_STMT_NO := 'Append_Adjustment_Lines#25';
6913:

Line 6914: OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id,x_line_adj_tbl=>l_Line_Adj_Tbl);

6910: else
6911: adj_debug('BCT p_line_id is null');
6912: G_STMT_NO := 'Append_Adjustment_Lines#25';
6913:
6914: OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id,x_line_adj_tbl=>l_Line_Adj_Tbl);
6915: End If;
6916:
6917: x_updated_flag := 'N';
6918: i:= l_Line_Adj_Tbl.First;

Line 7355: OE_Line_Adj_Util.Query_Row

7351: end if;
7352: j:=p_line_adj_tbl.next(j);
7353: end loop;
7354: IF NOT l_found_discount_line THEN
7355: OE_Line_Adj_Util.Query_Row
7356: (p_price_Adjustment_Id => p_Line_Adj_Assoc_Tbl(i).rltd_Price_Adj_Id
7357: , x_line_adj_rec => l_line_adj_rec);
7358: j:=p_line_adj_tbl.count+1;
7359: p_Line_Adj_Tbl(p_Line_Adj_Tbl.count+1) := l_Line_Adj_Rec;

Line 9205: oe_line_adj_util.delete_row(p_line_id => l_line_rec.line_id);

9201: Update Oe_Order_Lines
9202: set Unit_Selling_Price = Null,Unit_list_price = Null
9203: where line_id = l_line_rec.line_id;
9204:
9205: oe_line_adj_util.delete_row(p_line_id => l_line_rec.line_id);
9206: oe_debug_pub.add(' Updating unit price to null');
9207:
9208: l_line_rec.unit_selling_price := NULL;
9209: l_line_rec.unit_list_price:=NULL;

Line 10826: and nvl(OE_LINE_ADJ_UTIL.G_OPM_ITEM_CATCHWEIGHT_USED,'N') = 'Y' -- bug 2965218

10822: OE_GLOBALS.G_GMI_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(550);
10823: END IF;
10824:
10825: If (OE_GLOBALS.G_GMI_INSTALLED = 'Y')
10826: and nvl(OE_LINE_ADJ_UTIL.G_OPM_ITEM_CATCHWEIGHT_USED,'N') = 'Y' -- bug 2965218
10827: Then
10828: adj_debug('OPM - GMA installed');
10829: RETURN TRUE;
10830: End If; -- OPM 2547940 end