DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_PVT dependencies on MRP_FLOW_SCHEDULE_PVT

Line 1: PACKAGE BODY MRP_Flow_Schedule_PVT AS

1: PACKAGE BODY MRP_Flow_Schedule_PVT AS
2: /* $Header: MRPVWFSB.pls 115.6 2003/02/13 23:56:58 yulin ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Flow_Schedule_PVT';

2: /* $Header: MRPVWFSB.pls 115.6 2003/02/13 23:56:58 yulin ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Flow_Schedule_PVT';
7:
8: PROCEDURE PUB_Flow_Sched_Val_Rec_To_PVT (
9: p_flow_schedule_Val_rec IN MRP_Flow_Schedule_PUB.Flow_Schedule_Val_Rec_Type ,
10: x_Flow_Schedule_Val_Pvt_Rec OUT NOCOPY Flow_Schedule_Val_Pvt_Rec_Type)

Line 1054: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1050:
1051: PROCEDURE Flow_Schedule
1052: ( p_validation_level IN NUMBER
1053: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
1054: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1055: , x_old_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1056: )
1057: IS
1058: l_return_status VARCHAR2(1);

Line 1055: , x_old_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1051: PROCEDURE Flow_Schedule
1052: ( p_validation_level IN NUMBER
1053: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
1054: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1055: , x_old_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1056: )
1057: IS
1058: l_return_status VARCHAR2(1);
1059: l_control_rec MRP_GLOBALS.Control_Rec_Type;

Line 1060: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := x_flow_schedule_rec;

1056: )
1057: IS
1058: l_return_status VARCHAR2(1);
1059: l_control_rec MRP_GLOBALS.Control_Rec_Type;
1060: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := x_flow_schedule_rec;
1061: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := x_old_flow_schedule_rec;
1062: BEGIN
1063:
1064: -- Load API control record

Line 1061: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := x_old_flow_schedule_rec;

1057: IS
1058: l_return_status VARCHAR2(1);
1059: l_control_rec MRP_GLOBALS.Control_Rec_Type;
1060: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := x_flow_schedule_rec;
1061: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := x_old_flow_schedule_rec;
1062: BEGIN
1063:
1064: -- Load API control record
1065: l_control_rec := MRP_GLOBALS.Init_Control_Rec

Line 1311: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1307: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
1308: , x_return_status OUT NOCOPY VARCHAR2
1309: , x_msg_count OUT NOCOPY NUMBER
1310: , x_msg_data OUT NOCOPY VARCHAR2
1311: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1312: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1313: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1314: , p_explode_bom IN VARCHAR2 := NULL
1315: )

Line 1312: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1308: , x_return_status OUT NOCOPY VARCHAR2
1309: , x_msg_count OUT NOCOPY NUMBER
1310: , x_msg_data OUT NOCOPY VARCHAR2
1311: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1312: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1313: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1314: , p_explode_bom IN VARCHAR2 := NULL
1315: )
1316: IS

Line 1313: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1309: , x_msg_count OUT NOCOPY NUMBER
1310: , x_msg_data OUT NOCOPY VARCHAR2
1311: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1312: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1313: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1314: , p_explode_bom IN VARCHAR2 := NULL
1315: )
1316: IS
1317: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1321: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type :=p_flow_schedule_rec ;

1317: l_api_version_number CONSTANT NUMBER := 1.0;
1318: l_api_name CONSTANT VARCHAR2(30):= 'Process_Flow_Schedule';
1319: l_return_status VARCHAR2(1);
1320: l_control_rec MRP_GLOBALS.Control_Rec_Type;
1321: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type :=p_flow_schedule_rec ;
1322: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type :=p_old_flow_schedule_rec ;
1323: l_error_msg VARCHAR2(2000);
1324: l_error_code NUMBER;
1325: BEGIN

Line 1322: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type :=p_old_flow_schedule_rec ;

1318: l_api_name CONSTANT VARCHAR2(30):= 'Process_Flow_Schedule';
1319: l_return_status VARCHAR2(1);
1320: l_control_rec MRP_GLOBALS.Control_Rec_Type;
1321: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type :=p_flow_schedule_rec ;
1322: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type :=p_old_flow_schedule_rec ;
1323: l_error_msg VARCHAR2(2000);
1324: l_error_code NUMBER;
1325: BEGIN
1326:

Line 1497: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1493: , p_init_msg_list IN VARCHAR2 := NULL
1494: , x_return_status OUT NOCOPY VARCHAR2
1495: , x_msg_count OUT NOCOPY NUMBER
1496: , x_msg_data OUT NOCOPY VARCHAR2
1497: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1498: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1499: )
1500: IS
1501: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1498: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1494: , x_return_status OUT NOCOPY VARCHAR2
1495: , x_msg_count OUT NOCOPY NUMBER
1496: , x_msg_data OUT NOCOPY VARCHAR2
1497: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1498: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1499: )
1500: IS
1501: l_api_version_number CONSTANT NUMBER := 1.0;
1502: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Flow_Schedule';

Line 1635: MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1631:
1632: /*
1633: Enhancement : 2665434
1634: Description : Changed x_flow_schedule_rec and l_flow_schedule_rec to be of
1635: MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1636: */
1637:
1638: PROCEDURE Get_Flow_Schedule
1639: ( p_api_version_number IN NUMBER

Line 1645: , x_flow_schedule_rec OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

1641: , x_return_status OUT NOCOPY VARCHAR2
1642: , x_msg_count OUT NOCOPY NUMBER
1643: , x_msg_data OUT NOCOPY VARCHAR2
1644: , p_wip_entity_id IN NUMBER
1645: , x_flow_schedule_rec OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1646: )
1647: IS
1648: l_api_version_number CONSTANT NUMBER := 1.0;
1649: l_api_name CONSTANT VARCHAR2(30):= 'Get_Flow_Schedule';

Line 1650: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;

1646: )
1647: IS
1648: l_api_version_number CONSTANT NUMBER := 1.0;
1649: l_api_name CONSTANT VARCHAR2(30):= 'Get_Flow_Schedule';
1650: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
1651: BEGIN
1652:
1653: -- Standard call to check for call compatibility
1654:

Line 1738: END MRP_Flow_Schedule_PVT;

1734: );
1735:
1736: END Get_Flow_Schedule;
1737:
1738: END MRP_Flow_Schedule_PVT;