20: G_SCH_ERROR_TBL Schedule_Error_Tbl_Type;
21:
22: -- BYPASS ATP
23: PROCEDURE Inactive_Demand_Scheduling
24: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
25: , x_return_status OUT NOCOPY VARCHAR2
26: );
27:
28: PROCEDURE Insert_Error_Messages
25: , x_return_status OUT NOCOPY VARCHAR2
26: );
27:
28: PROCEDURE Insert_Error_Messages
29: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
30: )
31: IS
32: l_no_source_msg VARCHAR2(2000);
33: l_sch_error_msg VARCHAR2(2000);
113: END Insert_Error_Messages;
114:
115: --BYPASS ATP
116: PROCEDURE Inactive_Demand_Scheduling
117: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
118: , x_return_status OUT NOCOPY VARCHAR2
119: )
120: IS
121: l_order_date_type_code VARCHAR2(30);
280:
281: FUNCTION Get_Lead_Time
282: (
283: p_ato_index IN NUMBER
284: ,p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE
285:
286: )
287: RETURN NUMBER
288: IS
365: (p_line_index IN NUMBER
366: ,p_curr_ato_index IN NUMBER
367: ,p_header_index IN NUMBER
368: ,p_atp_index IN NUMBER
369: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
370: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
371: ,p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
372: )
373: IS
484: END Add_MRP_Rec;
485:
486:
487: PROCEDURE Load_MRP_Request
488: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
489: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
490: ,p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
491: ,p_x_atp_line_map_rec IN OUT NOCOPY OE_WSH_BULK_GRP.T_NUM
492: )
487: PROCEDURE Load_MRP_Request
488: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
489: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
490: ,p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
491: ,p_x_atp_line_map_rec IN OUT NOCOPY OE_WSH_BULK_GRP.T_NUM
492: )
493: IS
494: I NUMBER := 1;
495: J NUMBER := 1;
745:
746: PROCEDURE Update_Line_Rec
747: (p_line_index IN NUMBER
748: ,p_atp_index IN NUMBER
749: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
750: ,p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
751: )
752: IS
753: l_time_to_ship NUMBER;
1009: END Update_Line_Rec;
1010:
1011: PROCEDURE Update_MRP_Results
1012: (p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
1013: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1014: ,p_x_atp_line_map_rec IN OUT NOCOPY OE_WSH_BULK_GRP.T_NUM
1015: )
1016: IS
1017: J NUMBER;
1010:
1011: PROCEDURE Update_MRP_Results
1012: (p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
1013: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1014: ,p_x_atp_line_map_rec IN OUT NOCOPY OE_WSH_BULK_GRP.T_NUM
1015: )
1016: IS
1017: J NUMBER;
1018: --
1079: -- Scheduling updates are done directly on the line record.
1080: ---------------------------------------------------------------------
1081:
1082: PROCEDURE Schedule_Orders
1083: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1084: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
1085: ,x_return_status OUT NOCOPY VARCHAR2)
1086: IS
1087: l_msg_text VARCHAR2(2000);
1094: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
1095: l_mrp_msg_data VARCHAR2(200);
1096: l_start_time NUMBER;
1097: l_end_time NUMBER;
1098: l_atp_line_map_rec OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
1099: --
1100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1101: --
1102: BEGIN