36: -- Procedure Clear_Dependent_Attr
37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
45:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes
47:
45:
46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
54:
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
54:
55: -- Function Complete_Record
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
54:
55: -- Function Complete_Record
56:
54:
55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:
56:
57: FUNCTION Complete_Record
58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
66: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
67:
68: -- Procedure Update_Row
69:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
66: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row
67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row
71: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
72: );
73:
74: -- Procedure Insert_Row
75:
73:
74: -- Procedure Insert_Row
75:
76: PROCEDURE Insert_Row
77: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
78: );
79:
80: -- Procedure Delete_Row
81:
86: -- Function Query_Row
87:
88: FUNCTION Query_Row
89: ( p_qualifier_rule_id IN NUMBER
90: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
91:
92: -- Procedure lock_Row
93: --
94:
93: --
94:
95: PROCEDURE Lock_Row
96: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
98: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
99: );
100:
101: -- Function Get_Values
94:
95: PROCEDURE Lock_Row
96: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
98: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
99: );
100:
101: -- Function Get_Values
102:
100:
101: -- Function Get_Values
102:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
101: -- Function Get_Values
102:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
109: -- Function Get_Ids
102:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
109: -- Function Get_Ids
110:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
109: -- Function Get_Ids
110:
111: FUNCTION Get_Ids
108:
109: -- Function Get_Ids
110:
111: FUNCTION Get_Ids
112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
115:
116: END QP_Qualifier_Rules_Util;
109: -- Function Get_Ids
110:
111: FUNCTION Get_Ids
112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
115:
116: END QP_Qualifier_Rules_Util;
110:
111: FUNCTION Get_Ids
112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
115:
116: END QP_Qualifier_Rules_Util;