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

Line 419: oe_line_util.query_row(p_line_id => p_line_id,

415:
416: /* The next check is redundant and harmful if a child line is being deleted from
417: set. The check has already been done in process_sets(). Commented for 2525203.
418: -- See if this is already fulfilled . if fulfilled raise error
419: oe_line_util.query_row(p_line_id => p_line_id,
420: x_line_rec => l_line_rec);
421: IF (nvl(l_line_rec.fulfilled_flag,'N') = 'Y') THEN
422: fnd_message.set_name('ONT', 'OE_LINE_FULFILLED');
423: oe_msg_pub.add;

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

548: FOR optionrec in optiontbl
549: Loop
550: l_count := l_count + 1;
551: l_line_tbl(l_count).line_id := optionrec.line_id;
552: oe_line_util.query_row(p_line_id => optionrec.line_id,
553: x_line_rec => l_line_tbl(l_count));
554: g_old_line_tbl(l_count) :=
555: l_line_tbl(l_count);
556: l_old_line_tbl(l_count) := l_line_tbl(l_count);

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

770: END IF;
771:
772: IF NOT lexist THEN
773: p_x_line_tbl(l_count).line_id := optionrec.line_id;
774: oe_line_util.query_row(p_line_id => optionrec.line_id,
775: x_line_rec => p_x_line_tbl(l_count));
776:
777: g_old_line_tbl(g_old_line_tbl.count + 1) :=
778: p_x_line_tbl(l_count);

Line 990: oe_line_util.query_row(p_line_id => g_auto_set_tbl(I).line_id,

986: g_old_line_tbl.delete;
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add( 'ENTER INTO AUTO SET TABLE LOOP ' , 1 ) ;
989: END IF;
990: oe_line_util.query_row(p_line_id => g_auto_set_tbl(I).line_id,
991: x_line_rec => l_line_rec);
992: IF (l_line_rec.split_from_line_id is not null) THEN
993: IF l_debug_level > 0 THEN
994: oe_debug_pub.add( 'INVALID ITEM SPLIT'||L_LINE_REC.LINE_ID ) ;

Line 1124: oe_line_util.query_row(p_line_id => l_temp_line_tbl(J).top_model_line_id,

1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add( 'SHIP SET' || L_TEMP_LINE_TBL ( 1 ) .SHIP_SET_ID , 1 ) ;
1122: END IF;
1123: if not l_model_exists then
1124: oe_line_util.query_row(p_line_id => l_temp_line_tbl(J).top_model_line_id,
1125: x_line_rec => l_model_line_rec);
1126: if l_model_line_rec.ship_set_id is null and
1127: l_model_line_rec.arrival_set_id is null THEN
1128:

Line 1382: oe_line_util.query_row(p_line_id => l_line_tbl(I).top_model_line_id,

1378: exit;
1379: END IF;
1380: END LOOP;
1381: if not l_model_exists then
1382: oe_line_util.query_row(p_line_id => l_line_tbl(I).top_model_line_id,
1383: x_line_rec => l_model_line_rec);
1384: IF l_model_line_rec.ship_set_id is null then
1385: l_line_tbl(I).ship_set_id := NULL;
1386: ELSIF l_model_line_rec.ship_set_id is not null then

Line 1656: OE_LINE_UTIL.lock_row

1652: */
1653: FOR I IN 1..p_selected_line_tbl.COUNT LOOP
1654: l_line_id := p_selected_line_tbl(I).id1;
1655: -- R12.MOAC End
1656: OE_LINE_UTIL.lock_row
1657: ( p_line_id => l_line_id,
1658: p_x_line_rec => l_line_rec
1659: ,x_return_status => l_return_status);
1660:

Line 2342: oe_line_util.query_row(p_line_id => g_auto_set_tbl(I).line_id,

2338: Begin
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'ENTER INTO AUTO SET TABLE LOOP ' , 1 ) ;
2341: END IF;
2342: oe_line_util.query_row(p_line_id => g_auto_set_tbl(I).line_id,
2343: x_line_rec => l_line_rec);
2344: IF (l_line_rec.split_from_line_id IS NOT NULL) THEN
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add( 'INVALID SPLIT LINEE'||L_LINE_REC.LINE_ID ) ;

Line 2466: oe_line_util.query_row(p_line_id => l_temp_line_tbl(J).top_model_line_id,

2462: exit;
2463: END IF;
2464: END LOOP;
2465: if not l_model_exists then
2466: oe_line_util.query_row(p_line_id => l_temp_line_tbl(J).top_model_line_id,
2467: x_line_rec => l_model_line_rec);
2468: if l_model_line_rec.ship_set_id is null and
2469: l_model_line_rec.arrival_set_id is null THEN
2470:

Line 2635: oe_line_util.query_row(p_line_id => l_line_tbl(I).top_model_line_id,

2631: exit;
2632: END IF;
2633: END LOOP;
2634: if not l_model_exists then
2635: oe_line_util.query_row(p_line_id => l_line_tbl(I).top_model_line_id,
2636: x_line_rec => l_model_line_rec);
2637: IF l_model_line_rec.ship_set_id is null then
2638: l_line_tbl(I).ship_set_id := NULL;
2639: ELSIF l_model_line_rec.ship_set_id is not null then

Line 3209: OE_LINE_UTIL.lock_row

3205: j := j + 1.0;
3206: nextpos := INSTR(l_record_ids,',',1,j) ;
3207: */
3208: --R12.MOAC End
3209: OE_LINE_UTIL.lock_row
3210: (p_line_id => l_line_id
3211: ,p_x_line_rec => l_line_rec
3212: ,x_return_status => l_return_status);
3213:

Line 3562: oe_line_util.query_row(p_line_id => l_line_tbl(t).line_id,

3558:
3559: g_old_line_tbl.delete;
3560: For t in 1..l_line_tbl.count
3561: loop
3562: oe_line_util.query_row(p_line_id => l_line_tbl(t).line_id,
3563: x_line_rec => l_line_rec);
3564: g_old_line_tbl(t) := l_line_rec;
3565:
3566: IF l_debug_level > 0 THEN

Line 5140: oe_line_util.query_row(p_line_id => c1rec.line_id,

5136:
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: END;
5139: FOR C1REC in C1 LOOP
5140: oe_line_util.query_row(p_line_id => c1rec.line_id,
5141: x_line_rec => l_line_rec);
5142: x_line_tbl(x_line_tbl.count + 1) := l_line_rec;
5143: END LOOP;
5144:

Line 5161: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;

5157:
5158:
5159: -- Return fetched table
5160: IF l_debug_level > 0 THEN
5161: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;
5162: END IF;
5163:
5164:
5165: EXCEPTION

Line 5380: oe_line_util.query_row(p_line_id => g_set_tbl(I).line_id,

5376:
5377: IF g_set_tbl(I).process_flag <> 'Y' THEN
5378:
5379: BEGIN
5380: oe_line_util.query_row(p_line_id => g_set_tbl(I).line_id,
5381: x_line_rec => l_line_rec);
5382:
5383: EXCEPTION
5384:

Line 5564: oe_line_util.query_row(p_line_id => g_set_tbl(J).line_id,

5560: END IF;
5561: IF l_debug_level > 0 THEN
5562: oe_debug_pub.add( 'SET NAME- NEXT:' || G_SET_TBL ( J ) .SET_TYPE ) ;
5563: END IF;
5564: oe_line_util.query_row(p_line_id => g_set_tbl(J).line_id,
5565: x_line_rec => l_line_rec);
5566:
5567:
5568: IF (l_line_rec.item_type_code <> 'MODEL' AND

Line 5854: oe_line_util.query_row( l_line_tbl(K).line_id,

5850: LOOP
5851: IF l_debug_level > 0 THEN
5852: oe_debug_pub.add( 'BEFORE ASSIGNING THE OLD RECORD IN SET' , 1 ) ;
5853: END IF;
5854: oe_line_util.query_row( l_line_tbl(K).line_id,
5855: l_line_rec);
5856: g_old_line_tbl(K) := l_line_rec;
5857:
5858: IF l_Set_type = 'SHIP_SET' THEN

Line 6731: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);

6727:
6728: /*Changes for bug 6719457 start*/
6729:
6730: FOR i in C8 loop
6731: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);
6732: IF l_child_line_rec.schedule_status_code is not null THEN
6733: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
6734: ELSE
6735: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;