40: -- Procedure Clear_Dependent_Attr
41:
42: PROCEDURE Clear_Dependent_Attr
43: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
44: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
45: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
46: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
47: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
48: );
41:
42: PROCEDURE Clear_Dependent_Attr
43: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
44: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
45: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
46: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
47: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
48: );
49:
42: PROCEDURE Clear_Dependent_Attr
43: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
44: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
45: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
46: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
47: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
48: );
49:
50: -- Procedure Apply_Attribute_Changes
43: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
44: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
45: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
46: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
47: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
48: );
49:
50: -- Procedure Apply_Attribute_Changes
51:
49:
50: -- Procedure Apply_Attribute_Changes
51:
52: PROCEDURE Apply_Attribute_Changes
53: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
54: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
55: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
56: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
57: );
50: -- Procedure Apply_Attribute_Changes
51:
52: PROCEDURE Apply_Attribute_Changes
53: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
54: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
55: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
56: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
57: );
58:
51:
52: PROCEDURE Apply_Attribute_Changes
53: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
54: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
55: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
56: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
57: );
58:
59: -- Function Complete_Record
52: PROCEDURE Apply_Attribute_Changes
53: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
54: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
55: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
56: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
57: );
58:
59: -- Function Complete_Record
60:
58:
59: -- Function Complete_Record
60:
61: FUNCTION Complete_Record
62: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
63: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
64: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
65:
66: -- Function Convert_Miss_To_Null
59: -- Function Complete_Record
60:
61: FUNCTION Complete_Record
62: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
63: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
64: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
65:
66: -- Function Convert_Miss_To_Null
67:
60:
61: FUNCTION Complete_Record
62: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
63: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
64: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
65:
66: -- Function Convert_Miss_To_Null
67:
68: FUNCTION Convert_Miss_To_Null
65:
66: -- Function Convert_Miss_To_Null
67:
68: FUNCTION Convert_Miss_To_Null
69: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
70: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
71:
72: -- Function Get_Values
73:
66: -- Function Convert_Miss_To_Null
67:
68: FUNCTION Convert_Miss_To_Null
69: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
70: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
71:
72: -- Function Get_Values
73:
74: FUNCTION Get_Values
71:
72: -- Function Get_Values
73:
74: FUNCTION Get_Values
75: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
77: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
78: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
79:
72: -- Function Get_Values
73:
74: FUNCTION Get_Values
75: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
77: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
78: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
79:
80: -- Function Get_Ids
73:
74: FUNCTION Get_Values
75: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
77: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
78: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
79:
80: -- Function Get_Ids
81:
74: FUNCTION Get_Values
75: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
77: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
78: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
79:
80: -- Function Get_Ids
81:
82: FUNCTION Get_Ids
79:
80: -- Function Get_Ids
81:
82: FUNCTION Get_Ids
83: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
84: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
85: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
86:
87: END MRP_Sourcing_Rule_Util;
80: -- Function Get_Ids
81:
82: FUNCTION Get_Ids
83: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
84: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
85: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
86:
87: END MRP_Sourcing_Rule_Util;
81:
82: FUNCTION Get_Ids
83: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
84: , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
85: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
86:
87: END MRP_Sourcing_Rule_Util;