DBA Data[Home] [Help]

APPS.QP_QP_FORM_LIMIT_ATTRS dependencies on QP_LIMIT_ATTRS_UTIL

Line 180: l_LIMIT_ATTRS_val_rec := QP_Limit_Attrs_Util.Get_Values

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;

Line 344: IF p_attr_id = QP_Limit_Attrs_Util.G_COMPARISON_OPERATOR THEN

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

Line 346: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE 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

Line 348: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_CONTEXT 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

Line 350: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE 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

Line 352: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTRIBUTE_TYPE 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

Line 354: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_DATATYPE 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

Line 356: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT_ATTR_VALUE 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

Line 358: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_LIMIT THEN

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

Line 360: ELSIF p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE1

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

Line 361: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE10

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

Line 362: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE11

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

Line 363: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE12

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

Line 364: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE13

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

Line 365: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE14

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

Line 366: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE15

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

Line 367: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE2

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

Line 368: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE3

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

Line 369: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE4

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

Line 370: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE5

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

Line 371: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE6

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

Line 372: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE7

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

Line 373: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE8

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:

Line 374: OR p_attr_id = QP_Limit_Attrs_Util.G_ATTRIBUTE9

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;

Line 375: OR p_attr_id = QP_Limit_Attrs_Util.G_CONTEXT

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;

Line 484: l_LIMIT_ATTRS_val_rec := QP_Limit_Attrs_Util.Get_Values

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:

Line 1303: g_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Query_Row

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;