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 455: oe_line_util.query_row(p_line_id => p_line_id,

451:
452: /* The next check is redundant and harmful if a child line is being deleted from
453: set. The check has already been done in process_sets(). Commented for 2525203.
454: -- See if this is already fulfilled . if fulfilled raise error
455: oe_line_util.query_row(p_line_id => p_line_id,
456: x_line_rec => l_line_rec);
457: IF (nvl(l_line_rec.fulfilled_flag,'N') = 'Y') THEN
458: fnd_message.set_name('ONT', 'OE_LINE_FULFILLED');
459: oe_msg_pub.add;

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

584: FOR optionrec in optiontbl
585: Loop
586: l_count := l_count + 1;
587: l_line_tbl(l_count).line_id := optionrec.line_id;
588: oe_line_util.query_row(p_line_id => optionrec.line_id,
589: x_line_rec => l_line_tbl(l_count));
590: g_old_line_tbl(l_count) :=
591: l_line_tbl(l_count);
592: l_old_line_tbl(l_count) := l_line_tbl(l_count);

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

806: END IF;
807:
808: IF NOT lexist THEN
809: p_x_line_tbl(l_count).line_id := optionrec.line_id;
810: oe_line_util.query_row(p_line_id => optionrec.line_id,
811: x_line_rec => p_x_line_tbl(l_count));
812:
813: g_old_line_tbl(g_old_line_tbl.count + 1) :=
814: p_x_line_tbl(l_count);

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

1022: g_old_line_tbl.delete;
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.add( 'ENTER INTO AUTO SET TABLE LOOP ' , 1 ) ;
1025: END IF;
1026: oe_line_util.query_row(p_line_id => g_auto_set_tbl(I).line_id,
1027: x_line_rec => l_line_rec);
1028: IF (l_line_rec.split_from_line_id is not null) THEN
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'INVALID ITEM SPLIT'||L_LINE_REC.LINE_ID ) ;

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

1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'SHIP SET' || L_TEMP_LINE_TBL ( 1 ) .SHIP_SET_ID , 1 ) ;
1158: END IF;
1159: if not l_model_exists then
1160: oe_line_util.query_row(p_line_id => l_temp_line_tbl(J).top_model_line_id,
1161: x_line_rec => l_model_line_rec);
1162: if l_model_line_rec.ship_set_id is null and
1163: l_model_line_rec.arrival_set_id is null THEN
1164:

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

1414: exit;
1415: END IF;
1416: END LOOP;
1417: if not l_model_exists then
1418: oe_line_util.query_row(p_line_id => l_line_tbl(I).top_model_line_id,
1419: x_line_rec => l_model_line_rec);
1420: IF l_model_line_rec.ship_set_id is null then
1421: l_line_tbl(I).ship_set_id := NULL;
1422: ELSIF l_model_line_rec.ship_set_id is not null then

Line 1692: OE_LINE_UTIL.lock_row

1688: */
1689: FOR I IN 1..p_selected_line_tbl.COUNT LOOP
1690: l_line_id := p_selected_line_tbl(I).id1;
1691: -- R12.MOAC End
1692: OE_LINE_UTIL.lock_row
1693: ( p_line_id => l_line_id,
1694: p_x_line_rec => l_line_rec
1695: ,x_return_status => l_return_status);
1696:

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

2391: Begin
2392: IF l_debug_level > 0 THEN
2393: oe_debug_pub.add( 'ENTER INTO AUTO SET TABLE LOOP ' , 1 ) ;
2394: END IF;
2395: oe_line_util.query_row(p_line_id => g_auto_set_tbl(I).line_id,
2396: x_line_rec => l_line_rec);
2397: IF (l_line_rec.split_from_line_id IS NOT NULL) THEN
2398: IF l_debug_level > 0 THEN
2399: oe_debug_pub.add( 'INVALID SPLIT LINEE'||L_LINE_REC.LINE_ID ) ;

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

2515: exit;
2516: END IF;
2517: END LOOP;
2518: if not l_model_exists then
2519: oe_line_util.query_row(p_line_id => l_temp_line_tbl(J).top_model_line_id,
2520: x_line_rec => l_model_line_rec);
2521: if l_model_line_rec.ship_set_id is null and
2522: l_model_line_rec.arrival_set_id is null THEN
2523:

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

2684: exit;
2685: END IF;
2686: END LOOP;
2687: if not l_model_exists then
2688: oe_line_util.query_row(p_line_id => l_line_tbl(I).top_model_line_id,
2689: x_line_rec => l_model_line_rec);
2690: IF l_model_line_rec.ship_set_id is null then
2691: l_line_tbl(I).ship_set_id := NULL;
2692: ELSIF l_model_line_rec.ship_set_id is not null then

Line 3266: OE_LINE_UTIL.lock_row

3262: j := j + 1.0;
3263: nextpos := INSTR(l_record_ids,',',1,j) ;
3264: */
3265: --R12.MOAC End
3266: OE_LINE_UTIL.lock_row
3267: (p_line_id => l_line_id
3268: ,p_x_line_rec => l_line_rec
3269: ,x_return_status => l_return_status);
3270:

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

3615:
3616: g_old_line_tbl.delete;
3617: For t in 1..l_line_tbl.count
3618: loop
3619: oe_line_util.query_row(p_line_id => l_line_tbl(t).line_id,
3620: x_line_rec => l_line_rec);
3621: g_old_line_tbl(t) := l_line_rec;
3622:
3623: IF l_debug_level > 0 THEN

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

5193:
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: END;
5196: FOR C1REC in C1 LOOP
5197: oe_line_util.query_row(p_line_id => c1rec.line_id,
5198: x_line_rec => l_line_rec);
5199: x_line_tbl(x_line_tbl.count + 1) := l_line_rec;
5200: END LOOP;
5201:

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

5214:
5215:
5216: -- Return fetched table
5217: IF l_debug_level > 0 THEN
5218: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;
5219: END IF;
5220:
5221:
5222: EXCEPTION

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

5433:
5434: IF g_set_tbl(I).process_flag <> 'Y' THEN
5435:
5436: BEGIN
5437: oe_line_util.query_row(p_line_id => g_set_tbl(I).line_id,
5438: x_line_rec => l_line_rec);
5439:
5440: EXCEPTION
5441:

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

5617: END IF;
5618: IF l_debug_level > 0 THEN
5619: oe_debug_pub.add( 'SET NAME- NEXT:' || G_SET_TBL ( J ) .SET_TYPE ) ;
5620: END IF;
5621: oe_line_util.query_row(p_line_id => g_set_tbl(J).line_id,
5622: x_line_rec => l_line_rec);
5623:
5624:
5625: IF (l_line_rec.item_type_code <> 'MODEL' AND

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

5907: LOOP
5908: IF l_debug_level > 0 THEN
5909: oe_debug_pub.add( 'BEFORE ASSIGNING THE OLD RECORD IN SET' , 1 ) ;
5910: END IF;
5911: oe_line_util.query_row( l_line_tbl(K).line_id,
5912: l_line_rec);
5913: g_old_line_tbl(K) := l_line_rec;
5914:
5915: IF l_Set_type = 'SHIP_SET' THEN

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

7207:
7208: /*Changes for bug 6719457 start*/
7209:
7210: FOR i in C8 loop
7211: l_child_line_rec:=OE_LINE_UTIL.QUERY_ROW(p_line_id => i.line_id);
7212: IF l_child_line_rec.schedule_status_code is not null THEN
7213: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
7214: ELSE
7215: l_action := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;