8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
13: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
14: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
15: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
16: )
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
13: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
14: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
15: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
16: )
17: IS
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
13: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
14: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
15: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
16: )
17: IS
18: BEGIN
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
13: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
14: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
15: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
16: )
17: IS
18: BEGIN
19:
228:
229: -- Procedure Apply_Attribute_Changes
230:
231: PROCEDURE Apply_Attribute_Changes
232: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
233: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
234: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
235: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
236: )
229: -- Procedure Apply_Attribute_Changes
230:
231: PROCEDURE Apply_Attribute_Changes
232: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
233: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
234: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
235: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
236: )
237: IS
230:
231: PROCEDURE Apply_Attribute_Changes
232: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
233: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
234: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
235: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
236: )
237: IS
238: BEGIN
231: PROCEDURE Apply_Attribute_Changes
232: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
233: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
234: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
235: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
236: )
237: IS
238: BEGIN
239:
385:
386: -- Function Complete_Record
387:
388: FUNCTION Complete_Record
389: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
390: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
391: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
392: IS
393: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
386: -- Function Complete_Record
387:
388: FUNCTION Complete_Record
389: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
390: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
391: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
392: IS
393: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
394: BEGIN
387:
388: FUNCTION Complete_Record
389: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
390: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
391: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
392: IS
393: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
394: BEGIN
395:
389: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
390: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
391: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
392: IS
393: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
394: BEGIN
395:
396: IF l_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
397: l_Assignment_Set_rec.Assignment_Set_Id := p_old_Assignment_Set_rec.Assignment_Set_Id;
511:
512: -- Function Convert_Miss_To_Null
513:
514: FUNCTION Convert_Miss_To_Null
515: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
516: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
517: IS
518: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
519: BEGIN
512: -- Function Convert_Miss_To_Null
513:
514: FUNCTION Convert_Miss_To_Null
515: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
516: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
517: IS
518: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
519: BEGIN
520:
514: FUNCTION Convert_Miss_To_Null
515: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
516: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
517: IS
518: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
519: BEGIN
520:
521: IF l_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
522: l_Assignment_Set_rec.Assignment_Set_Id := NULL;
636:
637: -- Function Get_Values
638:
639: FUNCTION Get_Values
640: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
641: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
642: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
643: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
644: IS
637: -- Function Get_Values
638:
639: FUNCTION Get_Values
640: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
641: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
642: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
643: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
644: IS
645: l_Assignment_Set_val_rec MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type;
638:
639: FUNCTION Get_Values
640: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
641: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
642: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
643: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
644: IS
645: l_Assignment_Set_val_rec MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type;
646: BEGIN
639: FUNCTION Get_Values
640: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
641: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
642: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
643: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
644: IS
645: l_Assignment_Set_val_rec MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type;
646: BEGIN
647:
641: , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
642: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
643: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
644: IS
645: l_Assignment_Set_val_rec MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type;
646: BEGIN
647:
648: RETURN l_Assignment_Set_val_rec;
649:
651:
652: -- Function Get_Ids
653:
654: FUNCTION Get_Ids
655: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
656: , p_Assignment_Set_val_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
657: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
658: IS
659: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
652: -- Function Get_Ids
653:
654: FUNCTION Get_Ids
655: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
656: , p_Assignment_Set_val_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
657: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
658: IS
659: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
660: BEGIN
653:
654: FUNCTION Get_Ids
655: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
656: , p_Assignment_Set_val_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
657: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
658: IS
659: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
660: BEGIN
661:
655: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
656: , p_Assignment_Set_val_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
657: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
658: IS
659: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
660: BEGIN
661:
662: -- initialize return_status.
663: