176: x_limit_id := l_x_LIMIT_ATTRS_rec.limit_id;
177:
178: -- Load display out parameters if any
179:
180: l_LIMIT_ATTRS_val_rec := QP_Limit_Attrs_Util.Get_Values
181: ( p_LIMIT_ATTRS_rec => l_x_LIMIT_ATTRS_rec
182: );
183: x_comparison_operator := l_LIMIT_ATTRS_val_rec.comparison_operator;
184: x_limit := l_LIMIT_ATTRS_val_rec.limit;
340: );
341:
342: l_old_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec;
343:
344: IF p_attr_id = QP_Limit_Attrs_Util.G_COMPARISON_OPERATOR THEN
345: l_LIMIT_ATTRS_rec.comparison_operator_code := p_attr_value;
346: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
347: l_LIMIT_ATTRS_rec.limit_attribute := p_attr_value;
348: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_CONTEXT THEN
342: l_old_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec;
343:
344: IF p_attr_id = QP_Limit_Attrs_Util.G_COMPARISON_OPERATOR THEN
345: l_LIMIT_ATTRS_rec.comparison_operator_code := p_attr_value;
346: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
347: l_LIMIT_ATTRS_rec.limit_attribute := p_attr_value;
348: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_CONTEXT THEN
349: l_LIMIT_ATTRS_rec.limit_attribute_context := p_attr_value;
350: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
344: IF p_attr_id = QP_Limit_Attrs_Util.G_COMPARISON_OPERATOR THEN
345: l_LIMIT_ATTRS_rec.comparison_operator_code := p_attr_value;
346: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
347: l_LIMIT_ATTRS_rec.limit_attribute := p_attr_value;
348: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_CONTEXT THEN
349: l_LIMIT_ATTRS_rec.limit_attribute_context := p_attr_value;
350: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
351: l_LIMIT_ATTRS_rec.limit_attribute_id := TO_NUMBER(p_attr_value);
352: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_TYPE THEN
346: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
347: l_LIMIT_ATTRS_rec.limit_attribute := p_attr_value;
348: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_CONTEXT THEN
349: l_LIMIT_ATTRS_rec.limit_attribute_context := p_attr_value;
350: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
351: l_LIMIT_ATTRS_rec.limit_attribute_id := TO_NUMBER(p_attr_value);
352: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_TYPE THEN
353: l_LIMIT_ATTRS_rec.limit_attribute_type := p_attr_value;
354: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_DATATYPE THEN
348: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_CONTEXT THEN
349: l_LIMIT_ATTRS_rec.limit_attribute_context := p_attr_value;
350: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
351: l_LIMIT_ATTRS_rec.limit_attribute_id := TO_NUMBER(p_attr_value);
352: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_TYPE THEN
353: l_LIMIT_ATTRS_rec.limit_attribute_type := p_attr_value;
354: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_DATATYPE THEN
355: l_LIMIT_ATTRS_rec.limit_attr_datatype := p_attr_value;
356: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_VALUE THEN
350: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE THEN
351: l_LIMIT_ATTRS_rec.limit_attribute_id := TO_NUMBER(p_attr_value);
352: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_TYPE THEN
353: l_LIMIT_ATTRS_rec.limit_attribute_type := p_attr_value;
354: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_DATATYPE THEN
355: l_LIMIT_ATTRS_rec.limit_attr_datatype := p_attr_value;
356: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_VALUE THEN
357: l_LIMIT_ATTRS_rec.limit_attr_value := p_attr_value;
358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN
352: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_TYPE THEN
353: l_LIMIT_ATTRS_rec.limit_attribute_type := p_attr_value;
354: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_DATATYPE THEN
355: l_LIMIT_ATTRS_rec.limit_attr_datatype := p_attr_value;
356: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_VALUE THEN
357: l_LIMIT_ATTRS_rec.limit_attr_value := p_attr_value;
358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN
359: l_LIMIT_ATTRS_rec.limit_id := TO_NUMBER(p_attr_value);
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
354: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_DATATYPE THEN
355: l_LIMIT_ATTRS_rec.limit_attr_datatype := p_attr_value;
356: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_VALUE THEN
357: l_LIMIT_ATTRS_rec.limit_attr_value := p_attr_value;
358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN
359: l_LIMIT_ATTRS_rec.limit_id := TO_NUMBER(p_attr_value);
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
356: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_VALUE THEN
357: l_LIMIT_ATTRS_rec.limit_attr_value := p_attr_value;
358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN
359: l_LIMIT_ATTRS_rec.limit_id := TO_NUMBER(p_attr_value);
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
357: l_LIMIT_ATTRS_rec.limit_attr_value := p_attr_value;
358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN
359: l_LIMIT_ATTRS_rec.limit_id := TO_NUMBER(p_attr_value);
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN
359: l_LIMIT_ATTRS_rec.limit_id := TO_NUMBER(p_attr_value);
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
359: l_LIMIT_ATTRS_rec.limit_id := TO_NUMBER(p_attr_value);
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9
367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9
375: OR p_attr_id = QP_Limit_Attrs_Util.G_CONTEXT
368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9
375: OR p_attr_id = QP_Limit_Attrs_Util.G_CONTEXT
376: THEN
369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9
375: OR p_attr_id = QP_Limit_Attrs_Util.G_CONTEXT
376: THEN
377:
370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9
375: OR p_attr_id = QP_Limit_Attrs_Util.G_CONTEXT
376: THEN
377:
378: l_LIMIT_ATTRS_rec.attribute1 := p_attribute1;
371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6
372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7
373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8
374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9
375: OR p_attr_id = QP_Limit_Attrs_Util.G_CONTEXT
376: THEN
377:
378: l_LIMIT_ATTRS_rec.attribute1 := p_attribute1;
379: l_LIMIT_ATTRS_rec.attribute10 := p_attribute10;
480: x_limit := FND_API.G_MISS_CHAR;
481:
482: -- Load display out parameters if any
483:
484: l_LIMIT_ATTRS_val_rec := QP_Limit_Attrs_Util.Get_Values
485: ( p_LIMIT_ATTRS_rec => l_x_LIMIT_ATTRS_rec
486: , p_old_LIMIT_ATTRS_rec => l_LIMIT_ATTRS_rec
487: );
488:
1299: THEN
1300:
1301: -- Query row from DB
1302:
1303: g_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Query_Row
1304: ( p_limit_attribute_id => p_limit_attribute_id
1305: );
1306:
1307: g_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;