DBA Data[Home] [Help]

APPS.OE_BULK_SCHEDULE_UTIL dependencies on OE_BULK_ORDER_PVT

Line 74: OE_Bulk_Order_PVT.G_REQUEST_ID,'LINE' ,NULL

70: ,message_text
71: ,transaction_id
72: )
73: SELECT
74: OE_Bulk_Order_PVT.G_REQUEST_ID,'LINE' ,NULL
75: ,p_line_rec.line_id(l_index)
76: ,p_line_rec.header_id(l_index)
77: ,p_line_rec.line_id(l_index)
78: ,p_line_rec.order_source_id(l_index)

Line 318: OE_BULK_ORDER_PVT.G_ITEM_ORG);

314: p_line_rec.ship_from_org_id(p_ato_index), 1 ) ;
315: END IF;
316:
317: l_org_id := nvl(p_line_rec.ship_from_org_id(p_ato_index),
318: OE_BULK_ORDER_PVT.G_ITEM_ORG);
319:
320: l_c_index := OE_BULK_CACHE.Load_Item
321: (p_key1 => p_line_rec.inventory_item_id(p_ato_index)
322: ,p_key2 => l_org_id

Line 370: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

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

Line 452: OE_BULK_ORDER_PVT.G_ITEM_ORG;

448: p_line_rec.ato_line_id(p_line_index);
449: p_x_atp_rec.parent_line_id(p_atp_index) :=
450: p_line_rec.link_to_line_id(p_line_index);
451: p_x_atp_rec.validation_org(p_atp_index) :=
452: OE_BULK_ORDER_PVT.G_ITEM_ORG;
453: p_x_atp_rec.component_code(p_atp_index) :=
454: p_line_rec.component_code(p_line_index);
455: p_x_atp_rec.component_sequence_id(p_atp_index) :=
456: p_line_rec.component_sequence_id(p_line_index);

Line 489: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

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: )
493: IS

Line 519: /* Extend_MRP_Rec(p_count => OE_BULK_ORDER_PVT.G_SCH_COUNT

515: -- at index position 2 in p_x_atp_rec
516:
517: p_x_atp_line_map_rec.DELETE;
518: --commented out for bug3675870
519: /* Extend_MRP_Rec(p_count => OE_BULK_ORDER_PVT.G_SCH_COUNT
520: ,p_x_atp_rec => p_x_atp_rec
521: );*/
522:
523: --for bug 3675870

Line 526: p_index => OE_BULK_ORDER_PVT.G_SCH_COUNT);

522:
523: --for bug 3675870
524: MSC_SATP_FUNC.Extend_Atp(p_atp_tab=>p_x_atp_rec,
525: x_return_status => l_return_status,
526: p_index => OE_BULK_ORDER_PVT.G_SCH_COUNT);
527: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
528: oe_debug_pub.add('Error while extending ATP record');
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: end if ;

Line 531: p_x_atp_line_map_rec.extend(OE_BULK_ORDER_PVT.G_SCH_COUNT);

527: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
528: oe_debug_pub.add('Error while extending ATP record');
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: end if ;
531: p_x_atp_line_map_rec.extend(OE_BULK_ORDER_PVT.G_SCH_COUNT);
532:
533: IF nvl(FND_PROFILE.VALUE('MRP_ATP_CALC_SD'),'N') = 'Y' THEN
534: G_INSERT_FLAG := 1;
535: ELSE

Line 576: IF OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N' AND

572:
573: -- Add check here for HOLDS if the profile option schedule lines on hold is
574: -- False.
575:
576: IF OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N' AND
577: p_line_rec.item_type_code(I) <> 'STANDARD'
578: THEN
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add( 'Calling check for holds :'||J ) ;

Line 677: IF OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N' THEN

673:
674: l_result := FALSE;
675:
676: -- If Schedule Lines on holds is False then
677: IF OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N' THEN
678:
679: -- Call check for holds
680: l_result := OE_Bulk_Holds_PVT.Check_For_Holds(
681: p_header_id => p_line_rec.header_id(l_ii_index),

Line 955: IF OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE IS NOT NULL THEN

951: --p_line_rec.last_updated_by(p_line_index) := FND_GLOBAL.USER_ID;
952: --p_line_rec.last_update_login(p_line_index) := FND_GLOBAL.LOGIN_ID;
953: p_line_rec.lock_control(p_line_index) := (p_line_rec.lock_control(p_line_index) + 1);
954:
955: IF OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE IS NOT NULL THEN
956: -- If ship date is within reservation time fence, populate a message
957: l_time_to_ship := to_number(trunc(p_line_rec.schedule_ship_date(p_line_index)) - trunc(SYSDATE));
958:
959: BEGIN

Line 962: ELSIF l_time_to_ship <= to_number(OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE) THEN

958:
959: BEGIN
960: IF l_time_to_ship < 0 THEN
961: NULL;
962: ELSIF l_time_to_ship <= to_number(OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE) THEN
963: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RSV');
964: OE_BULK_MSG_PUB.Add;
965: END IF;
966: EXCEPTION

Line 1084: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

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);
1088: l_msg_count NUMBER;