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 1558: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;

1554: , x_return_status OUT NOCOPY VARCHAR2
1555:
1556: )
1557: IS
1558: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
1559: --
1560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1561: --
1562: BEGIN

Line 1652: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

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

Line 1657: l_line_rec OE_Order_Pub.Line_Rec_Type;

1653: ,p_shipped_quantity IN NUMBER DEFAULT 0
1654: ,x_result_out OUT NOCOPY VARCHAR2 )
1655: IS
1656: l_line_id NUMBER;
1657: l_line_rec OE_Order_Pub.Line_Rec_Type;
1658: l_msg_count NUMBER;
1659: l_msg_data VARCHAR2(2000);
1660: l_ordered_quantity NUMBER := 0;
1661: l_shipped_quantity NUMBER := 0;

Line 2099: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

2095: ---------------------------------------------------------------------*/
2096: PROCEDURE Get_PTO_Shipped_Quantity
2097: (
2098: p_top_model_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
2099: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2100: , x_ratio_status OUT NOCOPY VARCHAR2
2101:
2102: , x_return_status OUT NOCOPY VARCHAR2
2103:

Line 2107: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2103:
2104: )
2105: IS
2106: l_pto_shipment_tbl Shipment_Tbl_Type;
2107: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2108: l_line_index NUMBER;
2109: l_pto_index NUMBER :=0;
2110: l_top_index NUMBER :=0;
2111: l_final_index NUMBER :=0;

Line 2505: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2501: ( p_top_model_line_id IN NUMBER
2502: ,x_return_status OUT NOCOPY VARCHAR2)
2503:
2504: IS
2505: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2506: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2507: l_split_index NUMBER :=0;
2508: l_pto_index NUMBER;
2509: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;

Line 2506: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2502: ,x_return_status OUT NOCOPY VARCHAR2)
2503:
2504: IS
2505: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2506: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2507: l_split_index NUMBER :=0;
2508: l_pto_index NUMBER;
2509: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2510: l_ship_tolerance_below NUMBER;

Line 2524: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2520: l_activity_result VARCHAR2(30);
2521: l_activity_id NUMBER;
2522: l_fulfillment_activity VARCHAR2(30);
2523: l_item_key VARCHAR2(240);
2524: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2525: l_fulfill_index NUMBER := 0 ;
2526: l_fulfillment_set_flag VARCHAR2(1);
2527:
2528: -- Variables to call process order to update the shipped quantity for

Line 2531: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2527:
2528: -- Variables to call process order to update the shipped quantity for
2529: -- non shippable lines.
2530: l_upd_tbl_index NUMBER := 0;
2531: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2532: l_control_rec OE_GLOBALS.Control_Rec_Type;
2533: l_top_model_index NUMBER;
2534: l_ato_line_index NUMBER := 0;
2535: l_set_recursion VARCHAR2(1) := 'N';

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

2753: END IF;
2754: -- Assign the second record of the table for process order for
2755: -- create of new line.
2756:
2757: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
2758: l_split_line_tbl(2).split_from_line_id
2759: := l_line_tbl(l_top_model_index).line_id;
2760: l_split_line_tbl(2).ordered_quantity
2761: := l_line_tbl(l_top_model_index).ordered_quantity -

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

3109: IF l_fulfillment_activity = 'NO_ACTIVITY' OR
3110: l_fulfillment_activity = 'SHIP_LINE' THEN
3111:
3112: l_fulfill_index := l_fulfill_index + 1;
3113: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
3114: l_fulfill_tbl(l_fulfill_index).line_id
3115: := l_split_line_tbl(l_split_index).line_id;
3116: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
3117: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;

Line 3297: ,p_line_rec IN OE_ORDER_PUB.line_rec_type

3293:
3294: /*--------------------------------------------------------------*/
3295: PROCEDURE Ship_Confirm_Standard_Line
3296: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3297: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3298: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3299: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3300: ,p_check_line_set IN VARCHAR2 := 'Y'
3301: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3298: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC

3294: /*--------------------------------------------------------------*/
3295: PROCEDURE Ship_Confirm_Standard_Line
3296: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3297: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3298: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3299: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3300: ,p_check_line_set IN VARCHAR2 := 'Y'
3301: ,x_return_status OUT NOCOPY VARCHAR2)
3302:

Line 3304: l_line_rec OE_ORDER_PUB.line_rec_type;

3300: ,p_check_line_set IN VARCHAR2 := 'Y'
3301: ,x_return_status OUT NOCOPY VARCHAR2)
3302:
3303: IS
3304: l_line_rec OE_ORDER_PUB.line_rec_type;
3305: l_shipped_quantity NUMBER;
3306: l_x_result_out VARCHAR2(30);
3307: l_return_status VARCHAR2(1);
3308: l_msg_count NUMBER;

Line 3312: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3308: l_msg_count NUMBER;
3309: l_msg_data VARCHAR2(2000);
3310: l_unreserve_quantity NUMBER;
3311: l_result_code VARCHAR2(30);
3312: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3313: l_control_rec OE_GLOBALS.Control_Rec_Type;
3314: l_set_recursion VARCHAR2(1) := 'N';
3315:
3316: -- HW 2415731 variables for OPM

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

3573:
3574: -- Assign the second record of the table for process order for
3575: -- create of new line.
3576:
3577: l_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
3578: l_line_tbl(2).split_from_line_id := l_line_rec.line_id;
3579:
3580: -- HW BUG#: 2415731.
3581:

Line 3987: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

3983: ,x_return_status OUT NOCOPY VARCHAR2)
3984: IS
3985: l_line_id NUMBER;
3986: l_return_status VARCHAR2(1);
3987: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
3988: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3989: l_control_rec OE_GLOBALS.Control_Rec_Type;
3990: l_set_recursion VARCHAR2(1) := 'N';
3991: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3988: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3984: IS
3985: l_line_id NUMBER;
3986: l_return_status VARCHAR2(1);
3987: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
3988: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3989: l_control_rec OE_GLOBALS.Control_Rec_Type;
3990: l_set_recursion VARCHAR2(1) := 'N';
3991: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3992: l_result_out VARCHAR2(30);

Line 3991: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3987: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
3988: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3989: l_control_rec OE_GLOBALS.Control_Rec_Type;
3990: l_set_recursion VARCHAR2(1) := 'N';
3991: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3992: l_result_out VARCHAR2(30);
3993: --
3994: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3995: --

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

4080:
4081: -- Assign the second record of the table for process order for
4082: -- create of new line.
4083:
4084: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
4085: l_split_line_tbl(2).split_from_line_id := l_update_line_tbl(1).line_id;
4086: l_split_line_tbl(2).ordered_quantity :=
4087: l_line_rec.ordered_quantity - l_line_rec.shipped_quantity;
4088: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;

Line 4216: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

4212: , x_return_status OUT NOCOPY VARCHAR2
4213:
4214: )
4215: IS
4216: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4217: l_line_index NUMBER;
4218: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4219: l_process_index NUMBER := 0;
4220: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 4218: l_process_tbl OE_Order_Pub.Line_Tbl_Type;

4214: )
4215: IS
4216: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4217: l_line_index NUMBER;
4218: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4219: l_process_index NUMBER := 0;
4220: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4221: l_set_index NUMBER := 0;
4222: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 4220: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;

4216: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4217: l_line_index NUMBER;
4218: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4219: l_process_index NUMBER := 0;
4220: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4221: l_set_index NUMBER := 0;
4222: l_control_rec OE_GLOBALS.Control_Rec_Type;
4223: l_line_shipped VARCHAR2(1) := FND_API.G_FALSE;
4224: l_return_status VARCHAR2(1);

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

4397: IF l_debug_level > 0 THEN
4398: oe_debug_pub.add( 'SHIP SET IS PARTIALLY SHIPPED REMOVING THE SETID '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4399: END IF;
4400: l_set_index := l_set_index + 1;
4401: l_set_tbl(l_set_index) := OE_Order_Pub.G_MISS_LINE_REC;
4402: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
4403: l_set_tbl(l_set_index).line_id := l_process_tbl(l_process_index).top_model_line_id;
4404: ELSE
4405: l_set_tbl(l_set_index).line_id := l_process_tbl(l_process_index).line_id;

Line 4527: l_line_rec OE_ORDER_PUB.line_rec_type;

4523: , x_return_status OUT NOCOPY VARCHAR2
4524:
4525: )
4526: IS
4527: l_line_rec OE_ORDER_PUB.line_rec_type;
4528: l_line_id NUMBER;
4529: l_ordered_quantity NUMBER;
4530: l_shipped_quantity NUMBER;
4531: l_x_return_status VARCHAR2(1);

Line 5374: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

5370: ,p_top_model_line_id IN NUMBER
5371: ,x_return_status OUT NOCOPY VARCHAR2)
5372:
5373: IS
5374: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5375: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5376: l_update_lines_index NUMBER := 0;
5377: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;
5378: l_activity_status_code VARCHAR2(8);

Line 5375: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;

5371: ,x_return_status OUT NOCOPY VARCHAR2)
5372:
5373: IS
5374: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5375: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5376: l_update_lines_index NUMBER := 0;
5377: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;
5378: l_activity_status_code VARCHAR2(8);
5379: l_dummy VARCHAR2(52);

Line 5695: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5691:
5692: alcoa bug 2605086 - closing lines in line set
5693: --------------------------------------------------------------*/
5694: PROCEDURE Ship_Confirm_Split_Lines
5695: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5696: ,p_shipment_status IN VARCHAR2)
5697: IS
5698: l_line_set_rec OE_ORDER_PUB.line_rec_type;
5699: l_return_status VARCHAR2(1);

Line 5698: l_line_set_rec OE_ORDER_PUB.line_rec_type;

5694: PROCEDURE Ship_Confirm_Split_Lines
5695: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5696: ,p_shipment_status IN VARCHAR2)
5697: IS
5698: l_line_set_rec OE_ORDER_PUB.line_rec_type;
5699: l_return_status VARCHAR2(1);
5700: l_count NUMBER;
5701:
5702: CURSOR split_lines IS

Line 5850: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5846: needed - it will take more local variable declarations and copy of
5847: tables.
5848: --------------------------------------------------------------*/
5849: PROCEDURE Call_Notification_Framework
5850: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5851: ,p_caller IN VARCHAR2
5852: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5853: IS
5854: --

Line 5859: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

5855: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5856: --
5857: I NUMBER := 1;
5858: J NUMBER;
5859: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5860: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
5861:
5862:
5863: BEGIN

Line 5860: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

5856: --
5857: I NUMBER := 1;
5858: J NUMBER;
5859: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5860: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
5861:
5862:
5863: BEGIN
5864: