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_SRC_ASSIGNMENT_PUB

Line 13: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

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
17: )

Line 14: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

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
17: )
18: IS

Line 15: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

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
17: )
18: IS
19: l_return_status VARCHAR2(1);

Line 16: , x_old_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

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
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec MRP_GLOBALS.Control_Rec_Type;

Line 21: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;

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;
25: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;

Line 22: l_old_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;

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;
25: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
26: BEGIN

Line 24: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;

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;
25: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
26: BEGIN
27:
28: -- Load API control record

Line 25: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;

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;
25: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
26: BEGIN
27:
28: -- Load API control record
29:

Line 258: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type

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
262: )

Line 259: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type

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
262: )
263: IS

Line 260: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

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
262: )
263: IS
264: l_return_status VARCHAR2(1);

Line 261: , x_old_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

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
262: )
263: IS
264: l_return_status VARCHAR2(1);
265: l_control_rec MRP_GLOBALS.Control_Rec_Type;

Line 266: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_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;
270: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

Line 267: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;

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;
270: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
271: BEGIN

Line 268: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

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;
270: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
271: BEGIN
272:

Line 269: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

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;
270: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
271: BEGIN
272:
273: -- Init local table variables.

Line 270: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_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;
270: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
271: BEGIN
272:
273: -- Init local table variables.
274:

Line 288: l_old_Assignment_rec := MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_REC;

284:
285: IF l_old_Assignment_tbl.EXISTS(I) THEN
286: l_old_Assignment_rec := l_old_Assignment_tbl(I);
287: ELSE
288: l_old_Assignment_rec := MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_REC;
289: END IF;
290:
291: -- Load API control record
292:

Line 575: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_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 :=
576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=

Line 576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_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 :=
576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL

Line 577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=

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 :=
576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=

Line 578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC

574: , x_msg_data OUT NOCOPY VARCHAR2
575: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL

Line 579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=

575: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

Line 580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL

576: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
584: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

Line 581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=

577: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
584: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
585: )

Line 582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL

578: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
584: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
585: )
586: IS

Line 583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

579: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
584: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
585: )
586: IS
587: l_api_version_number CONSTANT NUMBER := 1.0;

Line 584: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

580: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
581: , p_old_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
582: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
583: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
584: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
585: )
586: IS
587: l_api_version_number CONSTANT NUMBER := 1.0;
588: l_api_name CONSTANT VARCHAR2(30):= 'Process_Assignment';

Line 591: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;

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;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

Line 592: l_old_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;

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;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

Line 593: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

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;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

Line 594: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

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;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:

Line 595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_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;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;

Line 596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

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;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;

Line 597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

593: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
594: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
601: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;

Line 599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;

595: l_old_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
601: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;
602: l_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
603:

Line 600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;

596: l_old_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
601: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;
602: l_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
603:
604: l_src_rule_org_id NUMBER;

Line 601: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;

597: l_old_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
601: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;
602: l_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
603:
604: l_src_rule_org_id NUMBER;
605: l_category_set_id NUMBER;

Line 602: l_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

598:
599: l_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
600: l_old_Assignment_Set_rec_out MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_old_Assignment_Set_rec;
601: l_Assignment_rec_out MRP_Src_Assignment_PUB.Assignment_Rec_Type;
602: l_Assignment_tbl_out MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
603:
604: l_src_rule_org_id NUMBER;
605: l_category_set_id NUMBER;
606: l_organization_id NUMBER := FND_API.G_MISS_NUM;

Line 900: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=

896: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
897: , x_return_status OUT NOCOPY VARCHAR2
898: , x_msg_count OUT NOCOPY NUMBER
899: , x_msg_data OUT NOCOPY VARCHAR2
900: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

Line 901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC

897: , x_return_status OUT NOCOPY VARCHAR2
898: , x_msg_count OUT NOCOPY NUMBER
899: , x_msg_data OUT NOCOPY VARCHAR2
900: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
905: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

Line 902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=

898: , x_msg_count OUT NOCOPY NUMBER
899: , x_msg_data OUT NOCOPY VARCHAR2
900: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
905: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
906: )

Line 903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL

899: , x_msg_data OUT NOCOPY VARCHAR2
900: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
905: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
906: )
907: IS

Line 904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

900: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
905: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
906: )
907: IS
908: l_api_version_number CONSTANT NUMBER := 1.0;

Line 905: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

901: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
902: , p_Assignment_tbl IN MRP_Src_Assignment_PUB.Assignment_Tbl_Type :=
903: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_TBL
904: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
905: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
906: )
907: IS
908: l_api_version_number CONSTANT NUMBER := 1.0;
909: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Assignment';

Line 911: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

907: IS
908: l_api_version_number CONSTANT NUMBER := 1.0;
909: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Assignment';
910: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
911: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
912: BEGIN
913:
914: -- Standard call to check for call compatibility
915:

Line 1071: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type

1067: , x_return_status OUT NOCOPY VARCHAR2
1068: , x_msg_count OUT NOCOPY NUMBER
1069: , x_msg_data OUT NOCOPY VARCHAR2
1070: , p_Assignment_Set_Id IN NUMBER
1071: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
1072: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
1073: )
1074: IS
1075: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1072: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type

1068: , x_msg_count OUT NOCOPY NUMBER
1069: , x_msg_data OUT NOCOPY VARCHAR2
1070: , p_Assignment_Set_Id IN NUMBER
1071: , x_Assignment_Set_rec OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
1072: , x_Assignment_tbl OUT NOCOPY MRP_Src_Assignment_PUB.Assignment_Tbl_Type
1073: )
1074: IS
1075: l_api_version_number CONSTANT NUMBER := 1.0;
1076: l_api_name CONSTANT VARCHAR2(30):= 'Get_Assignment';

Line 1077: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;

1073: )
1074: IS
1075: l_api_version_number CONSTANT NUMBER := 1.0;
1076: l_api_name CONSTANT VARCHAR2(30):= 'Get_Assignment';
1077: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
1078: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
1079: BEGIN
1080:
1081: -- Standard call to check for call compatibility

Line 1078: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

1074: IS
1075: l_api_version_number CONSTANT NUMBER := 1.0;
1076: l_api_name CONSTANT VARCHAR2(30):= 'Get_Assignment';
1077: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
1078: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
1079: BEGIN
1080:
1081: -- Standard call to check for call compatibility
1082: