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.

[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on DUAL

Line 114: -- HW addeded variables for DUAL (OPM)

110:
111: l_temp_requested_quantity NUMBER;
112: l_temp_requested_quantity2 NUMBER; -- INVCONV
113:
114: -- HW addeded variables for DUAL (OPM)
115: -- l_OPM_requested_quantity NUMBER; INVCONV
116: l_ordered_quantity2 NUMBER;
117: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
118: l_line_set_id NUMBER;

Line 148: l_temp_dual_shipped_qty NUMBER; -- INVCONV

144: AND NVL ( WDD.OE_INTERFACED_FLAG , 'N' ) <> 'Y';
145:
146: LOT LOT_INFO%ROWTYPE;
147:
148: l_temp_dual_shipped_qty NUMBER; -- INVCONV
149:
150: -- HW OPM end of changes for 2415731
151: --bug3480047 start
152: l_shippable_lines NUMBER;

Line 181: -- to determine if the line is dual

177: FOR J IN 1..p_req_qty_tbl.count
178:
179: LOOP
180: -- HW Retrieve ship_from_org_id,inventory_item_id and ordered_quantity2
181: -- to determine if the line is dual
182: SELECT ordered_quantity,
183: order_quantity_uom,
184: inventory_item_id,
185: top_model_line_id,

Line 440: FROM DUAL;

436: FOR J IN 1..p_line_adj_tbl.COUNT
437: LOOP
438: SELECT OE_PRICE_ADJUSTMENTS_S.nextval
439: INTO l_price_adjustment_id
440: FROM DUAL;
441:
442: l_line_adj_rec := p_line_adj_tbl(J);
443: l_Line_adj_rec.price_adjustment_id := l_price_adjustment_id;
444: l_Line_adj_rec.last_update_date := SYSDATE;

Line 595: -- Invoke lot Uom Conversion possibly if for DUAL line INVCONV

591: IF p_line_tbl(J).shipping_quantity_uom <> l_order_quantity_uom THEN
592:
593: /* --OPM 06/SEP/00 invoke process Uom Conversion for process line
594: --============================================================ */
595: -- Invoke lot Uom Conversion possibly if for DUAL line INVCONV
596:
597: IF oe_line_util.dual_uom_control
598: (l_inventory_item_id
599: ,l_ship_from_org_id

Line 597: IF oe_line_util.dual_uom_control

593: /* --OPM 06/SEP/00 invoke process Uom Conversion for process line
594: --============================================================ */
595: -- Invoke lot Uom Conversion possibly if for DUAL line INVCONV
596:
597: IF oe_line_util.dual_uom_control
598: (l_inventory_item_id
599: ,l_ship_from_org_id
600: ,l_item_rec) THEN
601:

Line 603: oe_debug_pub.add( 'DUAL ITEM - SHIPPING UPDATE ' , 1 ) ;

599: ,l_ship_from_org_id
600: ,l_item_rec) THEN
601:
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'DUAL ITEM - SHIPPING UPDATE ' , 1 ) ;
604: END IF;
605:
606: -- HW OPM BUG#:2415731 Since OM does not save lot and sublot information and shipping does,
607: -- we need to retrieve the information from wsh_delivery_details

Line 609: l_temp_dual_shipped_qty := 0;

605:
606: -- HW OPM BUG#:2415731 Since OM does not save lot and sublot information and shipping does,
607: -- we need to retrieve the information from wsh_delivery_details
608:
609: l_temp_dual_shipped_qty := 0;
610:
611: -- Fetch lot information from shipping table
612:
613: OPEN LOT_INFO(p_line_tbl(J).line_id);

Line 692: l_temp_dual_shipped_qty := l_temp_dual_shipped_qty + l_temp_shipped_quantity; -- INVCONV

688: ,NULL -- From uom name
689: ,NULL -- To uom name
690: );
691: -- BUG 2415731, sum the shipped_qty -- INVCONV
692: l_temp_dual_shipped_qty := l_temp_dual_shipped_qty + l_temp_shipped_quantity; -- INVCONV
693:
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'OPM , VALUE OF TEMP_DUAL_SHIPPED_QTY IS '||L_TEMP_DUAL_SHIPPED_QTY , 1 ) ; -- INVCONV
696: END IF;

Line 695: oe_debug_pub.add( 'OPM , VALUE OF TEMP_DUAL_SHIPPED_QTY IS '||L_TEMP_DUAL_SHIPPED_QTY , 1 ) ; -- INVCONV

691: -- BUG 2415731, sum the shipped_qty -- INVCONV
692: l_temp_dual_shipped_qty := l_temp_dual_shipped_qty + l_temp_shipped_quantity; -- INVCONV
693:
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'OPM , VALUE OF TEMP_DUAL_SHIPPED_QTY IS '||L_TEMP_DUAL_SHIPPED_QTY , 1 ) ; -- INVCONV
696: END IF;
697:
698: -- HW BUG#:2415731 Fetch the next record and close the cursor
699: FETCH LOT_INFO into LOT;

Line 704: l_temp_shipped_quantity := l_temp_dual_shipped_qty; --INVCONV

700: END LOOP;
701: << loop_end>>
702: CLOSE LOT_INFO;
703:
704: l_temp_shipped_quantity := l_temp_dual_shipped_qty; --INVCONV
705: -- HW end of changes for bug 2415731
706:
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'DUAL PROCESS SHIPPING UPDATE CONVERSION' || ' GIVES SHIPPED QUANTITY OF ' || L_TEMP_SHIPPED_QUANTITY , 1 ) ;

Line 708: oe_debug_pub.add( 'DUAL PROCESS SHIPPING UPDATE CONVERSION' || ' GIVES SHIPPED QUANTITY OF ' || L_TEMP_SHIPPED_QUANTITY , 1 ) ;

704: l_temp_shipped_quantity := l_temp_dual_shipped_qty; --INVCONV
705: -- HW end of changes for bug 2415731
706:
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'DUAL PROCESS SHIPPING UPDATE CONVERSION' || ' GIVES SHIPPED QUANTITY OF ' || L_TEMP_SHIPPED_QUANTITY , 1 ) ;
709: END IF;
710:
711: ELSE
712:

Line 724: END IF; --IF oe_line_util.dual_uom_control -- INVCONV

720: );
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'CONVERTED SHIPPED QUANTITY : '|| TO_CHAR ( L_TEMP_SHIPPED_QUANTITY ) , 1 ) ;
723: END IF;
724: END IF; --IF oe_line_util.dual_uom_control -- INVCONV
725:
726: --OPM 06/SEP/00 END
727:
728:

Line 851: FROM DUAL

847: IF l_make_remnant <> 'Y' THEN -- bug 4701487
848: l_count := 0;
849: BEGIN
850: SELECT 1 INTO l_count
851: FROM DUAL
852: WHERE EXISTS (
853: SELECT NULL
854: FROM oe_order_lines
855: WHERE top_model_line_id = l_top_model_line_id

Line 1506: --,x_dual_item OUT NOCOPY VARCHAR2) INVCONV

1502: PROCEDURE Validate_Quantity
1503: ( p_ship_line_rec IN OUT NOCOPY Ship_Line_Rec_Type
1504: ,p_handle_req_qty IN VARCHAR2 := 'N'
1505: ,p_index IN NUMBER )
1506: --,x_dual_item OUT NOCOPY VARCHAR2) INVCONV
1507: IS
1508: l_item_rec OE_ORDER_CACHE.item_rec_type;
1509: l_return_status VARCHAR2(1);
1510: l_primary_quantity NUMBER;

Line 1536: /* IF OE_Line_Util.dual_uom_control -- INVCONV RENAME PROCess_Characteristics INVCONV NO LONGER NEEDED

1532: ELSE
1533: l_primary_quantity := p_ship_line_rec.shipping_quantity(p_index);
1534: END IF;
1535:
1536: /* IF OE_Line_Util.dual_uom_control -- INVCONV RENAME PROCess_Characteristics INVCONV NO LONGER NEEDED
1537: (p_inventory_item_id => p_ship_line_rec.inventory_item_id(p_index)
1538: ,p_ship_from_org_id => p_ship_line_rec.ship_from_org_id(p_index)
1539: ,x_item_rec => l_item_rec) THEN
1540:

Line 1542: oe_debug_pub.add( 'DUAL PROCESS SHIPPING UPDATE ', 5); -- INVCONV

1538: ,p_ship_from_org_id => p_ship_line_rec.ship_from_org_id(p_index)
1539: ,x_item_rec => l_item_rec) THEN
1540:
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add( 'DUAL PROCESS SHIPPING UPDATE ', 5); -- INVCONV
1543: END IF;
1544:
1545: x_dual_item := 'Y'; -- INVCONV
1546:

Line 1545: x_dual_item := 'Y'; -- INVCONV

1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add( 'DUAL PROCESS SHIPPING UPDATE ', 5); -- INVCONV
1543: END IF;
1544:
1545: x_dual_item := 'Y'; -- INVCONV
1546:
1547: p_ship_line_rec.shipped_quantity(p_index) :=
1548: GMI_Reservation_Util.get_opm_converted_qty
1549: (p_apps_item_id => p_ship_line_rec.inventory_item_id(p_index),

Line 1708: -- ,x_dual_item => l_return_status); -- INVCONV

1704: Validate_Quantity
1705: ( p_ship_line_rec => p_requested_line_rec
1706: ,p_handle_req_qty => 'Y'
1707: ,p_index => I );
1708: -- ,x_dual_item => l_return_status); -- INVCONV
1709:
1710: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1711:
1712: --J := J + 1; bug 4422886

Line 2047: ('DUAL 3RD CONVERSION 1 '||l_line_tbl(1).ORDERED_QUANTITY2,1);

2043:
2044: oe_debug_pub.add('PAL here 5 index is '|| p_index, 3);
2045: IF l_debug_level > 0 THEN
2046: oe_debug_pub.add
2047: ('DUAL 3RD CONVERSION 1 '||l_line_tbl(1).ORDERED_QUANTITY2,1);
2048: END IF;
2049:
2050: ELSE -- order uom = order uom 2
2051: oe_debug_pub.add('PAL here 6 index is '|| p_index, 3);

Line 2658: FROM DUAL

2654: IF l_make_remnant <> 'Y' THEN -- bug 4701487
2655: l_count := 0;
2656: BEGIN
2657: SELECT 1 INTO l_count
2658: FROM DUAL
2659: WHERE EXISTS (
2660: SELECT NULL
2661: FROM oe_order_lines
2662: WHERE top_model_line_id = p_top_model_line_id

Line 3769: -- ,x_dual_item => l_varchar1); -- INVCONV

3765:
3766: Validate_Quantity
3767: ( p_ship_line_rec => p_ship_line_rec
3768: ,p_index => I );
3769: -- ,x_dual_item => l_varchar1); -- INVCONV
3770:
3771: /* IF l_debug_level > 0 THEN INVCONV WHOLE IF l_varchar1 = 'Y' THEN NOT USED.
3772: Oe_Debug_pub.Add('after Validate_Quantity '|| l_varchar1, 3);
3773: END IF;