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 283: oe_line_adj_util.delete_row(p_line_id => p_line_rec.line_id);

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

Line 1146: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);

1142:
1143: -- Set missing old record elements to NULL.
1144:
1145: -- l_old_Line_Adj_rec :=
1146: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);
1147: --bug 2721485 Begin
1148: adj_debug('Line id :'||l_line_adj_rec.line_id,3);
1149: if OE_GLOBALS.G_PRICING_RECURSION = 'N' and
1150: l_line_adj_rec.line_id is not null then

Line 1198: OE_Line_Adj_Util.Query_Row

1194: IF l_old_Line_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM
1195: OR l_old_Line_Adj_rec.line_id IS NULL
1196: THEN
1197:
1198: OE_Line_Adj_Util.Query_Row
1199: ( p_price_adjustment_id => l_Line_Adj_rec.price_adjustment_id
1200: , x_line_adj_rec => l_old_Line_Adj_rec
1201: );
1202:

Line 1210: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);

1206:
1207: -- Set missing old record elements to NULL.
1208:
1209: -- l_old_Line_Adj_rec :=
1210: OE_Line_Adj_Util.Convert_Miss_To_Null (l_old_Line_Adj_rec);
1211:
1212: END IF;
1213:
1214: -- Complete new record from old

Line 1217: OE_Line_Adj_Util.Complete_Record

1213:
1214: -- Complete new record from old
1215:
1216: -- l_Line_Adj_rec :=
1217: OE_Line_Adj_Util.Complete_Record
1218: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1219: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1220: );
1221:

Line 1292: OE_Line_Adj_Util.Clear_Dependent_Attr

1288: -- Clear dependent attributes.
1289:
1290: IF l_control_rec.clear_dependents THEN
1291:
1292: OE_Line_Adj_Util.Clear_Dependent_Attr
1293: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1294: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1295: --, x_Line_Adj_rec => l_Line_Adj_rec
1296: );

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

1323: THEN
1324:
1325: -- This will also log request/s to check duplicity/fixed_price
1326: -- check of price adjustment entered
1327: adj_debug('Before OE_Line_Adj_Util.Apply_Attribute_Changes ',2);
1328: OE_Line_Adj_Util.Apply_Attribute_Changes
1329: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1330: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1331: --, x_Line_Adj_rec => l_Line_Adj_rec

Line 1328: OE_Line_Adj_Util.Apply_Attribute_Changes

1324:
1325: -- This will also log request/s to check duplicity/fixed_price
1326: -- check of price adjustment entered
1327: adj_debug('Before OE_Line_Adj_Util.Apply_Attribute_Changes ',2);
1328: OE_Line_Adj_Util.Apply_Attribute_Changes
1329: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1330: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1331: --, x_Line_Adj_rec => l_Line_Adj_rec
1332: );

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

1329: ( p_x_Line_Adj_rec => l_Line_Adj_rec
1330: , p_old_Line_Adj_rec => l_old_Line_Adj_rec
1331: --, x_Line_Adj_rec => l_Line_Adj_rec
1332: );
1333: adj_debug('After OE_Line_Adj_Util.Apply_Attribute_Changes ',2);
1334:
1335: END IF;
1336:
1337:

Line 1342: oe_line_adj_util.log_adj_requests(l_return_status,

1338: -- If there has any activity causing a change in any attribute
1339: -- log a request for repricing
1340: /* IF l_control_rec.change_attributes
1341: THEN
1342: oe_line_adj_util.log_adj_requests(l_return_status,
1343: l_line_adj_rec,
1344: l_old_line_adj_rec);
1345:
1346: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1425: Oe_LINE_ADJ_Util.Pre_Write_Process

1421:
1422: /* Start AuditTrail */
1423: OE_DEBUG_PUB.add('OEXVADJB:calling to insert audit history for line adj from pre_write_process', 2);
1424:
1425: Oe_LINE_ADJ_Util.Pre_Write_Process
1426: (p_x_line_adj_rec => l_line_adj_rec,
1427: p_old_line_adj_rec => l_old_line_adj_rec);
1428: OE_DEBUG_PUB.add('OEXVADJB:After calling to insert audit history for line adj from pre_write_process', 2);
1429: /* End AuditTrail */

Line 1433: OE_Line_Adj_Util.Delete_Row

1429: /* End AuditTrail */
1430:
1431: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1432:
1433: OE_Line_Adj_Util.Delete_Row
1434: ( p_price_adjustment_id => l_Line_Adj_rec.price_adjustment_id
1435: );
1436:
1437: -- Log a delayed request to cause repricing due to deleted

Line 1550: OE_Line_Adj_Util.Update_Row (l_Line_Adj_rec);

1546: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1547: oe_debug_pub.add(' updating list line id:'||l_Line_Adj_rec.list_line_id);
1548: oe_debug_pub.add(' l_line_adj_rec adjusted_amount:'||l_Line_Adj_rec.adjusted_amount);
1549: oe_debug_pub.add(' line_id:'||l_Line_Adj_rec.line_id);
1550: OE_Line_Adj_Util.Update_Row (l_Line_Adj_rec);
1551:
1552: ELSIF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1553:
1554: l_Line_Adj_rec.creation_date := SYSDATE;

Line 1558: OE_Line_Adj_Util.Insert_Row (l_Line_Adj_rec);

1554: l_Line_Adj_rec.creation_date := SYSDATE;
1555: l_Line_Adj_rec.created_by := FND_GLOBAL.USER_ID;
1556:
1557: adj_debug('Before insert row',2);
1558: OE_Line_Adj_Util.Insert_Row (l_Line_Adj_rec);
1559: adj_debug('After insert row',2);
1560:
1561: END IF;
1562:

Line 5756: 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

5752: oe_debug_pub.add('Cache header operation:'||oe_order_pub.g_hdr.operation);
5753:
5754:
5755: If G_INT_CHANGED_LINE_ON = 'Y' Then
5756: 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
5757: -- or p_multiple_events = 'Y'
5758: or (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE
5759: and p_control_rec.pricing_event = 'BOOK')
5760: or p_action_code = 'PRICE_ORDER' --user request to reprice all lines

Line 5761: or Oe_Line_Adj_Util.has_service_lines(p_header_id)

5757: -- or p_multiple_events = 'Y'
5758: or (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE
5759: and p_control_rec.pricing_event = 'BOOK')
5760: or p_action_code = 'PRICE_ORDER' --user request to reprice all lines
5761: or Oe_Line_Adj_Util.has_service_lines(p_header_id)
5762: Then
5763: ----------------------------------------------------------------
5764: --Pricing says pass all lines, use query_lines is more efficient
5765: ----------------------------------------------------------------

Line 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

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
5772: --------------------------------------------------------------------
5773: oe_debug_pub.add('Query individual line');

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

5771: --Pricing says pass only changed lines, use query_line
5772: --------------------------------------------------------------------
5773: oe_debug_pub.add('Query individual line');
5774: g_pass_all_lines:='N';
5775: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5776: While i is Not Null Loop
5777: Begin
5778: --bug 3020702
5779: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);

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

5775: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;
5776: While i is Not Null Loop
5777: Begin
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;

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

5776: While i is Not Null Loop
5777: Begin
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;

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

5777: Begin
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

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 5786: oe_debug_pub.add('Not found 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);
5787: End;
5788: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5789: End Loop;
5790: End If;

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

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);
5787: End;
5788: i:= Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.Next(i);
5789: End Loop;
5790: End If;
5791:
5792: Else

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

6996:
6997: if p_line_id is not null then
6998: G_STMT_NO := 'Append_Adjustment_Lines#20';
6999: adj_debug('BCT p_line_id is not null:'||TO_CHAR(p_line_id));
7000: OE_Line_Adj_Util.Query_Rows(p_Line_Id => p_line_id,x_line_adj_tbl=>l_Line_Adj_Tbl );
7001: else
7002: adj_debug('BCT p_line_id is null');
7003: G_STMT_NO := 'Append_Adjustment_Lines#25';
7004:

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

7001: else
7002: adj_debug('BCT p_line_id is null');
7003: G_STMT_NO := 'Append_Adjustment_Lines#25';
7004:
7005: OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id,x_line_adj_tbl=>l_Line_Adj_Tbl);
7006: End If;
7007:
7008: x_updated_flag := 'N';
7009: i:= l_Line_Adj_Tbl.First;

Line 7447: OE_Line_Adj_Util.Query_Row

7443: end if;
7444: j:=p_line_adj_tbl.next(j);
7445: end loop;
7446: IF NOT l_found_discount_line THEN
7447: OE_Line_Adj_Util.Query_Row
7448: (p_price_Adjustment_Id => p_Line_Adj_Assoc_Tbl(i).rltd_Price_Adj_Id
7449: , x_line_adj_rec => l_line_adj_rec);
7450: j:=p_line_adj_tbl.count+1;
7451: p_Line_Adj_Tbl(p_Line_Adj_Tbl.count+1) := l_Line_Adj_Rec;

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

9292: Update Oe_Order_Lines
9293: set Unit_Selling_Price = Null,Unit_list_price = Null
9294: where line_id = l_line_rec.line_id;
9295:
9296: oe_line_adj_util.delete_row(p_line_id => l_line_rec.line_id);
9297: oe_debug_pub.add(' Updating unit price to null');
9298:
9299: l_line_rec.unit_selling_price := NULL;
9300: l_line_rec.unit_list_price:=NULL;

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

10930: OE_GLOBALS.G_GMI_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(550);
10931: END IF;
10932:
10933: If (OE_GLOBALS.G_GMI_INSTALLED = 'Y')
10934: and nvl(OE_LINE_ADJ_UTIL.G_OPM_ITEM_CATCHWEIGHT_USED,'N') = 'Y' -- bug 2965218
10935: Then
10936: adj_debug('OPM - GMA installed');
10937: RETURN TRUE;
10938: End If; -- OPM 2547940 end