DBA Data[Home] [Help]

APPS.OE_GRP_SCH_UTIL dependencies on OE_GRP_SCH_UTIL

Line 1: PACKAGE BODY OE_GRP_SCH_UTIL AS

1: PACKAGE BODY OE_GRP_SCH_UTIL AS
2: /* $Header: OEXVGRPB.pls 120.3 2005/08/05 07:54:27 kmuruges noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_GRP_SCH_UTIL';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_GRP_SCH_UTIL';

1: PACKAGE BODY OE_GRP_SCH_UTIL AS
2: /* $Header: OEXVGRPB.pls 120.3 2005/08/05 07:54:27 kmuruges noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_GRP_SCH_UTIL';
5:
6: PROCEDURE Query_Lines
7: ( p_header_id IN NUMBER,
8: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);

Line 11: (p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type

7: ( p_header_id IN NUMBER,
8: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);
9:
10: Procedure Validate_Group_Request
11: (p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
12: ,x_return_status OUT NOCOPY VARCHAR2);
13:
14:
15: Procedure Validate_Warehouse

Line 58: oe_debug_pub.add( '..ENTERING OE_GRP_SCH_UTIL.VALIDATE_LINE' , 1 ) ;

54: --
55: BEGIN
56:
57: IF l_debug_level > 0 THEN
58: oe_debug_pub.add( '..ENTERING OE_GRP_SCH_UTIL.VALIDATE_LINE' , 1 ) ;
59: END IF;
60:
61: -- If the quantity on the line is missing or null and if
62: -- the user is trying to performing scheduling, it is an error

Line 430: oe_debug_pub.add( '..EXITING OE_GRP_SCH_UTIL.VALIDATE_LINE WITH ' || L_RETURN_STATUS , 1 ) ;

426:
427: x_return_status := l_return_status;
428:
429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add( '..EXITING OE_GRP_SCH_UTIL.VALIDATE_LINE WITH ' || L_RETURN_STATUS , 1 ) ;
431: END IF;
432: END Validate_Line;
433:
434: /*-------------------------------------------------------------------

Line 456: Procedure Group_Schedule(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type

452: UnSchedule
453:
454: --------------------------------------------------------------------- */
455:
456: Procedure Group_Schedule(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
457: ,x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type
458:
459: ,x_return_status OUT NOCOPY Varchar2)
460:

Line 618: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
618: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
619:
620: l_arrival_set_id NUMBER;
621: l_ato_line_id NUMBER;
622: l_demand_class_code VARCHAR2(30);

Line 694: oe_debug_pub.add( 'ENTERING OE_GRP_SCH_UTIL.SCHEDULE_ORDER' , 1 ) ;

690: --
691: BEGIN
692:
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( 'ENTERING OE_GRP_SCH_UTIL.SCHEDULE_ORDER' , 1 ) ;
695: END IF;
696:
697: /* Bug :2222360 */
698: IF p_sch_action = OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK THEN

Line 1023: oe_debug_pub.add( 'EXITING OE_GRP_SCH_UTIL.SCHEDULE_ORDER' , 1 ) ;

1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add( 'COUNT IS ' || X_MSG_COUNT , 1 ) ;
1021: END IF;
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add( 'EXITING OE_GRP_SCH_UTIL.SCHEDULE_ORDER' , 1 ) ;
1024: END IF;
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026:
1027: /* Bug :2222360 */

Line 1110: Procedure Schedule_ATO(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,

1106: /* ---------------------------------------------------------------
1107: Procedure Schedule_ATO
1108: ---------------------------------------------------------------*/
1109:
1110: Procedure Schedule_ATO(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,
1111: x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
1112:
1113: x_return_status OUT NOCOPY VARCHAR2)
1114:

Line 1517: Procedure Schedule_SMC(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,

1513: /* ---------------------------------------------------------------
1514: Procedure : Schedule_SMC
1515: Description: ** Currently Not Used **
1516: ---------------------------------------------------------------*/
1517: Procedure Schedule_SMC(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,
1518: x_return_status OUT NOCOPY VARCHAR2)
1519:
1520: IS
1521: --

Line 1758: Procedure Schedule_Set(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,

1754: /* ---------------------------------------------------------------
1755: Procedure : Schedule_Set
1756: Description:
1757: ---------------------------------------------------------------*/
1758: Procedure Schedule_Set(p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type,
1759: x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
1760:
1761: x_return_status OUT NOCOPY VARCHAR2)
1762:

Line 3783: oe_debug_pub.add( 'EXITING OE_GRP_SCH_UTIL.QUERY_LINES' , 1 ) ;

3779:
3780:
3781: -- Return fetched table
3782: IF l_debug_level > 0 THEN
3783: oe_debug_pub.add( 'EXITING OE_GRP_SCH_UTIL.QUERY_LINES' , 1 ) ;
3784: END IF;
3785:
3786: -- RETURN l_line_tbl;
3787:

Line 3815: (p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type

3811: that is passed in.
3812:
3813: ---------------------------------------------------------------*/
3814: Procedure Validate_Group_Request
3815: (p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
3816: ,x_return_status OUT NOCOPY VARCHAR2)
3817:
3818: IS
3819: l_return_status VARCHAR2(1);

Line 3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;
3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
3938: l_line_rec OE_ORDER_PUB.line_rec_type;
3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3940: l_out_atp_tbl OE_ATP.atp_tbl_type;
3941: l_return_status VARCHAR2(1);
3942: --l_out_line_rec OE_ORDER_PUB.line_rec_type;
3943: l_old_line_rec OE_ORDER_PUB.line_rec_type;

Line 4480: END OE_GRP_SCH_UTIL;

4476:
4477: END Sch_Multi_selected_lines;
4478:
4479:
4480: END OE_GRP_SCH_UTIL;
4481: