51: -- Procedure Clear_Dependent_Attr
52:
53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
52:
53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
60:
53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
60:
61: -- Procedure Apply_Attribute_Changes
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
60:
61: -- Procedure Apply_Attribute_Changes
62:
60:
61: -- Procedure Apply_Attribute_Changes
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
61: -- Procedure Apply_Attribute_Changes
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
69:
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
69:
70: -- Function Complete_Record
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
69:
70: -- Function Complete_Record
71:
69:
70: -- Function Complete_Record
71:
72: FUNCTION Complete_Record
73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
70: -- Function Complete_Record
71:
72: FUNCTION Complete_Record
73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:
71:
72: FUNCTION Complete_Record
73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
81: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
82:
83: -- Procedure Update_Row
84:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
81: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row
82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row
86: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
87: );
88:
89: -- Procedure Insert_Row
90:
88:
89: -- Procedure Insert_Row
90:
91: PROCEDURE Insert_Row
92: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
93: );
94:
95: -- Procedure Delete_Row
96:
101: -- Function Query_Row
102:
103: FUNCTION Query_Row
104: ( p_limit_id IN NUMBER
105: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
106:
107: -- Procedure lock_Row
108: --
109:
108: --
109:
110: PROCEDURE Lock_Row
111: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
113: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
114: );
115:
116: -- Function Get_Values
109:
110: PROCEDURE Lock_Row
111: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
113: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
114: );
115:
116: -- Function Get_Values
117:
115:
116: -- Function Get_Values
117:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
116: -- Function Get_Values
117:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
124: -- Function Get_Ids
117:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
124: -- Function Get_Ids
125:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
124: -- Function Get_Ids
125:
126: FUNCTION Get_Ids
123:
124: -- Function Get_Ids
125:
126: FUNCTION Get_Ids
127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
124: -- Function Get_Ids
125:
126: FUNCTION Get_Ids
127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
125:
126: FUNCTION Get_Ids
127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
137:
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
137:
138:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
137:
138:
139: END QP_Limits_Util;