128: -- Procedure Clear_Dependent_Attr
129:
130: PROCEDURE Clear_Dependent_Attr
131: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
132: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
133: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
134: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
135: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
136: );
129:
130: PROCEDURE Clear_Dependent_Attr
131: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
132: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
133: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
134: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
135: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
136: );
137:
130: PROCEDURE Clear_Dependent_Attr
131: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
132: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
133: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
134: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
135: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
136: );
137:
138: -- Procedure Apply_Attribute_Changes
131: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
132: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
133: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
134: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
135: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
136: );
137:
138: -- Procedure Apply_Attribute_Changes
139:
137:
138: -- Procedure Apply_Attribute_Changes
139:
140: PROCEDURE Apply_Attribute_Changes
141: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
142: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
143: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
144: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
145: );
138: -- Procedure Apply_Attribute_Changes
139:
140: PROCEDURE Apply_Attribute_Changes
141: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
142: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
143: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
144: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
145: );
146:
139:
140: PROCEDURE Apply_Attribute_Changes
141: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
142: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
143: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
144: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
145: );
146:
147: -- Function Complete_Record
140: PROCEDURE Apply_Attribute_Changes
141: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
142: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
143: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
144: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
145: );
146:
147: -- Function Complete_Record
148:
146:
147: -- Function Complete_Record
148:
149: FUNCTION Complete_Record
150: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
151: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
152: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
153:
154: -- Function Convert_Miss_To_Null
147: -- Function Complete_Record
148:
149: FUNCTION Complete_Record
150: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
151: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
152: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
153:
154: -- Function Convert_Miss_To_Null
155:
148:
149: FUNCTION Complete_Record
150: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
151: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
152: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
153:
154: -- Function Convert_Miss_To_Null
155:
156: FUNCTION Convert_Miss_To_Null
153:
154: -- Function Convert_Miss_To_Null
155:
156: FUNCTION Convert_Miss_To_Null
157: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
158: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
159:
160: -- Procedure Update_Row
161:
154: -- Function Convert_Miss_To_Null
155:
156: FUNCTION Convert_Miss_To_Null
157: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
158: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
159:
160: -- Procedure Update_Row
161:
162: PROCEDURE Update_Row
159:
160: -- Procedure Update_Row
161:
162: PROCEDURE Update_Row
163: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
164: );
165:
166: -- Procedure Insert_Row
167:
165:
166: -- Procedure Insert_Row
167:
168: PROCEDURE Insert_Row
169: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
170: );
171:
172: -- Procedure Delete_Row
173:
178: -- Function Query_Row
179:
180: FUNCTION Query_Row
181: ( p_list_header_id IN NUMBER
182: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
183:
184: -- Procedure lock_Row
185: --
186:
185: --
186:
187: PROCEDURE Lock_Row
188: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
190: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
191: );
192:
193: -- Function Get_Values
186:
187: PROCEDURE Lock_Row
188: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
190: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
191: );
192:
193: -- Function Get_Values
194:
192:
193: -- Function Get_Values
194:
195: FUNCTION Get_Values
196: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
197: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
198: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
199: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200:
193: -- Function Get_Values
194:
195: FUNCTION Get_Values
196: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
197: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
198: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
199: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200:
201: -- Function Get_Ids
194:
195: FUNCTION Get_Values
196: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
197: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
198: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
199: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200:
201: -- Function Get_Ids
202:
195: FUNCTION Get_Values
196: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
197: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
198: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
199: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200:
201: -- Function Get_Ids
202:
203: FUNCTION Get_Ids
200:
201: -- Function Get_Ids
202:
203: FUNCTION Get_Ids
204: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
205: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
206: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
207:
208: FUNCTION Get_Segment_Level_for_Group
201: -- Function Get_Ids
202:
203: FUNCTION Get_Ids
204: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
205: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
206: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
207:
208: FUNCTION Get_Segment_Level_for_Group
209: (p_list_header_id IN NUMBER
202:
203: FUNCTION Get_Ids
204: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
205: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
206: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
207:
208: FUNCTION Get_Segment_Level_for_Group
209: (p_list_header_id IN NUMBER
210: ,p_list_line_id IN NUMBER