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 49: OE_Delayed_Schedule_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

45: -- END 1955004
46:
47: -- 6663462 Delayed_schedule
48:
49: OE_Delayed_Schedule_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
50:
51:
52:
53: -- Valid Scheduling Status.

Line 126: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

122: G_DATE_TYPE VARCHAR2(30) := null; -- moved from body to spec.
123:
124:
125: PROCEDURE Schedule_line
126: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
127: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
128: ,p_caller IN VARCHAR2 := SCH_INTERNAL
129: ,x_return_status OUT NOCOPY VARCHAR2);
130:

Line 127: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

123:
124:
125: PROCEDURE Schedule_line
126: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
127: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
128: ,p_caller IN VARCHAR2 := SCH_INTERNAL
129: ,x_return_status OUT NOCOPY VARCHAR2);
130:
131:

Line 134: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

130:
131:
132:
133: FUNCTION Need_Scheduling
134: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
135: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
136: ,x_line_action OUT NOCOPY VARCHAR2
137:
138: ,x_auto_sch OUT NOCOPY VARCHAR2)

Line 135: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

131:
132:
133: FUNCTION Need_Scheduling
134: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
135: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
136: ,x_line_action OUT NOCOPY VARCHAR2
137:
138: ,x_auto_sch OUT NOCOPY VARCHAR2)
139:

Line 144: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

140: RETURN BOOLEAN;
141:
142:
143: PROCEDURE Validate_Line
144: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
145: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
146: ,p_sch_action IN VARCHAR2
147: ,p_caller IN VARCHAR2 := SCH_EXTERNAL
148: ,x_return_status OUT NOCOPY VARCHAR2);

Line 145: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

141:
142:
143: PROCEDURE Validate_Line
144: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
145: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
146: ,p_sch_action IN VARCHAR2
147: ,p_caller IN VARCHAR2 := SCH_EXTERNAL
148: ,x_return_status OUT NOCOPY VARCHAR2);
149:

Line 152: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

148: ,x_return_status OUT NOCOPY VARCHAR2);
149:
150:
151: Procedure Process_request
152: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
153: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
154: ,p_caller IN VARCHAR2
155: ,p_sch_action IN VARCHAR2
156: ,x_return_status OUT NOCOPY VARCHAR2);

Line 153: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

149:
150:
151: Procedure Process_request
152: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
153: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
154: ,p_caller IN VARCHAR2
155: ,p_sch_action IN VARCHAR2
156: ,x_return_status OUT NOCOPY VARCHAR2);
157:

Line 176: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

172: RETURN NUMBER;
173:
174:
175: Procedure Load_INV_Request
176: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
177: ,p_quantity_to_reserve IN NUMBER
178: ,p_quantity2_to_reserve IN NUMBER DEFAULT NULL -- INVCONV
179: ,x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type);
180:

Line 184: ( p_header_rec IN OE_ORDER_PUB.header_rec_type);

180:
181:
182:
183: Procedure Insert_Into_Mtl_Sales_Orders
184: ( p_header_rec IN OE_ORDER_PUB.header_rec_type);
185:
186: FUNCTION Get_mtl_sales_order_id(p_header_id IN NUMBER,
187: p_order_type_id IN NUMBER DEFAULT NULL) --3745318 added a new parameter p_order_type_id
188: RETURN NUMBER;

Line 195: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

191: p_line_type_id IN NUMBER)
192: RETURN VARCHAR2;
193:
194: Procedure Process_Group_of_lines
195: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
196: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
197: ,p_caller IN VARCHAR2
198: ,x_return_status OUT NOCOPY VARCHAR2);
199:

Line 196: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

192: RETURN VARCHAR2;
193:
194: Procedure Process_Group_of_lines
195: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
196: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
197: ,p_caller IN VARCHAR2
198: ,x_return_status OUT NOCOPY VARCHAR2);
199:
200:

Line 202: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

198: ,x_return_status OUT NOCOPY VARCHAR2);
199:
200:
201: Procedure Process_line
202: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
203: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
204: ,p_caller IN VARCHAR2
205: ,p_call_prn IN BOOLEAN := TRUE
206: ,x_return_status OUT NOCOPY VARCHAR2);

Line 203: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

199:
200:
201: Procedure Process_line
202: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
203: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
204: ,p_caller IN VARCHAR2
205: ,p_call_prn IN BOOLEAN := TRUE
206: ,x_return_status OUT NOCOPY VARCHAR2);
207:

Line 211: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type

207:
208:
209: -- BUG 1955004
210: Procedure Inactive_Demand_Scheduling
211: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
212: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
213: ,p_sch_action IN VARCHAR2 := NULL
214: ,x_return_status OUT NOCOPY VARCHAR2);
215:

Line 212: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

208:
209: -- BUG 1955004
210: Procedure Inactive_Demand_Scheduling
211: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
212: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
213: ,p_sch_action IN VARCHAR2 := NULL
214: ,x_return_status OUT NOCOPY VARCHAR2);
215:
216: -- END 1955004

Line 219: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

215:
216: -- END 1955004
217:
218: Procedure Load_MRP_request_from_tbl
219: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
220: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
221: ,p_partial_set IN BOOLEAN := FALSE
222: ,p_sch_action IN VARCHAR2 := NULL
223: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' --4405004

Line 220: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

216: -- END 1955004
217:
218: Procedure Load_MRP_request_from_tbl
219: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
220: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
221: ,p_partial_set IN BOOLEAN := FALSE
222: ,p_sch_action IN VARCHAR2 := NULL
223: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' --4405004
224: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ);

Line 230: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type

226:
227: -- Added parameter p_old_line_tbl to support bug 1955004
228: Procedure Load_Results_from_tbl
229: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
230: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
231: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
232: , p_sch_action IN VARCHAR2 := NULL
233: , p_partial IN BOOLEAN := FALSE
234: , p_partial_set IN BOOLEAN := FALSE

Line 231: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

227: -- Added parameter p_old_line_tbl to support bug 1955004
228: Procedure Load_Results_from_tbl
229: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
230: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
231: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
232: , p_sch_action IN VARCHAR2 := NULL
233: , p_partial IN BOOLEAN := FALSE
234: , p_partial_set IN BOOLEAN := FALSE
235: , x_return_status OUT NOCOPY VARCHAR2);

Line 239: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

235: , x_return_status OUT NOCOPY VARCHAR2);
236:
237:
238: Procedure ATP_Check
239: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
240: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
241: p_validate IN VARCHAR2 := FND_API.G_TRUE,
242: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
243:

Line 240: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

236:
237:
238: Procedure ATP_Check
239: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
240: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
241: p_validate IN VARCHAR2 := FND_API.G_TRUE,
242: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
243:
244: x_return_status OUT NOCOPY VARCHAR2);

Line 248: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,

244: x_return_status OUT NOCOPY VARCHAR2);
245:
246:
247: PROCEDURE Multi_ATP_Check
248: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
249: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
250: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
251:
252: x_return_status OUT NOCOPY VARCHAR2);

Line 249: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

245:
246:
247: PROCEDURE Multi_ATP_Check
248: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
249: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
250: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
251:
252: x_return_status OUT NOCOPY VARCHAR2);
253:

Line 256: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

252: x_return_status OUT NOCOPY VARCHAR2);
253:
254:
255: Procedure Unreserve_Line
256: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
257: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 6628134
258: ,p_quantity_to_unreserve IN NUMBER
259: ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL-- INCONV
260: ,x_return_status OUT NOCOPY VARCHAR2);

Line 264: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

260: ,x_return_status OUT NOCOPY VARCHAR2);
261:
262:
263: Procedure Reserve_line
264: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
265: ,p_quantity_to_reserve IN NUMBER
266: ,p_quantity2_to_reserve IN NUMBER DEFAULT NULL-- INCONV
267: ,p_rsv_update IN BOOLEAN DEFAULT FALSE -- To be passed as TRUE where there is an increase to the reserve quantity
268: ,x_return_status OUT NOCOPY VARCHAR2);

Line 280: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

276: FUNCTION Get_Auto_Sch_Flag
277: RETURN VARCHAR2;
278:
279: Procedure SPLIT_SCHEDULING
280: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
281: , x_return_status OUT NOCOPY VARCHAR2);
282:
283:
284:

Line 335: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

331:
332: Procedure Delete_Row(p_line_id IN NUMBER);
333:
334: Procedure Call_MRP_ATP
335: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
336: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
337: ,x_return_status OUT NOCOPY VARCHAR2);
338:
339:

Line 336: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

332: Procedure Delete_Row(p_line_id IN NUMBER);
333:
334: Procedure Call_MRP_ATP
335: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
336: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
337: ,x_return_status OUT NOCOPY VARCHAR2);
338:
339:
340: Procedure Post_Forms_Commit

Line 349: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

345: ,x_msg_data OUT NOCOPY VARCHAR2);
346:
347:
348: Procedure call_process_order
349: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
350: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
351: , p_control_rec IN OE_GLOBALS.control_rec_type
352: , p_caller IN VARCHAR2
353: , x_return_status OUT NOCOPY VARCHAR2);

Line 350: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

346:
347:
348: Procedure call_process_order
349: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
350: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
351: , p_control_rec IN OE_GLOBALS.control_rec_type
352: , p_caller IN VARCHAR2
353: , x_return_status OUT NOCOPY VARCHAR2);
354:

Line 357: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type);

353: , x_return_status OUT NOCOPY VARCHAR2);
354:
355:
356: PROCEDURE Handle_External_Lines
357: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type);
358:
359: /*----------------------------------------------------------------
360: This record type will be used to remember old inventory item
361: values on the lines which is part of set. The related records will be

Line 385: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type

381: -- End 2434807 --
382:
383: Procedure Display_Sch_Errors
384: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
385: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
386: := OE_ORDER_PUB.G_MISS_LINE_TBL
387: , p_line_id IN NUMBER DEFAULT NULL);
388:
389:

Line 386: := OE_ORDER_PUB.G_MISS_LINE_TBL

382:
383: Procedure Display_Sch_Errors
384: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
385: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
386: := OE_ORDER_PUB.G_MISS_LINE_TBL
387: , p_line_id IN NUMBER DEFAULT NULL);
388:
389:
390: FUNCTION Schedule_Attribute_Changed

Line 391: ( p_line_rec IN Oe_Order_Pub.line_rec_type

387: , p_line_id IN NUMBER DEFAULT NULL);
388:
389:
390: FUNCTION Schedule_Attribute_Changed
391: ( p_line_rec IN Oe_Order_Pub.line_rec_type
392: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
393: RETURN BOOLEAN;
394:
395: FUNCTION Set_Attr_Matched(p_set_ship_from_org_id IN NUMBER ,

Line 392: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)

388:
389:
390: FUNCTION Schedule_Attribute_Changed
391: ( p_line_rec IN Oe_Order_Pub.line_rec_type
392: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
393: RETURN BOOLEAN;
394:
395: FUNCTION Set_Attr_Matched(p_set_ship_from_org_id IN NUMBER ,
396: p_line_ship_from_org_id IN NUMBER,

Line 417: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

413:
414: -- Start 2595661
415: FUNCTION Get_Pick_Status (p_line_id IN NUMBER) RETURN BOOLEAN;
416:
417: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
418: ,p_quantity_to_unreserve IN NUMBER
419: ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL -- INVCONV
420: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
421: ,x_return_status OUT NOCOPY VARCHAR2);

Line 445: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

441:
442: OE_sch_Attrb_Tbl OE_sch_Attrb_Tbl_Type;
443:
444: Procedure Schedule_Split_Lines
445: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
446: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
447:
448: Procedure Update_PO(p_schedule_ship_date IN DATE,
449: p_source_document_id IN VARCHAR2,

Line 453: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

449: p_source_document_id IN VARCHAR2,
450: p_source_document_line_id IN VARCHAR2);
451: -- Pack J
452: PROCEDURE Promise_Date_for_Sch_Action
453: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
454: ,p_sch_action IN VARCHAR2
455: ,P_header_id IN NUMBER DEFAULT NULL);
456:
457: PROCEDURE Global_atp(p_line_id IN NUMBER);

Line 463: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

459: FUNCTION Get_ATP_CHECK_Session_Id
460: RETURN number;
461:
462: Procedure Cascade_Ship_Set_Attr
463: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
464: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
465:
466: -- 4026758
467: Procedure Log_Delete_Set_Request

Line 544: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,

540: ,x_set_scheduled OUT NOCOPY BOOLEAN );
541:
542:
543: Procedure Log_Set_Request
544: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
545: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type, -- making public for 4241385
546: p_sch_action IN VARCHAR2,
547: p_caller IN VARCHAR2,
548: x_return_status OUT NOCOPY VARCHAR2);

Line 545: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type, -- making public for 4241385

541:
542:
543: Procedure Log_Set_Request
544: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
545: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type, -- making public for 4241385
546: p_sch_action IN VARCHAR2,
547: p_caller IN VARCHAR2,
548: x_return_status OUT NOCOPY VARCHAR2);
549: