DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_PVT dependencies on OE_PRICE_LIST_UTIL

Line 66: OE_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);

62:
63: -- Set missing old record elements to NULL.
64:
65: l_old_PRICE_LIST_rec :=
66: OE_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);
67:
68: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE
69: OR l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_DELETE
70: THEN

Line 80: l_old_PRICE_LIST_rec := OE_Price_List_Util.Query_Row

76: IF l_old_PRICE_LIST_rec.Name = FND_API.G_MISS_CHAR
77: OR l_old_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
78: THEN
79:
80: l_old_PRICE_LIST_rec := OE_Price_List_Util.Query_Row
81: ( p_name => l_PRICE_LIST_rec.name
82: , p_price_list_id => l_PRICE_LIST_rec.price_list_id
83: );
84:

Line 90: OE_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);

86:
87: -- Set missing old record elements to NULL.
88:
89: l_old_PRICE_LIST_rec :=
90: OE_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);
91:
92: END IF;
93:
94: -- Complete new record from old

Line 96: l_PRICE_LIST_rec := OE_Price_List_Util.Complete_Record

92: END IF;
93:
94: -- Complete new record from old
95:
96: l_PRICE_LIST_rec := OE_Price_List_Util.Complete_Record
97: ( p_PRICE_LIST_rec => l_PRICE_LIST_rec
98: , p_old_PRICE_LIST_rec => l_old_PRICE_LIST_rec
99: );
100:

Line 131: OE_Price_List_Util.Clear_Dependent_Attr

127: -- Clear dependent attributes.
128:
129: IF l_control_rec.change_attributes THEN
130: l_p_PRICE_LIST_rec := l_PRICE_LIST_rec;
131: OE_Price_List_Util.Clear_Dependent_Attr
132: ( p_PRICE_LIST_rec => l_p_PRICE_LIST_rec
133: , p_old_PRICE_LIST_rec => l_old_PRICE_LIST_rec
134: , x_PRICE_LIST_rec => l_PRICE_LIST_rec
135: );

Line 158: OE_Price_List_Util.Apply_Attribute_Changes

154: IF l_control_rec.default_attributes
155: OR l_control_rec.change_attributes
156: THEN
157: l_p_PRICE_LIST_rec := l_PRICE_LIST_rec;
158: OE_Price_List_Util.Apply_Attribute_Changes
159: ( p_PRICE_LIST_rec => l_p_PRICE_LIST_rec
160: , p_old_PRICE_LIST_rec => l_old_PRICE_LIST_rec
161: , x_PRICE_LIST_rec => l_PRICE_LIST_rec
162: );

Line 201: OE_Price_List_Util.Delete_Row

197: IF l_control_rec.write_to_db THEN
198:
199: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
200:
201: OE_Price_List_Util.Delete_Row
202: ( p_name => l_PRICE_LIST_rec.name
203: , p_price_list_id => l_PRICE_LIST_rec.price_list_id
204: );
205:

Line 216: OE_Price_List_Util.Update_Row (l_PRICE_LIST_rec);

212: l_PRICE_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
213:
214: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
215:
216: OE_Price_List_Util.Update_Row (l_PRICE_LIST_rec);
217:
218: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
219:
220: l_PRICE_LIST_rec.creation_date := SYSDATE;

Line 223: OE_Price_List_Util.Insert_Row (l_PRICE_LIST_rec);

219:
220: l_PRICE_LIST_rec.creation_date := SYSDATE;
221: l_PRICE_LIST_rec.created_by := FND_GLOBAL.USER_ID;
222:
223: OE_Price_List_Util.Insert_Row (l_PRICE_LIST_rec);
224:
225: END IF;
226:
227: END IF;

Line 870: OE_Price_List_Util.Lock_Row

866: -- Lock PRICE_LIST
867:
868: IF p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN
869:
870: OE_Price_List_Util.Lock_Row
871: ( p_PRICE_LIST_rec => p_PRICE_LIST_rec
872: , x_PRICE_LIST_rec => x_PRICE_LIST_rec
873: , x_return_status => l_return_status
874: );

Line 1032: l_PRICE_LIST_rec := OE_Price_List_Util.Query_Row

1028: END IF;
1029:
1030: -- Get PRICE_LIST ( parent = PRICE_LIST )
1031:
1032: l_PRICE_LIST_rec := OE_Price_List_Util.Query_Row
1033: ( p_name => p_name
1034: , p_price_list_id => p_price_list_id
1035: );
1036: