139: TYPE Mrp_Line_Tbl_Type IS TABLE OF mrp_line_rec_type
140: INDEX BY BINARY_INTEGER;
141:
142: Procedure Schedule_line
143: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
144: , p_write_to_db IN VARCHAR2
145: , p_update_flag IN VARCHAR2 := FND_API.G_TRUE
146: , p_recursive_call IN VARCHAR2 := FND_API.G_TRUE
147: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
143: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
144: , p_write_to_db IN VARCHAR2
145: , p_update_flag IN VARCHAR2 := FND_API.G_TRUE
146: , p_recursive_call IN VARCHAR2 := FND_API.G_TRUE
147: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
148: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type
149: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
150:
151: Procedure Update_line_record
148: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type
149: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
150:
151: Procedure Update_line_record
152: ( p_line_tbl IN OE_ORDER_PUB.line_tbl_type
153: , p_x_new_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
154: , p_write_to_db IN VARCHAR2
155: , p_recursive_call IN VARCHAR2
156: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
149: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
150:
151: Procedure Update_line_record
152: ( p_line_tbl IN OE_ORDER_PUB.line_tbl_type
153: , p_x_new_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
154: , p_write_to_db IN VARCHAR2
155: , p_recursive_call IN VARCHAR2
156: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
157:
155: , p_recursive_call IN VARCHAR2
156: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
157:
158: FUNCTION Need_Scheduling
159: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
160: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type)
161: RETURN BOOLEAN;
162:
163: Procedure Check_Item_Attribute
156: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
157:
158: FUNCTION Need_Scheduling
159: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
160: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type)
161: RETURN BOOLEAN;
162:
163: Procedure Check_Item_Attribute
164: (p_line_rec IN OE_ORDER_PUB.line_rec_type);
160: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type)
161: RETURN BOOLEAN;
162:
163: Procedure Check_Item_Attribute
164: (p_line_rec IN OE_ORDER_PUB.line_rec_type);
165:
166: FUNCTION Scheduling_Activity
167: (p_line_rec IN OE_ORDER_PUB.line_rec_type)
168: RETURN BOOLEAN;
163: Procedure Check_Item_Attribute
164: (p_line_rec IN OE_ORDER_PUB.line_rec_type);
165:
166: FUNCTION Scheduling_Activity
167: (p_line_rec IN OE_ORDER_PUB.line_rec_type)
168: RETURN BOOLEAN;
169:
170: Procedure Validate_Line
171: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
167: (p_line_rec IN OE_ORDER_PUB.line_rec_type)
168: RETURN BOOLEAN;
169:
170: Procedure Validate_Line
171: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
172: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
173: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
174:
175: Procedure Process_request
168: RETURN BOOLEAN;
169:
170: Procedure Validate_Line
171: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
172: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
173: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
174:
175: Procedure Process_request
176: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
172: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
173: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
174:
175: Procedure Process_request
176: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
177: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
178: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type
179: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
180:
173: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
174:
175: Procedure Process_request
176: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
177: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
178: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type
179: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
180:
181:
184: , p_ship_from_org_id IN NUMBER)
185: RETURN NUMBER;
186:
187: Procedure Create_Group_Request
188: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
189: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type
190: , x_group_req_rec OUT NOCOPY /* file.sql.39 change */ OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
191: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
192: );
185: RETURN NUMBER;
186:
187: Procedure Create_Group_Request
188: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
189: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type
190: , x_group_req_rec OUT NOCOPY /* file.sql.39 change */ OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
191: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
192: );
193:
192: );
193:
194:
195: Procedure Load_INV_Request
196: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
197: , p_quantity_to_reserve IN NUMBER
198: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL-- INVCONV
199: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type);
200:
198: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL-- INVCONV
199: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type);
200:
201: FUNCTION Schedule_Attribute_Changed
202: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
203: , p_old_line_rec IN Oe_Order_Pub.Line_Rec_Type)
204: RETURN BOOLEAN;
205:
206: Procedure Unreserve_Line
199: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type);
200:
201: FUNCTION Schedule_Attribute_Changed
202: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
203: , p_old_line_rec IN Oe_Order_Pub.Line_Rec_Type)
204: RETURN BOOLEAN;
205:
206: Procedure Unreserve_Line
207: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
203: , p_old_line_rec IN Oe_Order_Pub.Line_Rec_Type)
204: RETURN BOOLEAN;
205:
206: Procedure Unreserve_Line
207: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
208: , p_quantity_to_unreserve IN NUMBER
209: , p_quantity2_to_unreserve IN NUMBER -- INVCONV
210: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
211:
219: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
220: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER);
221:
222: Procedure Load_MRP_Request
223: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
224: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
225: := OE_ORDER_PUB.G_MISS_LINE_TBL
226: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
227: );
220: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER);
221:
222: Procedure Load_MRP_Request
223: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
224: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
225: := OE_ORDER_PUB.G_MISS_LINE_TBL
226: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
227: );
228:
221:
222: Procedure Load_MRP_Request
223: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
224: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
225: := OE_ORDER_PUB.G_MISS_LINE_TBL
226: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
227: );
228:
229: Procedure Load_Results
227: );
228:
229: Procedure Load_Results
230: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
231: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
232: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.ATP_tbl_Type
233: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
234:
235: Procedure Insert_Into_Mtl_Sales_Orders
232: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.ATP_tbl_Type
233: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
234:
235: Procedure Insert_Into_Mtl_Sales_Orders
236: ( p_header_rec IN OE_ORDER_PUB.header_rec_type);
237:
238: FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER)
239: RETURN NUMBER;
240:
247: PROCEDURE Set_Auto_Sch_Flag
248: (p_value_from_user IN VARCHAR2 := FND_API.G_MISS_CHAR);
249:
250: PROCEDURE Build_Included_Items
251: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
252: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
253:
254: Procedure SPLIT_SCHEDULING
255: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
248: (p_value_from_user IN VARCHAR2 := FND_API.G_MISS_CHAR);
249:
250: PROCEDURE Build_Included_Items
251: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
252: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
253:
254: Procedure SPLIT_SCHEDULING
255: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
256: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
251: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
252: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
253:
254: Procedure SPLIT_SCHEDULING
255: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
256: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
257:
258: PROCEDURE SPLIT_RESERVATIONS
259: ( p_reserved_line_id IN NUMBER