APPS.MRP_SOURCING_RULE_UTIL dependencies on MRP_SOURCING_RULE_PUB

Line 12: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
13: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
15: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
16: )

Line 13: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
13: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
15: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
16: )
17: IS

Line 14: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
13: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
15: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
16: )
17: IS
18: BEGIN

Line 15: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
13: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
15: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
16: )
17: IS
18: BEGIN
19:

Line 260: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

256:
257: -- Procedure Apply_Attribute_Changes
258:
259: PROCEDURE Apply_Attribute_Changes
260: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
261: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
262: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
263: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
264: )

Line 261: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=

257: -- Procedure Apply_Attribute_Changes
258:
259: PROCEDURE Apply_Attribute_Changes
260: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
261: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
262: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
263: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
264: )
265: IS

Line 262: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC

258:
259: PROCEDURE Apply_Attribute_Changes
260: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
261: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
262: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
263: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
264: )
265: IS
266: BEGIN

Line 263: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

259: PROCEDURE Apply_Attribute_Changes
260: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
261: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
262: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
263: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
264: )
265: IS
266: BEGIN
267:

Line 437: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

433:
434: -- Function Complete_Record
435:
436: FUNCTION Complete_Record
437: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
438: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
439: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
440: IS
441: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;

Line 438: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

434: -- Function Complete_Record
435:
436: FUNCTION Complete_Record
437: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
438: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
439: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
440: IS
441: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
442: BEGIN

Line 439: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

435:
436: FUNCTION Complete_Record
437: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
438: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
439: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
440: IS
441: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
442: BEGIN
443:

Line 441: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;

437: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
438: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
439: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
440: IS
441: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
442: BEGIN
443:
444: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
445: l_Sourcing_Rule_rec.Sourcing_Rule_Id := p_old_Sourcing_Rule_rec.Sourcing_Rule_Id;

Line 579: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

575:
576: -- Function Convert_Miss_To_Null
577:
578: FUNCTION Convert_Miss_To_Null
579: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
580: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
581: IS
582: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
583: BEGIN

Line 580: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

576: -- Function Convert_Miss_To_Null
577:
578: FUNCTION Convert_Miss_To_Null
579: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
580: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
581: IS
582: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
583: BEGIN
584:

Line 582: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;

578: FUNCTION Convert_Miss_To_Null
579: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
580: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
581: IS
582: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
583: BEGIN
584:
585: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
586: l_Sourcing_Rule_rec.Sourcing_Rule_Id := NULL;

Line 720: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

716:
717: -- Function Get_Values
718:
719: FUNCTION Get_Values
720: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
721: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
722: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
723: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
724: IS

Line 721: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=

717: -- Function Get_Values
718:
719: FUNCTION Get_Values
720: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
721: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
722: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
723: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
724: IS
725: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;

Line 722: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC

718:
719: FUNCTION Get_Values
720: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
721: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
722: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
723: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
724: IS
725: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
726: BEGIN

Line 723: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type

719: FUNCTION Get_Values
720: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
721: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
722: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
723: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
724: IS
725: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
726: BEGIN
727:

Line 725: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;

721: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
722: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
723: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
724: IS
725: l_Sourcing_Rule_val_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
726: BEGIN
727:
728: RETURN l_Sourcing_Rule_val_rec;
729:

Line 735: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

731:
732: -- Function Get_Ids
733:
734: FUNCTION Get_Ids
735: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
736: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
737: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
738: IS
739: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;

Line 736: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type

732: -- Function Get_Ids
733:
734: FUNCTION Get_Ids
735: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
736: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
737: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
738: IS
739: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
740: BEGIN

Line 737: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

733:
734: FUNCTION Get_Ids
735: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
736: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
737: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
738: IS
739: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
740: BEGIN
741:

Line 739: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;

735: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
736: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
737: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
738: IS
739: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
740: BEGIN
741:
742: -- initialize return_status.
743: