DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_PVT dependencies on QP_FORMULA_UTIL

Line 50: QP_Formula_Util.Convert_Miss_To_Null (l_old_FORMULA_rec);

46:
47: -- Set missing old record elements to NULL.
48:
49: l_old_FORMULA_rec :=
50: QP_Formula_Util.Convert_Miss_To_Null (l_old_FORMULA_rec);
51:
52: ELSIF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_UPDATE
53: OR l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_DELETE
54: THEN

Line 63: l_old_FORMULA_rec := QP_Formula_Util.Query_Row

59:
60: IF l_old_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
61: THEN
62:
63: l_old_FORMULA_rec := QP_Formula_Util.Query_Row
64: ( p_price_formula_id => l_FORMULA_rec.price_formula_id
65: );
66:
67: ELSE

Line 72: QP_Formula_Util.Convert_Miss_To_Null (l_old_FORMULA_rec);

68:
69: -- Set missing old record elements to NULL.
70:
71: l_old_FORMULA_rec :=
72: QP_Formula_Util.Convert_Miss_To_Null (l_old_FORMULA_rec);
73:
74: END IF;
75:
76: -- Complete new record from old

Line 78: l_FORMULA_rec := QP_Formula_Util.Complete_Record

74: END IF;
75:
76: -- Complete new record from old
77:
78: l_FORMULA_rec := QP_Formula_Util.Complete_Record
79: ( p_FORMULA_rec => l_FORMULA_rec
80: , p_old_FORMULA_rec => l_old_FORMULA_rec
81: );
82:

Line 119: QP_Formula_Util.Clear_Dependent_Attr

115: IF l_control_rec.change_attributes THEN
116:
117: l_p_FORMULA_rec := l_FORMULA_rec; --[prarasto]
118:
119: QP_Formula_Util.Clear_Dependent_Attr
120: ( p_FORMULA_rec => l_p_FORMULA_rec
121: , p_old_FORMULA_rec => l_old_FORMULA_rec
122: , x_FORMULA_rec => l_FORMULA_rec
123: );

Line 150: QP_Formula_Util.Apply_Attribute_Changes

146: THEN
147:
148: l_p_FORMULA_rec := l_FORMULA_rec; --[prarasto]
149:
150: QP_Formula_Util.Apply_Attribute_Changes
151: ( p_FORMULA_rec => l_p_FORMULA_rec
152: , p_old_FORMULA_rec => l_old_FORMULA_rec
153: , x_FORMULA_rec => l_FORMULA_rec
154: );

Line 193: QP_Formula_Util.Delete_Row

189: IF l_control_rec.write_to_db THEN
190:
191: IF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
192:
193: QP_Formula_Util.Delete_Row
194: ( p_price_formula_id => l_FORMULA_rec.price_formula_id
195: );
196:
197: ELSE

Line 207: QP_Formula_Util.Update_Row (l_FORMULA_rec);

203: l_FORMULA_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
204:
205: IF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
206:
207: QP_Formula_Util.Update_Row (l_FORMULA_rec);
208:
209: ELSIF l_FORMULA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
210:
211: l_FORMULA_rec.creation_date := SYSDATE;

Line 214: QP_Formula_Util.Insert_Row (l_FORMULA_rec);

210:
211: l_FORMULA_rec.creation_date := SYSDATE;
212: l_FORMULA_rec.created_by := FND_GLOBAL.USER_ID;
213:
214: QP_Formula_Util.Insert_Row (l_FORMULA_rec);
215:
216: END IF;
217:
218: END IF;

Line 897: QP_Formula_Util.Lock_Row

893: -- Lock FORMULA
894:
895: IF p_FORMULA_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
896:
897: QP_Formula_Util.Lock_Row
898: ( p_FORMULA_rec => p_FORMULA_rec
899: , x_FORMULA_rec => x_FORMULA_rec
900: , x_return_status => l_return_status
901: );

Line 1060: l_FORMULA_rec := QP_Formula_Util.Query_Row

1056: END IF;
1057:
1058: -- Get FORMULA ( parent = FORMULA )
1059:
1060: l_FORMULA_rec := QP_Formula_Util.Query_Row
1061: ( p_price_formula_id => p_price_formula_id
1062: );
1063:
1064: -- Get FORMULA_LINES ( parent = FORMULA )