DBA Data[Home] [Help]

APPS.QP_QUALIFIER_RULES_PVT dependencies on QP_QUALIFIER_RULES_UTIL

Line 53: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);

49:
50: --oe_debug_pub.add('setting missing old record to null');
51:
52: l_old_QUALIFIER_RULES_rec :=
53: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);
54:
55: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE
56: OR l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE
57: THEN

Line 66: l_old_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Query_Row

62:
63: IF l_old_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
64: THEN
65:
66: l_old_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Query_Row
67: ( p_qualifier_rule_id => l_QUALIFIER_RULES_rec.qualifier_rule_id
68: );
69:
70: ELSE

Line 75: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);

71:
72: -- Set missing old record elements to NULL.
73:
74: l_old_QUALIFIER_RULES_rec :=
75: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);
76:
77: END IF;
78:
79: -- Complete new record from old

Line 81: l_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Complete_Record

77: END IF;
78:
79: -- Complete new record from old
80:
81: l_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Complete_Record
82: ( p_QUALIFIER_RULES_rec => l_QUALIFIER_RULES_rec
83: , p_old_QUALIFIER_RULES_rec => l_old_QUALIFIER_RULES_rec
84: );
85:

Line 142: QP_Qualifier_Rules_Util.Clear_Dependent_Attr

138: -- Clear dependent attributes.
139:
140: IF l_control_rec.change_attributes THEN
141: l_p_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec; --added for nocopy hint
142: QP_Qualifier_Rules_Util.Clear_Dependent_Attr
143: ( p_QUALIFIER_RULES_rec => l_p_QUALIFIER_RULES_rec
144: , p_old_QUALIFIER_RULES_rec => l_old_QUALIFIER_RULES_rec
145: , x_QUALIFIER_RULES_rec => l_QUALIFIER_RULES_rec
146: );

Line 180: QP_Qualifier_Rules_Util.Apply_Attribute_Changes

176: THEN
177:
178: --dbms_output.put_line('calling _rule apply changes attribute');
179: l_p_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec; --added for nocopy hint
180: QP_Qualifier_Rules_Util.Apply_Attribute_Changes
181: ( p_QUALIFIER_RULES_rec => l_p_QUALIFIER_RULES_rec
182: , p_old_QUALIFIER_RULES_rec => l_old_QUALIFIER_RULES_rec
183: , x_QUALIFIER_RULES_rec => l_QUALIFIER_RULES_rec
184: );

Line 225: QP_Qualifier_Rules_Util.Delete_Row

221: IF l_control_rec.write_to_db THEN
222:
223: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
224:
225: QP_Qualifier_Rules_Util.Delete_Row
226: ( p_qualifier_rule_id => l_QUALIFIER_RULES_rec.qualifier_rule_id
227: );
228:
229: ELSE

Line 239: QP_Qualifier_Rules_Util.Update_Row (l_QUALIFIER_RULES_rec);

235: l_QUALIFIER_RULES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
236:
237: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
238:
239: QP_Qualifier_Rules_Util.Update_Row (l_QUALIFIER_RULES_rec);
240:
241: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
242:
243: l_QUALIFIER_RULES_rec.creation_date := SYSDATE;

Line 248: QP_Qualifier_Rules_Util.Insert_Row (l_QUALIFIER_RULES_rec);

244: l_QUALIFIER_RULES_rec.created_by := FND_GLOBAL.USER_ID;
245:
246: --dbms_output.put_line('calling _rule insert row');
247: oe_debug_pub.add('calling insert row');
248: QP_Qualifier_Rules_Util.Insert_Row (l_QUALIFIER_RULES_rec);
249:
250: END IF;
251:
252: END IF;

Line 1184: QP_Qualifier_Rules_Util.Lock_Row

1180: -- Lock QUALIFIER_RULES
1181:
1182: IF p_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
1183:
1184: QP_Qualifier_Rules_Util.Lock_Row
1185: ( p_QUALIFIER_RULES_rec => p_QUALIFIER_RULES_rec
1186: , x_QUALIFIER_RULES_rec => x_QUALIFIER_RULES_rec
1187: , x_return_status => l_return_status
1188: );

Line 1345: l_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Query_Row

1341: END IF;
1342:
1343: -- Get QUALIFIER_RULES ( parent = QUALIFIER_RULES )
1344:
1345: l_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Query_Row
1346: ( p_qualifier_rule_id => p_qualifier_rule_id
1347: );
1348:
1349: -- Get QUALIFIERS ( parent = QUALIFIER_RULES )