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

Line 314: l_model_line_rec OE_ORDER_PUB.line_rec_type;

310: x_return_status OUT NOCOPY VARCHAR2
311:
312: )
313: IS
314: l_model_line_rec OE_ORDER_PUB.line_rec_type;
315: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
316: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
317: l_ship_set VARCHAR2(30);
318: lTableName VARCHAR2(30);

Line 859: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

855: Description : This API calls Inventory's APIs to reserve.
856: --------------------------------------------------------------------- */
857:
858: Procedure Reserve_line
859: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
860: ,p_quantity_to_reserve IN NUMBER
861: ,p_quantity2_to_reserve IN NUMBER DEFAULT NULL -- INVCONV
862: ,p_rsv_update IN BOOLEAN DEFAULT FALSE
863: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1118: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1114: is satisfied.
1115: --------------------------------------------------------------------- */
1116:
1117: Procedure Unreserve_Line
1118: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1119: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 6628134
1120: ,p_quantity_to_unreserve IN NUMBER
1121: ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL -- INVCONV
1122: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1432: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,

1428: Other wise log a schedule or reschedule delayed request.
1429:
1430: -------------------------------------------------------------------------*/
1431: Procedure Log_Set_Request
1432: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
1433: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type,
1434: p_sch_action IN VARCHAR2,
1435: p_caller IN VARCHAR2,
1436: x_return_status OUT NOCOPY VARCHAR2)

Line 1433: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type,

1429:
1430: -------------------------------------------------------------------------*/
1431: Procedure Log_Set_Request
1432: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
1433: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type,
1434: p_sch_action IN VARCHAR2,
1435: p_caller IN VARCHAR2,
1436: x_return_status OUT NOCOPY VARCHAR2)
1437:

Line 2130: ( p_line_rec IN Oe_Order_Pub.line_rec_type

2126: ----------------------------------------------------------------------------- */
2127:
2128:
2129: FUNCTION Schedule_Attribute_Changed
2130: ( p_line_rec IN Oe_Order_Pub.line_rec_type
2131: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
2132: RETURN BOOLEAN
2133: IS
2134: --

Line 2131: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)

2127:
2128:
2129: FUNCTION Schedule_Attribute_Changed
2130: ( p_line_rec IN Oe_Order_Pub.line_rec_type
2131: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
2132: RETURN BOOLEAN
2133: IS
2134: --
2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2242: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type

2238: fields - schedule_ship_date, schedule_arrival_date,
2239: visible_demand_flag, and schedule_status_code.
2240: ------------------------------------------------------------------------*/
2241: PROCEDURE Inactive_Demand_Scheduling
2242: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
2243: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
2244: , p_sch_action IN VARCHAR2 := NULL
2245: , x_return_status OUT NOCOPY VARCHAR2
2246:

Line 2243: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

2239: visible_demand_flag, and schedule_status_code.
2240: ------------------------------------------------------------------------*/
2241: PROCEDURE Inactive_Demand_Scheduling
2242: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
2243: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
2244: , p_sch_action IN VARCHAR2 := NULL
2245: , x_return_status OUT NOCOPY VARCHAR2
2246:
2247: ) IS

Line 2598: PROCEDURE check_split_needed(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

2594: /*
2595: Scheduling Enhancements ER 2736896
2596: Checks whether a split is needed based on the MRP record returned
2597: */
2598: PROCEDURE check_split_needed(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
2599: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
2600: p_index IN NUMBER,
2601: p_split_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type,
2602: p_line_action IN VARCHAR2,

Line 2601: p_split_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type,

2597: */
2598: PROCEDURE check_split_needed(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
2599: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
2600: p_index IN NUMBER,
2601: p_split_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type,
2602: p_line_action IN VARCHAR2,
2603: p_config_exists IN VARCHAR2,
2604: p_om_auto_split IN VARCHAR2,
2605: p_order_date_type_code IN VARCHAR2,

Line 2610: l_bckup_request_tbl OE_Order_PUB.Request_Tbl_Type;

2606: x_return_status OUT NOCOPY VARCHAR2
2607: )
2608: IS
2609:
2610: l_bckup_request_tbl OE_Order_PUB.Request_Tbl_Type;
2611: l_atp_tbl OE_ATP.atp_tbl_type;
2612: l_sch_recursion VARCHAR2(30);
2613:
2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2610: l_bckup_request_tbl OE_Order_PUB.Request_Tbl_Type;
2611: l_atp_tbl OE_ATP.atp_tbl_type;
2612: l_sch_recursion VARCHAR2(30);
2613:
2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2616: l_control_rec OE_GLOBALS.Control_Rec_Type;
2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2611: l_atp_tbl OE_ATP.atp_tbl_type;
2612: l_sch_recursion VARCHAR2(30);
2613:
2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2616: l_control_rec OE_GLOBALS.Control_Rec_Type;
2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

2613:
2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2616: l_control_rec OE_GLOBALS.Control_Rec_Type;
2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2616: l_control_rec OE_GLOBALS.Control_Rec_Type;
2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2616: l_control_rec OE_GLOBALS.Control_Rec_Type;
2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2616: l_control_rec OE_GLOBALS.Control_Rec_Type;
2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2617: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2618: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

2619: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

2620: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

2621: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

2622: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

2623: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2631: l_msg_count NUMBER;

Line 2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

2624: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2631: l_msg_count NUMBER;
2632: l_msg_data VARCHAR2(2000);

Line 2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

2625: l_header_adj_assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2631: l_msg_count NUMBER;
2632: l_msg_data VARCHAR2(2000);
2633: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2626: l_header_adj_att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2627: l_line_price_att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2628: l_line_adj_assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2631: l_msg_count NUMBER;
2632: l_msg_data VARCHAR2(2000);
2633: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2634: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2633: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2629: l_line_adj_att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2631: l_msg_count NUMBER;
2632: l_msg_data VARCHAR2(2000);
2633: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2634: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2635:
2636: l_service_exists varchar2(30);
2637:

Line 2634: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2630: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2631: l_msg_count NUMBER;
2632: l_msg_data VARCHAR2(2000);
2633: l_header_payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2634: l_line_payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2635:
2636: l_service_exists varchar2(30);
2637:
2638: l_substitute_flag BOOLEAN := FALSE;

Line 2752: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

2748: ,x_return_status => l_return_status);
2749:
2750: END IF;
2751:
2752: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
2753: l_split_line_tbl(1).line_id := p_x_line_rec.line_id;
2754: --l_split_line_tbl(1).line_set_id := l_line_set_id;
2755:
2756: --check if UOM has changed in ATP

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

2796:
2797: l_split_line_tbl(1).split_action_code := 'SPLIT';
2798: l_split_line_tbl(1).split_by := 'USER';
2799:
2800: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
2801: l_split_line_tbl(2).ordered_quantity := p_x_line_rec.ordered_quantity - l_split_line_tbl(1).ordered_quantity ;
2802: IF p_x_line_rec.ordered_quantity2 is not null
2803: AND p_x_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM
2804: THEN

Line 2883: l_update_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

2879: oe_debug_pub.add( 'check_split_needed() l_split_line_tbl(2) : SAD ' || l_split_line_tbl(2).schedule_arrival_date , 1 ) ;
2880: END IF;
2881:
2882: --Call PO API to schedule the split line 2 with correct SSD/SAD
2883: l_update_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
2884: l_update_line_tbl(1).line_id := l_split_line_tbl(2).line_id;
2885: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
2886: l_update_line_tbl(1).change_reason := 'SYSTEM';
2887: l_update_line_tbl(1).ship_from_org_id := Nvl(p_x_line_rec.ship_from_org_id, p_atp_rec.source_organization_id(J));

Line 3009: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

3005: ,p_item_id => p_atp_rec.inventory_item_id(J)
3006: ,p_schedule_action_code => OESCH_ACT_UNSCHEDULE
3007: ,x_return_status => l_return_status);
3008:
3009: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
3010: l_split_line_tbl(1).line_id := p_x_line_rec.line_id;
3011: --check if UOM has changed in ATP
3012: IF p_x_line_rec.order_quantity_uom <> p_atp_rec.quantity_uom(J) THEN
3013: IF l_debug_level > 0 THEN

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

3043: ELSE
3044: l_split_line_tbl(1).schedule_arrival_date := p_atp_rec.requested_arrival_date(J);
3045: END IF;
3046:
3047: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
3048: l_split_line_tbl(2) := p_x_line_rec;
3049: l_split_line_tbl(2).line_id := FND_API.G_MISS_NUM;
3050: l_split_line_tbl(2).split_from_line_id := p_x_line_rec.line_id;
3051: l_split_line_tbl(2).ordered_quantity := p_x_line_rec.ordered_quantity - l_split_line_tbl(1).ordered_quantity ;

Line 3208: l_update_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

3204: END IF;
3205:
3206: /*
3207: --Call PO API to update newly created line with new inventory item id
3208: l_update_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
3209: l_update_line_tbl(1).line_id := l_split_line_tbl(2).line_id;
3210: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
3211: l_update_line_tbl(1).change_reason := 'SYSTEM';
3212: l_update_line_tbl(1).ship_from_org_id := Nvl(p_x_line_rec.ship_from_org_id, p_atp_rec.source_organization_id(J));

Line 3404: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

3400: CTO's GET_MANDATORY_COMPONENTS API to get the mandatory
3401: components, and we pass them along with the ATO model to MRP.
3402: -------------------------------------------------------------------- */
3403: Procedure Load_MRP_request
3404: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
3405: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3406: ,p_sch_action IN VARCHAR2 := NULL
3407: ,p_mrp_calc_sd IN VARCHAR2
3408: ,p_type_code IN VARCHAR2

Line 3405: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

3401: components, and we pass them along with the ATO model to MRP.
3402: -------------------------------------------------------------------- */
3403: Procedure Load_MRP_request
3404: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
3405: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3406: ,p_sch_action IN VARCHAR2 := NULL
3407: ,p_mrp_calc_sd IN VARCHAR2
3408: ,p_type_code IN VARCHAR2
3409: ,p_order_number IN NUMBER

Line 4430: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type

4426: CTO's GET_MANDATORY_COMPONENTS API to get the mandatory
4427: components, and we pass them along with the ATO model to MRP.
4428: -------------------------------------------------------------------- */
4429: Procedure Load_MRP_request_from_rec
4430: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type
4431: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type
4432: ,p_sch_action IN VARCHAR2 := NULL
4433: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
4434:

Line 4431: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type

4427: components, and we pass them along with the ATO model to MRP.
4428: -------------------------------------------------------------------- */
4429: Procedure Load_MRP_request_from_rec
4430: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type
4431: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type
4432: ,p_sch_action IN VARCHAR2 := NULL
4433: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
4434:
4435: IS

Line 4503: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

4499: components, and we pass them along with the ATO model to MRP.
4500:
4501: -------------------------------------------------------------------- */
4502: Procedure Load_MRP_request_from_tbl
4503: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
4504: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
4505: ,p_partial_set IN BOOLEAN := FALSE
4506: ,p_sch_action IN VARCHAR2 := NULL
4507: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004

Line 4504: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

4500:
4501: -------------------------------------------------------------------- */
4502: Procedure Load_MRP_request_from_tbl
4503: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
4504: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
4505: ,p_partial_set IN BOOLEAN := FALSE
4506: ,p_sch_action IN VARCHAR2 := NULL
4507: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004
4508: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)

Line 4732: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

4728: while loading the results.
4729: -------------------------------------------------------------------------- */
4730: Procedure Load_Results_from_rec
4731: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
4732: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
4733: , p_index IN NUMBER := 1
4734: , p_sch_action IN VARCHAR2 := NULL
4735: , p_config_exists IN VARCHAR2 := 'N'
4736: , p_partial_set IN BOOLEAN := FALSE

Line 4758: l_split_line_rec OE_ORDER_PUB.line_rec_type;

4754:
4755: --Scheduling Enhancement ER 2736896
4756: --l_atp_flag VARCHAR2(1);
4757: l_om_auto_split VARCHAR2(1);
4758: l_split_line_rec OE_ORDER_PUB.line_rec_type;
4759: l_split_eligible BOOLEAN := FALSE;
4760: --Scheduling Enhancement ER 2736896
4761: --
4762: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6009: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type

6005: for call to Inactive_Demand_Scheduling()
6006: -------------------------------------------------------------------------- */
6007: Procedure Load_Results_from_tbl
6008: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
6009: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
6010: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
6011: , p_sch_action IN VARCHAR2 := NULL
6012: , p_partial IN BOOLEAN := FALSE
6013: , p_partial_set IN BOOLEAN := FALSE

Line 6010: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

6006: -------------------------------------------------------------------------- */
6007: Procedure Load_Results_from_tbl
6008: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
6009: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
6010: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
6011: , p_sch_action IN VARCHAR2 := NULL
6012: , p_partial IN BOOLEAN := FALSE
6013: , p_partial_set IN BOOLEAN := FALSE
6014: , x_return_status OUT NOCOPY VARCHAR2)

Line 6423: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type

6419: END Load_Results_from_tbl;
6420:
6421: Procedure Display_Sch_Errors
6422: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
6423: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
6424: := OE_ORDER_PUB.G_MISS_LINE_TBL
6425: , p_line_id IN NUMBER DEFAULT NULL)
6426:
6427: IS

Line 6424: := OE_ORDER_PUB.G_MISS_LINE_TBL

6420:
6421: Procedure Display_Sch_Errors
6422: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
6423: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
6424: := OE_ORDER_PUB.G_MISS_LINE_TBL
6425: , p_line_id IN NUMBER DEFAULT NULL)
6426:
6427: IS
6428:

Line 6616: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

6612: Description : Create and call MRP API.
6613: --------------------------------------------------------------------- */
6614:
6615: Procedure Call_MRP_ATP
6616: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
6617: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
6618: ,x_return_status OUT NOCOPY VARCHAR2)
6619:
6620: IS

Line 6617: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

6613: --------------------------------------------------------------------- */
6614:
6615: Procedure Call_MRP_ATP
6616: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
6617: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
6618: ,x_return_status OUT NOCOPY VARCHAR2)
6619:
6620: IS
6621: l_msg_count NUMBER;

Line 6759: (p_line_rec IN OE_ORDER_PUB.line_rec_type)

6755: END IF;
6756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6757: END Call_MRP_ATP;
6758: PROCEDURE Cascade_Override_atp
6759: (p_line_rec IN OE_ORDER_PUB.line_rec_type)
6760: IS
6761: --
6762: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6763: --

Line 7035: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

7031: Description : This procedure is called to perform atp_check on a single
7032: line
7033: --------------------------------------------------------------------- */
7034: Procedure Action_ATP
7035: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
7036: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7037: x_return_status OUT NOCOPY VARCHAR2)
7038:
7039: IS

Line 7036: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

7032: line
7033: --------------------------------------------------------------------- */
7034: Procedure Action_ATP
7035: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
7036: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7037: x_return_status OUT NOCOPY VARCHAR2)
7038:
7039: IS
7040: l_msg_count NUMBER;

Line 7428: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

7424: Description : This procedure is called from Process_Request proecudure
7425: to perform the action of SCHEDULE or RESERVE on the line.
7426: --------------------------------------------------------------------- */
7427: Procedure Action_Schedule
7428: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
7429: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7430: p_sch_action IN VARCHAR2,
7431: p_qty_to_reserve IN NUMBER := Null,
7432: x_return_status OUT NOCOPY VARCHAR2)

Line 7429: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

7425: to perform the action of SCHEDULE or RESERVE on the line.
7426: --------------------------------------------------------------------- */
7427: Procedure Action_Schedule
7428: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
7429: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7430: p_sch_action IN VARCHAR2,
7431: p_qty_to_reserve IN NUMBER := Null,
7432: x_return_status OUT NOCOPY VARCHAR2)
7433:

Line 7746: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

7742: to perform the action of UNSCHEDULE or UNRESERVE on the line.
7743: --------------------------------------------------------------------- */
7744:
7745: Procedure Action_UnSchedule
7746: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7747: p_sch_action IN VARCHAR2,
7748: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
7749: x_return_status OUT NOCOPY VARCHAR2)
7750:

Line 7748: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

7744:
7745: Procedure Action_UnSchedule
7746: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7747: p_sch_action IN VARCHAR2,
7748: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
7749: x_return_status OUT NOCOPY VARCHAR2)
7750:
7751: IS
7752:

Line 7913: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

7909: to perform the UNDEMAD on the line when an item is changed.
7910: --------------------------------------------------------------------- */
7911:
7912: Procedure Action_Undemand
7913: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
7914: x_return_status OUT NOCOPY VARCHAR2)
7915:
7916:
7917: IS

Line 8038: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

8034: Procedure Name : Action_Reserve
8035: Description : This procedure is called from Process_Request proecudure
8036: --------------------------------------------------------------------- */
8037: Procedure Action_Reserve
8038: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
8039: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8040: x_return_status OUT NOCOPY VARCHAR2)
8041:
8042: IS

Line 8039: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

8035: Description : This procedure is called from Process_Request proecudure
8036: --------------------------------------------------------------------- */
8037: Procedure Action_Reserve
8038: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
8039: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8040: x_return_status OUT NOCOPY VARCHAR2)
8041:
8042: IS
8043: l_old_reserved_qty NUMBER :=nvl(p_old_line_rec.reserved_quantity,0);

Line 8262: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

8258: Procedure Name : Action_Reschedule
8259: Description : This procedure is called from Process_Request proecudure
8260: --------------------------------------------------------------------- */
8261: Procedure Action_Reschedule
8262: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
8263: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8264: x_return_status OUT NOCOPY VARCHAR2,
8265:
8266: x_reserve_later OUT NOCOPY VARCHAR2)

Line 8263: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

8259: Description : This procedure is called from Process_Request proecudure
8260: --------------------------------------------------------------------- */
8261: Procedure Action_Reschedule
8262: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
8263: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8264: x_return_status OUT NOCOPY VARCHAR2,
8265:
8266: x_reserve_later OUT NOCOPY VARCHAR2)
8267:

Line 8993: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

8989: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
8990: as the identifier.
8991: ----------------------------------------------------------------------------- */
8992: Procedure Load_INV_Request
8993: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
8994: , p_quantity_to_reserve IN NUMBER
8995: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL
8996: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
8997:

Line 9218: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)

9214: /*---------------------------------------------------------------
9215: Handle_External_Lines
9216: ----------------------------------------------------------------*/
9217: PROCEDURE Handle_External_Lines
9218: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
9219: IS
9220:
9221: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9222: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 9221: l_line_tbl OE_ORDER_PUB.line_tbl_type;

9217: PROCEDURE Handle_External_Lines
9218: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
9219: IS
9220:
9221: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9222: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9223: l_line_rec OE_ORDER_PUB.line_rec_type
9224: := OE_Order_Pub.G_MISS_LINE_REC;
9225: l_control_rec OE_GLOBALS.control_rec_type;

Line 9222: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

9218: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
9219: IS
9220:
9221: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9222: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9223: l_line_rec OE_ORDER_PUB.line_rec_type
9224: := OE_Order_Pub.G_MISS_LINE_REC;
9225: l_control_rec OE_GLOBALS.control_rec_type;
9226: l_index NUMBER;

Line 9223: l_line_rec OE_ORDER_PUB.line_rec_type

9219: IS
9220:
9221: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9222: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9223: l_line_rec OE_ORDER_PUB.line_rec_type
9224: := OE_Order_Pub.G_MISS_LINE_REC;
9225: l_control_rec OE_GLOBALS.control_rec_type;
9226: l_index NUMBER;
9227: l_return_status VARCHAR2(1);

Line 9224: := OE_Order_Pub.G_MISS_LINE_REC;

9220:
9221: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9222: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9223: l_line_rec OE_ORDER_PUB.line_rec_type
9224: := OE_Order_Pub.G_MISS_LINE_REC;
9225: l_control_rec OE_GLOBALS.control_rec_type;
9226: l_index NUMBER;
9227: l_return_status VARCHAR2(1);
9228:

Line 9376: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

9372:
9373: Added new call to Handle_External_Lines for config dropshipments.
9374: -----------------------------------------------------------------*/
9375: Procedure Schedule_line
9376: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
9377: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
9378: p_caller IN VARCHAR2 := SCH_INTERNAL,
9379: x_return_status OUT NOCOPY VARCHAR2 )
9380:

Line 9377: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

9373: Added new call to Handle_External_Lines for config dropshipments.
9374: -----------------------------------------------------------------*/
9375: Procedure Schedule_line
9376: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
9377: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
9378: p_caller IN VARCHAR2 := SCH_INTERNAL,
9379: x_return_status OUT NOCOPY VARCHAR2 )
9380:
9381: IS

Line 9382: l_old_line_rec OE_ORDER_PUB.line_rec_type;

9378: p_caller IN VARCHAR2 := SCH_INTERNAL,
9379: x_return_status OUT NOCOPY VARCHAR2 )
9380:
9381: IS
9382: l_old_line_rec OE_ORDER_PUB.line_rec_type;
9383: l_sales_order_id NUMBER;
9384: l_need_sch BOOLEAN;
9385: l_line_action VARCHAR2(30) := Null;
9386: l_auto_sch VARCHAR2(1) := Null;

Line 10169: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

10165: -- we will not do scheduling for lines with source_type=EXTERNAL
10166: -- We should not perform scheduling if the line is already scheduled
10167: --------------------------------------------------------------------- */
10168: FUNCTION Need_Scheduling
10169: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
10170: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
10171: x_line_action OUT NOCOPY VARCHAR2,
10172:
10173: x_auto_sch OUT NOCOPY VARCHAR2

Line 10170: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

10166: -- We should not perform scheduling if the line is already scheduled
10167: --------------------------------------------------------------------- */
10168: FUNCTION Need_Scheduling
10169: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
10170: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
10171: x_line_action OUT NOCOPY VARCHAR2,
10172:
10173: x_auto_sch OUT NOCOPY VARCHAR2
10174:

Line 10859: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

10855: we will perform scheduling on lines on hold. If it is
10856: set to 'N', we will not perform scheduling.
10857: --------------------------------------------------------------------- */
10858: Procedure Validate_Line
10859: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
10860: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
10861: p_sch_action IN VARCHAR2,
10862: p_caller IN VARCHAR2 := SCH_EXTERNAL,
10863: x_return_status OUT NOCOPY VARCHAR2)

Line 10860: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

10856: set to 'N', we will not perform scheduling.
10857: --------------------------------------------------------------------- */
10858: Procedure Validate_Line
10859: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
10860: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
10861: p_sch_action IN VARCHAR2,
10862: p_caller IN VARCHAR2 := SCH_EXTERNAL,
10863: x_return_status OUT NOCOPY VARCHAR2)
10864:

Line 12141: Procedure Process_request(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

12137: or it could be just a simple standard line which does not
12138: belong to any set.
12139:
12140: --------------------------------------------------------------------- */
12141: Procedure Process_request(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
12142: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
12143: p_caller IN VARCHAR2,
12144: p_sch_action IN VARCHAR2,
12145: x_return_status OUT NOCOPY VARCHAR2)

Line 12142: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

12138: belong to any set.
12139:
12140: --------------------------------------------------------------------- */
12141: Procedure Process_request(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
12142: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
12143: p_caller IN VARCHAR2,
12144: p_sch_action IN VARCHAR2,
12145: x_return_status OUT NOCOPY VARCHAR2)
12146:

Line 12149: l_orig_line_rec OE_ORDER_PUB.line_rec_type;

12145: x_return_status OUT NOCOPY VARCHAR2)
12146:
12147: IS
12148: l_update_flag VARCHAR2(1):= FND_API.G_TRUE;
12149: l_orig_line_rec OE_ORDER_PUB.line_rec_type;
12150: l_reserve_later VARCHAR2(1) := 'N';
12151: l_qty_to_reserve NUMBER;
12152: l_qty2_to_reserve NUMBER; -- INVCONV
12153: --Bug 12641867

Line 12854: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)

12850: SEGMENT3 : stores the ont_source_code value
12851:
12852: -------------------------------------------------------------------------- */
12853: Procedure Insert_Into_Mtl_Sales_Orders
12854: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
12855: IS
12856: l_order_type_name VARCHAR2(80);
12857: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
12858: l_sales_order_id NUMBER;

Line 12969: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

12965: on the line and the result needs to be verified and/or
12966: updated to the database.
12967: --------------------------------------------------------------------- */
12968: Procedure call_process_order
12969: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
12970: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
12971: , p_control_rec IN OE_GLOBALS.control_rec_type
12972: , p_caller IN VARCHAR2
12973: , x_return_status OUT NOCOPY VARCHAR2)

Line 12970: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

12966: updated to the database.
12967: --------------------------------------------------------------------- */
12968: Procedure call_process_order
12969: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
12970: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
12971: , p_control_rec IN OE_GLOBALS.control_rec_type
12972: , p_caller IN VARCHAR2
12973: , x_return_status OUT NOCOPY VARCHAR2)
12974:

Line 13083: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

13079: on the line and the result needs to be verified and/or
13080: updated to the database.
13081: --------------------------------------------------------------------- */
13082: Procedure Process_Group_of_Lines
13083: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
13084: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
13085: , p_caller IN VARCHAR2
13086: , x_return_status OUT NOCOPY VARCHAR2)
13087:

Line 13084: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

13080: updated to the database.
13081: --------------------------------------------------------------------- */
13082: Procedure Process_Group_of_Lines
13083: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
13084: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
13085: , p_caller IN VARCHAR2
13086: , x_return_status OUT NOCOPY VARCHAR2)
13087:
13088: IS

Line 13360: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

13356: either call process order or do a direct update.
13357: p_call_prn is call process_request and notify.
13358: --------------------------------------------------------------------- */
13359: Procedure Process_Line
13360: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
13361: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
13362: , p_caller IN VARCHAR2
13363: , p_call_prn IN BOOLEAN := TRUE
13364: , x_return_status OUT NOCOPY VARCHAR2)

Line 13361: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

13357: p_call_prn is call process_request and notify.
13358: --------------------------------------------------------------------- */
13359: Procedure Process_Line
13360: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
13361: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
13362: , p_caller IN VARCHAR2
13363: , p_call_prn IN BOOLEAN := TRUE
13364: , x_return_status OUT NOCOPY VARCHAR2)
13365:

Line 13368: l_line_tbl OE_ORDER_PUB.line_tbl_type;

13364: , x_return_status OUT NOCOPY VARCHAR2)
13365:
13366: IS
13367: l_process_requests BOOLEAN;
13368: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13369: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
13370: l_sec_result NUMBER;
13371: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
13372: l_control_rec OE_GLOBALS.control_rec_type;

Line 13369: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

13365:
13366: IS
13367: l_process_requests BOOLEAN;
13368: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13369: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
13370: l_sec_result NUMBER;
13371: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
13372: l_control_rec OE_GLOBALS.control_rec_type;
13373: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 13895: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

13891: PROCEDURE ATP_Check
13892:
13893: --------------------------------------------------------*/
13894: Procedure ATP_Check
13895: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
13896: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
13897: p_validate IN VARCHAR2 := FND_API.G_TRUE,
13898: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
13899:

Line 13896: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

13892:
13893: --------------------------------------------------------*/
13894: Procedure ATP_Check
13895: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
13896: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
13897: p_validate IN VARCHAR2 := FND_API.G_TRUE,
13898: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
13899:
13900: x_return_status OUT NOCOPY VARCHAR2

Line 14018: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,

14014: PROCEDURE Multi_ATP_Check
14015:
14016: --------------------------------------------------------*/
14017: PROCEDURE Multi_ATP_Check
14018: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
14019: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
14020: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
14021:
14022: x_return_status OUT NOCOPY VARCHAR2

Line 14019: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

14015:
14016: --------------------------------------------------------*/
14017: PROCEDURE Multi_ATP_Check
14018: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
14019: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
14020: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
14021:
14022: x_return_status OUT NOCOPY VARCHAR2
14023:

Line 14476: l_line_rec OE_ORDER_PUB.line_rec_type;

14472: END Multi_ATP_Check;
14473:
14474: Procedure Delete_Row(p_line_id IN NUMBER)
14475: IS
14476: l_line_rec OE_ORDER_PUB.line_rec_type;
14477: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14478: l_sales_order_id NUMBER;
14479: l_ato_exists VARCHAR2(1);
14480: l_request_search_rslt BOOLEAN;

Line 14831: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

14827: /* Function find line
14828:
14829: This is be used to find the line in the pl/sql table.
14830: */
14831: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
14832: p_line_id IN NUMBER)
14833: Return BOOLEAN
14834: IS
14835: --

Line 14867: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

14863: If the ato model is part of set, then whole set information will
14864: be passed to MRP and so on */
14865:
14866: PROCEDURE PROCESS_SPLIT
14867: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
14868: x_return_status OUT NOCOPY VARCHAR2)
14869:
14870: IS
14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;

14867: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
14868: x_return_status OUT NOCOPY VARCHAR2)
14869:
14870: IS
14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;
14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868

Line 14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;

14868: x_return_status OUT NOCOPY VARCHAR2)
14869:
14870: IS
14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;
14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14876: l_old_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868

Line 14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868

14869:
14870: IS
14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;
14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14876: l_old_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14877: l_order_date_type_code VARCHAR2(20); -- 8706868

Line 14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868

14870: IS
14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;
14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14876: l_old_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14877: l_order_date_type_code VARCHAR2(20); -- 8706868
14878: l_rsv_update BOOLEAN :=FALSE; --8706868

Line 14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868

14871: l_line_tbl OE_ORDER_PUB.line_tbl_type;
14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14876: l_old_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14877: l_order_date_type_code VARCHAR2(20); -- 8706868
14878: l_rsv_update BOOLEAN :=FALSE; --8706868
14879: K NUMBER;

Line 14876: l_old_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868

14872: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
14873: l_old_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14874: l_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14875: l_non_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14876: l_old_mrp_line_tbl OE_ORDER_PUB.line_tbl_type; -- 8706868
14877: l_order_date_type_code VARCHAR2(20); -- 8706868
14878: l_rsv_update BOOLEAN :=FALSE; --8706868
14879: K NUMBER;
14880: I NUMBER;

Line 15610: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

15606: ---------------------------------------------------------------------- */
15607:
15608:
15609: Procedure SPLIT_SCHEDULING
15610: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
15611: , x_return_status OUT NOCOPY VARCHAR2)
15612:
15613: IS
15614: l_rsv_qty NUMBER := 0;

Line 16355: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

16351:
16352:
16353: -------------------------------------------------------------*/
16354: Procedure Schedule_Split_Lines
16355: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
16356: , x_return_status OUT NOCOPY VARCHAR2)
16357: IS
16358: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;
16359: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

Line 16358: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;

16354: Procedure Schedule_Split_Lines
16355: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
16356: , x_return_status OUT NOCOPY VARCHAR2)
16357: IS
16358: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;
16359: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
16360: BEGIN
16361:
16362: oe_debug_pub.add('Entering Schedule_Split_Lines',1);

Line 16359: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

16355: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
16356: , x_return_status OUT NOCOPY VARCHAR2)
16357: IS
16358: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;
16359: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
16360: BEGIN
16361:
16362: oe_debug_pub.add('Entering Schedule_Split_Lines',1);
16363:

Line 16448: l_line_rec OE_ORDER_PUB.line_rec_type;

16444: , x_return_status OUT NOCOPY VARCHAR2)
16445:
16446: IS
16447: /*
16448: l_line_rec OE_ORDER_PUB.line_rec_type;
16449: I NUMBER;
16450: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16451: l_msg_count NUMBER := 0;
16452: l_msg_data VARCHAR2(2000) := null;

Line 16454: l_line_tbl OE_ORDER_PUB.line_tbl_type;

16450: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16451: l_msg_count NUMBER := 0;
16452: l_msg_data VARCHAR2(2000) := null;
16453: l_control_rec OE_GLOBALS.control_rec_type;
16454: l_line_tbl OE_ORDER_PUB.line_tbl_type;
16455: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
16456: l_file_val VARCHAR2(80);
16457: */
16458: --

Line 16455: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

16451: l_msg_count NUMBER := 0;
16452: l_msg_data VARCHAR2(2000) := null;
16453: l_control_rec OE_GLOBALS.control_rec_type;
16454: l_line_tbl OE_ORDER_PUB.line_tbl_type;
16455: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
16456: l_file_val VARCHAR2(80);
16457: */
16458: --
16459: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 16503: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;

16499: IF l_debug_level > 0 THEN
16500: oe_debug_pub.add( 'RR: SCHEDULE_SHIP_DATE ' || P_MRP_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 1 ) ;
16501: END IF;
16502:
16503: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
16504: l_line_rec.line_id := p_mrp_line_tbl(I).line_id;
16505: l_line_rec.schedule_ship_date :=
16506: p_mrp_line_tbl(I).schedule_ship_date;
16507: l_line_rec.schedule_arrival_date :=

Line 16958: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

16954: END IF;
16955: RETURN (FALSE);
16956: END Get_Pick_Status;
16957:
16958: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
16959: ,p_quantity_to_unreserve IN NUMBER
16960: ,p_quantity2_to_unreserve IN NUMBER -- INVCONV
16961: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
16962: ,x_return_status OUT NOCOPY VARCHAR2)

Line 17337: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,

17333: date type code and scheduling action sets the promise date
17334: with schedule ship date/schedule arrival date.
17335: -------------------------------------------------------------------------- */
17336: PROCEDURE Promise_Date_for_Sch_Action
17337: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
17338: p_sch_action IN VARCHAR2,
17339: P_header_id IN NUMBER DEFAULT NULL)
17340: IS
17341: CURSOR order_header_id IS

Line 18190: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

18186: END Global_ATP;
18187:
18188:
18189: Procedure Cascade_Ship_Set_Attr
18190: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
18191: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
18192: IS
18193:
18194: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 18194: l_line_tbl OE_ORDER_PUB.line_tbl_type;

18190: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
18191: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
18192: IS
18193:
18194: l_line_tbl OE_ORDER_PUB.line_tbl_type;
18195: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
18196: l_control_rec OE_GLOBALS.control_rec_type;
18197: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18198: --

Line 18195: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

18191: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
18192: IS
18193:
18194: l_line_tbl OE_ORDER_PUB.line_tbl_type;
18195: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
18196: l_control_rec OE_GLOBALS.control_rec_type;
18197: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18198: --
18199: l_msg_count NUMBER;

Line 18312: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18311: l_mrp_msg_data VARCHAR2(200);
18312: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18313: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
18314:
18315: --
18316: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 18313: l_new_line_rec OE_Order_Pub.Line_Rec_Type;

18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18311: l_mrp_msg_data VARCHAR2(200);
18312: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18313: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
18314:
18315: --
18316: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18317: --

Line 18427: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18426: l_mrp_msg_data VARCHAR2(200);
18427: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18428: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
18429:
18430: --
18431: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 18428: l_new_line_rec OE_Order_Pub.Line_Rec_Type;

18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18426: l_mrp_msg_data VARCHAR2(200);
18427: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18428: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
18429:
18430: --
18431: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18432: --

Line 18579: l_line_tbl OE_ORDER_PUB.Line_tbl_type;

18575: l_atp_tbl OE_ATP.Atp_Tbl_Type;
18576: l_return_status VARCHAR2(1);
18577: l_msg_count NUMBER;
18578: l_msg_data VARCHAR2(2000);
18579: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
18580: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
18581: l_line_rec OE_Order_PUB.Line_Rec_Type; --Bug 8652339
18582: BEGIN
18583: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');

Line 18580: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;

18576: l_return_status VARCHAR2(1);
18577: l_msg_count NUMBER;
18578: l_msg_data VARCHAR2(2000);
18579: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
18580: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
18581: l_line_rec OE_Order_PUB.Line_Rec_Type; --Bug 8652339
18582: BEGIN
18583: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');
18584:

Line 18581: l_line_rec OE_Order_PUB.Line_Rec_Type; --Bug 8652339

18577: l_msg_count NUMBER;
18578: l_msg_data VARCHAR2(2000);
18579: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
18580: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
18581: l_line_rec OE_Order_PUB.Line_Rec_Type; --Bug 8652339
18582: BEGIN
18583: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');
18584:
18585: --Bug 8652339 : Initialize l_line_tbl from OE_ORDER_LINES_ALL table