eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_ASSIGNMENT_PVT dependencies on MRP_GLOBALS

Line 12: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type

8: -- Assignment_Set
9:
10: PROCEDURE Assignment_Set
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
13: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
14: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
15: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
16: , x_old_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

Line 20: l_control_rec MRP_GLOBALS.Control_Rec_Type;

16: , x_old_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec MRP_GLOBALS.Control_Rec_Type;
21: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
22: l_old_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
23:
24: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;

Line 30: l_control_rec := MRP_GLOBALS.Init_Control_Rec

26: BEGIN
27:
28: -- Load API control record
29:
30: l_control_rec := MRP_GLOBALS.Init_Control_Rec
31: ( p_operation => l_Assignment_Set_rec.operation
32: , p_control_rec => p_control_rec
33: );
34:

Line 41: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_CREATE THEN

37: l_Assignment_Set_rec.return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: -- Prepare record.
40:
41: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_CREATE THEN
42:
43: l_Assignment_Set_rec.db_flag := FND_API.G_FALSE;
44:
45: -- Set missing old record elements to NULL.

Line 50: ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE

46:
47: l_old_Assignment_Set_rec :=
48: MRP_Assignment_Set_Util.Convert_Miss_To_Null (l_old_Assignment_Set_rec);
49:
50: ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE
51: OR l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE
52: THEN
53:
54: l_Assignment_Set_rec.db_flag := FND_API.G_TRUE;

Line 51: OR l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE

47: l_old_Assignment_Set_rec :=
48: MRP_Assignment_Set_Util.Convert_Miss_To_Null (l_old_Assignment_Set_rec);
49:
50: ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE
51: OR l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE
52: THEN
53:
54: l_Assignment_Set_rec.db_flag := FND_API.G_TRUE;
55:

Line 153: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE THEN

149: -- Entity level validation.
150:
151: IF l_control_rec.validate_entity THEN
152:
153: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE THEN
154:
155: MRP_Validate_Assignment_Set.Entity_Delete
156: ( x_return_status => l_return_status
157: , p_Assignment_Set_rec => l_Assignment_Set_rec

Line 182: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE THEN

178: -- Step 4. Write to DB
179:
180: IF l_control_rec.write_to_db THEN
181:
182: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE THEN
183:
184: MRP_Assignment_Set_Handlers.Delete_Row
185: ( p_Assignment_Set_Id => l_Assignment_Set_rec.Assignment_Set_Id
186: );

Line 196: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE THEN

192: l_Assignment_Set_rec.last_update_date := SYSDATE;
193: l_Assignment_Set_rec.last_updated_by := FND_GLOBAL.USER_ID;
194: l_Assignment_Set_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
195:
196: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
197:
198: MRP_Assignment_Set_Handlers.Update_Row (l_Assignment_Set_rec);
199:
200: ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_CREATE THEN

Line 200: ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_CREATE THEN

196: IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
197:
198: MRP_Assignment_Set_Handlers.Update_Row (l_Assignment_Set_rec);
199:
200: ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_CREATE THEN
201:
202: l_Assignment_Set_rec.creation_date := SYSDATE;
203: l_Assignment_Set_rec.created_by := FND_GLOBAL.USER_ID;
204:

Line 257: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type

253: -- Assignments
254:
255: PROCEDURE Assignments
256: ( p_validation_level IN NUMBER
257: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type
258: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
259: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
260: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
261: , x_old_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

Line 265: l_control_rec MRP_GLOBALS.Control_Rec_Type;

261: , x_old_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
262: )
263: IS
264: l_return_status VARCHAR2(1);
265: l_control_rec MRP_GLOBALS.Control_Rec_Type;
266: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
267: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;
268: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
269: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

Line 293: l_control_rec := MRP_GLOBALS.Init_Control_Rec

289: END IF;
290:
291: -- Load API control record
292:
293: l_control_rec := MRP_GLOBALS.Init_Control_Rec
294: ( p_operation => l_Assignment_rec.operation
295: , p_control_rec => p_control_rec
296: );
297:

Line 304: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE THEN

300: l_Assignment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: -- Prepare record.
303:
304: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE THEN
305:
306: l_Assignment_rec.db_flag := FND_API.G_FALSE;
307:
308: -- Set missing old record elements to NULL.

Line 313: ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE

309:
310: l_old_Assignment_rec :=
311: MRP_Assignment_Util.Convert_Miss_To_Null (l_old_Assignment_rec);
312:
313: ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE
314: OR l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE
315: THEN
316:
317: l_Assignment_rec.db_flag := FND_API.G_TRUE;

Line 314: OR l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE

310: l_old_Assignment_rec :=
311: MRP_Assignment_Util.Convert_Miss_To_Null (l_old_Assignment_rec);
312:
313: ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE
314: OR l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE
315: THEN
316:
317: l_Assignment_rec.db_flag := FND_API.G_TRUE;
318:

Line 416: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE THEN

412: -- Entity level validation.
413:
414: IF l_control_rec.validate_entity THEN
415:
416: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE THEN
417:
418: MRP_Validate_Assignment.Entity_Delete
419: ( x_return_status => l_return_status
420: , p_Assignment_rec => l_Assignment_rec

Line 445: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE THEN

441: -- Step 4. Write to DB
442:
443: IF l_control_rec.write_to_db THEN
444:
445: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE THEN
446:
447: MRP_Assignment_Handlers.Delete_Row
448: ( p_Assignment_Id => l_Assignment_rec.Assignment_Id
449: );

Line 459: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE THEN

455: l_Assignment_rec.last_update_date := SYSDATE;
456: l_Assignment_rec.last_updated_by := FND_GLOBAL.USER_ID;
457: l_Assignment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
458:
459: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
460:
461: MRP_Assignment_Handlers.Update_Row (l_Assignment_rec);
462:
463: ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE THEN

Line 463: ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE THEN

459: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE THEN
460:
461: MRP_Assignment_Handlers.Update_Row (l_Assignment_rec);
462:
463: ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE THEN
464:
465: l_Assignment_rec.creation_date := SYSDATE;
466: l_Assignment_rec.created_by := FND_GLOBAL.USER_ID;
467:

Line 570: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type :=

566: ( p_api_version_number IN NUMBER
567: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
568: , p_commit IN VARCHAR2 := FND_API.G_FALSE
569: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
570: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type :=
571: MRP_GLOBALS.G_MISS_CONTROL_REC
572: , x_return_status OUT NOCOPY VARCHAR2
573: , x_msg_count OUT NOCOPY NUMBER
574: , x_msg_data OUT NOCOPY VARCHAR2

Line 571: MRP_GLOBALS.G_MISS_CONTROL_REC

567: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
568: , p_commit IN VARCHAR2 := FND_API.G_FALSE
569: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
570: , p_control_rec IN MRP_GLOBALS.Control_Rec_Type :=
571: MRP_GLOBALS.G_MISS_CONTROL_REC
572: , x_return_status OUT NOCOPY VARCHAR2
573: , x_msg_count OUT NOCOPY NUMBER
574: , x_msg_data OUT NOCOPY VARCHAR2
575: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=

Line 590: l_control_rec MRP_GLOBALS.Control_Rec_Type;

586: IS
587: l_api_version_number CONSTANT NUMBER := 1.0;
588: l_api_name CONSTANT VARCHAR2(30):= 'Process_Assignment';
589: l_return_status VARCHAR2(1);
590: l_control_rec MRP_GLOBALS.Control_Rec_Type;
591: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
592: l_old_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
593: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
594: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

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

648:
649: -- Perform Assignment_Set group requests.
650:
651: IF p_control_rec.process AND
652: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR
653: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ASSIGNMENT_SET)
654: THEN
655:
656: NULL;

Line 653: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ASSIGNMENT_SET)

649: -- Perform Assignment_Set group requests.
650:
651: IF p_control_rec.process AND
652: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR
653: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ASSIGNMENT_SET)
654: THEN
655:
656: NULL;
657:

Line 666: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE

662: FOR I IN 1..l_Assignment_tbl.COUNT LOOP
663:
664: l_Assignment_rec := l_Assignment_tbl(I);
665:
666: IF l_Assignment_rec.operation = MRP_Globals.G_OPR_CREATE
667: AND (l_Assignment_rec.Assignment_Set_Id IS NULL OR
668: l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM)
669: THEN
670:

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

689:
690: -- Perform Assignment group requests.
691:
692: IF p_control_rec.process AND
693: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR
694: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ASSIGNMENT)
695: THEN
696:
697: FOR I IN 1..l_Assignment_tbl.COUNT LOOP

Line 694: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ASSIGNMENT)

690: -- Perform Assignment group requests.
691:
692: IF p_control_rec.process AND
693: (p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL OR
694: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ASSIGNMENT)
695: THEN
696:
697: FOR I IN 1..l_Assignment_tbl.COUNT LOOP
698:

Line 779: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL

775:
776: -- Step 6. Perform Object group logic
777:
778: IF p_control_rec.process AND
779: p_control_rec.process_entity = MRP_GLOBALS.G_ENTITY_ALL
780: THEN
781:
782: NULL;
783:

Line 938: IF p_Assignment_Set_rec.operation = MRP_Globals.G_OPR_LOCK THEN

934: SAVEPOINT Lock_Assignment_PVT;
935:
936: -- Lock Assignment_Set
937:
938: IF p_Assignment_Set_rec.operation = MRP_Globals.G_OPR_LOCK THEN
939:
940: MRP_Assignment_Set_Handlers.Lock_Row
941: ( p_Assignment_Set_rec => p_Assignment_Set_rec
942: , x_Assignment_Set_rec => x_Assignment_Set_rec

Line 959: IF p_Assignment_tbl(I).operation = MRP_Globals.G_OPR_LOCK THEN

955: -- Lock Assignment
956:
957: FOR I IN 1..p_Assignment_tbl.COUNT LOOP
958:
959: IF p_Assignment_tbl(I).operation = MRP_Globals.G_OPR_LOCK THEN
960:
961: MRP_Assignment_Handlers.Lock_Row
962: ( p_Assignment_rec => p_Assignment_tbl(I)
963: , x_Assignment_rec => l_Assignment_rec