196: x_reserved_amount := l_x_LIMIT_BALANCES_rec.reserved_amount;
197:
198: -- Load display out parameters if any
199:
200: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values
201: ( p_LIMIT_BALANCES_rec => l_x_LIMIT_BALANCES_rec
202: );
203: x_limit_balance := l_LIMIT_BALANCES_val_rec.limit_balance;
204: x_limit := l_LIMIT_BALANCES_val_rec.limit;
370: );
371:
372: l_old_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec;
373:
374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN
375: l_LIMIT_BALANCES_rec.available_amount := TO_NUMBER(p_attr_value);
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
372: l_old_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec;
373:
374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN
375: l_LIMIT_BALANCES_rec.available_amount := TO_NUMBER(p_attr_value);
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN
375: l_LIMIT_BALANCES_rec.available_amount := TO_NUMBER(p_attr_value);
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
427:
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
427:
428: l_LIMIT_BALANCES_rec.attribute1 := p_attribute1;
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
427:
428: l_LIMIT_BALANCES_rec.attribute1 := p_attribute1;
429: l_LIMIT_BALANCES_rec.attribute10 := p_attribute10;
540: x_limit := FND_API.G_MISS_CHAR;
541:
542: -- Load display out parameters if any
543:
544: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values
545: ( p_LIMIT_BALANCES_rec => l_x_LIMIT_BALANCES_rec
546: , p_old_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
547: );
548:
1438: THEN
1439:
1440: -- Query row from DB
1441:
1442: g_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Query_Row
1443: ( p_limit_balance_id => p_limit_balance_id
1444: );
1445:
1446: g_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;