DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_PVT dependencies on MRP_GLOBALS

Line 1053: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type

1049: -- Flow_Schedule
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

Line 1059: l_control_rec MRP_GLOBALS.Control_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;
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:

Line 1065: l_control_rec := MRP_GLOBALS.Init_Control_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
1066: ( p_operation => l_flow_schedule_rec.operation
1067: , p_control_rec => p_control_rec
1068: );
1069:

Line 1076: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN

1072: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: -- Prepare record.
1075:
1076: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN
1077:
1078: l_flow_schedule_rec.db_flag := FND_API.G_FALSE;
1079:
1080: -- Set missing old record elements to NULL.

Line 1086: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE

1082: l_old_flow_schedule_rec :=
1083: MRP_Flow_Schedule_Util.Convert_Miss_To_Null (l_old_flow_schedule_rec);
1084:
1085:
1086: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE
1087: OR l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE
1088: THEN
1089: l_flow_schedule_rec.db_flag := FND_API.G_TRUE;
1090:

Line 1087: OR l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE

1083: MRP_Flow_Schedule_Util.Convert_Miss_To_Null (l_old_flow_schedule_rec);
1084:
1085:
1086: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE
1087: OR l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE
1088: THEN
1089: l_flow_schedule_rec.db_flag := FND_API.G_TRUE;
1090:
1091: -- Query Old if missing

Line 1144: IF l_control_rec.change_attributes and l_flow_schedule_rec.operation <> MRP_GLOBALS.G_OPR_CREATE THEN

1140: END IF;
1141:
1142: -- Clear dependent attributes.
1143:
1144: IF l_control_rec.change_attributes and l_flow_schedule_rec.operation <> MRP_GLOBALS.G_OPR_CREATE THEN
1145:
1146: MRP_Flow_Schedule_Util.Clear_Dependent_Attr
1147: ( p_flow_schedule_rec => l_flow_schedule_rec
1148: , p_old_flow_schedule_rec => l_old_flow_schedule_rec

Line 1185: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE THEN

1181: -- Entity level validation.
1182:
1183: IF l_control_rec.validate_entity THEN
1184:
1185: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE THEN
1186:
1187: MRP_Validate_Flow_Schedule.Entity_Delete
1188: ( x_return_status => l_return_status
1189: , p_flow_schedule_rec => l_flow_schedule_rec

Line 1214: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE THEN

1210: -- Step 4. Write to DB
1211:
1212: IF l_control_rec.write_to_db THEN
1213:
1214: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE THEN
1215:
1216: MRP_Flow_Schedule_Util.Delete_Row
1217: ( p_wip_entity_id => l_flow_schedule_rec.wip_entity_id
1218: );

Line 1229: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE THEN

1225: l_flow_schedule_rec.last_update_date := SYSDATE;
1226: l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;
1227: l_flow_schedule_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1228:
1229: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE THEN
1230:
1231: MRP_Flow_Schedule_Util.Update_Row (l_flow_schedule_rec);
1232:
1233: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN

Line 1233: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN

1229: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE THEN
1230:
1231: MRP_Flow_Schedule_Util.Update_Row (l_flow_schedule_rec);
1232:
1233: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN
1234:
1235: l_flow_schedule_rec.creation_date := SYSDATE;
1236: l_flow_schedule_rec.created_by := FND_GLOBAL.USER_ID;
1237:

Line 1307: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type

1303: ( p_api_version_number IN NUMBER
1304: , p_init_msg_list IN VARCHAR2 := NULL
1305: , p_commit IN VARCHAR2 := NULL
1306: , p_validation_level IN NUMBER := NULL
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

Line 1320: l_control_rec MRP_GLOBALS.Control_Rec_Type;

1316: IS
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;

Line 1358: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR

1354:
1355: -- Perform flow_schedule group requests.
1356:
1357: IF p_control_rec.process AND
1358: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR
1359: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_FLOW_SCHEDULE)
1360: THEN
1361:
1362: NULL;

Line 1359: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_FLOW_SCHEDULE)

1355: -- Perform flow_schedule group requests.
1356:
1357: IF p_control_rec.process AND
1358: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR
1359: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_FLOW_SCHEDULE)
1360: THEN
1361:
1362: NULL;
1363:

Line 1369: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL

1365:
1366: -- Step 6. Perform Object group logic
1367:
1368: IF p_control_rec.process AND
1369: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL
1370: THEN
1371:
1372: NULL;
1373:

Line 1530: IF p_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_LOCK THEN

1526: SAVEPOINT Lock_Flow_Schedule_PVT;
1527:
1528: -- Lock flow_schedule
1529:
1530: IF p_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_LOCK THEN
1531:
1532: MRP_Flow_Schedule_Util.Lock_Row
1533: ( p_flow_schedule_rec => p_flow_schedule_rec
1534: , x_flow_schedule_rec => x_flow_schedule_rec