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_SHIPPING_INTEGRATION_PVT dependencies on OE_ORDER_PUB

Line 19: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

15: Forward Declarations
16: ----------------------------------------------------------------*/
17:
18: PROCEDURE Ship_Confirm_Split_Lines
19: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
20: ,p_shipment_status IN VARCHAR2);
21:
22:
23: PROCEDURE Call_Notification_Framework

Line 24: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

20: ,p_shipment_status IN VARCHAR2);
21:
22:
23: PROCEDURE Call_Notification_Framework
24: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
25: ,p_caller IN VARCHAR2
26: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
27:
28: PROCEDURE Print_Time(p_msg IN VARCHAR2);

Line 156: (p_line_tbl IN OE_Order_PUB.Line_Tbl_Type

152: /*---------------------------------------------------------------
153: PROCEDURE Call_Process_Order
154: ----------------------------------------------------------------*/
155: PROCEDURE Call_Process_Order
156: (p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
157: ,p_control_rec IN OE_GLOBALS.Control_Rec_Type DEFAULT OE_GLOBALS.G_MISS_CONTROL_REC
158: ,p_process_requests IN BOOLEAN := FALSE
159: ,x_return_status OUT NOCOPY VARCHAR2
160:

Line 163: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

159: ,x_return_status OUT NOCOPY VARCHAR2
160:
161: )
162: IS
163: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
164: l_control_rec OE_GLOBALS.Control_Rec_Type;
165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

161: )
162: IS
163: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
164: l_control_rec OE_GLOBALS.Control_Rec_Type;
165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

162: IS
163: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
164: l_control_rec OE_GLOBALS.Control_Rec_Type;
165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

163: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
164: l_control_rec OE_GLOBALS.Control_Rec_Type;
165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

164: l_control_rec OE_GLOBALS.Control_Rec_Type;
165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

169: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

170: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
178: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

171: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
178: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
179: l_return_status VARCHAR2(1);

Line 176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

172: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
178: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
179: l_return_status VARCHAR2(1);
180: l_msg_count NUMBER;

Line 177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

173: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
178: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
179: l_return_status VARCHAR2(1);
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(2000);

Line 178: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

174: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
175: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
176: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
177: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
178: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
179: l_return_status VARCHAR2(1);
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(2000);
182: --serla begin

Line 183: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

179: l_return_status VARCHAR2(1);
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(2000);
182: --serla begin
183: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
184: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
185: --serla end
186: --
187: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 184: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(2000);
182: --serla begin
183: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
184: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
185: --serla end
186: --
187: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
188: --

Line 301: ( p_update_lines_tbl IN OE_ORDER_PUB.Request_Tbl_Type

297: U : update
298: -----------------------------------------------------------------*/
299:
300: PROCEDURE Update_Shipping_From_OE
301: ( p_update_lines_tbl IN OE_ORDER_PUB.Request_Tbl_Type
302: ,x_return_status OUT NOCOPY VARCHAR2)
303: IS
304: l_shp_index NUMBER :=0;
305: l_line_index NUMBER :=0;

Line 307: l_line_rec OE_Order_Pub.line_rec_type;

303: IS
304: l_shp_index NUMBER :=0;
305: l_line_index NUMBER :=0;
306: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
307: l_line_rec OE_Order_Pub.line_rec_type;
308: l_line_id NUMBER;
309: l_return_status VARCHAR2(1);
310: l_line_at_shipping VARCHAR2(1) := FND_API.G_FALSE;
311: l_result_out VARCHAR2(30);

Line 319: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

315: l_x_result_out VARCHAR2(30);
316: l_result_code VARCHAR2(30);
317: l_error_msg VARCHAR2(240);
318: l_msg_index NUMBER;
319: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
320: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
321: l_line_number VARCHAR2(150);
322: l_index NUMBER;
323: l_shipping_interfaced_flag VARCHAR2(1);

Line 320: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

316: l_result_code VARCHAR2(30);
317: l_error_msg VARCHAR2(240);
318: l_msg_index NUMBER;
319: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
320: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
321: l_line_number VARCHAR2(150);
322: l_index NUMBER;
323: l_shipping_interfaced_flag VARCHAR2(1);
324: -- odaboval : Begin of OPM Changes

Line 1562: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;

1558: , x_return_status OUT NOCOPY VARCHAR2
1559:
1560: )
1561: IS
1562: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
1563: --
1564: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1565: --
1566: BEGIN

Line 1656: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1652: If line id is not passed the ordered and shipped quantity must be passed
1653: in order to do the check for shipment.
1654: --------------------------------------------------------------------*/
1655: PROCEDURE Check_Shipment_Line --INVCONV PAL OPEN ISSUE
1656: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1657: ,p_shipped_quantity IN NUMBER DEFAULT 0
1658: ,x_result_out OUT NOCOPY VARCHAR2 )
1659: IS
1660: l_line_id NUMBER;

Line 1661: l_line_rec OE_Order_Pub.Line_Rec_Type;

1657: ,p_shipped_quantity IN NUMBER DEFAULT 0
1658: ,x_result_out OUT NOCOPY VARCHAR2 )
1659: IS
1660: l_line_id NUMBER;
1661: l_line_rec OE_Order_Pub.Line_Rec_Type;
1662: l_msg_count NUMBER;
1663: l_msg_data VARCHAR2(2000);
1664: l_ordered_quantity NUMBER := 0;
1665: l_shipped_quantity NUMBER := 0;

Line 2103: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

2099: ---------------------------------------------------------------------*/
2100: PROCEDURE Get_PTO_Shipped_Quantity
2101: (
2102: p_top_model_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
2103: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2104: , x_ratio_status OUT NOCOPY VARCHAR2
2105:
2106: , x_return_status OUT NOCOPY VARCHAR2
2107:

Line 2111: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2107:
2108: )
2109: IS
2110: l_pto_shipment_tbl Shipment_Tbl_Type;
2111: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2112: l_line_index NUMBER;
2113: l_pto_index NUMBER :=0;
2114: l_top_index NUMBER :=0;
2115: l_final_index NUMBER :=0;

Line 2517: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2513: ( p_top_model_line_id IN NUMBER
2514: ,x_return_status OUT NOCOPY VARCHAR2)
2515:
2516: IS
2517: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2518: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2519: l_split_index NUMBER :=0;
2520: l_pto_index NUMBER;
2521: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;

Line 2518: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2514: ,x_return_status OUT NOCOPY VARCHAR2)
2515:
2516: IS
2517: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2518: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2519: l_split_index NUMBER :=0;
2520: l_pto_index NUMBER;
2521: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2522: l_ship_tolerance_below NUMBER;

Line 2536: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2532: l_activity_result VARCHAR2(30);
2533: l_activity_id NUMBER;
2534: l_fulfillment_activity VARCHAR2(30);
2535: l_item_key VARCHAR2(240);
2536: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2537: l_fulfill_index NUMBER := 0 ;
2538: l_fulfillment_set_flag VARCHAR2(1);
2539:
2540: -- Variables to call process order to update the shipped quantity for

Line 2543: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2539:
2540: -- Variables to call process order to update the shipped quantity for
2541: -- non shippable lines.
2542: l_upd_tbl_index NUMBER := 0;
2543: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2544: l_control_rec OE_GLOBALS.Control_Rec_Type;
2545: l_top_model_index NUMBER;
2546: l_ato_line_index NUMBER := 0;
2547: l_set_recursion VARCHAR2(1) := 'N';

Line 2769: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;

2765: END IF;
2766: -- Assign the second record of the table for process order for
2767: -- create of new line.
2768:
2769: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
2770: l_split_line_tbl(2).split_from_line_id
2771: := l_line_tbl(l_top_model_index).line_id;
2772: l_split_line_tbl(2).ordered_quantity
2773: := l_line_tbl(l_top_model_index).ordered_quantity -

Line 3125: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

3121: IF l_fulfillment_activity = 'NO_ACTIVITY' OR
3122: l_fulfillment_activity = 'SHIP_LINE' THEN
3123:
3124: l_fulfill_index := l_fulfill_index + 1;
3125: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
3126: l_fulfill_tbl(l_fulfill_index).line_id
3127: := l_split_line_tbl(l_split_index).line_id;
3128: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
3129: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;

Line 3309: ,p_line_rec IN OE_ORDER_PUB.line_rec_type

3305:
3306: /*--------------------------------------------------------------*/
3307: PROCEDURE Ship_Confirm_Standard_Line
3308: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3309: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3310: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3311: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3312: ,p_check_line_set IN VARCHAR2 := 'Y'
3313: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3310: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC

3306: /*--------------------------------------------------------------*/
3307: PROCEDURE Ship_Confirm_Standard_Line
3308: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3309: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3310: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3311: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3312: ,p_check_line_set IN VARCHAR2 := 'Y'
3313: ,x_return_status OUT NOCOPY VARCHAR2)
3314:

Line 3316: l_line_rec OE_ORDER_PUB.line_rec_type;

3312: ,p_check_line_set IN VARCHAR2 := 'Y'
3313: ,x_return_status OUT NOCOPY VARCHAR2)
3314:
3315: IS
3316: l_line_rec OE_ORDER_PUB.line_rec_type;
3317: l_shipped_quantity NUMBER;
3318: l_x_result_out VARCHAR2(30);
3319: l_return_status VARCHAR2(1);
3320: l_msg_count NUMBER;

Line 3324: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3320: l_msg_count NUMBER;
3321: l_msg_data VARCHAR2(2000);
3322: l_unreserve_quantity NUMBER;
3323: l_result_code VARCHAR2(30);
3324: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3325: l_control_rec OE_GLOBALS.Control_Rec_Type;
3326: l_set_recursion VARCHAR2(1) := 'N';
3327:
3328: -- HW 2415731 variables for OPM

Line 3589: l_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;

3585:
3586: -- Assign the second record of the table for process order for
3587: -- create of new line.
3588:
3589: l_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
3590: l_line_tbl(2).split_from_line_id := l_line_rec.line_id;
3591:
3592: -- HW BUG#: 2415731.
3593:

Line 3999: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

3995: ,x_return_status OUT NOCOPY VARCHAR2)
3996: IS
3997: l_line_id NUMBER;
3998: l_return_status VARCHAR2(1);
3999: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4000: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4001: l_control_rec OE_GLOBALS.Control_Rec_Type;
4002: l_set_recursion VARCHAR2(1) := 'N';
4003: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 4000: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3996: IS
3997: l_line_id NUMBER;
3998: l_return_status VARCHAR2(1);
3999: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4000: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4001: l_control_rec OE_GLOBALS.Control_Rec_Type;
4002: l_set_recursion VARCHAR2(1) := 'N';
4003: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4004: l_result_out VARCHAR2(30);

Line 4003: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3999: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4000: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4001: l_control_rec OE_GLOBALS.Control_Rec_Type;
4002: l_set_recursion VARCHAR2(1) := 'N';
4003: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4004: l_result_out VARCHAR2(30);
4005: --
4006: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4007: --

Line 4096: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;

4092:
4093: -- Assign the second record of the table for process order for
4094: -- create of new line.
4095:
4096: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
4097: l_split_line_tbl(2).split_from_line_id := l_update_line_tbl(1).line_id;
4098: l_split_line_tbl(2).ordered_quantity :=
4099: l_line_rec.ordered_quantity - l_line_rec.shipped_quantity;
4100: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;

Line 4230: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

4226: , x_return_status OUT NOCOPY VARCHAR2
4227:
4228: )
4229: IS
4230: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4231: l_line_index NUMBER;
4232: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4233: l_process_index NUMBER := 0;
4234: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 4232: l_process_tbl OE_Order_Pub.Line_Tbl_Type;

4228: )
4229: IS
4230: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4231: l_line_index NUMBER;
4232: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4233: l_process_index NUMBER := 0;
4234: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4235: l_set_index NUMBER := 0;
4236: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 4234: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

4230: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4231: l_line_index NUMBER;
4232: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4233: l_process_index NUMBER := 0;
4234: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4235: l_set_index NUMBER := 0;
4236: l_control_rec OE_GLOBALS.Control_Rec_Type;
4237: l_line_shipped VARCHAR2(1) := FND_API.G_FALSE;
4238: l_return_status VARCHAR2(1);

Line 4416: l_set_tbl(l_set_index) := OE_Order_Pub.G_MISS_LINE_REC;

4412: IF l_debug_level > 0 THEN
4413: oe_debug_pub.add( 'SHIP SET IS PARTIALLY SHIPPED REMOVING THE SETID '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4414: END IF;
4415: l_set_index := l_set_index + 1;
4416: l_set_tbl(l_set_index) := OE_Order_Pub.G_MISS_LINE_REC;
4417: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
4418: l_set_tbl(l_set_index).line_id := l_process_tbl(l_process_index).top_model_line_id;
4419: ELSE
4420: l_set_tbl(l_set_index).line_id := l_process_tbl(l_process_index).line_id;

Line 4543: l_line_rec OE_ORDER_PUB.line_rec_type;

4539: , x_return_status OUT NOCOPY VARCHAR2
4540:
4541: )
4542: IS
4543: l_line_rec OE_ORDER_PUB.line_rec_type;
4544: l_line_id NUMBER;
4545: l_ordered_quantity NUMBER;
4546: l_shipped_quantity NUMBER;
4547: l_x_return_status VARCHAR2(1);

Line 5394: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

5390: ,p_top_model_line_id IN NUMBER
5391: ,x_return_status OUT NOCOPY VARCHAR2)
5392:
5393: IS
5394: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5395: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5396: l_update_lines_index NUMBER := 0;
5397: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;
5398: l_activity_status_code VARCHAR2(8);

Line 5395: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;

5391: ,x_return_status OUT NOCOPY VARCHAR2)
5392:
5393: IS
5394: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5395: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5396: l_update_lines_index NUMBER := 0;
5397: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;
5398: l_activity_status_code VARCHAR2(8);
5399: l_dummy VARCHAR2(52);

Line 5720: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5716:
5717: alcoa bug 2605086 - closing lines in line set
5718: --------------------------------------------------------------*/
5719: PROCEDURE Ship_Confirm_Split_Lines
5720: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5721: ,p_shipment_status IN VARCHAR2)
5722: IS
5723: l_line_set_rec OE_ORDER_PUB.line_rec_type;
5724: l_return_status VARCHAR2(1);

Line 5723: l_line_set_rec OE_ORDER_PUB.line_rec_type;

5719: PROCEDURE Ship_Confirm_Split_Lines
5720: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5721: ,p_shipment_status IN VARCHAR2)
5722: IS
5723: l_line_set_rec OE_ORDER_PUB.line_rec_type;
5724: l_return_status VARCHAR2(1);
5725: l_count NUMBER;
5726:
5727: CURSOR split_lines IS

Line 5875: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5871: needed - it will take more local variable declarations and copy of
5872: tables.
5873: --------------------------------------------------------------*/
5874: PROCEDURE Call_Notification_Framework
5875: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5876: ,p_caller IN VARCHAR2
5877: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5878: IS
5879: --

Line 5884: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

5880: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5881: --
5882: I NUMBER := 1;
5883: J NUMBER;
5884: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5885: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
5886:
5887:
5888: BEGIN

Line 5885: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

5881: --
5882: I NUMBER := 1;
5883: J NUMBER;
5884: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5885: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
5886:
5887:
5888: BEGIN
5889: