DBA Data[Home] [Help]

APPS.OE_ORDER_SCH_UTIL dependencies on OE_ORDER_PUB

Line 143: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 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

Line 152: ( p_line_tbl IN OE_ORDER_PUB.line_tbl_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
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);

Line 153: , p_x_new_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_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);
157:

Line 159: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 160: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type)

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);

Line 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;

Line 167: (p_line_rec IN OE_ORDER_PUB.line_rec_type)

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

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

Line 172: , p_old_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
176: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

Line 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:

Line 177: , p_x_line_rec IN OUT NOCOPY 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:
181:

Line 188: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

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: );

Line 189: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type

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:

Line 196: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

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:

Line 202: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

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

Line 203: , p_old_line_rec IN Oe_Order_Pub.Line_Rec_Type)

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

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:

Line 223: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type

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: );

Line 224: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type

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:

Line 225: := OE_ORDER_PUB.G_MISS_LINE_TBL

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

Line 231: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

Line 236: ( p_header_rec IN OE_ORDER_PUB.header_rec_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
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:

Line 251: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

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

Line 252: 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);

Line 255: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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