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

Line 106: oe_line_util.query_row(ser_rec.line_id,x_line_rec => l_ser_line_rec);

102: END IF;
103: FOR Ser_rec IN Sertbl LOOP
104: l_service_count := l_service_count + 1;
105: l_ser_line_tbl(l_service_count).line_id := ser_rec.line_id;
106: oe_line_util.query_row(ser_rec.line_id,x_line_rec => l_ser_line_rec);
107: l_ser_line_tbl(l_service_count) := l_ser_line_rec;
108: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
109: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
110: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_line_rec.split_from_line_id;

Line 275: oe_line_util.query_row(ser_rec.line_id,x_line_rec => l_ser_rec);

271: END IF;
272: x_line_tbl := p_line_tbl;
273: l_line_id := g_split_line_tbl(1).line_id;
274: FOR Ser_rec IN Sertbl LOOP
275: oe_line_util.query_row(ser_rec.line_id,x_line_rec => l_ser_rec);
276: -- for bug 2035100
277: IF p_line_tbl(1).split_by IS NOT NULL THEN
278: l_ser_rec.split_by := p_line_tbl(1).split_by;
279: END IF;

Line 403: oe_line_util.query_row(p_line_id => l_line_id,x_line_rec => l_line_rec);

399: END IF;
400: END LOOP;
401: x_line_tbl := p_line_tbl;
402: l_line_id := p_line_tbl(1).top_model_line_id;
403: oe_line_util.query_row(p_line_id => l_line_id,x_line_rec => l_line_rec);
404: l_parent_quantity := l_line_rec.ordered_quantity - p_line_tbl(1).ordered_quantity;
405: l_parent_line := l_line_rec;
406: -- Get Complete shipped Model if any
407: -- Form Complete Shipped Model if g_max_model > 0

Line 426: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);

422: l_set_id := l_parent_line.line_set_id;
423: l_option_count := l_option_count + 1;
424: l_option_line_tbl(l_option_count) := l_parent_line;
425: FOR optionrec in optiontbl LOOP
426: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);
427: l_model_ratio := l_option_line.ordered_quantity/l_line_rec.ordered_quantity;
428: option_updated := FALSE;
429: FOR I in 1..P_line_tbl.count LOOP
430: IF p_line_tbl(I).line_id = optionrec.line_id THEN

Line 497: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);

493: END IF;
494: l_option_count := l_option_count + 1;
495: l_option_line_tbl(l_option_count) := l_parent_line;
496: FOR optionrec in optiontbl LOOP
497: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);
498: l_model_ratio := l_option_line.ordered_quantity /l_line_rec.ordered_quantity;
499: l_option_count := l_option_count + 1;
500: l_option_line_tbl(l_option_count) := l_option_line;
501: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;

Line 581: oe_line_util.query_row(p_line_id => optionrec.line_id,x_line_rec => l_option_line);

577: l_option_count := l_option_count + 1;
578: l_option_line_tbl(l_option_count) := l_parent_line;
579: END IF;
580: FOR optionrec in optiontbl LOOP
581: oe_line_util.query_row(p_line_id => optionrec.line_id,x_line_rec => l_option_line);
582: l_model_ratio := l_option_line.ordered_quantity /l_line_rec.ordered_quantity;
583: FOR I in 1..P_line_tbl.count LOOP
584: l_actual_shipment_date := p_line_tbl(i).actual_shipment_date;
585: IF p_line_tbl(I).line_id = optionrec.line_id THEN

Line 664: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);

660: l_option_line_tbl(l_option_count) := l_parent_line;
661: l_option_line_tbl(l_option_count).model_remnant_flag := 'Y';
662: END IF;*/
663: FOR optionrec in optiontbl LOOP
664: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);
665: l_model_ratio := l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
666: option_updated := FALSE;
667: l_insert_quantity := 0;
668: FOR I in 1..P_line_tbl.count LOOP

Line 810: oe_line_util.query_row(p_line_id => l_line_id, x_line_rec => l_line_rec);

806: --
807: BEGIN
808: x_line_tbl := p_line_tbl;
809: l_line_id := p_line_tbl(1).line_id;
810: oe_line_util.query_row(p_line_id => l_line_id, x_line_rec => l_line_rec);
811: l_parent_quantity := l_line_rec.ordered_quantity - p_line_tbl(1).ordered_quantity;
812: l_parent_line := l_line_rec;
813: -- Get Complete shipped Model if any
814: -- Form Complete Shipped Model if g_max_model > 0

Line 833: oe_line_util.query_row(p_line_id => optionrec.line_id,

829: l_set_id := l_parent_line.line_set_id;
830: x_line_tbl(1) := l_parent_line;
831: --l_option_line_tbl(l_option_count) := l_parent_line;
832: FOR optionrec IN optiontbl LOOP
833: oe_line_util.query_row(p_line_id => optionrec.line_id,
834: x_line_rec => l_option_line);
835: l_model_ratio := l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
836: option_updated := FALSE;
837: FOR I in 1..P_line_tbl.count LOOP

Line 896: oe_line_util.query_row(p_line_id => optionrec.line_id,

892: END IF;
893: l_option_count := l_option_count + 1;
894: l_option_line_tbl(l_option_count) := l_parent_line;
895: FOR optionrec in optiontbl LOOP
896: oe_line_util.query_row(p_line_id => optionrec.line_id,
897: x_line_rec => l_option_line);
898: l_model_ratio :=l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
899: l_option_count := l_option_count + 1;
900: l_option_line_tbl(l_option_count) := l_option_line;

Line 1010: oe_line_util.query_row(p_line_id => optionrec.line_id,

1006: l_top_model_line_id := l_rem_top_model_line_id ;
1007: END IF;
1008: -- Get remanat shipped options
1009: FOR optionrec in optiontbl LOOP
1010: oe_line_util.query_row(p_line_id => optionrec.line_id,
1011: x_line_rec => l_option_line);
1012: l_model_ratio := l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
1013: FOR I in 1..P_line_tbl.count LOOP
1014: IF p_line_tbl(I).line_id = optionrec.line_id THEN

Line 1070: oe_line_util.query_row(p_line_id => optionrec.line_id,

1066: ELSE
1067: l_top_model_line_id := l_rem_shp_top_model_line_id ;
1068: END IF;
1069: FOR optionrec in optiontbl LOOP
1070: oe_line_util.query_row(p_line_id => optionrec.line_id,
1071: x_line_rec => l_option_line);
1072: l_model_ratio := l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
1073: option_updated := FALSE;
1074: l_insert_quantity := 0;

Line 1236: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);

1232: END IF;
1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add( 'ORDERED QUANTITY RATIO : ' || OPTIONREC.ORDERED_QUANTITY , 1 ) ;
1235: END IF;
1236: oe_line_util.query_row(p_line_id => optionrec.line_id, x_line_rec => l_option_line);
1237: l_line_scredit_tbl.delete;
1238: oe_line_scredit_util.query_rows( p_line_id => optionrec.line_id, x_line_scredit_tbl => l_line_scredit_tbl);
1239: l_option_line_tbl(l_option_count) := l_option_line;
1240: l_option_line_tbl(l_option_count).line_id := optionrec.line_id;

Line 1415: oe_line_util.query_row(p_line_id => p_x_line_rec.split_from_line_id,

1411: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN
1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'ENTER INTO DEFAULTING SPLITS' ) ;
1414: END IF;
1415: oe_line_util.query_row(p_line_id => p_x_line_rec.split_from_line_id,
1416: x_line_rec => l_line_rec);
1417: l_line_rec.line_id := OE_Default_Line.get_Line;
1418: --online changes
1419: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND

Line 1512: oe_line_util.convert_miss_to_null(p_x_line_rec => l_line_rec);

1508: /* IF l_line_rec.schedule_status_code IS NOT NULL THEN
1509: l_line_rec.schedule_action_code := OE_ORDER_SCH_UTIL.OESCH_ACT_DEMAND;
1510: l_line_rec.schedule_status_code := NULL;
1511: END IF;*/
1512: oe_line_util.convert_miss_to_null(p_x_line_rec => l_line_rec);
1513: l_line_rec.operation := oe_globals.g_opr_create;
1514: p_x_line_rec := l_line_rec;
1515: ELSIF (l_line_rec.line_id IS NOT NULL AND
1516: l_line_rec.line_id <> FND_API.G_MISS_NUM AND

Line 1667: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,

1663: oe_debug_pub.add( 'SPLIT- NOT ALLOWED TO UPDATE WITH QUANTITY ZERO' ) ;
1664: END IF;
1665: RAISE FND_API.G_EXC_ERROR;
1666: END IF;
1667: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,
1668: x_line_rec => l_line_rec);
1669: IF l_debug_level > 0
1670: THEN
1671: oe_debug_pub.add( 'ITEM TYPE CODE : '|| L_LINE_REC.ITEM_TYPE_CODE ) ;

Line 1692: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,

1688: END IF;
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691: END IF;
1692: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,
1693: x_line_rec => l_line_rec);
1694: l_parent_ordered_quantity := l_line_rec.ordered_quantity;
1695: l_split_count := l_split_count + 1;
1696: g_split_line_tbl(l_split_count).line_id := l_line_tbl(I).line_id;

Line 1964: oe_line_util.query_row(p_line_id => l_line_tbl(1).line_id, x_line_rec => l_line_rec);

1960: oe_debug_pub.add('Shipped quantity : '||l_line_tbl(i).shipped_quantity,5) ;
1961: END IF;
1962: END LOOP;
1963:
1964: oe_line_util.query_row(p_line_id => l_line_tbl(1).line_id, x_line_rec => l_line_rec);
1965:
1966: IF (l_line_rec.item_type_code = 'MODEL' OR
1967: l_line_rec.item_type_code = 'KIT') THEN
1968: IF l_line_rec.shippable_flag = 'Y' THEN

Line 1974: oe_line_util.query_row(p_line_id => l_line_tbl(1).top_model_line_id, x_line_rec => l_line_rec);

1970: ELSE
1971: l_tbl_count := 2;
1972: END IF;
1973: ELSE
1974: oe_line_util.query_row(p_line_id => l_line_tbl(1).top_model_line_id, x_line_rec => l_line_rec);
1975: l_model_flag := 'N';
1976: l_tbl_count := 1;
1977: END IF;
1978:

Line 1995: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id, x_line_rec => l_option_line);

1991: l_complete_shipment := 'N';
1992: end if;
1993: --End of the bug fix 3474977
1994: FOR I in l_tbl_count .. L_Line_tbl.count LOOP
1995: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id, x_line_rec => l_option_line);
1996: l_model_ratio := l_option_line.ordered_quantity/l_line_rec.ordered_quantity;
1997: l_temp_min_model := Floor(l_line_tbl(I).ordered_quantity/l_model_ratio);
1998: IF l_complete_shipment = 'Y' THEN
1999: l_temp_max_model := Floor(l_line_tbl(I).shipped_quantity/l_model_ratio);

Line 2371: OE_Line_Util.Lock_Row

2367: IF l_debug_level > 0 THEN
2368: oe_debug_pub.add(' Query Line for Split'||l_line_conc_tbl(i).LINE_ID,3) ;
2369: END IF;
2370: l_x_line_tbl(i).line_id := l_line_conc_tbl(i).line_id;
2371: OE_Line_Util.Lock_Row
2372: ( x_return_status => l_return_status
2373: , p_x_line_rec => l_x_line_tbl(i)
2374: , p_line_id => l_line_conc_tbl(i).line_id);
2375: