162: x_qualifier_rule_id := l_x_QUALIFIER_RULES_rec.qualifier_rule_id;
163:
164: -- Load display out parameters if any
165:
166: l_QUALIFIER_RULES_val_rec := QP_Qualifier_Rules_Util.Get_Values
167: ( p_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
168: );
169: x_qualifier_rule := l_QUALIFIER_RULES_val_rec.qualifier_rule;
170:
322: );
323:
324: l_old_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec;
325:
326: IF p_attr_id = QP_Qualifier_Rules_Util.G_DESCRIPTION THEN
327: l_QUALIFIER_RULES_rec.description := p_attr_value;
328: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_NAME THEN
329: l_QUALIFIER_RULES_rec.name := p_attr_value;
330: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_QUALIFIER_RULE THEN
324: l_old_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec;
325:
326: IF p_attr_id = QP_Qualifier_Rules_Util.G_DESCRIPTION THEN
327: l_QUALIFIER_RULES_rec.description := p_attr_value;
328: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_NAME THEN
329: l_QUALIFIER_RULES_rec.name := p_attr_value;
330: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_QUALIFIER_RULE THEN
331: l_QUALIFIER_RULES_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
326: IF p_attr_id = QP_Qualifier_Rules_Util.G_DESCRIPTION THEN
327: l_QUALIFIER_RULES_rec.description := p_attr_value;
328: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_NAME THEN
329: l_QUALIFIER_RULES_rec.name := p_attr_value;
330: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_QUALIFIER_RULE THEN
331: l_QUALIFIER_RULES_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
328: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_NAME THEN
329: l_QUALIFIER_RULES_rec.name := p_attr_value;
330: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_QUALIFIER_RULE THEN
331: l_QUALIFIER_RULES_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
329: l_QUALIFIER_RULES_rec.name := p_attr_value;
330: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_QUALIFIER_RULE THEN
331: l_QUALIFIER_RULES_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
330: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_QUALIFIER_RULE THEN
331: l_QUALIFIER_RULES_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
331: l_QUALIFIER_RULES_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
332: ELSIF p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE1
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
333: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE10
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
334: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE11
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
335: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE12
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
336: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE13
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
337: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE14
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
338: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE15
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
346: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE9
339: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE2
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
346: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE9
347: OR p_attr_id = QP_Qualifier_Rules_Util.G_CONTEXT
340: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE3
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
346: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE9
347: OR p_attr_id = QP_Qualifier_Rules_Util.G_CONTEXT
348: THEN
341: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE4
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
346: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE9
347: OR p_attr_id = QP_Qualifier_Rules_Util.G_CONTEXT
348: THEN
349:
342: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE5
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
346: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE9
347: OR p_attr_id = QP_Qualifier_Rules_Util.G_CONTEXT
348: THEN
349:
350: l_QUALIFIER_RULES_rec.attribute1 := p_attribute1;
343: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE6
344: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE7
345: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE8
346: OR p_attr_id = QP_Qualifier_Rules_Util.G_ATTRIBUTE9
347: OR p_attr_id = QP_Qualifier_Rules_Util.G_CONTEXT
348: THEN
349:
350: l_QUALIFIER_RULES_rec.attribute1 := p_attribute1;
351: l_QUALIFIER_RULES_rec.attribute10 := p_attribute10;
436: x_qualifier_rule := FND_API.G_MISS_CHAR;
437:
438: -- Load display out parameters if any
439:
440: l_QUALIFIER_RULES_val_rec := QP_Qualifier_Rules_Util.Get_Values
441: ( p_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
442: , p_old_QUALIFIER_RULES_rec => l_QUALIFIER_RULES_rec
443: );
444:
1318: THEN
1319:
1320: -- Query row from DB
1321:
1322: g_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Query_Row
1323: ( p_qualifier_rule_id => p_qualifier_rule_id
1324: );
1325:
1326: g_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;