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 123: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 124: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

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

Line 131: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

127:
128:
129:
130: FUNCTION Need_Scheduling
131: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
132: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
133: ,x_line_action OUT NOCOPY VARCHAR2
134:
135: ,x_auto_sch OUT NOCOPY VARCHAR2)

Line 132: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 141: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

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

Line 142: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

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

Line 149: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 150: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

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

Line 173: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

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

Line 181: ( p_header_rec IN OE_ORDER_PUB.header_rec_type);

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

Line 192: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

Line 193: ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

Line 199: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 200: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

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

Line 208: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type

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

Line 209: ,p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

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

Line 216: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

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

Line 217: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

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

Line 227: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type

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

Line 228: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

Line 236: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

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

Line 237: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

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

Line 245: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,

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

Line 246: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

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

Line 253: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

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

Line 261: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

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

Line 277: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

Line 332: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

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

Line 333: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

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

Line 346: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

Line 347: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

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

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

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

Line 382: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type

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

Line 383: := OE_ORDER_PUB.G_MISS_LINE_TBL

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

Line 388: ( p_line_rec IN Oe_Order_Pub.line_rec_type

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

Line 389: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)

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

Line 414: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

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

Line 442: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

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

Line 450: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

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

Line 460: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

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